Save your self some typing

coldfusion

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_?



Related Entries

4 people found this page useful, what do you think?

 Download FuseGuard WAF for ColdFusion

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




  



Spell Checker by Foundeo

Recent Entries



foundeo


did you hack my cf?