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

Reply via email to