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!

Recent content by RockbridgeBob

  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...
See more

Part and Inventory Search

Back
Top