Sætte data under hinanden
Hvordan sætter man data fra en ms sql server under hinanden, i et .asp document?Kan man ikke skrive
"SELECT Nummer FROM BogTabel ORDER by ....."?
<html>
<head>
<title></title>
</head>
<body>
<%
Set conn = Server.CreateObject("ADODB.Connection")
strConn = "DRIVER=SQL Server;UID=Anonym;PWD=Anonym;Server=172.19.193.0;Database=BogDatabase"
conn.open strConn
%>
<Table>
<Tr>
<td width="20%"><H3><p align="center">Nummer</p></H3></td>
</tr>
<tr>
<td>
<%
strSQL = "SELECT Nummer FROM BogTabel"
set res = Conn.execute(strSQL)
if not res.eof then
while not res.eof
response.write res("nummer")
res.movenext
wend
else
response.write "EOF"
end if
%>
<td>
</tr>
</table>
</body>
</html>
