|
-
Jan 8th, 2001, 03:07 PM
#1
Thread Starter
Junior Member
My dB has a column name called price and the value of currency how do you convert it to currency?
i have this in place
If Request.Form("price") = vbNullString Then
strSQL = strSQL & "0,"
Else
strSQL = strSQL & ccur(Request.Form("price")) & ","
End If
and i get this error
Disallowed implicit conversion from data type varchar to data type money, table 'ShaganappiTest.dbo.used_cars', column 'Price'. Use the CONVERT function to run this query.
I assums i Have to do something with the 0 but what....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|