This content has been marked as final. Show 2 replies
I have a script that loads two pics at once and saves them as individual files. What I am trying to do is grab them individually using min(), max() where date_entered. But, I get the error "You tried to execute a query that does not include the specified expression 'date_entered' as part of an aggregate function." HEre is my code"
<cfquery name="getSire" datasource="#application.database#">
select date_entered, max(pic) as topPic from litters
where date_entered = '7/19/2013'
How can I select the min picture and the max picture by the date it was entered?