> 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
