|
Author |
Message |
Iyonix
WebHelper
Joined: 12 Nov 2002
Posts: 82
Location: Yarm, England
|
Posted:
Wed Aug 13, 2003 6:36 pm (21 years, 4 months ago) |
|
How would I order a SELECT query by the sum of 5 integer feilds? I have tried
ORDER BY strength+agility+vitality+enlightenment+sagacity
but it doesn't work.
Thanks in advance for any replys |
________________________________ Iyonix |
|
|
|
jayant
Team Member
Joined: 07 Jan 2002
Posts: 262
Location: New Delhi, India
|
Posted:
Wed Aug 13, 2003 7:23 pm (21 years, 4 months ago) |
|
|
|
|
Iyonix
WebHelper
Joined: 12 Nov 2002
Posts: 82
Location: Yarm, England
|
Posted:
Wed Aug 13, 2003 8:04 pm (21 years, 4 months ago) |
|
Thank you for the very quick response. I will try it out now. |
________________________________ Iyonix |
|
|
|
Iyonix
WebHelper
Joined: 12 Nov 2002
Posts: 82
Location: Yarm, England
|
Posted:
Wed Aug 13, 2003 8:23 pm (21 years, 4 months ago) |
|
I just implemented your code and it worked.
Thanks again |
________________________________ Iyonix |
|
|
|
jayant
Team Member
Joined: 07 Jan 2002
Posts: 262
Location: New Delhi, India
|
Posted:
Thu Aug 14, 2003 7:17 am (21 years, 4 months ago) |
|
|
|
|
|
|
You cannot post new topics in this forum. You cannot reply to topics in this forum. You cannot edit your posts in this forum. You cannot delete your posts in this forum. You cannot vote in polls in this forum.
|
Page generation time: 0.15697 seconds :: 17 queries executed :: All Times are GMT
Powered by phpBB 2.0
© 2001, 2002 phpBB Group :: Based on an FI Theme
| |