Remove the date from the query. On 10/2/07, Travis Haley <[EMAIL PROTECTED]> wrote: > Thanks for all the help so far I know I'm almost there > > I figured out that all the items in the select need to be in the group by > clause, however what is causing the problem is the date. When I run the > query without the date it runs fine (actually I had to remove the FullName > and break it into pat_First, Pat_Last) but I assume the GROUP BY is wanting > everything the same before it adds them together. Well the date is the same > but the time is different causing the entries to not match exactly and > therefore will not add them together
-- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289877 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
