Since you're on CF9:
<cfqueryparam value="#isDefined('form.myVar')?form.myVar:''#"
null="#!isDefined('form.myVar')#" />
The (new in CF9) ?: operator only evaluates the true-expr if the
condition is true.
On Mon, May 3, 2010 at 8:12 AM, Matthew Lowrey <[email protected]> wrote:
> This is getting to be quite an interesting challenge. All the examples I've
> seen logically make sense but none of them have worked so far. I will say
> I'm learning quite a bit from everyone's knowledge/wisdom. I will try and
> list here all the different methods I've tried out and have failed. First,
> the method I've used (and still using):
>
> <cfif isDefined("form.myVal")><cfqueryparam cfsqltype="cf_sql_varchar"
> value="#form.myVal#" maxlength="50"><cfelse><cfqueryparam null="yes"></c
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:333301
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
