MySQL Forums
Forum List  »  Newbie

Re: broad match search results, splitting the search by spaces
Posted by: Joseph Charles
Date: November 11, 2014 02:54PM

Thank you for your suggestion, but it isnt something that I am capable of at this time, what im actually looking for is help with the SQL query:

rsCustSearch.Source = "SELECT * FROM Products WHERE MATCH (ProductName, LLength, LHeight) AGAINST ("'%" + Replace(rsCustSearch__testvar, "'", "''") + "%'" IN BOOLEAN MODE);"




That query gives the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51 Driver][mysqld-5.5.30]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 '' at line 1


Can someone please tell me where the syntax error in my SQL query is?

Options: ReplyQuote


Subject
Written By
Posted
Re: broad match search results, splitting the search by spaces
November 11, 2014 02:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.