Updating one table with another

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 21956
interpreted = N
texte = I receive a database containing subjective size values for variousinventory items. I need to convert these subjective values intoquantitative values so I can do math based searches throughout the rest ofthe site. I have a second database that contains the quantitative valuesfor each of the different categories. What technique would I use to comparethese two databases and then write out a fresh fully quantified database?Subjective databaseCategory Item_1 Item_2A short mediumB medium shortC medium longQuantitative Reference databaseCategory Short Medium LongA 20 24 26B 6 8 10C 36 42 60Final desired Quantified databaseCategory Item_1 Item_2A 20 24B 8 6C 42 60Thanks for all the help (as always)Marty Schmid Associated Messages, from the most recent to the oldest:

Updating one table with another (Marty Schmid 1998)

I receive a database containing subjective size values for variousinventory items. I need to convert these subjective values intoquantitative values so I can do math based searches throughout the rest ofthe site. I have a second database that contains the quantitative valuesfor each of the different categories. What technique would I use to comparethese two databases and then write out a fresh fully quantified database?Subjective databaseCategory Item_1 Item_2A short mediumB medium shortC medium longQuantitative Reference databaseCategory Short Medium LongA 20 24 26B 6 8 10C 36 42 60Final desired Quantified databaseCategory Item_1 Item_2A 20 24B 8 6C 42 60Thanks for all the help (as always)Marty Schmid Marty Schmid

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:

PCS Frames-Default page is solution! (1997) UPS/FEDEX/OTHER Ship lookups available?? (1998) One more try (1997) Search bug. Help (2002) Emailer problems (1998) serial number dishing (1997) [QuantityPrice] Not working in WebCatNT 2.0.1??? (1997) [WebDNA] shopping sites and the "old commerce tags" (2012) WebCat2: multiple currency support (1997) boldwords funky (1998) encryption madness (2003) WebCat2 - [format thousands] (1997) Privacy Issue (LEGIT QUESTION) (2003) Bad card db - *mislabled post* (1999) Hummm .... (2002) Cleaning up all the shopping carts (2000) Security for malls with different webmasters (1998) Webcat stopped responding .. (2002) dynamic PDF no longer working? (2004) Catalog Design (1999)