2 Replies Latest reply: Jul 22, 2013 12:55 AM by rickaclark54 RSS

    How can I grab the min pic and max pic by the date entered?

    rickaclark54

      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'

      </cfquery>

       

      How can I select the min picture and the max picture by the date it was entered?