<div>
Hi Ryan,<br />
<br />
It does, but I was hoping to avoid that. I'll ponder over it for a while 'cause it's going to take some re-coding of the rest of my site.<br />
<br />
I'll award you the points though as it is a sound solution.
</div>


Hi Ryan,

It does, but I was hoping to avoid that. I'll ponder over it for a while 'cause it's going to take some re-coding of the rest of my site.

I'll award you the points though as it is a sound solution.

<div>
if you do not want to have an additional column to determine the sequence ordering, then you will need to &quot;hardcode&quot; the ordering in your SQL statement, which in some cases, it's a valid solution.
</div>


if you do not want to have an additional column to determine the sequence ordering, then you will need to "hardcode" the ordering in your SQL statement, which in some cases, it's a valid solution.

<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
I've gotten a customer request. I have a task management system with various types of status. <i>Completed</i> &amp;&nbsp;<i>Recieved</i> being one of them. My customer wants <i>Recieved</i> @ the top. However it's a Text based column in mySQL. I would normally sort either ASC or DESC, but neither puts <i>Recieved</i> @ the top. Anyway around this?<br />
<br />
Best regards<br />
Michael
</div>
</div>


Hi all,

I've gotten a customer request. I have a task management system with various types of status. Completed & Recieved being one of them. My customer wants Recieved @ the top. However it's a Text based column in mySQL. I would normally sort either ASC or DESC, but neither puts Recieved @ the top. Anyway around this?

Best regards
Michael

Sorting - Classic asp putting a specific text @ the top of the table

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.