Jag har en databs med olika fields. Jag vill kunna sortera dessa på olika sätt. Varför funkar inte detta.
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "batang.com-fame/biljett"
if request.querystring("order")= id Then
Set rs = Server.CreateObject("ADODB.Recordset")
Visa = "Select \* FROM forum ORDER BY id"
rs.Open Visa, Connect, 3,3
else if request.querystring("order")= user Then
Set rs = Server.CreateObject("ADODB.Recordset")
Visa = "Select \* FROM forum ORDER BY user"
rs.Open Visa, Connect, 3,3
I filen innan står det
<a href="admin_forumset_sort.asp?order=id">Order by id</a>
if request.querystring("order")= [b]"id"[/b] Then
Set rs = Server.CreateObject("ADODB.Recordset")
Visa = "Select * FROM forum ORDER BY id"
rs.Open Visa, Connect, 3,3
else if request.querystring("order")= [b]"user"[/b] Then
Set rs = Server.CreateObject("ADODB.Recordset")
Visa = "Select * FROM forum ORDER BY user"
rs.Open Visa, Connect, 3,3
du har glömt apostrofer runt querystringvärdet du jämför med (fet markering ovan).
gjorde det susen?
------------------
<A HREF="http://cartman.nu" TARGET=_blank>
all your base are belong to us!</A>
if request.querystring("order")<>"" then
Set rs = Server.CreateObject("ADODB.Recordset")
Visa = "Select * FROM forum ORDER BY " & request.querystring("order")
rs.Open Visa, Connect, 3,3
end if
------------------
<A HREF="http://cartman.nu" TARGET=_blank>
all your base are belong to us!</A>
