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 for adding used records that sets the can delete flag to Y or true automatically ie:hidden, and make a different template for adding new CD's remotely 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 guess work out of the hands of the person doing the input. From what you have explained above it does in my head :). Have such a data base on my system where we show sales reps over many trade channels, electronics, hobby, industrial, cellular, security, sound. IE classical, used vinyl, and new CD's. The main office records are flagged can not delete.IE: New CD's The staff members of a main office can be deleted. IE: used vinyl. Very similar to what you have in a different application. Of course ours is just data base management and does not involve carts. But the concepts is close.=============================================== 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:

    
  1. Re: Multiple catalog databases and showcart (Grant Hulbert 1997)
  2. Re: Multiple catalog databases and showcart (Ed Trefzger 1997)
  3. Re: Multiple catalog databases and showcart (grichter@panavise.com (Gary Richter) 1997)
  4. Re: Multiple catalog databases and showcart (Kenneth Grome 1997)
  5. Multiple catalog databases and showcart (Ed Trefzger 1997)
>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 for adding used records that sets the can delete flag to Y or true automatically ie:hidden, and make a different template for adding new CD's remotely 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 guess work out of the hands of the person doing the input. From what you have explained above it does in my head :). Have such a data base on my system where we show sales reps over many trade channels, electronics, hobby, industrial, cellular, security, sound. IE classical, used vinyl, and new CD's. The main office records are flagged can not delete.IE: New CD's The staff members of a main office can be deleted. IE: used vinyl. Very similar to what you have in a different application. Of course ours is just data base management and does not involve carts. But the concepts is close.=============================================== 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)