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" <[email protected]>
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
