Jason,
To resolve this you need to see what if any you have in the Verity collection itself. You can try a search with an open criteria or better still use the command line tools to dig around in the index -- check the CF doco for these.
You need to be cautious of using REFRESH. Especially for updates. REFRESH means purge collection and rebuild from scratch. With larger collections this can be disastrous. Using UPDATE and a filtered query looking for only upated records is best if possible.
Anyhoot... using REFRESH *might* have the unexpected side effect of causing Verity to return no results till it sorts itself out. The version of Verity that ships 5+ doesn't require locking for maintenance and sort of caches its index during the build process. It could be that you are REFRESHing.. then searching and seeing a cache of the purged index.
-- geoff http://www.daemon.com.au/
PS. Prolly nothing but you got spaces for one BODY specification and not for the other?
Jason Bayly wrote:
Hi Guys
Yeah im using CF 5 where i am now. Ive used verity half a dozen times over the years and never encountered this issue.
I'll include my code etc so u can see if ive lost the plot..
I have two pages, first one creates the catalogues, runs the query and populates them
<!--- STEP1 create the catalogues for the DB content, catalogues represent the content level --->
<cfcollection action="CREATE" collection="DLH_SearchItems" path="#ExpandPath("../")#search">
<cfcollection action="CREATE" collection="DLH_SearchSections" path="#ExpandPath("../")#search">
<!--- populate the index with the search results --->
<cfindex action="refresh" collection="DLH_SearchItems" type="CUSTOM" key="id" title="title" query="popIndex1" body="Title,Abstract,BC,Location,Venue" custom1="Path" custom2="ALevel">
<cfindex action="refresh" collection="DLH_SearchSections" type="CUSTOM" key="id" title="title" query="popIndex2" body="Title,Abstract,BC,Location,Venue" custom1="Path" custom2="ALevel">
I place all the fields i want to search over in the body attribute, as per above.
I have a second page which i'll schedule to keep the catalogues refreshed.
<!--- repopulate the index with the search results --->
<cfindex action="refresh" collection="DLH_SearchItems" type="CUSTOM" key="id" title="title" query="popIndex1" body="Title, Abstract, BC, Location, Venue" custom1="Path" custom2="ALevel">
<cfindex action="refresh" collection="DLH_SearchSections" type="CUSTOM" key="id" title="title" query="popIndex2" body="Title, Abstract, BC, Location, Venue" custom1="Path" custom2="ALevel">
Can anyone see anything wrong with my methodolgy/ tag implementation?
Im guessing if this cant be resolved with verity i'll use MS SQL FTS instead, which isnt great considering my tight deadline.. Any further advice appreciated..
Cheers
Jason
"Jason Bayly" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
Hi Peoples,
I ve just written a site search feature for a client using verity. Its all DB content across several tables.
Ive written a query which spans the tables (using UNION and CAST func. on the datatypes for conformance etc) and it all runs and looks ok, except it doesnt return all the recs in a table. When i create/refresh the catalouge my query returns 130recs which is right, but only some of them i can search across.
eg.. i can look at at title of one of the records in the site and then do a search on specific words i know are in the title, i dont get any matches... nada
Any ideas, where to begin?
My SQL look likes below... and i know its not my verity tags etc as ive used these before without issues in a recent job.
TIA Jason
SELECT UID AS ID, Title AS Title, CAST(newsBodyCopy AS NVarChar(4000)) AS BC, OBJPath AS Path, Status AS Status, AccessLevelIDLU AS ALevel, newsAbstract AS Abstract, NULL AS Date, NULL AS Location, NULL AS Venue FROM TBL_NewsAwardItems WHERE status = 1 AND AccessLevelIDLU <> 3 UNION SELECT UID AS ID, Title AS Title, CAST(oppBodyCopy AS NVarChar(4000)) AS BC, OBJPath AS Path, Status AS Status, AccessLevelIDLU AS ALevel, oppAbstract AS Abstract, NULL AS Date, NULL AS Location, NULL AS Venue FROM TBL_OpportunityItems WHERE status = 1 AND AccessLevelIDLU <> 3 UNION SELECT UID AS ID, Title AS Title, CAST(BodyCopy AS NVarChar(4000)) AS BC, OBJPath AS Path, Status AS Status, AccessLevelIDLU AS ALevel, Abstract AS Abstract, NULL AS Date, NULL AS Location, NULL AS Venue FROM TBL_AboutItems WHERE status = 1 AND AccessLevelIDLU <> 3
--- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
