Assuming you have 100 records. SELECT TOP 50 * from employee Order by EmpoyeeID
SELECT TOP 50 * from employee Order by EmpoyeeID DESC 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]
