RE: maxrows and blockfactor

2001-07-09 Thread Dave Watts
> > Thanks for the tip; I didn't know this. Apparently, neither do > > the folks who write the CF documentation. You might want to share > > it with them. > > Well, it is missing from the CF4.x docs, but it does exist in > the CF5 doc. Right you are! It's nice to see the inexorable march of p

RE: maxrows and blockfactor

2001-07-09 Thread Raymond Camden
> Thanks for the tip; I didn't know this. Apparently, neither do > the folks who > write the CF documentation. You might want to share it with them. Well, it is missing from the CF4.x docs, but it does exist in the CF5 doc. ==

Re: maxrows and blockfactor

2001-07-09 Thread Chris Norloff
-- Original Message -- From: sebastian palmigiani <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Sat, 07 Jul 2001 16:28:06 -0500 > >What is the difference between maxrows and blockfactor? > >Both are available with but only blockfactor

RE: maxrows and blockfactor

2001-07-09 Thread Raymond Camden
> MAXROWS allows you to define the maximum rows retrieved each query > (eg: 10). If you leave out MAXROWS the query will return all records > in the database matching your query. This could be thousands so > maxrows can be handy. By the way, did you know if you pass -1 to MAXROWS, it will return

RE: maxrows and blockfactor

2001-07-09 Thread Peter Tilbrook
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Both MAXROWS and BLOCKFACTOR are optional attributes for CFQUERY. MAXROWS allows you to define the maximum rows retrieved each query (eg: 10). If you leave out MAXROWS the query will return all records in the database matching your query. This could

RE: maxrows and blockfactor

2001-07-08 Thread Christopher Olive, CIO
://www.crescotech.com -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 07, 2001 5:28 PM To: CF-Talk Subject: maxrows and blockfactor What is the difference between maxrows and blockfactor? Both are available with but only blockfactor is

RE: maxrows and blockfactor

2001-07-08 Thread Dave Watts
> What is the difference between maxrows and blockfactor? > > Both are available with but only blockfactor is > available with . MAXROWS specifies the maximum number of rows. BLOCKFACTOR specifies the number of rows that CF will attempt to store in the database driver's st

maxrows and blockfactor

2001-07-08 Thread sebastian palmigiani
What is the difference between maxrows and blockfactor? Both are available with but only blockfactor is available with . Can you use blockfactor with a the same way that you would use maxrows in ? Sebastian Palmigiani Cash Flow Club Charity