Help with MAX function

[Hobbydesigns]

I'm trying to have a query find the most recent date on a specific record search.

Here's the coding:
<cfquery name="dog_search" dbtype="ODBC" datasource="XX">
select max(file_date) from items
where '#prod_group#' = 'AA'
</cfquery>

<cfoutput query="dog_search">
#file_date#
</cfoutput>

.. but to no avail.

Any ideas why ?

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---