Going crazy with the Update Record wizard

[jaumeH]

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

[bregent]

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.