I've seen it tons of times, CF pukes and outputs nothing. No error message,
but I've never seen anything else cause cf to output nothing so at least
it's possible to figure out what is causing it...
Perhaps using blockfactor might help? Then again no one wants to look at
1300+ records. You could put 2 cfquerys on the page and have the first one
get only 1000 records and have the second one get 1000-2000 and so on...very
kludgy though.
Also <cfloop> is the second slowest tag in cf. Get rid of the <cfloop
query="queryName">, and just use <cfoutput query="queryname">. You will
speed that program up quite a bit.
jon
----- Original Message -----
From: "David Cummins" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, February 11, 2001 7:38 PM
Subject: Re: Bizarre disappearing page - help!!!
> Are you sure? If the DB chokes, you'd expect an error message, or your
page to
> display as if there were less/no records, right?
>
> If I limit the records using endrow it works fine!
>
> David
>
> Jon Hall wrote:
> >
> > heh damn, still check the max records allowed. What you are describing
is
> > exactly what happens when too many records are pulled from a db. Or try
just
> > changing the query so it pulls less records to test it.
> >
> > jon
> > ----- Original Message -----
> > From: "David Cummins" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Sunday, February 11, 2001 7:02 PM
> > Subject: Re: Bizarre disappearing page - help!!!
> >
> > > Nope... SQL Server 7... ;)
> > >
> > > Dave
> > >
> > > Jon Hall wrote:
> > > >
> > > > You are using Access right? That would be your problem. Check in the
CF
> > > > Admin for the max records allowed to be pulled from the db.
> > > > Either dont pull 1300 records, delete some records, or use a better
> > > > database.
> > > >
> > > > jon
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
