Editing only the price field in the database

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21642
interpreted = N
texte = I have been slowly adding products to my database and eventually I expect to have about 15,000 entries in Catalog.db. Each item in the database has, among other fields, a Price field which will need to be updated regularly. I have been exporting the items slowly from our off-line database. This off-line database is constantly being updated by others who are in charge of price-setting etc. However, I cannot simply re-export the newly changed items for the web, since many of the other fields in our off-line database have been changed or replaced before exporting for web. 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? -- -------------------------------------------------------- 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)
I have been slowly adding products to my database and eventually I expect to have about 15,000 entries in Catalog.db. Each item in the database has, among other fields, a Price field which will need to be updated regularly. I have been exporting the items slowly from our off-line database. This off-line database is constantly being updated by others who are in charge of price-setting etc. However, I cannot simply re-export the newly changed items for the web, since many of the other fields in our off-line database have been changed or replaced before exporting for web. 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? -- -------------------------------------------------------- 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:

Dummy Credit Card Number for debug? (1997) [ShowIf] and empty fields (1997) typhoon... (1997) forming a SKU (1999) [TaxTotal] (1998) Protecting Files (how to display vs. present a link to (2005) searchable list archive (1997) Sorting alphabetical (2003) WebCat cannot handle compatible search parameters? (1997) RE: type 2 errors with ssl server (1997) using showpage and showcart commands (1996) Re:Emailer and encryption (1997) Nav. 4 probs with cart (1997) Mozilla/4. and Browser Info.txt (1997) WebCat2 several catalogs? (1997) WebCat and WebTV (1997) Fwd: Problem with order (1998) WC2.0 Memory Requirements (1997) Date Formats (1997) Classifieds (2000)