Re: Editing only the price field in the database

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21724
interpreted = N
texte = PCS Technical Support wrote:> >Basically, I would like to be able to export everything from our > >off-line database, create a temporary online database with the > >exported info, be able to compare the part numbers in the temporary > >database with the part numbers in the Catalog.db and when it finds > >matching part numbers, replace the price field in the Catalog.db with > >the price in the temporary database. Is it possible to do this using > >WebCat? > > Yes, you can certainly write some 'merge' WebDNA that searches thru an > update database and does a [replace] on your main database with the new > price information. It can take some time for large databases, though. > > But I'd recommend a nice little hybrid instead: keep the price information > *out* of your main Catalog.db, and instead keep a separate SKU/price > database which contains just those two fields. That way you can easily > export just those 2 fields from your offline database, and whenever you > need to find the price of something in your templates, just do a quick > [lookup] in the price database to see its current value. You can even > modify your Formulas.db to automatically pull prices from this alternate > database.Thanks. I like the idea of having a separate db for sku/price. I may decide to go that route. -- -------------------------------------------------------- Mike Eberly Auto Krafters, Inc. P.O. Box 8 522 S. Main Street Broadway, VA 22815 1-800-288-7346 -------------------------------------------------------- Associated Messages, from the most recent to the oldest:

    
  1. Re: Editing only the price field in the database (Mike Eberly 1998)
  2. Re: Editing only the price field in the database (PCS Technical Support 1998)
  3. Editing only the price field in the database (Mike Eberly 1998)
PCS Technical Support wrote:> >Basically, I would like to be able to export everything from our > >off-line database, create a temporary online database with the > >exported info, be able to compare the part numbers in the temporary > >database with the part numbers in the Catalog.db and when it finds > >matching part numbers, replace the price field in the Catalog.db with > >the price in the temporary database. Is it possible to do this using > >WebCat? > > Yes, you can certainly write some 'merge' WebDNA that searches thru an > update database and does a [replace] on your main database with the new > price information. It can take some time for large databases, though. > > But I'd recommend a nice little hybrid instead: keep the price information > *out* of your main Catalog.db, and instead keep a separate SKU/price > database which contains just those two fields. That way you can easily > export just those 2 fields from your offline database, and whenever you > need to find the price of something in your templates, just do a quick > [lookup] in the price database to see its current value. You can even > modify your formulas.db to automatically pull prices from this alternate > database.Thanks. I like the idea of having a separate db for sku/price. I may decide to go that route. -- -------------------------------------------------------- Mike Eberly Auto Krafters, Inc. P.O. Box 8 522 S. Main Street Broadway, VA 22815 1-800-288-7346 -------------------------------------------------------- Mike Eberly

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: Explorer oddities (1997) [random] only for 1-100??? (1997) webcat2b12 CGI -- Date comparisons (1997) synching databases on multiple servers (1997) [Webcat 2]Next (1997) Error after loading WebDNA (2004) Users.db LF/CR problem (2006) Accepting credit cards (1997) Fedora Core 2 (2005) possible, WebCat2.0 and checkboxes-restated (1997) Date math (1997) Can this be done? (2003) Emailer errors (1997) [WebDNA] OT: Issue with some clouds (2009) Find one not all, code not working (2003) Unexceling (was I need a smart quote...) (1999) syntax question, not in online refernce (1997) authorizenet and netscape (2002) Replto in [SendMail] (2000) HMAC-MD5 hash -- what the... (2003)