Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RockbridgeBob

    Can't output aggregate query

    Thanks! That last suggestion was the solution. It seems that the date that I was using was not being interpreted correctly, so no records matched, and no sum was being calculated. However, the query would respond with 1 record - a blank one. Your code helped to clear that up. Thanks again
  2. RockbridgeBob

    Can't output aggregate query

    Actually I have tried that with no success. The page processes without error, but also with nothing showing in the location that CFOUTPUT is located.
  3. RockbridgeBob

    Can't output aggregate query

    I have a query as follows: <cfquery name=&quot;KAMLate&quot; datasource=&quot;directory&quot;> select sum(TotalLate) as tLate from AttendanceSum where Room='K-am' and Date=#Date# </cfquery> It does not give any errors. The purpose is to total all of the values in the TotalLate field. The...

Part and Inventory Search

Back
Top