> 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
everything? Why would you do that? Imagine a situation where MAXROWS was a
variable, like so:
<CFSET MAX = 100>
<CFQUERY .... MAXROWS="#MAX#">
...
</CFQUERY>
What if you needed a way to go from a max of 100 to no max? Normally you
would use a CFIF and two CFQUERY blocks since CF tags that allow you to
dynamically pass attributes (unlike custom tags which can use
ATTRIBUTECOLLECTION), but by using MAX="-1" you could then support this type
of switch.
Hope that makes sense.
=======================================================================
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
Email : [EMAIL PROTECTED]
ICQ UIN : 3679482
"My ally is the Force, and a powerful ally it is." - Yoda
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
