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.)
> 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
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)