The default cfsqltype for cfqueryparam

Updated June 27, 2024, First Published April 7, 2005 by Pete Freitag

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

Update: As of ColdFusion 11 you can omit the cf_sql_ prefix on the cfsqltype attribute of the cfqueryparam tag.