I hope you have already tried just plain-old ORDER BY field_name in your
query. What is wrong with the default order presented? Can you show an
example of how the ORDER BY did not solve your problem along with an
example of what it should have been for your situation?
Thanks in advance,
Shawn
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 28, 2004 7:58 AM
To: Scott Fletcher
Cc: [EMAIL PROTECTED]
Subject: Re: Using function followed by order by
function_name(table.field_name).
I hope you have already tried just plain-old ORDER BY field_name
in your query
be at the bottom in integer value. Similar concept
with the double or float value?
Thanks,
FletchSOD
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 28, 2004 8:56 AM
To: Scott Fletcher
Cc: [EMAIL PROTECTED]
Subject: RE: Using function followed by order by
function_name
Scott,
I am glad that you understand what I meant but I still don't think you
understand what you can do with MySQL. You are killing your query
performance by trying to convert things on the fly. YOU DON'T NEED TO
DO THAT WITH MYSQL. Maybe you did in DB2 but not here.
So you can stop
I'm having a little bit of a trouble with the use of the SQL function...
What I have here is a webpage that show the row of data, the web user
get to click on the field to sort the row by the field name. So, when I
use order by char(field_name), the data doesn't turned out right in
alpha-numeric