Skip to main content
J
jaumeH
Known Participant
September 15, 2011
Question

Going crazy with the Update Record wizard

  • September 15, 2011
  • 1 reply
  • 377 views

Hi there!!

If anyone can help I'll be forever thankful!!!

I've created a simple form in Dreamweaver. Set up the Recordsets and configured the Server Behavior to update MySQL table.

I've also linked all the fields at the database to the textboxes and press ok.

Ot looks good but when I try to change any data prompts an error message:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Condition='Esplugues', Accesory1=NULL, Accesory2=NULL, Accesory3=NULL, Accesory4' at line 1

Any help??

Thank you very much

Jaume

This topic has been closed for replies.

1 reply

B
bregent
Participating Frequently
September 15, 2011

Yes, syntax is certainly not correct. Conditions in the where clause must be separated using either AND or OR predicates, not commas. You must have entered this manually - DW would not have created the query this way.

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