Solved

Simple access DB search & shopping cart using CF

Posted on 2004-04-15
7
176 Views
Last Modified: 2013-12-24
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!
0
Comment
Question by:psychotiK
  • 3
7 Comments
 
LVL 18

Expert Comment

by:Plucka
ID: 10837552
It's not too hard!

But you can't expect someone is going to explain how to write a cart in the forum, there's lots around if you go searching.

As for your database it's easy, no need to change the existing database by the sounds of things.

<cfquery name="GetProducts">
        select *
        from products
        where name like '%#keyword#%'
        or colour like '%#keyword#%'
</cfquery>
0
 

Author Comment

by:psychotiK
ID: 10837565
ok, the products will also have to be expandable, so when the results show up, the user can click on one and see detailed information, and then a button "add to cart" incase they wanna buy.
0
 
LVL 18

Accepted Solution

by:
Plucka earned 63 total points
ID: 10837675
That's easy.

Just have a link at the end of the line that takes you to a productview.cfm?productid=#productid# page.

The productview page reads info for just the passed product and displays it with the add to cart button etc.
0
 
LVL 35

Assisted Solution

by:mrichmon
mrichmon earned 62 total points
ID: 10843096
You can look into Cartweaver which is made to work with Dreamweaver and from what I hear and have demoed meets all of your requirements and is easy to customize :

http://www.cartweaver.com/
0
 
LVL 18

Expert Comment

by:Plucka
ID: 10856611
Plucka,

Any luck?

Regards
Plucka
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Redundant SQL Servers Without Clustering 7 107
Problem to get function 52 106
Webserver access problem 5 73
business account would work but I have a regular paypal account 2 82
Often people are aiming at development of perfect Magento websites. Though, it is easier said than done. You know what’s much easier? To ruin everything. It can be done in seconds. Many of us experimented with design, tried to change some values dir…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question