YA!!!!!!!!!!!!!!!!!!!!!!!! SEAN WINS THE PRIZE!! Thank you Mr. Corfield. This
worked beautifully and better yet I didn't have to set anything or cfif
anything, just one tag with everything all inside of it. Thanks a million x
yourVal
Matt...
> 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:333306
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm