Only able to use numbers in a form post text field ??

Originally posted by : Mal (mal@go-planit.co.uk)Can only use numbers in a text form field??????On the posted page I have:rdev=request.form("rdev")I wish to put the results in the database so I'm using:db.execute("update orders set rdevref= " & rdev & " where orderid=" & valid_sql(orderid))but it will only allow me to use numbers in the form text field, I wish to use any character. if I get rid of the db.execute I can put anything in. It's definitely passing it through because I checked with a response.write. I get Http error 500 page returned if I try to use anything other than numbers. The database feild can definitely take any character as if I change the db.execute bit to rdevref='test///***' (or anything similar) it puts it in. So I'm suspecting rdevref= " & rdev & " is coded incorrectly.

Originally posted by : Stephen W Roberts Jr (racegene@yahoo.com)Some of the dbs ive used require you to enclose all strings in single quotes(' '). If that doesn't work, Im not sure. ------------Mal at 11/28/2001 3:46:18 AMCan only use numbers in a text form field??????On the posted page I have:rdev=request.form("rdev")I wish to put the results in the database so I'm using:db.execute("update orders set rdevref= " & rdev & " where orderid=" & valid_sql(orderid))but it will only allow me to use numbers in the form text field, I wish to use any character. if I get rid of the db.execute I can put anything in. It's definitely passing it through because I checked with a response.write. I get Http error 500 page returned if I try to use anything other than numbers. The database feild can definitely take any character as if I change the db.execute bit to rdevref='test///***' (or anything similar) it puts it in. So I'm suspecting rdevref= " & rdev & " is coded incorrectly.