Syntax error in Update

Results 1 to 3 of 3

Thread: Syntax error in Update

  1. #1
    Join Date
    Dec 1969

    Default Syntax error in Update

    UPDATE users SET password = &#039;tai&#039; WHERE username = &#039;ash&#039; <BR>Microsoft JET Database Engine error &#039;80040e14&#039; <BR><BR>Syntax error in UPDATE statement. <BR><BR>/update.asp, line 56 <BR><BR>can anybody tell me whats wrong in above update statement ?<BR>thankx

  2. #2
    Join Date
    Dec 1969

    Default RE: Syntax error in Update

    Jet SQL has password as a reserved word. It would be preferable to change it to something else. If that is not possible you need to use this (abnomiable) syntax<BR><BR>UPDATE users SET [password} = &#039;tai&#039; WHERE username = &#039;ash&#039;

  3. #3
    Join Date
    Dec 1969

    Default Reserved word

    password is a reserved word in MS Jet.<BR><BR>UPDATE users SET [password] = &#039;tai&#039; WHERE username = &#039;ash&#039;<BR><BR>

Posting Permissions

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