what type of thing are you searching for? try searching for e*, which should give you some results. it sounds like the indexing is working if you've got a 8Mb collection, but Verity can be a bit funny about all this sometimes.
you sure the value of #SearchCollection# and #Form.Collections# point to the same collection name? also, the key has to be unique. So if you've got two tables used to populate your collection, and you do two <cfindex>'s based on those two queries, you can't just use ID both times, as both tables will likely have overlapping ID numbers. I usually append a string there, e.g: <!--- 1. index news ---> select "news" & ID AS theID <cfindex key="theID" ... > <!--- 2. index staff ---> select "staff" & ID AS theID <cfindex key="theID" ... > Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Douglas Humphris" <[EMAIL PROTECTED] To: <[EMAIL PROTECTED]> itech.net> cc: Subject: [ cf-dev ] VERITY PROBLEMS 22/10/2003 15:29 Please respond to dev Hi folks, I'm having a nightmare today trying to get a verity search collection to return results. I haven't used them for quite a while. I've got a search collection (Reg_enq) which is built from a recordset. After running cfindex I get a collection of about 8Mb in size. When I try cfsearch on that collection it never returns any results. Also, when I try cfsearch on multiple collections it returns no results. The other collections are all built from a directory tree and they return results fine when searched by themselves. Here's the code for cfindex: cfindex action="REFRESH" collection="#SearchCollection#" key="ID" type="CUSTOM" title="Title" query="GetRegEnq" body="Inquiry, Title" custom1="reg_enq" Appears to work fine, but when I cfdump the results of: cfsearch name = "GetResults" collection = "#FORM.Collections#" criteria = "#SearchCriteria#" startrow = "#FORM.StartRow#" the resultset is empty. Any ideas, pointers would be much appreciated. Thanks, Douglas PS This is old CF3.5 code which I'm migrating to CF5 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
