Use the Maxrows argument in the CFQuery Tag:
<cfquery name="get_stuff" datasource="some_odbc_datasource"
maxrows="50">
Select * from the_table where user_id = 1
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
- ORACLE and SQL Todd McFarlin
- Re: ORACLE and SQL Judith Campbell
- Oracle and SQL Todd McFarlin
- RE: Oracle and SQL Eli Shechter
- RE: Oracle and SQL Todd McFarlin
- Re: Oracle and SQL Peter Theobald
- RE: ORACLE and SQL mikec
- Re: Oracle and SQL John Stanley
- Re: Oracle and SQL Michael Thomas
- RE: Oracle and SQL mherbene
