Brian had an interesting question about the cfqueryparam tag:
Question about the cfqueryparam maxlength attribute. I understand that it is (psuedo-)required for string types, but is it used for numerics, integers, or dates? Or does ColdFusion ignore it for non-string datatypes?
For those who aren't familiar with cfqueryparam, stop everything and go straight to the docs for it. The maxlength attribute is typically used for a string. So for example, if you were inserting a name and the size of the column in the database was 50, your tag could look like so:
<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.name#" maxlength="50">
So while this makes sense, what does maxlength do for non-string based column types? Believe it or not, it still gets checked. For example, if you try to pass a number, 999, and the maxlength is 2, ColdFusion will throw an error since the string length (3) is greater than 2.