Building numbers are ordered elements

1,095 registered users | 0 active users | 1 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #280,918 by tuberculosis 4/7/07 6:23:52 PM Reply	Building numbers are ordered elements Think about scheduling a delivery route. If you treat them as strictly alpha, then you'll have #10 sorted with the #100's. Strictly numeric doesn't work either. They don't exactly fit either scenario. I4 NOW! Impeach, Indict, Incarcerate, Inject Bush, Cheney, Gonzalez, Rumsfeld, Rove, Rice
Post #280,924 by crazy 4/7/07 7:43:43 PM Reply	And if you want to code a war-dialer, you need phone math
Post #280,938 by tonytib 4/7/07 10:12:00 PM Reply	And if you're in Japan if you're using Western-style street centric code, it ain't going to work. --Tony
Post #280,979 by Seamus 4/8/07 8:09:58 AM Reply	Street addresses are a real PITA You need to be able to input as text, munge the non-conforming addresses and convert to a number for sorting. Not to mention keeping track of street name modifiers such directions: North Main, South Main, 5th Street, 5th Ave. Or even streets with different names for different parts of the street. Or one street name for what is essentially two different roads. Efficient delivery routes don't always follow street number order, so that's a different attribute. If you need any kind of history, street numbers and even street names do occasionally change. Alot of details for something so simple as an American style address. And because they are so simple everyone expects them to be handled flawlessly. Seamus

Database's worst enemy: real life - (Arkadiy) - (14) - March 11, 2007, 09:57:51 PM EDT

Nothing wrong with it - (crazy) - (1) - March 11, 2007, 10:42:51 PM EDT

Funny. -NT - (folkert) - March 11, 2007, 11:54:32 PM EDT

Absolutely. - (static) - March 12, 2007, 05:28:54 AM EDT

Lemme guess - the field is defined as a numeric type? - (tuberculosis) - March 12, 2007, 06:38:44 AM EDT

Tell me about it. - (JayMehaffey) - (4) - March 12, 2007, 09:52:09 AM EDT

Makes you want to find the joker who named the road ... - (drewk) - (2) - March 12, 2007, 10:51:29 PM EDT

You insulting Jeremiah Street, the founder of Town City? -NT - (CRConrad) - (1) - March 12, 2007, 11:02:01 PM EDT

Is that in Statesota? -NT - (folkert) - March 13, 2007, 02:42:22 AM EDT

Agree w/ Drook - (jb4) - March 13, 2007, 09:36:35 AM EDT

Re: Database's worst enemy: real life - (systems) - (4) - April 7, 2007, 02:54:19 PM EDT

Building numbers are ordered elements - (tuberculosis) - (3) - April 7, 2007, 06:23:52 PM EDT

And if you want to code a war-dialer, you need phone math -NT - (crazy) - April 7, 2007, 07:43:43 PM EDT

And if you're in Japan - (tonytib) - April 7, 2007, 10:12:00 PM EDT

Street addresses are a real PITA - (Seamus) - April 8, 2007, 08:09:58 AM EDT

For Thanks-giv-ing we had ta-ters, suc-co-tash and ru-ta-ba-gas.
43 ms