that was it!  I changed the cfindex key to the primary key in the table ..
purged and updated the verity.. works great!  Thanks so much!

-----Original Message-----
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Friday, January 09, 2004 9:18 AM
To: CF-Talk
Subject: RE: verity search

Is the value for the key attribute unique?

Ade

-----Original Message-----
From: Tim Do [mailto:[EMAIL PROTECTED]
Sent: 09 January 2004 16:47
To: CF-Talk
Subject: RE: verity search

The query returns 10 more than the cfsearch did.

-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 08, 2004 9:16 PM
To: CF-Talk
Subject: RE: verity search

> thanks Dave... I removed the extensions and double checked
> the query.. it does return correctly.  Anything else?

When you search the collection, does the RecordsSearched variable within
your CFSEARCH recordset match the number of records from your original
query?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/ <http://www.figleaf.com/>  <http://www.figleaf.com/>
<http://www.figleaf.com/>

phone: 202-797-5496
fax: 202-797-5444
  _____
  _____
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to