reducing a query result

Say I have a query returned with 500 records. Is there a way in CF (not SQL) to reduce the query to only rows 1-50, 51-100 etc? I talking physically reducing the query object. ~| Want to reach the ColdFusion community with so

RE: reducing a query result

Query the query using the same query variable name. Adrian > -Original Message- > From: Chad Gray [mailto:cg...@careyweb.com] > Sent: 04 June 2009 16:07 > To: cf-talk > Subject: reducing a query result > > > Say I have a query returned with 500 records. >

RE: reducing a query result

Oh ya... duh. I kept thinking of using functions to do it. Guess I need another cup of coffee. Thanks! > -Original Message- > From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] > Sent: Thursday, June 04, 2009 11:11 AM > To: cf-talk > Subject: RE: reducing

Re: reducing a query result

Hey Chad, It's kind of an odd questions. Can you tell us what you are trying to accomplish? So often on these lists people ask about their solution, not their problem... I'm guess you don't really want to reduce the query, you don't want it to dump out 500 records on a page. Instead you want some

RE: reducing a query result

To: cf-talk > Subject: Re: reducing a query result > > > Hey Chad, > It's kind of an odd questions. Can you tell us what you are trying to > accomplish? So often on these lists people ask about their solution, not > their problem... > > I'm guess you don't

Re: reducing a query result

Coolio... If you ever need my good friend Nathan Strutz wrote a great tool for pagination http://www.dopefly.com/projects/pagination/ Sure saves a lot of time... =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix

Re: reducing a query result

All I can say is wow! -- Ryan On Thu, Jun 4, 2009 at 10:24 AM, Alan Rother wrote: > > Coolio... > If you ever need my good friend Nathan Strutz wrote a great tool for > pagination > > http://www.dopefly.com/projects/pagination/ > > > Sure saves a lot of time... > >

Re: reducing a query result

- From: "Chad Gray" To: "cf-talk" Sent: Thursday, June 04, 2009 10:07 AM Subject: reducing a query result > > Say I have a query returned with 500 records. > > Is there a way in CF (not SQL) to reduce the query to only rows 1-50,

Re: reducing a query result

+ 1 billion for pagination.cfc It "just works". But for the record blockfactor maxrows can be used to limit the number of rows returned. On Thu, Jun 4, 2009 at 11:24 AM, Alan Rother wrote: > > Coolio... > If you ever need my good friend Nathan Strutz wrote a great tool for > pagination > > h

RE: reducing a query result

com] Sent: Thursday, June 04, 2009 10:07 AM To: cf-talk Subject: reducing a query result Say I have a query returned with 500 records. Is there a way in CF (not SQL) to reduce the query to only rows 1-50, 51-100 etc? I talking physically reducing the qu

Re: reducing a query result

n by a coworker of mine on Ext data grids: > http://blog.cutterscrossing.com/index.cfm/2007/4/24/My-First-ExtJS-DataGrid- > Pt-1 > > > andy > > -Original Message- > From: Chad Gray [mailto:cg...@careyweb.com] > Sent: Thursday, June 04, 2009 10:07 AM > To: cf