-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
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
-- 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 cfquery but only blockfactor is available
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.
===
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 progress.
What is the difference between maxrows and blockfactor?
Both are available with cfquery but only blockfactor is available with
cfstoredproc.
Can you use blockfactor with a cfstoredproc the same way that you would
use maxrows in cfquery?
Sebastian Palmigiani
What is the difference between maxrows and blockfactor?
Both are available with cfquery but only blockfactor is
available with cfstoredproc.
MAXROWS specifies the maximum number of rows. BLOCKFACTOR specifies the
number of rows that CF will attempt to store in the database driver's
storage
://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 cfquery but only blockfactor
8 matches
Mail list logo