Hi Guys, I seem to have avoided the issue, by creating an additional catalogue. I simplified the queries alittle also by adding the new cat. So im guessing it wasnt entirely happy with the SQL populating the indexes. Well probelm solved, onto the next one :)
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/
