Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › Dreamweaver › Getting error "There is an error in your SQL syntax."

View all replies to this thread

Getting error "There is an error in your SQL syntax."

Thread began 11/12/2015 7:29 am by Ian | Last modified 11/20/2015 2:22 pm by Ian | 1646 views | 5 replies

11/12/2015 7:29 amIan

Getting error "There is an error in your SQL syntax."

The message is not very helpful I know, but I cannot see why I am getting it.I have rebuilt the file several times to no avail. I have copied a file that carries out an identical function, amended it to take into account the difference in table and field names. That too produces the error.
I am a newby to this so please bear with me. I have created this site using tutorials from Adobe and your web site tutorials.
Attached are two files which as far as I can see are identical (apart for the obvious need for different table and field names). One works, the other doesn't.
I have looked at the SQL database and that too seem OK.

I have spent hours on this so would appreciate any help you can offer. Thank you.

Attached Files

File that does not work.txt

File that works.txt

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.