Skip to main content
S
spill-wjzVEv
Inspiring
December 7, 2008
Question

syntax error in SQL - I think i need sleep

  • December 7, 2008
  • 2 replies
  • 547 views
for the like of me I cant find whats wrong with this UPDATE statement.

cf says there is a syntax error. I've narrowed it down to the PASSWORD statement as it works fine when I comment that bit out.

Maybe I've been awake too long but I just cant see whats wrong with it. Can someone please have a look and tell me I'm been stupid as its obvious whats wrong with it.
This topic has been closed for replies.

2 replies

D
Dan_Bracuk
Inspiring
December 8, 2008
password might be a reserved word in your db.
S
spill-wjzVEvAuthor
Inspiring
December 8, 2008
never mind, I changed PASSWORD to USER_PASSWORD and it then worked. Dont know why it made a difference I've used PASSWORD in the past, maybe someone could enlighten me.

Now I think I must sleep
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices