One other item to consider is using the cf_sql type of cf_sql_timestamp rather than cf_sql_date.
Good luck, Tom -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, June 06, 2006 11:58 AM To: 'Dallas/Fort Worth ColdFusion User Group Mailing List' Subject: RE: [DFW CFUG] Newbie Confusion: Dateformat from SQL I was going to let this thread go by, but I was alarmed at the volume of well-intentioned but not necessarily helpful advice. So here's my 2 cents. Your best bet is to use cfqueryparam with the createodbcdate() function within the <cfquery>, per Dave Shuck's suggestion, for a number of reasons, including: o Performance (not necessarily in this case, but as a rule of thumb) o Security o Ease of maintenance/portability (across db platforms) Do some reading on what cfqueryparam is and how it works, in the WACK if you have it, and/or on Adobe's site (see below). As a best practice, you should use this whenever possible in all of your queries. CFQUERYPARAM and Oracle Databases http://www.macromedia.com/v1/handlers/index.cfm?id=17324 Faster and safer database queries using the <CFQUERYPARAM> tag http://www.adobe.com/devnet/coldfusion/articles/ben_forta_faster.html Docs and Stuff http://livedocs.macromedia.com/coldfusion/7/htmldocs/00000317.htm http://livedocs.macromedia.com/coldfusion/7/htmldocs/00001257.htm http://livedocs.macromedia.com/coldfusion/7/htmldocs/00001371.htm http://livedocs.macromedia.com/cfmxdocs/Developing_ColdFusion_MX_Applica tion s_with_CFML/formatData3.htm Take Care, Seth _______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/ _______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
