[program-java] Re: SQL
- From: "Corbett, James" <James.Corbett@xxxxxxxxxxxxx>
- To: <program-java@xxxxxxxxxxxxx>
- Date: Tue, 21 Oct 2008 07:47:44 -0400
MS Access or other wise known as Notepad....
Jim
In regards to your Eclipse issue, just ask away....
Jim
-----Original Message-----
From: program-java-bounce@xxxxxxxxxxxxx
[mailto:program-java-bounce@xxxxxxxxxxxxx]On Behalf Of Don Raikes
Sent: October 20, 2008 5:23 PM
To: program-java@xxxxxxxxxxxxx
Subject: [program-java] Re: SQL
Jim,
What database are you going against (not that that should make a difference,
but it might).
-----Original Message-----
From: Corbett, James [mailto:James.Corbett@xxxxxxxxxxxxx]
Sent: Monday, October 20, 2008 10:26 AM
To: Program-L (E-mail); Program-J (E-mail)
Subject: [program-java] SQL
Sorry for the cross post.
I have a table in a database that contains a string representation of times
captured in a 24 hour clock.
I.E. 1.09, 14:59, 13:09, 4:09
I retrieve them like this:
strSQL = Select * from table where date = date ordered by sTime.
Result: 4:09, 14:59, 13:09, 1:09....
It appears that the order by clause is doing something unexpected. Any ideas,
and no I can't change the database.
Jim
James M. Corbett
GST Division (Micro Applications)
Acting CS3 IT Specialist / Acting Team Leader
(613) 941-1338
"I love deadlines. I like the whooshing sound they make as they fly by."
Douglas Adams
"I'm Jim Corbett and I approve this message"
Other related posts:
