maxrows is the maximum rows the query will return.
blockfactor is how many rows are returned per database call. a query returning 100
rows with a blockfactor=1 (default) will make 100 database calls. with
blockfactor=100 (the maximum) it will make one database call.
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 <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
>--------------------------------------------
>Cash Flow Club Charity
>http://www.cashflowclubonline.com/?SEB007883
>voice: 773.929.9256
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
