> We use MS SQL and utilize full text queries just like any other select
> query. I suspect that MySQL will work the same.
So the below should be a valid query then?
<cfquery>
SELECT field1, field2
FROM myTABLE
WHERE MATCH (field1, field2)
AGAINST ('#form.searchINPUT#')
</cfquery>
Will report back on what happens with this...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:287012
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
