Re: Any new thoughts on OTLT (One True Lookup Table)
From: Jonathan Leffler <jleffler_at_earthlink.net>
Date: Sat, 27 Mar 2004 04:58:21 GMT
Message-ID: <NR79c.3330$lt2.2164_at_newsread1.news.pas.earthlink.net>
Date: Sat, 27 Mar 2004 04:58:21 GMT
Message-ID: <NR79c.3330$lt2.2164_at_newsread1.news.pas.earthlink.net>
Laconic2 wrote:
> Consider the following code and description pairs drawn from a travel
> reservation system,
>
> <code>
> ("PA", "Pennsylvania")
> ("PA", "Pan American")
> </code>
Otherwise, you can't tell which row to use when displaying the lookup data for a state - and you could end up displaying 'Pan American' as part of someone's address.
-- Jonathan Leffler #include <disclaimer.h> Email: jleffler_at_earthlink.net, jleffler_at_us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/Received on Sat Mar 27 2004 - 05:58:21 CET