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 decideto go that route.-- --------------------------------------------------------Mike EberlyAuto Krafters, Inc.P.O. Box 8522 S. Main StreetBroadway, VA 228151-800-288-7346--------------------------------------------------------
Associated Messages, from the most recent to the oldest:
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 decideto go that route.-- --------------------------------------------------------Mike EberlyAuto Krafters, Inc.P.O. Box 8522 S. Main StreetBroadway, VA 228151-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)