> <CFSET Temp = QuerySetCell(Session.Cart, "Amount",
> "<CFOUTPUT>#Evaluate(Form.S4x6 * 3.95)#</CFOUTPUT>")>
Rick:
What are the CFOUTPUT tags doing in your CFSET tag? Shouldn't this just be:
<CFSET Temp = QuerySetCell(Session.Cart, "Amount", Evaluate(Form.S4x6 *
3.95))>
My guess is that your SESSION.cart.amount variable is really equal to:
<CFOUTPUT>11.85</CFOUTPUT>
and when that string gets spat out to the browser in the error message, your
browser is hiding the CFOUTPUT tags because it assumes they are HTML tags
that it is unfamiliar with. Check the HTML source code.
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
> -----Original Message-----
> From: Rick Faircloth [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 18, 2003 3:39 PM
> To: CF-Talk
> Subject: Can anyone explain why this code is behaving like it is?
>
>
> This stuff is driving me crazy! All day spent to get almost nowhere...
>
> Anyway...(deep breath)...
>
> Quick question: Does taking a number from a formfield and putting it into
> a "session.cart.amount" variable automatically turn it into a string
> variable?
>
> I'm sending a number from a formfield and in testing the amount from the
> formfield,
> I can multiply it, format it using DollarFormat, etc... behaves like a
> number should.
>
> But once the formfield variable is placed in the Session Query as
> session.cart.amount,
> it behaves like a string...I can't use DollarFormat...it returns an error
> that the variable session.cart.amount
> has to be a number...if I use DollarFormat(Val(session.cart.amount)), the
> value of the variable is 0...zero...
> it becomes a valueless string...
>
> I've haven't worked with the "session-type" queries created with
> Session.Cart = QueryNew etc., before
> and I guess I'm missing something...this should be simple stuff...but...
>
> If anyone has any suggestions about why this is going on, I'd be grateful
> for the help...
>
> Rick
>
>
> Excerpts from the code:
>
> The formfield:
>
> <SELECT Name="S4x6" Class="TextInput01">
>
> <Option Value="0" Selected>0</Option>
> <Option Value="1">1</Option>
> <Option Value="2">2</Option>
> <Option Value="3">3</Option>
> <Option Value="4">4</Option>
> <Option Value="5">5</Option>
> <Option Value="6">6</Option>
> <Option Value="7">7</Option>
> <Option Value="8">8</Option>
> <Option Value="9">9</Option>
> <Option Value="10">10</Option>
>
> </SELECT>
>
>
>
> Sent to another page for processing:
>
>
>
> <CFLOCK Scope="Session" Type="Exclusive" TimeOut="5">
>
> <CFSET Session.Total = 0>
>
> <CFIF Form.S4x6 is not "0">
>
> <CFSET Temp = QueryAddRow(Session.Cart)>
> <CFSET Temp = QuerySetCell(Session.Cart, "PhotoFileName",
> "<CFOUTPUT>#Form.PhotoFileName#</CFOUTPUT>")>
> <CFSET Temp = QuerySetCell(Session.Cart, "Quantity",
> "<CFOUTPUT>#Form.S4x6#</CFOUTPUT>")>
> <CFSET Temp = QuerySetCell(Session.Cart, "Size", "4 x 6")>
> <CFSET Temp = QuerySetCell(Session.Cart, "Amount",
> "<CFOUTPUT>#Evaluate(Form.S4x6 * 3.95)#</CFOUTPUT>")>
>
> <CFOUTPUT>#DollarFormat(Session.Cart.Amount)#</CFOUTPUT><br>
>
>
> -----------------Note: CURRENTLY, ON THE LINE ABOVE, I GET THE FOLLOWING
> ERROR:
>
> Parameter 1 of function DollarFormat which is now "11.85" must be a number
>
> I've tried using Val to create a number out of what must be a string, but
> that will create a variable with a value of 0 (zero)...
>
> ------------------------------------------------------------------
> ----------
> -------------------------------------------------------
>
> </CFIF>
>
> <CFLOOP Query="Session.Cart">
>
> <CFOUTPUT>
> PhotoFileName: #PhotoFileName#
> Quantity: #Quantity#
> Size: #Size#
> Amount: #DollarFormat(Amount)#
> </CFOUTPUT>
>
> <CFOUTPUT>#DollarFormat(Amount)#</CFOUTPUT>
>
> <CFSET Session.Total = Evaluate(Session.Total+Session.Cart.Amount)>
>
> </CFLOOP>
> <br><br>
>
> Order Total: <CFOUTPUT>#DollarFormat(Session.Cart.Amount)#</CFOUTPUT>
>
> </CFLOCK>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137595
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Get the mailserver that powers this list at
http://www.coolfusion.com
