Now that you've stepped up to bat, is there an alternative to the OR in the
following? It seems to me that 1 CONTAINS ought to be able to search more
than one column, but I haven't figured out how.
best, paul
<CFQUERY NAME="SEARCHLISTINGS" DATASOURCE="#REQUEST.DSN#"
USERNAME="#REQUEST.USER#" PASSWORD="#REQUEST.PASS#" BLOCKFACTOR="100">
SELECT ID
FROM orgs (nolock)
<CFIF CompareNoCase("#REQUEST.GetClientDataCity.City#","All Cities")>
WHERE City = '#REQUEST.GetClientDataCity.City#'
AND ( CONTAINS(org_name,' #VARIABLES_SEARCHTERM# ')
OR CONTAINS(classified,' #VARIABLES_SEARCHTERM# ') )
<CFELSE>
WHERE CONTAINS(org_name,' #VARIABLES_SEARCHTERM# ')
OR CONTAINS(classified,' #VARIABLES_SEARCHTERM# ')
</CFIF>
</CFQUERY>
At 01:08 PM 11/22/00 -0500, you wrote:
>I agree... using SQL 'CONTAINS' on full-text indexed database fields has
>always been a much better search method for doing database searches, in my
>experience.
>
>~Simon
>
> > Simon Horwith
> > Certified ColdFusion Developer
> > Fig Leaf Software
> > 1400 16th St NW, # 220
> > Washington DC 20036
> > 202.797.6570 (direct line)
> > www.figleaf.com
> >
>
>
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, November 22, 2000 12:57 PM
>To: CF-Talk
>Cc: [EMAIL PROTECTED]
>Subject: Re: MS Index Server vs. Verity
>
>
>Index Server is included in SQL Server 7.
>
>For my application, I like SQL7 full-text indexing and searching on
>database fields better than Verity, having directly compared their
>performance in the same application. I don't use stemming though (and,
>like Google, don't want to). For my application, SQL full-text is
>decidedly faster. As always, YMMV.
>
>best, paul
>
>At 08:45 AM 11/22/00 -0800, you wrote:
> >I had to demo how cold fusion works to my I.S. department last week and
> >after showing them how 'verity' works they suggested I look into 'Index
> >Server' as a 'better' alternative. Can I get some of your opinions as to
>the
> >differences between the two and where I can get more info on 'Index Server'
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Structure your ColdFusion code with Fusebox. Get the official book at
>http://www.fusionauthority.com/bkinfo.cfm
>
>Archives: http://www.mail-archive.com/[email protected]/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Structure your ColdFusion code with Fusebox. Get the official book at
>http://www.fusionauthority.com/bkinfo.cfm
>
>Archives: http://www.mail-archive.com/[email protected]/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
