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]
