Make Sure you have the Fields set as Fulltext
Eric
On 8/23/07, Les Mizzell <[EMAIL PROTECTED]> wrote:
>
> > 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...
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287025
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
