CFParam, unless you want to go the multiline route:
<cfif structKeyExists(form, "myVar")>
<cfqueryparam type="cf_sql_integer" value="#form.myVar#" />
<cfelse>
<cfqueryparam type="cf_sql_integer" value="" isNull="Yes" />
</cfif>
But you can't go <cfqueryparam type="cf_sql_integer" value="#form.myVar#"
isNull="#NOT
isNumeric(form.myVar)#" />
because value="#form.myVar#" will fail to compile if form.myVar doesn't
exist.
----------------------------------------
From: "Dave Watts" <[email protected]>
Sent: Monday, May 03, 2010 12:05 PM
To: "cf-talk" <[email protected]>
Subject: Re: <cfqueryparam> question ("null" attribute)
> I think the point is that if you're going to use any of those
techniques,
> you DO have to param the variable, or use some other mechanism to make
sure
> the variable exists. Otherwise the code in your "value" attribute will
> always fail when the variable doesn't exist. Make sense?
Yes. This is the part that, in my initial reading, I didn't even see.
This doesn't have anything to do with CFQUERYPARAM per se, it's just
that you can't reference a variable that doesn't exist at all.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333296
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
