This is driving me crazy. I am using a simple ASP table editor to make changes to an Access table. The following command is causing me to get an error:
UPDATE rates Set IRItype='A2', IRIProductName='Stylish', SQfeet='803', Bathrooms=1, IRIunitprice='600',
This is the error message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
The SQL command is automaticly generated by the ASP script. I do not know if that extra comma is the cause of the error.is that all there was to the UPDATE statement? if so, it produces an error because it ends with a dangling comma
typically, you would have a WHERE clause, unless your intention is to update all rows to those values
so yeah, look into the ASP script|||The extra comma is certainly a problem. Also, make sure SQfeet and IRIunitprice are text values in the table. If they are numeric, then you wouldn't want the single quote surrounding the values.
Showing posts with label causing. Show all posts
Showing posts with label causing. Show all posts
Friday, March 23, 2012
Subscribe to:
Posts (Atom)