select * from table where a field is of the time type 1

[MattJames]

I have a mysql database which has been in use for a while. I recently installing it onto a new windows xp pro machine. The prevous computers have been both xp pro and 2000 server.
Since this new installation the ASP application I have been using along with mysqladmin both fail to list any table that contains a time field. This includes creating the field and inserting to it as a new record.

The code is as simple as

SELECT * FROM

Every attempt just shows no records.

Help!

 

[TonyGroves]

What on earth is that all about?

Get back to us when you've sobered up!

-----
ALTER world DROP injustice, ADD peace;

 

[MattJames]

Ok, in order to test this I created a table that had an id field and a time field.

The time field is called Day_Start.

There is one value in this field which is 06:00:00

If I use mySQL control centre I can view this fine. If I use Select * from tblTest or Select Day_Start from tblTest and then list all the values I get an empty record set.

If I use the asp based mysqladmin program and view this table I again get an empty table.

I hope this helps.

 

[MattJames]

Ok, I found an older version of the odbc driver that I had on disk rather than the newer one I had downloaded for the new install. It all works fine now.

 

[TonyGroves]

OK.

Sorry for the aspersion-casting earlier!

-----
ALTER world DROP injustice, ADD peace;