Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 209
  • Last Modified:

Simple access DB search & shopping cart using CF

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
psychotiK
Asked:
psychotiK
  • 3
2 Solutions
 
PluckaCommented:
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
 
psychotiKAuthor Commented:
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
 
PluckaCommented:
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
 
mrichmonCommented:
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
 
PluckaCommented:
Plucka,

Any luck?

Regards
Plucka
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now