• Chad Crawford (9/21/2012)


    Luis Cazares (9/21/2012)


    Chad Crawford (9/21/2012)


    For our app we are going to go with a generic "Phone 1", "Phone 2", etc. up to a "Phone 7" and store each in it's own column in the table. That way we don't have to worry about types and everyone can choose for themselves what "Phone 1" means without having to define static types. Ok, just kidding we're really not doing that, I couldn't resist. :-D:-P:-D

    Thanks!

    Chad

    Why wouldn't you normalize the table?

    We did. I had a twitch of humor while reading Steve's comment and tried to think of the worst design possible. I did add that we are not really doing that, sorry that it didn't carry through in the post.

    That's what happens when you don't read the last sentence 😀

    I was in shock and I missed it. The worst part is that I'm sure there are tables designed like that somewhere in the world.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2