Hi Peter,
I asked this question a month ago, and here is one of the responses I
recieved:
(from Dan Haley, I believe)
"The easiest way to cache the query is with the 'cachedwithin' attribute of
<cfquery>. For example <cfquery name="myQuery" datasource="myDataSource"
cachedwithin="#createtimespan(0,0,30,0)#"> would cache your query for 30
minutes. The only time the page will be slowed down is every 30 minutes
when the query refreshes, and the caching time can be changed easily
depending on how often your data changes.
For displaying 10 rows at a time, use the 'startrow' and 'maxrows'
attributes of <cfoutput>. <cfoutput query="myQuery" startrow="11"
maxrows="10">.
There are other ways to do this, but if this meets your needs it is most
likely the simplest."
Dana
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
