On Friday 24 Aug 2007, [EMAIL PROTECTED] wrote:
cfquery
SELECT field1, field2
FROM myTABLE
WHERE MATCH (field1, field2)
AGAINST ('#form.searchINPUT#')
/cfquery
cfqueryparam !
--
Tom Chiverton
Helping to seamlessly iterate revolutionary web-readiness
on:
cfquery
SELECT field1, field2
FROM myTABLE
WHERE MATCH (field1, field2)
AGAINST ('#form.searchINPUT#')
/cfquery
cfqueryparam !
I know! I know!
I was just presenting things in their most simple form
~|
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
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
Is it possible to run a full text search using cfquery (after the
appropriate columns have been indexed with FULLTEXT )?
cfquery
SELECT field1, field2
FROM myTABLE
WHERE MATCH (field1, field2)
AGAINST ('#form.searchINPUT#')
/cfquery
If not, how would you do this?
TIA!
Is it possible to run a full text search using cfquery
We use MS SQL and utilize full text queries just like any other select
query. I suspect that MySQL will work the same.
Best Regards,
Dennis Powers
UXB Internet - A website design and Hosting Company
690 Wolcott Road
P.O. Box 6029
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
7 matches
Mail list logo