are you doing the mad recursion thing? if so the verity engine will have probably not finished indexing.. that's another reason why you should chuck as much info at it at once in one go rather than many ;) ----- Original Message ----- From: "Douglas Humphris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 22, 2003 5:09 PM Subject: RE: [ cf-dev ] VERITY PROBLEMS
Hey it's started yielding results! Most search criteria works now, but some words still won't return results (but I KNOW that they should!). At the moment I've established that "the" and "bt" don't return results but they both should. Everything else I'm trying is returning results now. I didn't change anything...honest. Cheers, Douglas -----Original Message----- From: Douglas Humphris [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 16:52 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] VERITY PROBLEMS I've searched for the*, "the", *the*, etc and get no results. I know that "the" appears in the recordset. I tried a windows search on "the" and got plenty of results. Scanning through the files in the collection, I can see that Verity seems to have successfully indexed the text. :( Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 16:32 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] VERITY PROBLEMS e* means get everything that starts with e and has anything after it. e being the most common letter, it's usually a good way to get at least some results. so you can get results, just not the ones you want. try broadening your search, to perhaps the*, which should again give you some results (i think). is it possible that the word(s) you're searching on simply aren't in your collection? if you're sure they are there, actually do a Find (from Windows) on the files in the collection for your word. It could be it simply hasn't indexed it properly. what phrase are you searching on? 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: RE: [ cf-dev ] VERITY PROBLEMS 22/10/2003 16:19 Please respond to dev Duncan, I searched for e* and got a large resultset, but anything else I try yields nothing. Is e* shorthand for return everything? Yep, the values of SearchCollection and Form.Collections point to the same collection and I've hard coded the collection name in to make sure. I'm only indexing one database table, but have tried your suggestion here anyway, using SELECT 'enq' + CAST(ID AS varchar(10)) AS enqID, Title, Inquiry And then using enqID as the key. It doesn't seem to make the slightest bit of difference though. Thanks for help, Douglas -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 15:42 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] VERITY PROBLEMS 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] -- ** 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] -- ** 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] -- ** 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]
