[thelist] SQL order by

[Drew Shiel]

At 10:09 07/02/2003 -0500, Joshua Olson wrote:

>Asking the database to do this may be a little more taxing than you may have
>hoped.  Here's one possible approach:
>
>Insert the values into a temporary table that has an identity field.  Then,
>add this temp table into the join and order by the identity field.

   That's a possibility...

>If you don't want to do that, then you may consider handling the resort on
>the scripting page.  What is your scripting language of choice?  CF, ASP,
>PHP, ??

   I'm scripting in CF here.

   Cheers,
   Drew.


Drew Shiel                               webmaster at swiftpay.com
                                                     +353-1-2365705
------------------------------------------------------------------
Swiftpay -- The best way to pay online -- http://www.swiftpay.com