in reply to Comparing Dates With a Twist

In my usual spirit of trying to notice something useful, I note that you are referring to locations of things in your database by position.

Positional logic like that is notoriously hard to maintain and debug. (Quick! What is field 14? Which program were you looking at again? What if someone's output is off by one column? What if the spec changes?) If you can, you will save yourself a lot of pain by switching to name based logic, eg by using hashes instead of arrays. True, there is some overhead to doing that, but my experience is that the overhead nothing compared to the savings in development effort.

  • Comment on Re (tilly) 1: Comparing Dates With a Twist

Replies are listed 'Best First'.
Re: Re (tilly) 1: Comparing Dates With a Twist
by suggus (Sexton) on Nov 01, 2001 at 23:10 UTC
    Hi Tilly,

    I agree with your comment, but it's not my database, and that's the only logic that I've come up to parse the information. The database will remain the same though...it's just located in India instead of the US. :-) For the time being, my script is a small part of what the others (that own the DB) will be using it for.

    Thanks for all of your suggestions! I really appreciate the quick responses.

    -Gus