in the SQL query to specify start and end rows?
I'm outputting the info to an html table and want to have a NEXT 10
records button. I know I can do this on the <cfoutput query="blah"
startrow="20" endrow="30"> but that means everytime that page loads it's
getting all the rows from the database.
Cheers,
Stuart
-----Original Message-----
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: 03 February 2004 11:29
To: CF-Talk
Subject: RE: Get Records
SELECT Top 10
> -----Original Message-----
> From: Stuart Kidd [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 3 februari 2004 11:24
> To: CF-Talk
> Subject: RE: Get Records
>
> It's Access.
>
> -----Original Message-----
> From: Pascal Peters [mailto:[EMAIL PROTECTED]
> Sent: 03 February 2004 10:21
> To: CF-Talk
> Subject: RE: Get Records
>
> What DB?
>
> > -----Original Message-----
> > From: Stuart Kidd [mailto:[EMAIL PROTECTED]
> > Sent: dinsdag 3 februari 2004 10:58
> > To: CF-Talk
> > Subject: Get Records
> >
> > Hi guys, can someone tell me the way I can specify how many
> records to
> > get, e.g. just the first 10 records?
> >
> > <CFQUERY NAME="DisplayPropertyList" datasource="020"> SELECT
> > PropertyData.PropertyDataID,
> PropertyData.PropertyDataAgentReference,
> > PropertyData.PropertyDataFlatNumberHouseName,
> > PropertyData.PropertyDataStreetNumber,
> > PropertyData.PropertyDataStreetName,
> > PropertyData.PropertyDataPostcodeZip,
> > PropertyData.PropertyDataDateModified,
> > Count(PropertyEnquiry.PropertyEnquiryID) AS countEnquiries FROM
> > PropertyData LEFT JOIN PropertyEnquiry ON
> PropertyData.PropertyDataID
> > = PropertyEnquiry.PropertyDataID WHERE PropertyAgentID =
> > #Client.PropertyAgentID# GROUP BY PropertyData.PropertyDataID,
> > PropertyData.PropertyDataAgentReference,
> > PropertyData.PropertyDataFlatNumberHouseName,
> > PropertyData.PropertyDataStreetNumber,
> > PropertyData.PropertyDataStreetName,
> > PropertyData.PropertyDataPostcodeZip,
> > PropertyData.PropertyDataDateModified
> > ORDER BY #URL.SortBy#
> > </CFQUERY>
> >
> > Cheers,
> >
> > Stuart
> >
> > Ps: (I am going to start sticking in cfqueryparam tags,
> just working
> > on
> > them!)
> >
> >
> >
> _____
>
>
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
