If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

SQL Problem

ConsultClifford · 2005-03-25 13:21:48

Hi ive got an sql issue thats been wrecking my head this is the sql: SELECT DISTINCT thread FROM messages ORDER BY time DESC LIMIT 7 basically that selects the 7 most recent entries in messages ...which is grand HOWEVER the actual resultset is not sorted by time Can anyone tell me how to do so? tnx

Options

25-03-2005 2:21pm

#1

ConsultClifford

Registered Users Posts: 252 ✭✭

Join Date: May 2003

Posts: 140

Hi
ive got an sql issue thats been wrecking my head

this is the sql:

SELECT DISTINCT thread FROM messages ORDER BY time DESC LIMIT 7

basically that selects the 7 most recent entries in messages ...which is grand
HOWEVER the actual resultset is not sorted by time

Can anyone tell me how to do so?

tnx

0

Comments

Options
#2 25-03-2005 5:24pm
Kernel32

Registered Users Posts: 640 ✭✭✭

Join Date: May 2003

Posts: 618

Is the time column an actual datatype for datetime? or possible a varchar? I have seen it done before where string datatypes are used to store dates and time. If thats the case you will need to use some sort of conversion in the sql, it will depend on the database. SQL Server would use CONVERT or CAST for instance.

0
Options
#3 25-03-2005 5:51pm
ConsultClifford

Registered Users Posts: 252 ✭✭

Join Date: May 2003

Posts: 140

time is in fact and int.....

0
Options
#4 25-03-2005 6:57pm
causal

Registered Users Posts: 1,184 ✭✭✭

Join Date: January 2005

Posts: 1157

I think you need to include 'time' (assuming that is the correct column name) in the SELECTed list of columns.

causal

0