Solved

Simple access DB search & shopping cart using CF

Posted on 2004-04-15
7
191 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

SSL stands for “Secure Sockets Layer” and an SSL certificate is a critical component to keeping your website safe, secured, and compliant. Any ecommerce website must have an SSL certificate to ensure the safe handling of sensitive information like…
Original post  on Monitis Blog. Web performance monitoring is broken into two camps: passive and active. Passive monitoring is defined as looking at real-world historical performance by monitoring actual log-ins, site hits, clicks, requests for …
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
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.
Suggested Courses

627 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