Wow, I can't believe I didn't think of using a temporary table to store the dynamic data while it's being edited, that's a great idea. I can't use session variables because it's a grid and would be considered a complex data type. (I was under the impression that session variables can only hold simple data types...am I mistaken on that?) In any case, you have been so helpful Justin, I really appreciate it. Thanks a bunch.
>> Thanks Justin, I wasn't aware that a dynamic query was lost >> once the page was finished loading. Does the same rule apply >> to structures? > >Yes, that would apply to all variables unless you store them in >persistent memory (e.g. database, session scope, write to a file, >etc.). In your case I would use a separate table in the database to >store their pending order while it's in progress (you could also store >that query object in the session scope if enabled). You can then use >AJAX calls from the HTML page when things change to call a ColdFusion >template (or CFC method) to update their "cart" table before >finalizing it as an order. ColdFusion can return the updated >information via JSON (among other formats) and JavaScript in the HTML >can take that and update the HTML display accordingly. Once the order >is finalized (i.e. they click submit) then it would post to a >ColdFusion page which makes any final adjustments to the cart, >finalizes the order, and removes the temporary cart table entries. >This can also be good for tracking abandoned checkouts since the data >is persistent. > > >-Justin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348602 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
