uShop English (U.S.) for 179!

uStorekeeper English (U.S.) for 149!

 Tech Support
       Support Policy
       Knowledge Base
       Reference Sites
       Software Piracy
       Legal Notices
       Privacy Policy
       Reseller Info
       Contact Us
       Site Map
Database in MS Access 2000 - 3000 products?!

Knowledge Base Lobby : uShop Support Conference : Programmer Tips
Jul-16-18 06:11 AM EST
Original Message
Database in MS Access 2000 - 3000 products?!
Author kachurak on 06-04-2000 at 19:56 (EST)
One question that is similar to one in a previous post. I am hosted on an ASP capable server. I was wondering if anyone could tell me HOW they use the database to use conjunctively with UShop? I'm a little confused as to how this would work. You can obviously see WHY I'd like to use it with that many products. FYI; I have the full version UShop and will probably need to get the addin. Thanks in advance!

Table Of Contents
  RE: Database in MS Access 2000 - 3000 products?! Bill Weiner, 2000-06-05 05:40:36 (1)
  db driven ushop Charlie Edmunds, 2000-06-05 18:33:44 (2)

Messages In This Discussion
         1. RE: Database in MS Access 2000 - 3000 products?!
        Author Bill Weiner on 06-05-2000 at 05:40 (EST)
I know some people have ended up developing their own CGI or ASP interface to their own database. This basically involved making a script that queries the database and then dynamically generates the product pages with the uShop applets on them.

I personally, am not familiar with interfacing ASP to MS Access, but perhaps anyone else using this forum may have some tips on that. Suggestions anyone?.....
         2. db driven ushop
        Author Charlie Edmunds on 06-05-2000 at 18:33 (EST)

Instead of hard coding your product information via html into your pages you start by entering all your product info into the database. Typical fields might include:

Item Size

The ItemCategory field is important so you can organize your items.

Having your items in a database allows for extensive searching and flexible presentation possibilities. For instance: You could perform a query that would search for items that had a category of xxx and price less than xxx.

Typically the output of the query loops a data structure which includes the applet parameters being populated by the query results. Each application server (PHP, ASP, Cold Fusion) has a different syntax but the principle is the same. If you experiment with ASP you'll quickly see that it's easy to populate the applet parameters with the results of a query. Database driven web apps allow you to update your site via the web. In other words, no page editing required when you change your inventory.

If you pursue a db driven ushop, start simple, work your way into more sophisticated applications.

Good luck,
Charlie Edmunds
Micrburst Technologies, Inc.

© 2003 Microburst Technologies, Inc.