The only time I've ever done this, to return a staggered result to Flex, I had to create a new query and stick the rows I wanted in to it.... It was a bit of a pain!
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joe Eugene Sent: Friday, 14 October 2005 10:48 a.m. To: [email protected] Subject: Re: [CFCDev] spliting recordset What is the usage? Are you trying to do pagination? If so, splitting the dataset is probably not the best approach. On 10/13/05, Nathan Strutz <[EMAIL PROTECTED]> wrote: > cfloop, or query of queries, or select 50 at a time from the database. > > -nathan strutz > http://www.dopefly.com/ > > On 10/13/05, Ung, Seng <[EMAIL PROTECTED]> wrote: > > > > > > <cfQuery name="getData" datasource="#Application.dsn#" > > > SELECT * from employee > > </cfquery> > > > > ---> Query will returns 100 records > > > > What is the best way to split the first 50 assigned to dataset1 and > > the last 50 assigned to dataset 2? > > > > ie: > > dataset1=getdata[1] to getdata[50] > > > > dataset1=getdata[51] to getdata[100] > > > > Thanks > > seng > > ---------------------------------------------------------- > > You are subscribed to cfcdev. To unsubscribe, send an email to > > [email protected] with the words 'unsubscribe cfcdev' as the > > subject of the email. > > > > CFCDev is run by CFCZone (www.cfczone.org) and supported by > > CFXHosting (www.cfxhosting.com). > > > > CFCDev is supported by New Atlanta, makers of BlueDragon > > http://www.newatlanta.com/products/bluedragon/index.cfm > > > > An archive of the CFCDev list is available at > > www.mail-archive.com/[email protected] > > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email to > [email protected] with the words 'unsubscribe cfcdev' as the subject > of the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > (www.cfxhosting.com). > > CFCDev is supported by New Atlanta, makers of BlueDragon > http://www.newatlanta.com/products/bluedragon/index.cfm > > An archive of the CFCDev list is available at > www.mail-archive.com/[email protected] > > > ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). CFCDev is supported by New Atlanta, makers of BlueDragon http://www.newatlanta.com/products/bluedragon/index.cfm An archive of the CFCDev list is available at www.mail-archive.com/[email protected] This email contains confidential information. If you are not the intended recipient of this email, please notify Straker Interactive and delete the email. You are not entitled to use it in any way. ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). CFCDev is supported by New Atlanta, makers of BlueDragon http://www.newatlanta.com/products/bluedragon/index.cfm An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
