I try to order by fírst one recordset lastname and then by firstname
so it will be sth like:
Andersson Andrews
Andersson Bartholomew
Baskerton Anders
Bollinger Anders
Could this be done without multidimentional arrays sorting?
try something like this..
Code:
SQL = "SELECT ID as poster, LASTNAME,FIRSTNAME as poster1 _
FROM "&strTabell&" where LASTNAME like '"& u_letter &"%' order by poster1"
'then later looping
x = 0
do while not rs.eof
%>
<option value="<%=rs("poster")%>"><%=rs("poster1")%></option>
<%
rs.movenext
x=x+1
loop
rs.close
cn.close
dBforums
>
order by 2 columns
02-21-06, 08:17
order by 2 columns
Linear Mode
