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