Please send
comments/questions to
michael@
teratech.com
<CFQUERYPARAM>
<CFQUERYPARAM>
Parsing, validating, and analyzing the query can take longer than actually processing it
Simple queries are easy to cache.
SELECT id, FirstName, LastName
FROM Employees
It’s a waste of time and space to cache dynamic queries, perfert for cfqueryparam.
SELECT id, FirstName, LastName
FROM Employees
WHERE ID = <cfqueryparam value=“150" cfsqltype="CF_SQL_NUMERIC">
<CFQUERYPARAM> helps differentiate what is dynamic in the SQL statement
Previous slide
Next slide
Back to first slide
View graphic version
Home
|
Links
|
Articles
|
Past Meetings
|
Meeting Photos
|
Site Map
About MDCFUG
|
Join
|
Mailing List
|
Forums
|
Directions
|
Suggestions
|
Quotes
|
Newbie Tips
TOP
Copyright © 1997-2024, Maryland Cold Fusion User Group. All rights reserved.
< >