Hi, Mosh.
Yes, the CFOUTPUT's were the problem...leaving them out solved the issue.
Thanks for the tip...
Rick
> -----Original Message-----
> From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 18, 2003 4:08 PM
> To: CF-Talk
> Subject: RE: Can anyone explain why this code is behaving like it is?
>
>
> > <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=708.628.4
>
> Get the mailserver that powers this list at
> http://www.coolfusion.com
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137630
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
