Converting varchar to money

The problem I am having is that I am trying to insert data from a form into a DB, but I cannot figure out how to change the form value (varchar) to the db value (money).

I've tried cast(bill_priceA as money) and I get

Microsoft VBScript compilation error '800a03ee'

Expected ')'

/Version1/AppointmentTypeFormSubmit.asp, line 35

"values('"& RMclientID & "', '" & sku & "', '" & appointmenttype & "', '" & appointmentdesc &"','"& cast(bill_priceA as Money) &"','"& bill_priceB &"','" & bill_priceC &_
---------------------------------------------------------------------------------------------------------------------^
with the arrow landing under the a in as

I've tried convert(Money, bill_priceA) and receive

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'convert'

/Version1/AppointmentTypeFormSubmit.asp, line 33


any help is appreciated!!!


code that assigns variables from form, and creates SQL string in ASP

RMclientID = Session("RMclientID")
sku = fixit(Request.Form("sku"))
appointmenttype = fixit(Request.Form("appointmenttype"))
appointmentdesc = fixit(Request.Form("appointmentdesc"))
bill_priceA = Request.Form("bill_priceA")
bill_priceB = Request.Form("bill_priceB")
bill_priceC = Request.Form("bill_priceC")
bill_priceD = Request.Form("bill_priceD")
bill_priceE = Request.Form("bill_priceE")
commissionrateA = Request.Form("commissionrateA")
commissionrateB = Request.Form("commissionrateB")
commissionrateC = Request.Form("commissionrateC")
commissionrateD = Request.Form("commissionrateD")
commissionrateE = Request.Form("commissionrateE")
ResourceTypeNeeded1 = Request.Form("ResourceTypeNeeded1")
ResourceTypeNeeded2 = Request.Form("ResourceTypeNeeded2")
ResourceTypeNeeded3 = Request.Form("ResourceTypeNeeded3")
ResourceTypeNeeded4 = Request.Form("ResourceTypeNeeded4")
ResourceTypeNeeded5 = Request.Form("ResourceTypeNeeded5")
id = Request.Form("id")

if Request.QueryString("action")= "create" then
'Response.Write(Request.QueryString("action"))
sql = "insert into AppointmentTypes (RMclientID, sku, appointmenttype, appointmentdesc, bill_priceA, bill_priceB, bill_priceC, bill_priceD, bill_priceE, " &_
"commissionrateA, commissionrateB, commissionrateC, commissionrateD, commissionrateE, ResourceTypeNeeded1, ResourceTypeNeeded2, ResourceTypeNeeded3, ResourceTypeNeeded4, ResourceTypeNeeded5) " &_
"values('"& RMclientID & "', '" & sku & "', '" & appointmenttype & "', '" & appointmentdesc &"','"& bill_priceA &"','"& bill_priceB &"','" & bill_priceC &_
"', '" & bill_priceD & "', '" & bill_priceE & "', '" & commissionrateA & "', '" & commissionrateB & "', '"& commissionrateC & "', '"& commissionrateD &_
"', '" & commissionrateE & "', '" & ResourceTypeNeeded1 & "', '" & ResourceTypeNeeded2 & "', '" & ResourceTypeNeeded3 & "', '" & ResourceTypeNeeded4 &"', '" & ResourceTypeNeeded5 & "')"
Response.Write(sql)

hi jstalnaker,

try this.

& also your error

should not have a single quote '

thanks! the apostrophe did the trick

your welcome. glad to help.