Is there a way that i can make the query only group by the date portion of the datetime stamp as this will then allow me to group all records of the same date together and then sort said grouped records by the complete date value which includes the date value.
<CFQUERY NAME="mycalendar1" dbtype="query">
select starttime, [from] as sentfrom, endtime, subject, duration, location, message, organizer, htmlmessage, requiredattendees
from mycalendar
group by starttime, endtime, subject, sentfrom, duration, location, message, organizer, htmlmessage, requiredattendees
order by starttime
</cfquery>
Regards
Claude Raiola
B.Econ (Acc), B.Hot.Mngt.
Websites:
www.AustralianAccommodation.com
www.SAMARIS.NET
www.WebSiteSolutions.com.au
Mobile: 0414 228 948
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---
