Bob,
Sounds to me like your talking about an everyday shopping cart. I would use
a associative array (structure) to store all the items names and values for
each item and then append each of these structures to an array. At the end
of the order, just loop through the array and output the structures (or line
items) into the database. Make sure you have your line item table set up
with a foreign key to the parent order table by using an order id. Then to
pull an order just join the two tables by the order id.
If none of this makes sense to you, just look at some tutorials on doing a
shopping cart in Cold Fusion and they should give you the ideas you need.
Rick
-----Original Message-----
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 8:32 AM
To: CF-Talk
Subject: Unlimited Line Item Subform functionality in a <FORM>
Hi all,
Here's the scenario: A user is entering an order, the order will have some
info associated with it, and then the order can have multiple line items
added to it. Each line item will have a number of attributes (like product,
quantity, etc.). In a program like Access, you can create a form for the
Order, and then create a subform for the line items. You can easily set it
up so that the user can enter as many line items as they like. After they
enter a line item, the interface adds a new blank line item.
We need to replace an Access application with a ColdFusion application and
provide this same functionality. If we have to, we could provide input
fields for a specific number of line items, and then provide a button to add
more items, but I was wondering if anyone knows of any custom tags, applets
or ActiveX controls that would provide this functionality. Or perhaps I'm
missing an obvious easy solution.
Any suggestions would be greatly appreciated.
Thanks,
Bob
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
