3 Replies Latest reply on Aug 16, 2006 10:22 AM by MiMiB

    Update action using cfquery

    MiMiB
      I'm trying to update 2 tables within an access db so I'm using the UPDATE action with cfquery.
      The code is below. The error I'm getting is
      ODBC Error Code = 37000 (Syntax error or access violation)

      [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

      The error occurred while processing an element with a general identifier of (CFQUERY), occupying document

      <cfquery name="inputMeetings1" datasource="JohnJ">
      UPDATE Meetings1
      SET Issue='#Form.Issue#',
      Priority='#Form.Priority#',
      StartDate='#Form.StartDate#',
      Comcode='#Form.Comcode#',
      Desc='#Form.Desc#',
      CompleteDate='#Form.CompleteDate#',
      MDate='#Form.MDate#'
      WHERE ItemNo='#Form.ItemNo#'
      </cfquery>

      Hope someone can help.