What is the result if you do a SELECT COUNT (DISTINCT ID) FROM
[_Temp_Search_Table]?
If Verity sees duplicates for the key, it will fail on adding them to the
index.
dave
At 09:22 AM 6/15/2001 +0100, you wrote:
>> I'm thinking the key you are using isn't unique. Could you post the code
>> you are using to create the collection.
>
>Below is the SQL used to build, add and select the database - then the
>CFIndex command
>
>The big table is meant to be built from about 230 mini-sites, each of which
>having 15-20 pages, and the main search is to jump to those mini-sites (you
>get the idea)
>
>The table is built perfectly OK - I've opened it in Enterprise Manager and
>it has 6,840 real records...
>
>Any ideas???
>Oh yeah, CF4.5 (latest SP)
>
>create table [_Temp_Search_Table]
>(ID varchar(255) null,
>Title varchar(255) null,
>Body text null,
>EventID varchar(255) null,
>ConfTitle text null,
>URLprefix varchar(255) null)
>
>insert into [_Temp_Search_Table] (ID, Title, Body, EventID, ConfTitle,
>URLprefix)
>select '#EventID#-'+Convert(varchar(50),ID) as ID, Title, Body , '#EventID#'
>as EventID, '#ConfTitle#' as ConfTitle, '#myURLprefix#' as URLprefix
>from #EventID#_Pages
>where Title is not null
> and not (Convert(varchar,Body) is NULL
> or Convert(varchar,Body)=' ')
>order by Title desc
>
>
>select ID, Title, Body, EventID, ConfTitle, URLprefix
>from [_Temp_Search_Table]
>order by Convert(varchar(4096),ConfTitle) desc, Title desc
>
>
><cfindex
> collection="Complete_Pages"
> action="Refresh"
> type="Custom"
> body="ConfTitle,Title,Body,EventID"
> key="ID"
> title="Title"
> query="fullSQL"
> custom1="URLprefix"
> custom2="ConfTitle">
>
>Philip Arnold
>Director
>Certified ColdFusion Developer
>ASP Multimedia Limited
>T: +44 (0)20 8680 1133
>
>"Websites for the real world"
>
>**********************************************************************
>This email and any files transmitted with it are confidential and
>intended solely for the use of the individual or entity to whom they
>are addressed. If you have received this email in error please notify
>the system manager.
>**********************************************************************
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
