Re: Multiple catalog databases and showcart
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 10686
interpreted = N
texte = >I'm racking my brain on this one:>>The site we are building currently is for a record shop whose catalogs>consist of:>>(1) A general collection of used vinyl, (2) used classical, (3 and 4 and>maybe more) new CD catalogs imported from CD rom.>>Here's the problem. I want to be able to add items to my cart from any>catalog database. How can I do a showcart for a cart than spans more than>one database?>>I don't want to combine the databases--the used catalogs need to have items>removed when ordered because each item is unique, and will also have items>added remotely three or four times a week.>>The CD rom databases will be updated in one fell swoop, and because they>are new, orders will not delete them from the database, because the orders>will drop ship from a distributor.>>Any thoughts?Put in one data base, put a flag on a field delete=Y/N, make a templete foradding used records that sets the can delete flag to Y or trueautomatically ie:hidden, and make a different template for adding new CD'sremotely that sets the delete flag to false or N automatically ie: hidden.do a showif thingy on your delete function and should work. Take the guesswork out of the hands of the person doing the input. From what you haveexplained above it does in my head :). Have such a data base on my systemwhere we show sales reps over many trade channels, electronics, hobby,industrial, cellular, security, sound. IE classical, used vinyl, and newCD's. The main office records are flagged can not delete.IE: New CD's Thestaff members of a main office can be deleted. IE: used vinyl. Verysimilar to what you have in a different application. Of course ours isjust data base management and does not involve carts. But the concepts isclose.===============================================Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com===============================================
Associated Messages, from the most recent to the oldest:
>I'm racking my brain on this one:>>The site we are building currently is for a record shop whose catalogs>consist of:>>(1) A general collection of used vinyl, (2) used classical, (3 and 4 and>maybe more) new CD catalogs imported from CD rom.>>Here's the problem. I want to be able to add items to my cart from any>catalog database. How can I do a showcart for a cart than spans more than>one database?>>I don't want to combine the databases--the used catalogs need to have items>removed when ordered because each item is unique, and will also have items>added remotely three or four times a week.>>The CD rom databases will be updated in one fell swoop, and because they>are new, orders will not delete them from the database, because the orders>will drop ship from a distributor.>>Any thoughts?Put in one data base, put a flag on a field delete=Y/N, make a templete foradding used records that sets the can delete flag to Y or trueautomatically ie:hidden, and make a different template for adding new CD'sremotely that sets the delete flag to false or N automatically ie: hidden.do a showif thingy on your delete function and should work. Take the guesswork out of the hands of the person doing the input. From what you haveexplained above it does in my head :). Have such a data base on my systemwhere we show sales reps over many trade channels, electronics, hobby,industrial, cellular, security, sound. IE classical, used vinyl, and newCD's. The main office records are flagged can not delete.IE: New CD's Thestaff members of a main office can be deleted. IE: used vinyl. Verysimilar to what you have in a different application. Of course ours isjust data base management and does not involve carts. But the concepts isclose.===============================================Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com===============================================
grichter@panavise.com (Gary Richter)
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Re:Emailer and encryption (1997)
Dr. Watson Error (1998)
GETCOOKIE not working as expected (2005)
Who needs Yoda! (2002)
autosensing lanague selection (1997)
[isfile] ? (1997)
WebCat2 - Getting to the browser's username/password data (1997)
[WebDNA] Graphite Forum (2009)
webcat (2000)
[WebDNA] XML Help (2009)
Repharesed: Web Site Stats (2002)
[OT] (waaaay OT) (2004)
SKU lookup (1997)
HTML Editors (1997)
This Code Kills My WebCatalog Dead (2003)
WebCatalog for Dummies part 2 (2000)
Forms Search Questions (1997)
2.0.1 new commands and contexts (1997)
Old $ commands and migration (2004)
WebCat2 - [format thousands] (1997)