Parker Software Ltd Homepage
Forum Home Forum Home > Email2DB Email Parser > Scripting
  New Posts New Posts RSS Feed: Type Mismatch Native Error -2147352571
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Type Mismatch Native Error -2147352571

 Post Reply Post Reply
Author
Message
pvitt View Drop Down
New User
New User


Joined: 01 Aug 2011
Posts: 18
Post Options Post Options   Quote pvitt Quote  Post ReplyReply Direct Link To This Post Topic: Type Mismatch Native Error -2147352571
    Posted: 01 May 2012 at 5:05pm

Hi - I'm getting the subject error in my trigger when it runs on schedule automatically, but when I manually run the trigger with the same email text it works fine.  The trigger was working good using the automatic scheduling under 2.3 and the error has only appeared with the 3.0 version.  Any ideas?  I have a vb script that I think may be causing the error:

the data that gets fed to this script is like 000013 or  00014
the script strips out the leading zeros and inserts a number in the database
Sub Main()
 ' commands start here
    Email2DBExtract = RemoveLeadingZeroes(Email2DBExtract)
End Sub
Function RemoveLeadingZeroes(ByVal Str)
    Dim tempStr
    tempStr = Str
    While Left(tempStr,1) = "0" And tempStr <> ""
        tempStr = Right(tempStr,Len(tempStr)-1)
    Wend
    RemoveLeadingZeroes = tempStr
End Function
 
Thanks
 
Pete
Back to Top
pvitt View Drop Down
New User
New User


Joined: 01 Aug 2011
Posts: 18
Post Options Post Options   Quote pvitt Quote  Post ReplyReply Direct Link To This Post Posted: 01 May 2012 at 8:57pm

I see where the error is coming from -- nevermind

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.063 seconds.
These are the forums for Parker Software, developers of Live Chat Software: WhosOn and Email Automation Software: Email2DB.