Rick, I think he is looking for an interface widget.

----- Original Message -----
From: "Rick Lamb" <[EMAIL PROTECTED]>


> 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]]
>
>
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to