SELECT * FROM Customers WHERE ID in (SELECT ID FROM Customers WHERE Name like '%Builders' hardware%' OR Desc like '%Builders' hardware%' OR c1 like '%Builders' hardware%' OR c2 like '%Builders' hardware%' OR Details like '%Builders' hardware%') ORDER BY Name ASC
THIS IS DB:C:\inetpub\vhosts\emotivemedia.com\httpdocs\alberta\ab.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 '%Builders' hardware%' OR Desc like '%Builders' hardware%' OR c1 like '%Builders' hardware%' OR c2 like '%Builders' hardware%' OR Details like '%Builders' hardware%') ORDER BY Name ASC'. in C:\inetpub\vhosts\emotivemedia.com\httpdocs\alberta\fr\index.php:738
Stack trace:
#0 C:\inetpub\vhosts\emotivemedia.com\httpdocs\alberta\fr\index.php(738): com->Open()
#1 {main}
thrown in C:\inetpub\vhosts\emotivemedia.com\httpdocs\alberta\fr\index.php on line 738
