asp run sql server stored procedure problem??
Web Development
1
Posts
1
Posters
0
Views
1
Watching
-
Hi, I have a stored procedure in sql server like this: create procedure sp_insert ( @some_value float ) as --insert statement here and the column is defined to float go I call it in ASP. and the code like this set cmd=function to create the command cmd.Parameters.Append cmd.CreateParameter("@some_value",5,1,,CDbl("text_value_here")) cmd.execute I got the error message to complain about can not convert nvarchar to float all the time. BTW, the function to create the command object is tested working. My question is: How to deal with the float parameter in ASP code? Thanks a lot in advance!
Alan Shen MCAD for .NET Version ^~^~^~^~^~^~^~^~^~^~^ Great idea is the beginging of success!