What Data Types..

[handle87]

Hi,
If I am using a Float in an MS SQL Db what data type can I use in ASP? Or should I change the field to a different data type?

 

[Sheco]

If you are using VBScript for your ASP then all variables are Variants by default. You could use a variant to hold a float but if you want to make numeric comparisons you might want to convert it to the Double data type with the CDbl() function.

 

[DotNetGnat]

Just making it clear...

all variables are Variants by default

that means they can take any type of values- float, char etc...

this also means that you will never need to declare a variable as an string or integer or float, you just declare it.

-DNG

 

[tsdragon]

you will never need to declare a variable as an string or integer or float, you just declare it

In fact, you CANNOT declare the type of a variable in VBScript.

Tracy Dryden

Meddle not in the affairs of dragons,
For you are crunchy, and good with mustard.