Disk Space?
Maybe Quota?
Try specifiying a diffrent path for the collection
Thanks,
Michael
----- Original Message -----
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 14, 2001 1:25 PM
Subject: RE: Verity Limit
> > do you have ANY where clause in your SQL query (that the verity builds
> > collection on)?
> > maybe maxrows?
> >
> > try getting the query.recordcount before creating the index - see what
it
> > shows.
> > I'm using CF 4.5 Verity for over 5,000 rows, it's not alot, but it's
more
> > then you have so it's YOUR problem, I guess ;-)
>
> The query is a straight;
> Select columns
> from table
> order by field1 desc
>
> I have debug turned on, so it displays the full 6,840 records found...
>
> I never use MaxRows (as I use TOP if I'm doing that sort of thing)
>
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
