Thursday, September 04, 2008

A helpful tip for saving a date and time in Access using ColdFusion

two steps ...

1. Use odbccreatedatetime() so that you have an ODBC object with both date and time, otherwise all Access gets is a date.
2. Use cf_sql_timestamp (you are using cfqueryparam, right?), so that the ODBC driver understands it's getting a date-time parameter.

Ta da! Date and time in your Access database.

No comments:

Post a Comment

There was an error in this gadget