http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-25T15:03:40 en-us http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functio6.htm#17359 FYI, coldfusion/java incorrectly stores the a default MySQL datetime of 0000-00-00 00:00:00 as 0002-11-30 00:00:00.0 due to the fact that is not a valid datetime in Java. Java automatically stores it as a default escape string of 0002-11-30 etc. Beware of using MySQL default datetime escape string - use NULL instead<br /><br />More info about this, now classified, NON-bug at:<br />http://bugs.mysql.com/bug.php?id=3331<br /><br />.pjf MaestroFJP 0 0 2004-06-21T07:55:47