I've set up a FULLTEXT index in the MySQL database. This part should be
correct as the database shows the below with no errors:
Index Name: textSEARCH
Field Names: Title, Author, Publishers
Index: Full Text
Here's my query:
<cfquery name="getBOOK"
dataSource="#getDATASOURCE">
SELECT title,
Author,
Publishers,
ListPrice,
ISBN
FROM booksDATA
WHERE MATCH (Title, Author, Publishers)
AGAINST <cfqueryparam
cfsqltype="cf_sql_varchar"
value="#form.search#">
</cfquery>
So, let's try to find a Beatrix Potter book about rabbits.
Here's the error.
"Syntax error or access violation: 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 ''potter rabbit''"
Not sure what I've got wrong. I've never used a fulltext index before,
but query looks correct tome. Hmmmmm - suggestions?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287546
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
