Updating Prices in Online Database
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23249
interpreted = N
texte = I would like to write a merge WebDNA that searches thru a temporary(updated) database and does a [replace] on the main database. I hadposted this in the past and someone from Technical support had suggestedcreating a separate db with just the sku number and price fields. Thiswould be an easy solution, however I would like to keep the databasetogether for other reasons (instead of pulling info from two differentdb's). Does anyone have a code already developed which is similar towhat I am looking for?>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.Thanks for your help.Mike
Associated Messages, from the most recent to the oldest:
I would like to write a merge WebDNA that searches thru a temporary(updated) database and does a
[replace] on the main database. I hadposted this in the past and someone from Technical support had suggestedcreating a separate db with just the sku number and price fields. Thiswould be an easy solution, however I would like to keep the databasetogether for other reasons (instead of pulling info from two differentdb's). Does anyone have a code already developed which is similar towhat I am looking for?>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.Thanks for your help.Mike
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:
[WebDNA] [OT] the "Work in progress" thread. (2009)
Additional Subtotals (1999)
Searchable list archive (1997)
OK, here goes... (1997)
setting username and password using a form. (2000)
shipCost not working v2.1b4 (1997)
Looking for a Manual (1997)
WebDNA 4.5 upgrade? (2002)
Allowed fields in formulas.db (1998)
New Problem (1997)
[HIDEIF] inside [FOUNDITEM] (1997)
[OT] Connect to MySQL (2004)
WebSite and *NO* Authentication Dialog Box!!? (1998)
Merchant account (1998)
[shipCost] math formula? (1997)
Emailer problem (2000)
[Shownext] [whynot] (2000)
Where's Cart Created ? (1997)
Bug? (1997)
Emailer (WebCat2) (1997)