Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    8

    Unanswered: Noob Query Problem -This will be easy for you

    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.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    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.
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •