Forums
This topic is locked
how do i create sort for...
Posted 22 years ago
1
has voted
22 years ago 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"


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, "'", "''"

links.CursorType = 0
links.CursorLocation = 2
links.LockType = 1
links.Open()
links_numRows = 0
%>
thx.