Inheriting a database
1.
database.SetQuery("select *\n from " + TABLE);
\n in the middle of a simple select * query? That’s just weird, man.
(Besides that it’s not particularly good form to use select * in the first place. Although it’s not good form on my part for not responding to most of your comments–will do tonight.)
2.
> now, what did you say was holding you up from declaring a
> proper datetime datatype?I have inherited the database. Unfortunately because the date field is
of type varchar, there exist some incorrect dates, so I need to clean up
the data….You will feel a slight shift in the Force when I have rectified the
datatype error.
I’m in this situation! Except I don’t have time to make all the necessary changes to the code. It would be much appreciated to withhold any snide comments such as, “The real WTF is that you’re using MySQL.”
(Quote from [thelist] MySQL Convert String To Date)
The clients probably need...
Refactored from:
database.SetQuery(”select *”
+ ” from ” + TABLE);
??
Reply to Tacticus Maximus
Comment by Tacticus Maximus | 18 June 2008
I think someone just literally saw this:
select *
from table
and thought hey, i should keep that formatting in place. *shrugs*
Reply to Allen
Comment by Allen | 18 June 2008
@Tacticus: Exactly, but that’s a situation where I prefer StringBuilder.
@Allen: And the initials of that someone are…DB.
Reply to Donnie
Comment by Donnie | 18 June 2008
Hey Donnie, how about noon my time on Saturday? That would be 2PM your time?
Reply to wang
Comment by wang | 19 June 2008
Lots of people have the initials of DB.
Reply to Allen
Comment by Allen | 19 June 2008
@Wang: Sounds good to me!
@Allen: It’s perfect cover in case DB ever stumbles on this site,.
Reply to Donnie
Comment by Donnie | 19 June 2008