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:
>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:
Occasional crashes with $remove (1997)
WebCat2b12 forgets serial # (1997)
Moving files from one server to another... (2001)
Q: for those who use Cookies for sessions? (2004)
[/application] error? (1997)
Support ?? (1997)
Redirect frame targets (1998)
Ampersand (1997)
Re2: frames & carts (1997)
SiteEdit Pro Update Announcement (1997)
WebTEN vs webSTAR (1998)
How can I record purchases to a database? (1998)
WebCat2.0 [format thousands .0f] no go (1997)
[WebDNA] Send Mail and SMTP Host (2015)
Interactive Online Docs Was: [OT] Mozilla | Was: R.I.P. (2003)
[ShowNext] (2007)
Help! WebCat2 bug (1997)
Separate SSL Server (1997)
WebCat for paper collection, review and coordination ? (1998)
Strange database format import (2000)