Scott, As for ORM frameworks it was only a suggestion....
Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Wednesday, 27 June 2007 11:27 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Cfqueryparam and Dates err, I think that would have to be (on Update): <cfif WARD_HIST.END neq ""> mydatefield = <cfqueryparam cfsqltype="cf_sql_timestamp" value="#CreateODBCDateTime(WARD_HIST.END)#" /> </cfif> ? And if I leave it out, the fields keeps the same value..... I think I will go with the approach below. I think if I were starting a new project I would look into these fandangled frameworks, but meanwhile I am stuck with the current coding standard (or lack thereof.. Its not my system, and the guy who owns it will never change!). I must confess that every time I start looking into them after a few hours I get too confused over the many choices and give up at the moment. No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.9.9/872 - Release Date: 26/06/2007 6:43 PM --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---