I've got a bit a code the can track what pages users are viewing on my web site in real time. It works great. I'd like to expand on that code to see what is in their shopping basket in real time. I'm using CF 5.0.
I use Client variables to store shopping basket variables w/in a database. var ShoppingBasket is a structure that is stored as a WDDX Packet. I use a query like the one below to select the Client variable that contains the ShoppingBasket structure as well as all other variables that are tied to the respective CFID & CFTOKEN. <cfquery name="getCartInfo" datasource="#DSN#"> SELECT DATA FROM CDATA WHERE APP='MY_APP' AND CFID='#Application.WhoIsOnArray[idx][1]#' </cfquery> When I loop over all of the 'live' customers, to create my report... I can't seem to extract the WDDX packet (the ShoppingBasket struct) no matter what I try. <cfdump> doesn't work. I cannot deserialize the variable. I get an error that the provided string is not a valid WDDX packet. Any ideas??? Below is what the 'struct' Shoppingbasket looks like. May be that will help. <wddxPacket version='1.0'><header></header><data><struct><var name='2790'><array length='9'><string>7142</string><string>1</string><string>13.9500</string><s tring>Size 0 (Child Size 12-14) - Ea.</string><string>2790</string><string>10.2500</string><string>0</string>< string>ProForce 5oz. Ultra Lightweight TKD Student Uniform</string><string>2788</string></array></var></struct></data></wddxPac ket> Thanks, Che ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207807 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
