Joe: An exam that I was giving out to my students. I want them to see how others responsed.
Thanks Seng -----Original Message----- From: Joe Eugene [mailto:[EMAIL PROTECTED] Sent: Thursday, October 13, 2005 2:48 PM 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] ---------------------------------------------------------- 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]
