Forums

ASP

This topic is locked

how do i create sort for...

Posted 19 Jul 2002 02:35:20
1
has voted
19 Jul 2002 02:35:20 Satya Gumilang posted:
Date Ascending
Date Descending
Hits Asc, Hits, Desc
Title Asc, Title Desc ?

Tabel Name : Links
Coloums: Linkid, Date, Time, Name (Title), Hits.

How do change this recordset? or do i have to create a new function?
please help.
This is for the link management system, and im trying to create a sort from this recordset

<%
Dim links
Dim links_numRows

Dim links__MMColParam2
links__MMColParam2 = "1"
if (Request.QueryString("Csub" <> "" then
links__MMColParam2 = Request.QueryString("Csub"
end if

Set links = Server.CreateObject("ADODB.Recordset"
links.ActiveConnection = MM_database_STRING
links.Source = "SELECT * FROM links WHERE CatsubID = " + Replace(links__MMColParam2, "'", "''" + " ORDER BY Title ASC"
links.CursorType = 0
links.CursorLocation = 2
links.LockType = 1
links.Open()

links_numRows = 0
%>


thx.

Reply to this topic