Philip,
Even trhough you can see 6,000+ records through the Enterprise Manager
doesn't necessarily mean that your SQL is successfully pully all 6,000+
records.
Try commenting out your CFINDEX and do a record count of all returned
'hits' from your database table.
This is something that I've had to do before myself - and I just *knew*
that my SQL was doing what it was supposed to. ;o)
Judith (The Other ;o)
Philip Arnold - ASP put into words:
>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...
Judith Taylor
ICQ: 67460562
Freelance ColdFusion Developer - Athens, OH
Friends don't let friends code before coffee.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
