What about that session.dealer_id? 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 :)
-- Jon mailto:[EMAIL PROTECTED] Wednesday, July 24, 2002, 4:10:36 PM, you wrote: NS> ColdFusion MX and Session Variables... NS> ColdFusion MX on a Solaris 7 with Apache 1.3.26 Web Server NS> When I use Session Variables and set a total price to 527 the Session NS> variable would change Randomly too 1052 or 827 and other such numbers. NS> I took the exact same code and made them all Request Variables and it did NS> not change at all. NS> Why is this happening? Is this a know bug. NS> Code Below NS> ==================================================================== NS> <cfset request.cartquantity=0> NS> <cfset request.carttotal=0> NS> <cfquery name="qry_checkoutcart" datasource="#request.dsnSQL#"> NS> SELECT * NS> FROM OreckDealerCart NS> WHERE OreckDealer_id = #session.dealer_id# NS> </cfquery> NS> <cfif qry_checkoutcart.recordcount eq 0> NS> <cfelse> NS> <cfset counter=0> NS> <cfoutput query="qry_checkoutcart"> NS> <!--- removed AS400 Query here to get the price ---> NS> <cfset price = price*100> NS> <cfset subtotal=#price#*#quantity#> NS> <cfset request.carttotal=#request.carttotal#+#subtotal#> NS> <cfset request.cartquantity=#request.cartquantity#+#quantity#> NS> </cfoutput> NS> <cfoutput> NS> <a href="index.cfm?fuseaction=checkout"> NS> <img src="/oreckdealer/images/icons/dealer_cart.gif" border="0" alt="View Cart">> NS> </a> NS> #request.cartquantity# Items #dollarformat(request.carttotal)# Total NS> </cfoutput> NS> </cfif> NS> ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
