ASP datatype for SQL server Numeric [Command object]
Posted on 2002-06-28
I have a numeric field in sql server of size 10 [it says size 9 and precision - i am confused about this also]
In my asp code when i use adNumeric as below in command object i get an error, when i use adInteger instead it works withought any problem. I fear adInteger will have a limitation of 32767 numbers. I want it to take up to 10 digits of numbers.
cmdUsers.Parameters.Append cmdUsers.CreateParameter ("USERID", adNumeric ,adParamInput,10)
'cmdUsers is command object
Any help greatly appreciated.