> 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>
Doh! Needed parenthesis...
SELECT title,
Author,
Publishers,
ListPrice,
ISBN
FROM booksDATA
WHERE MATCH (Title, Author, Publishers)
AGAINST (<cfqueryparam
cfsqltype="cf_sql_varchar"
value="#form.search#">)
Like I said - never done an fulltext index before...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287578
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
