ASP Sorting

[Guest_imported]

How can you sort information pulled from a database through ASP's?

 

[Karl Blessing]

Depends on the data, depends on how you grab it from the, if you use SQL Statements, this could be as easy as including a &quot;...Order By Field,Field2...&quot; into the SQL statement. But it all depends. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href=

http://kb244.8m.com>

</a><br>Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)<br>

http://www.brainbench.com/transcript.jsp?pid=629151

 

[jfriestman]

As Karl mentioned, you can include an &quot;ORDER BY&quot; clause in your SQL statement.&nbsp;&nbsp;This is definitely the most efficient method... let the DB do the Sorting.<br><br>If however you are using a disconnected recordset or your recordset is generated by non-database data (like a text file or a CDO mailbox) then you can also use the Sort method of the Recordset object.<br><br>Here's a URL that explains...<br><br><A HREF="

http://msdn.microsoft.com/library/psdk/dasdk/mdap1w8f.htm"

TARGET="_new">

http://msdn.microsoft.com/library/psdk/dasdk/mdap1w8f.htm</A>

<p> Jeff Friestman<br><a href=mailto: > </a><br><a href=

http://www.brainbench.com/transcript.jsp?pid=61192>

View my Brainbench transcript</a><br>Brainbench 'Most Valuable Professional' for ASP<br>
Brainbench 'Most Valuable Professional' for JavaScript<br>

http://www.brainbench.com