>
> > If not, then when you get the query back to CF one of the
> > additional columns you get with the query is CurrentRow.
>
> This is one of those "I should have explained it properly at the
> beginning" type situations... :)
>
> What we're attempting to do is to cache a query and then page it by
> using the rowid as a WHERE clause of a QoQ:
>
> <cfquery name="myquery" dbtype="query" maxrows="10">
> SELECT * FROM myoldquery
> WHERE rowid > #thecurrentrowid#
> </cfquery>
>
ummm..... If the query is already cached, then there's no need to requery
it.
In the simplest form you can just use
<cfoutput query="somequery" startrow="#thecurrentrowid#" maxrows="10">
#col1# - #col2#
</cfoutput>
Otherwise, you can do stuff like
<cfset endrow = thecurrentrowid+10>
<cfloop from="#thecurrentrowid#" to="#endrow#" index="thisRow">
#somequery.col1[thisRow]# - #somequery.col2[thisRow]#
</cfloop>
Hope this helps
Regards
Stephen
PS. Thanks for the unix commands guys - worked like a treat!
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
