pf » Save your self some typing

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?

Trackback Address: 313/6C9BB6CF2D643005778BAAE6E50A0922
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.




  



Spell Checker by Foundeo





Subscribe to my RSS Feed: solosub RSS
Tags