How 'bout <cfif len(arguments.asking1) or len(arguments.asking2)> <cfif len(arguments.asking1)> price = #arguments.asking1#, <cfelse> price = #arguments.asking2#, </cfif> <cfelse> price = 0, </cfif>
----- Original Message ----- From: "Doug Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Thursday, December 21, 2006 4:15 PM Subject: <CFIF>? >I am having some troubles with an if statement and cannot seem to get it >right. I have 2 text fields that hold the value of the price of items a >user is selling, a user can fill in either one of the fields or none at >all. If the user chooses not to fill in these fields, then I want to add a >default value of 0 to the price in the database. > > > I am using this so far with not luck. I tried using <CFELSEIF> with no > luck either. In the below code, I will get two price objects due to one or > both fields being empty. > > <cfif arguments.asking1 IS NOT ""> > price = #ARGUMENTS.asking1#, > </cfif> > > <cfif arguments.asking2 IS NOT ""> > price = #ARGUMENTS.asking2#, > </cfif> > > <cfif arguments.asking1 IS "" AND arguments.asking2 IS ""> > price = NULL, > </cfif> > > > > Doug B. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264855 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4