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
- Nginx redirect www to non www domain
- HashDOS and ColdFusion
- HackMyCF Updated for APSB11-29 Security Hotfix
- Adobe eSeminar on FuseGuard
- Determining Which Cumulative Hotfixes are Installed on ColdFusion
- Adding Two Factor Authentication to ColdFusion Administrator
- ColdFusion Developer Week at Adobe.com
- Bug Loading Scripts for CFFileUpload and CFMediaPlayer
