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/
