www.uburst.com www.uburst.com

"Database in MS Access 2000 - 3000 products?!"

Go back to the LobbyClick here to Go Back to Main ListingClick here to see helpClick here to Search the Forum

Programmer Tips
Forum Type: Public
Moderator: edmunds
Time Zone: EST
Printer Friendly Format
Original Message
 
"Database in MS Access 2000 - 3000 products?!"
Posted by kachurak on Jun-04-00 at 07:56 PM (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 Authorize.net addin. Thanks in advance!
Click to Send Alert Message to the Administrator Click to edit this messageClick to EMail Click here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents

 Table of Contents

RE: Database in MS Access 2000 - 30..., Bill Weiner, Jun-05-00, (1)
db driven ushop, Charlie Edmunds, Jun-05-00, (2)

 

 
Click here to goto Click here to goto the Lobby
Messages in this discussion
 
1 . "RE: Database in MS Access 2000 - 3000 products?!"
Posted by Bill Weiner on Jun-05-00 at 05:40 AM (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?.....

Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents
 
2 . "db driven ushop"
Posted by Charlie Edmunds on Jun-05-00 at 06:33 PM (EST)
Kachurak,

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:

ItemID
ItemName
ItemDesciption
ItemSKU
ItemPrice
Item Size
ItemCategory

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.

Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick to EMail Click here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents


Archive This Thread: Admin and Moderator OnlyRemove This Thread: Admin and Moderator Only
Click here to goto Click here to goto the Lobby

 

 

 

 

 

 

 

 

 

 

 

 
Questions or problems regarding this bulletin board should be directed to Webmaster
©1997-1999 by DCScripts. All rights reserved.