and dont forget locking....
Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]
(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487 aim: lv2bounce
http://www.cs.odu.edu/~bader
-----Original Message-----
From: Keith Thornburn [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 12, 2001 8:32 AM
To: CF-Talk
Subject: RE: boolean search with CF and SQL statement
Just an aside here with using Verity and boolean operators in the search
term:
CF (Verity) will error on an incorrectly formed boolean search term, eg,
fast and car and and skoda --> error
fast and car and not skoda --> OK
fast and car or or skoda --> error
fast and car or not skoda --> error
fast and car not skoda and --> error
etc
So you'll have to clear up the search term before it hits Verity.
Also it is know that Verity can't handle large collection (eg greater than
50-60MB) - the trick is to break it into smaller indexes and then query them
together ... CFSEARCH COLLECTION="collection1,collection2" ... It think
there's an Allaire Knowledge Base article on this.
Make sure to re-index and optimise the collections regularly to make sure
the content is up to date and the collection optimised and error free.
Keith
> -----Original Message-----
> From: river [mailto:[EMAIL PROTECTED]]
> Sent: 12 February 2001 13:18
> To: CF-Talk
> Subject: Re: boolean search with CF and SQL statement
>
>
> I gotta ask my ISP if I can use Verity on their servers. I guess it could
> make my life whole a lot easier if I could use Verity for such a thing?
>
> > Is is possible to create a Verity Collection for that data and search it
> > instead of doing a SQL search?
>
> > I know that doesn't answer your Q, but just a thought...
>
> No, any suggestion is appreciated. Thanks.
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
