Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › I'm getting a Syntax Error when I use the delete icon for a record on the results form I generated.

View all replies to this thread

I'm getting a Syntax Error when I use the delete icon for a record on the results form I generated.

Thread began 2/17/2016 1:07 pm by anonymous | Last modified 2/18/2016 6:33 pm by anonymous | 2062 views | 11 replies

2/17/2016 1:07 pmanonymous

I'm getting a Syntax Error when I use the delete icon for a record on the results form I generated.

I've generated forms using the form generation wizard and after everything was generated, I added some extra sorting parameters for the results page. When I use the delete button I now get the following...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 '%test%) ORDER BY Lastname, Firstname, Company, Zip, Phone, Email ASC LIMIT 0, 2' at line 1

How can I correct this? I've included the forms I've created and I've also tested this with the original forms I generated and I got the same error.

Attached Files

SUBSCRIP_detail-5.php

SUBSCRIP_insert-5.php

SUBSCRIP_results-4.php

SUBSCRIP_search-13.php

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.