Save your self some typing
April 07, 2005
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_?
Tweet
add to del.icio.usRelated Entries
- Mastering CFQUERYPARAM - July 24, 2008
- 6 Tags for ColdFusion beginners - April 5, 2005
Trackbacks
Trackback Address: 313/6C9BB6CF2D643005778BAAE6E50A0922
Comments
On 04/07/2005 at 3:02:43 PM EDT 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 3:33:10 PM EDT 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.
Post a Comment
Recent Entries
- Firefox Aurora now Supports Content Security Policy 1.0
- Writing Secure CFML cfObjective 2013 Slides
- Upgrading to Java 7 on Linux
- J2EE Sessions in CF10 Uses Secure Cookies
- Learn about ColdFusion Security at cfObjective 2013
- Session Loss and Session Fixation in ColdFusion
- FuseGuard 2.3 Released
- CKEditor Spell Checker Plugin
