I've previously had a problem with a hand-built query (built while looping over other queries) which has problems in CFIndex When I originally built and tested it, I had problems of around 150 smaller queries - now the client has used the site a lot, there are 284 small queries which should be added together to make the big query... The problem is that it stops after 160 queries are added - thus it appears to "lose" the queries after this point I'm checking into the number of rows, but it's roughly 20 rows per small query, thus on average, 3200 rows... and then CFIndex "fails" on the subsequent rows Any ideas, anyone? 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
