Getting an error on the following SQL. The field in question is the Description field which has * in the description. Not sure how I should have the SQL to solve this
UPDATE Taylors
SET Area=::Area::,Avail=::Avail::,Address=::Address::,Type=::Type::,Price=::Price::,Bedrooms=::Bedrooms::,HotProps=::HotProps::,Office=::Office::,Description=::Description::
WHERE RefNo =::RefNo::
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '* modern retirement flat * double bedroom * south lounge * fitted kitchen * good size bathroom * communal gardens * residence parking *'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC DriversCan you show the UPDATE command as it appears just before you send it? I have no idea what you mean by ::Area::, etc. Are these strings? Do you enclose literal strings in single quotes?
If you use parameters instead of doing whatever you are doing (Search and Replace?) things will go lots easier.
http://aspnet101.com/aspnet101/tutorials.aspx?id=1
No comments:
Post a Comment