> Interested in hearing more about the cfqueryparam tag... 4.5 version
> addition I suspect?
I think it was introduced in CF 4.0.1, but I'm not sure - it may have been
introduced in CF 4.5.x. There isn't much to say about it - you can use it
within a CFQUERY tag to wrap a variable that you're passing into your SQL
string. This can improve both security and performance. When you use it,
you're building what's usually called a "prepared statement", in which the
variables are replaced by placeholders, allowing the SQL engine to parse the
statement itself before inserting the variables. The CFQUERYPARAM creates
what's called a "bind parameter", which is the variable passed along with
the prepared statement.
Oracle especially seems to get a performance boost from using prepared
statements.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
