Forums
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 AscendingDate 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.