When the where clause in a lookup wizard contains a syntax error, the SQL query is not displayed as part of the PHP error message:
Technical information
Error type 256
Error description 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 'ORDER BY `Industry_Personnel`.`IP_Name`' at line 1
URL www.beverlyhecht.com/bhdb31/Industry_Personnel_Relationships_Client2_add.php?
Error file /home/mikeb941/public_html/bhdb31/include/dbconnection.php
Error line 26
SQL query
Solution This is a general error. It occurs when there is an error in event code or in SQL.
Send your SQL or event code along with full error message tosupport@xlinesoft.com&.
*** NOTICE THE SQL QUERY IS BLANK - so you can't see the SQL causing the problem.
Thanks for your help with this.
Take Care... Mike.
