Just guessing but could you slit the results up. You only show so many on the results page.
Displaying 1-25 NEXT Then limit the results to only the first 25 records in the database carry over the MAX record of the query to start the second page and so on .... Ahhhh I'm sure theirs a better way. I had problems with Verity on 4.5 it would work for a week or so then blow up. I would have to delete the verity and start over, re-indexing didn't help. Rick -----Original Message----- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 8:54 AM To: CF-Community Subject: Grrr... Damn CF4.5 Verity We've got a customer who refuses to pay for the upgrade to CF5 (even though they can get the educational discount) for 2 servers... Anyways, the moan about this is that I'm trying to build one HAUGE Verity on it (covering about 200 mini-sites) which has 9,800 pages... The problem is that if you search for "*", it returns "Criteria is not specific enough. Result set exceeded maximum size (64K)." Does anybody know a simple (and quick) way to get around this nightmare I'm having? Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 F: +44 (0)20 8686 7911 An ISO9001 registered company. ********************************************************************** 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. ********************************************************************** ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
