Seth,
Thank you, this seems to be good material to soak up.
Mark
On Jun 6, 2006, at 1:58 PM, <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> wrote:
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_Application
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/
