Pete Freitag Pete Freitag

Another Reason to use CFQUERYPARAM

coldfusion

A question posed on the BlueDragon Interest list today by Jeff Houser revealed another advantage to using CFQUERYPARAM in your queries.

Since CFML accepts several valid values for boolean values (0/1, yes/no, true/false). When it comes time to use one of these values in a database query you typically want to use the 0/1, but if the variable resolves to a Yes/No value your database server will throw an exception. Guy Rish suggested that if you use CFQUERYPARAM you can force the proper datatype using the cfsqltype attribute.


Like this? Follow me ↯

Another Reason to use CFQUERYPARAM was first published on March 08, 2004.

FuseGuard Web App Firewall for ColdFusion

The FuseGuard Web Application Firewall for ColdFusion & CFML is a high performance, customizable engine that blocks various attacks against your ColdFusion applications.