<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]

Reply via email to