Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot, bind-address mysql multiple, sanibleone xxxx, ftp://192.168.100.100/, www.xxxcon

Links

XODOX
Impressum

#1: UnitsToElement

Posted on 2005-04-13 16:05:05 by Murray Carter

I am doing a Water Analysis DB
Structured
Fields
Ca
Mg
Mn
BOD5
PH
etc.
Would like to do a table where the fields of above becomes records ie
Element Unit
Ca g/l
Mg g/l
Mn g/l
BOD5 mg/l
PH -H
etc.
Then have a function that would return the unit from field name
Hope this is clear
thanks
Murray Carter

Report this message

#2: Re: UnitsToElement

Posted on 2005-04-13 17:59:28 by pietlinden

WaterAnalysisResults(
AnalysisID - Long Integer,
ChemicalID - string/long integer (depends on what makes sense)
Measurement - Number of some type
....)

Then you could have a table of Elements (well, loosely speaking,
anyway)

(Element, Unit)
and then you could just link that table to your measurements table and
you'd be all set. But then you MUST be consistent with the units of
measurement.
Then returning the measurement is a simple matter of using a join in a
query... nothing to it.

Report this message