Bocky Wocky Posted December 25, 2004 Posted December 25, 2004 Ik heb mdb file die ik door asp laat lezen. Nu wil ik middels een href link kunnen sorteren op tabel "SOF_STICKER" of "SOF_NAAM". Wie helpt mij mijn bestaande script aan te passen: Code: <body><%Set Conn = Server.CreateObject("ADODB.Connection")Set RS = Server.CreateObject("ADODB.RecordSet")Conn.Open "Mijn_Uitleen"selFrom = "SELECT * FROM software where SOF_TYPE='DVD' ORDER BY SOF_NAAM"Set RS = Conn.Execute( selFrom )RS.movefirst%><table><%do While Not RS.EOF%> <tr> <td><font face="Tahoma"><%=RS("SOF_STICKER")%></font></td> <td><font face="Tahoma"><%=RS("SOF_NAAM")%></font></td> </tr><%RS.movenextloopRS.CloseConn.Close%></table></body> There are 10 kinds of people in the world. Those who understand binary numbers and those who don't.
rlckring Posted December 25, 2004 Posted December 25, 2004 selFrom = "SELECT * FROM software where SOF_TYPE='DVD' ORDER BY SOF_NAAM ASC" of selFrom = "SELECT * FROM software where SOF_TYPE='DVD' ORDER BY SOF_NAAM DESC" of <% RS.Sort="SOF_NAAM ASC" %> <% RS.Sort="SOF_NAAM DESC" %>
Bocky Wocky Posted December 25, 2004 Author Posted December 25, 2004 Thx voor je snelle response, maar hoe maak ik daar nu een hyperlink van? Ik wil dus deze sortering maken door erop te klikken. There are 10 kinds of people in the world. Those who understand binary numbers and those who don't.
Bocky Wocky Posted December 25, 2004 Author Posted December 25, 2004 yes, thats the one <img src="/ubbthreads/images/graemlins/laugh.gif" alt="" /> Hier kan ik weer mee aan de slag. Nogmaals... bedankt! There are 10 kinds of people in the world. Those who understand binary numbers and those who don't.
rlckring Posted December 25, 2004 Posted December 25, 2004 Dit is het begin van het ado object klik Voor nog meer zaken..
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now