pf » Save your self some typing
April 07, 2005
Save your self some typing
If you want to save yourself some typing, note that cf_sql_varchar is the default value for the cfsqltype attribute in the cfqueryparam tag.
So you can omit the cfsqltype attribute, if your type is cf_sql_varchar at the expense of some readability.
I probably would not mention this if cfqueryparam was not so verbose. Why not type="varchar" what's with all the cfsql/cf_sql_?
add to del.icio.usRelated Entries
- Mastering CFQUERYPARAM - July 24, 2008
- 6 Tags for ColdFusion beginners - April 5, 2005
Trackback Address: 313/6C9BB6CF2D643005778BAAE6E50A0922
Comments
On 04/07/2005 at 1:02:43 PM MDT Ryan Guill wrote:
1
Ah, great tip. You're right, cfqueryparam is horribly verbose, if nothing else this may improve readability...
On 04/07/2005 at 1:33:10 PM MDT Barney wrote:
2
That's what code snippets are for, and when you bind them to a keyboard shortcut (as most editors aside from DWMX let you do), it becomes even less typing. For example, I've got a CFQP for integer, timestamp, and varchar mapped to different keys, so I can insert them with a single (compound) keystroke.
- Dear SQL Server Enterprise Manager Developer
- PostalMethods - Web Service for Snail Mail
- Mastering CFQUERYPARAM
- Google Code Search for ColdFusion
- Speaking at CFUNITED 2008
- Getting ColdFusion SQL Statements from SQL Server Trace
- CFSCRIPT Cheatsheet
- 3 New Image Effects for ColdFusion 8
Subscribe to my RSS Feed: 
RSS
RSS
Pete Freitag is a software engineer, and web developer located in central new york.
Pete's company Foundeo Inc. builds products for web developers and provides consulting services.
In 2003 Pete published the ColdFusion MX Developers Cookbook with SAMs Publishing.
More about Pete.
Use SoloSub to subscribe to my RSS feed using Bloglines, MyYahoo, NewsGator, and more.