Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Going crazy with the Update Record wizard

New Here ,
Sep 15, 2011 Sep 15, 2011

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

TOPICS
Server side applications
378
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Sep 15, 2011 Sep 15, 2011
LATEST

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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines