Troy,
Use a cached query, then set your output to loop from a given start row to a
given endrow (thse can be passed in the url)
i.e. [Pseudo Code]
<cf query=myquery datasource=dsn cachedwithin=createtimespan(0,0,2,0)>
SELECT etc etc etc
</cfquery>
<cfloop query=myquery from=startrow to=endrow>
<cfoutput>
Query results
</cfoputput>
</cfloop>
Hope this helps
Dave
Dave Wilson
Internet Technology Manager,
BizNet Solutions
<Allaire Premier Partner>
Co-Founder CFUG Ireland
http://www.cfug.ie
224, Lisburn Road
Belfast BT9 6GE
Tel: 02890 225 776
Fax: 02890 223 223
web: http://www.biznet-solutions.com
email: [EMAIL PROTECTED]
----- Original Message -----
From: Troy Johnson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 11, 2000 3:44 PM
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.
