My question is:
How do you combine between SQL Full Text Search and Coldufiosn?
simply by calling SQL using CFQUERY i.e something like:
<CFQUERY datasource="xx" name="xx">
SELECT colum1,colum2 ....
CONTAINS .....
AND. ....
WHERE....
</CFQUERY>
or do you use CFSTOREDPROCEDURE to run a stored query that
is already on the SQL database (that run the full text for you).
or do you do it completly diffrently (and I'll feel stupid).
please help.
-=michael
----- Original Message -----
From: "Paul Smith" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 16, 2001 3:50 PM
Subject: Re: SQL full text search with CF
> I use M$ full-text quite a bit. But I don't understand your question.
>
> best, paul
>
> At 02:06 PM 5/16/01 +0200, you wrote:
> >Has someone experince the SQL full text search mechanisem
> >with ColdFusion? Is it possible to send regular FullText Queries
> >(i.e CONTAINS and FREETEXT code) and display results
> >EFFICIENTLY? or should I use some other method (for displaying,
> >not searching - SQL Full Text is the mechanisem I want to search with..)
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
