URL Atribute Dynamically Changing Query

[fidibidabah]

:confused;

This is a very real life program, but for simplicity terms, I'm going to use
the ubiquitous Art Gallery example.

I know a little bit about the whole #URL.attribute# thing, but I'm confused on
how to integrate it into an actual SQL query (or if I even can). Basically I
want something like the following:

SELECT DISTINCTROW LASTNAME, FIRST NAME
FROM ARTISTS
ORDER BY URL.ORDERBY

and if the url is art.cfm?orderby=lastname I want it to sort by the last name,
and if art.cfm?orderby=firstname I want it to sort by the first name. Again,
I'm familiar with the concept, but not the syntax to be used in an actual SQL
query as opposed to just a query output.

Thanks for any light you can shed on the topic :)

[paross1]

I might do something like this:

SELECT DISTINCTROW LASTNAME, FIRST NAME
FROM ARTISTS
<cfif IsDefined("url.orderby")>ORDER BY #URL.ORDERBY#</cfif>

Phil