>> So the below should be a valid query then?
>> {deleted for brevity}
I am unfamiliar with the syntax of MySQL full text queries so I can not be
definite however this MSSQL full text query works just fine.
<cfquery>
SELECT (KEY_TBL.RANK * 1000) AS RANK, field1, field2
FROM myTable AS Sometable INNER JOIN
CONTAINSTABLE(myTable, *, '#SQLSearchString#' ) AS KEY_TBL ON
Sometable.ID = KEY_TBL.[KEY]
WHERE field3= 'A'
</cfquery>
If the DB supports the Query syntax then it should run fine.
Best Regards,
Dennis Powers
UXB Internet - A website design and Hosting Company
690 Wolcott Road
P.O. Box 6029
Wolcott, CT 06716
Tel: (203)879-2844
http://www.uxbinternet.com/
http://www.uxb.net/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:287075
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
