Numeric Value from Database is being considered a string 2

[alexkeel79]

I am having a problem with a sub routine that I wrote. The sub routine takes in one parameter and then gets another value from a SQL server database. The parameter is numeric as well as the value taken from the database. However, although the value from the db is type numeric in the db vbscript is considering it a string so it gives me the following type mismatch error:

Microsoft VBScript runtime error '800a000d'

Type mismatch


Is it possible to do something similar to the SQL Cast function in VBScript?

 

[Kendel]

In VBScript, you can convert a string to integer using
CInt().

 

[DotNetGnat]

try CINT or CDBL()

-DNG

 

[DotNetGnat]

oops...i meant CINT() or CDBL()

-DNG

 

[alexkeel79]

Great that worked. Thanks Guys.