update query

Results 1 to 2 of 2

Thread: update query

  1. #1
    Aku Guest

    Default update query

    For some reason followin sql wont work. Id is passed on from previous page and its datatype in an access database is autonumber<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e14&#039 <BR>[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression &#039ID=&#039. <BR><BR>sqlstmt = "UPDATE staff"<BR> sqlstmt = sqlstmt & " SET Title=&#039" & Title & "&#039,"<BR> sqlstmt = sqlstmt & "FirstName=&#039" & FirstName & "&#039,"<BR> sqlstmt = sqlstmt & "LastName=&#039" & LastName & "&#039,"<BR> sqlstmt = sqlstmt & "Extension=&#039" & Extension & "&#039,"<BR> sqlstmt = sqlstmt & "Location=&#039" & Location & "&#039,"<BR> sqlstmt = sqlstmt & "EMail=&#039" & EMail & "&#039,"<BR> sqlstmt = sqlstmt & "Profile=&#039" & Profile & "&#039" <BR> sqlstmt = sqlstmt & "WHERE ID=" & ID<BR> Set RS = conn.execute(SQLstmt)

  2. #2
    Nathen Grass Guest

    Default RE: update query

    Sounds as though your ID variable is empty. Try inserting response.write(sqlstmt) before your &#039Set RS&#039 statememt to see your SQL statement in the &#039sqlstmt&#039 variable.

Posting Permissions

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