home Links Articles Books Past Meetings Photos SiteMap
The MDCFUG is sponsored by TeraTech. Visit us at www.TeraTech.com

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-2017, Maryland Cold Fusion User Group. All rights reserved.
< >