Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › SQL Syntax Error

View all replies to this thread

SQL Syntax Error

Thread began 7/13/2010 4:53 pm by htp372188 | Last modified 7/14/2010 7:18 am by htp372188 | 891 views | 1 replies

7/13/2010 4:53 pmhtp372188

SQL Syntax Error

I am getting the following error when trying to use the xxx_Insert.php page:
"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 'update FROM member_info WHERE item = -1 OR ( -1= -1 AND item= 4)' at line 1"

A somewhat similar error occurs when I use the Search.php page.

A check of the Server Behaviours for Insert & Update indicate that the data types are all correct.

The page may be tested at: member_info_Insert.php

The database tables are attached as are the Pages generated by DataAssist.

Attached Files

DataAssist.zip

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.