> -----Original Message-----
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 24, 2002 4:19 PM
> To: CF-Talk
> Subject: Re: ColdFusion MX and Session Variables
>
>
> What about that session.dealer_id?
Yes when adding Testing Variables the out put stayed the same.
Is it staying consistent? What
> about the actual data? Is there some other query somewhere writing
> data that is affecting the price and or quantity variables, which I
> assume are coming from the qry_checkoutcart query, but I'm not sure,
> because they aren't scoped...hint hint :)
They are not scoped because there is a AS400 Query and they can not be
scoped because there is no resultset coming back from the AS400. Price is
not coming from qry_checkoutcart but I guess I could go scope quantity. We
have tried several drivers with ColdFusion MX on a Solaris 7 with Apache
1.3.26 Web Server. When we tried the same thing on the NT it seemed to be
fine. We even created a test page outside the application to verify it was
not linked to any other page.
Who out there is working on a Solaris 7 with ColdFusion and Apache?
Testing Code Below
====================================================================
<cfset request.cartquantity=0>
<cfset request.carttotal=0>
<cfquery name="qry_checkoutcart" datasource="#request.dsnSQL#">
SELECT *
FROM OreckDealerCart
WHERE OreckDealer_id = #session.dealer_id#
</cfquery>
<cfif qry_checkoutcart.recordcount eq 0>
<cfelse>
<cfset counter=0>
<cfoutput query="qry_checkoutcart">
<!--- removed AS400 Query here to get the PRICE --->
<cfset price = price*100>
<cfset subtotal=#price#*#qry_checkoutcart.quantity#>
<cfset request.carttotal=#request.carttotal#+#subtotal#>
<cfset
request.cartquantity=#request.cartquantity#+#qry_checkoutcart.quantity#>
<!---
STILL WORKING HERE:
======================
--->
#session.dealer_id#<br>
#session.carttotal#<br>
#session.cartquantity#<br>
#price# X #quantity# = #subtotal#<br>
</cfoutput>
<cfoutput>
<a href="index.cfm?fuseaction=checkout">
<img src="/oreckdealer/images/icons/dealer_cart.gif" border="0"
alt="View Cart">
</a>
<!---
WRONG INFORMATION COMES OUT HERE:
--->
#session.cartquantity# Items #dollarformat(session.carttotal)# Total
</cfoutput>
</cfif>
>
> --
> Jon
> mailto:[EMAIL PROTECTED]
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
