SELECT * FROM Customers WHERE ID in (SELECT ID FROM Customers WHERE Name like '%Hors d'oeuvres%' OR Desc like '%Hors d'oeuvres%' OR c1 like '%Hors d'oeuvres%' OR c2 like '%Hors d'oeuvres%' OR Details like '%Hors d'oeuvres%') ORDER BY Name ASC
THIS IS DB:C:\inetpub\vhosts\emotivemedia.com\httpdocs\quebec\qc.mdb
Fatal error: Uncaught com_exception: <b>Source:</b> Microsoft OLE DB Provider for ODBC Drivers<br/><b>Description:</b> [Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query expression 'ID in (SELECT ID FROM Customers WHERE Name like '%Hors d'oeuvres%' OR Desc like '%Hors d'oeuvres%' OR c1 like '%Hors d'oeuvres%' OR c2 like '%Hors d'oeuvres%' OR Details like '%Hors d'oeuvres%') ORDER BY Name ASC'. in C:\inetpub\vhosts\emotivemedia.com\httpdocs\quebec\fr\index.php:738
Stack trace:
#0 C:\inetpub\vhosts\emotivemedia.com\httpdocs\quebec\fr\index.php(738): com->Open()
#1 {main}
thrown in C:\inetpub\vhosts\emotivemedia.com\httpdocs\quebec\fr\index.php on line 738
