SELECT * FROM Customers WHERE ID in (SELECT ID FROM Customers WHERE Name like '%Marchand d'alimentation spcialise%' OR Desc like '%Marchand d'alimentation spcialise%' OR c1 like '%Marchand d'alimentation spcialise%' OR c2 like '%Marchand d'alimentation spcialise%' OR Details like '%Marchand d'alimentation spcialise%') 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 '%Marchand d'alimentation spcialise%' OR Desc like '%Marchand d'alimentation spcialise%' OR c1 like '%Marchand d'alimentation spcialise%' OR c2 like '%Marchand d'alimentation spcialise%' OR Details like '%March'. 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