2) Is the date field set at date or a db specific equiv?
3) Have you tried to run the query manually to make sure the query is the
problem?
Mike
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 22, 2004 2:29 PM
To: CF-Newbie
Subject: Help with MAX function
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]
