Changing Sort criteria of DB table.

[juniorbee]

hello

whats the easiest way to change my recordsets sort criteria from say,
alphabetical order to town name, am i best using sql (if so whats the code) or
do i have to actually have to have two .asp pages with the different recordset
criteria's??


thanks

jay

[Manuel Socarras]

you just need one page. call it passing a URL parameter specifying the
field you want the recordset ordered by, retrieve it & in the SELECT
stament use it instead a fixed field name. for example:

yourpage.asp?sf=name

or

yourpage.asp?sf=town

<%
Dim sortedField

sortedField = CStr(Request.QueryString("sf"))

....

rsCustomers.Source = "SELECT * FROM YOUR_TABLE_NAME ORDER BY " & sortedField

....

%>

HTH,

manuel

juniorbee wrote:

> hello
>
> whats the easiest way to change my recordsets sort criteria from say,
> alphabetical order to town name, am i best using sql (if so whats the code) or
> do i have to actually have to have two .asp pages with the different recordset
> criteria's??
>
>
> thanks
>
> jay
>
>
>

[juniorbee]

sorry, i should have added that im using javascript rather than VBscript.

can you translate?

[Manuel Socarras]

var sortedField

not sure now but toString should be equivalent to CStr

rsCustomers.Source = "SELECT * FROM YOUR_TABLE_NAME ORDER BY " + sortedField

juniorbee wrote:

> sorry, i should have added that im using javascript rather than VBscript.
>
> can you translate?