[thelist] CF: grouping output by date & Access
Frank
frank at loofahcom.com
Thu Aug 30 04:36:44 CDT 2001
<tip type="Cold Fusion" author="Frank Marion">
I wanted to group some articles by publication date. Easy: group by date,
right? When using MS Access, the field type is date/time. If one use's
Access's Now() function as the default for the field, every record will be
different, because they will all be inserted at different times, defeating
the ability to group by date. The solution is to insert an ODBC date
programmatically. If no time is specified, access will still include a
time, but will default to 00:00:00
</tip>
More information about the thelist
mailing list