Re: SQL full text search with CF

2001-05-16 Thread Paul Hastings
* Team Allaire * > > SELECT colum1,colum2 > CONTAINS . > AND. > WHERE > SELECT colum1,colum2 WHERE CONTAINS(*,'wheat beer') AND temperature=#justRight#

Re: SQL full text search with CF

2001-05-16 Thread Paul Hastings
* Team Allaire * > I haven't decided yet on which SQL version to use : 7 or 2000 (any major > diffrence?, > because money is an issue...) sql server 2000's full text has quite a few nice improvements. we can't even buy new sql server 7 here.

Re: SQL full text search with CF

2001-05-16 Thread Michael Lugassy
I haven't decided yet on which SQL version to use : 7 or 2000 (any major diffrence?, because money is an issue...) can you tell me a bit more about the enignes you assembled? I currently have the content as pure txt that resides on the file system (i.e - 100s and 1000s of .txt files on my hdd). w

Re: SQL full text search with CF

2001-05-16 Thread Paul Hastings
* Team Allaire * > That's great to hear! are you simply using CFQUERY with the appropriate > CONTAINS/FREETEXT code or running a Stored Procedure !?) both. what sql server version? what language (locale)? > I'm very new in SQL Full Text Sea

Re: SQL full text search with CF

2001-05-16 Thread Michael Lugassy
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 Subj

Re: SQL full text search with CF

2001-05-16 Thread Paul Smith
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 resul

Re: SQL full text search with CF

2001-05-16 Thread Michael Lugassy
> * Team Allaire * > > Has someone experince the SQL full text search mechanisem > > with ColdFusion? Is it possible to send regular FullText Queries > > yes. do it all the time. That's great to hear! are you simply using CFQUERY with the ap

Re: SQL full text search with CF

2001-05-16 Thread Paul Hastings
* Team Allaire * > Has someone experince the SQL full text search mechanisem > with ColdFusion? Is it possible to send regular FullText Queries yes. do it all the time. > (i.e CONTAINS and FREETEXT code) and display results > EFFICIENTLY?

SQL full text search with CF

2001-05-16 Thread Michael Lugassy
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