Shite.
Firstly what version of CFMX? If using CFMX 7 then the latter version of
Verity (depending on license - Standard or Enterprise).
I did good (I thought) in indexing www.itsanhonour.gov.au but that was way
back with CF5 and VERY painful!
Peter Tilbrook
ColdGen Internet Solutions
Manager, ACT and Region ColdFusion Users Group
PO Box 2247
Queanbeyan, NSW, 2620
AUSTRALIA
WWW 1: http://www.coldgen.com/
WWW 2: http://www.actcfug.com/
Telephone: +61-2-6284-2727
Mobile: 0432 897 437
E-mail: [EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jason Bayly
Sent: Monday, April 04, 2005 6:37 PM
To: CFAussie Mailing List
Subject: [cfaussie] Verity indexing issue
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/
---
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/
