Simple access DB search & shopping cart using CF
Posted on 2004-04-15
Here's the scoop: I have a simple access DB with some products in it, primary key is product ID and foreign key's are the colour of the product. I need to make this searchable via some easy criteria, like colour or product name, using CF. I also need a shopping cart, very simple, where users can add products, decide on quantities, and then click "order" and have the server give them a distinct order ID, and show them their total order (nothing further, so no input of order info or credit card info etc). The DB is a simple MS access one and I would like to use dreamweaver MX for this. Any help would be GREATLY appreciated. Please provide as detailed explanation as possible but I can fill in my specific situational details. Thanks ahead of time!