Cache the query and then use the MAXROWS / STARTROWS attributes in the CFOUTPUT.
Works like a charm for me.
Dave
=================================
"Always Drink Upstream From The Herd!"
David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524
----- Original Message -----
From: Troy Johnson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 11, 2000 9:44 AM
Subject: Can you pass a query??
Let's say I had a query that has 10 rows, but I only want to display 5 rows
at a time. A link will then call the same tag do display the next 5 rows.
How can I do this without running the query each time?
Can I pass a query as a url variable?
Can I put the query into an array and pass the array?
thanks in advance,
Troy
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to
[EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.