Flere connections til forskellige tabeller i database
Hej!Jeg er ved at lave et kommentarsystem til mit sourcesodesystem.
Jeg vil have det sådan at på infosiden hvor der vises information om sourcen, via infoen, fx. info1.asp?id=85.
Det er ikke noget problem at få infoen frem, men når jeg vil hente kommentarene frem kommer der bare ikke noget frem:
<%
Response.Buffer = True
id = Request.QueryString(\"id\")
Set myConn = Server.CreateObject(\"ADODB.Connection\")
myConn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"profil.mdb\")
Set list = Server.CreateObject(\"ADODB.RecordSet\")
list.Open \"SELECT * FROM brugere WHERE ID=\" & id, myConn, 1, 3
Set rs = Server.CreateObject(\"ADODB.RecordSet\")
rs.Open \"SELECT * from brugere\", myConn, 1, 3
Set coment = Server.CreateObject(\"ADODB.RecordSet\")
coment.Open \"SELECT * from kommentar\", myConn, 1, 3
If Not (rs.BOF Or rs.EOF) Then
rs(\"Hits\") = rs(\"Hits\") + 1
strURL = rs(\"URL\")
rs.Update
Response.Clear
End If
%>
<html>
<head>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1252\">
<meta name=\"GENERATOR\" content=\"Microsoft FrontPage 4.0\">
<meta name=\"ProgId\" content=\"FrontPage.Editor.Document\">
<title>Fun4you.dk >> Source</title>
<style>
A:link {color : #333366;text-decoration: none}
A:visited {color : #333366;text-decoration: none}
A:active {color : #CC3300;text-decoration: none}
A:hover {color : #CC3300;text-decoration: none}
.t{font: 11px Verdana, Arial;text-decoration: none}
.nu{font: bold 8px Verdana, Arial;text-decoration: none}
.n{font: 10px/11px Verdana, Arial;text-decoration: none}
a.S{color : #000000;text-decoration: none}
A:link.S{color : #000000;text-decoration: none}
A:visited.S{color : #000000;text-decoration: none}
A:active.S{color : #000000;text-decoration: none}
</style>
</head>
<body background=\"bg.jpg\">
<font class=\"nu\">
<center><a href=\"http://tracker.tradedoubler.com/tracker.asp?code=138954\"><img border= 0 src=\"http://www.kontornet.dk/banner/knet_palm3.gif\"></a></center>
<%
if list.EOF then
Response.Write(\"Den ønskede sourcecode findes <b>IKKE</b>\") & vbCrLF
else
do while not list.EOF
response.write(\"<div align=\'left\'>\") & vbCrLf
response.write(\" <table border=\'0\' width=\'100%\'>\") & vbCrLf
response.write(\" <tr>\") & vbCrLf
response.write(\" <td><h2>\" & list(\"navn\") & \"</h2></td>\") & vbCrLf
response.write(\" <td></td>\") & vbCrLf
response.write(\" <td></td>\") & vbCrLf
response.write(\" <td rowspan=\'4\'></td>\") & vbCrLf
response.write(\"</tr>\") & vbCrLf
response.write(\" <tr>\") & vbCrLf
response.write(\" <td></td>\") & vbCrLf
response.write(\" <td></td>\") & vbCrLf
response.write(\" <td></td>\") & vbCrLf
response.write(\" </tr>\") & vbCrLf
response.write(\" <tr>\") & vbCrLf
response.write(\" <td>Udviklet af: \" & list(\"editor\") & \" <br>(<a href=\'mailto:\" & list(\"editoremail\") & \"\'>\" & list(\"editoremail\") & \"</a>)<hr noshade size=\'1\' color=\'#003366\'><br>\" & list(\"descrip\") & \"<hr noshade size=\'1\' color=\'#003366\'><a href=\'\" & list(\"url\") & \"\'> <img src=\'download.gif\' alt=\'klik her for at downloade filen\' border=\'0\'> Download Source</a> </td>\") & vbCrLf
response.write(\" <td><font size=-1>Hits: \" & rs(\"hits\") & \"</p></td>\") & vbCrLf
response.write(\" <td></td>\") & vbCrLf
response.write(\" </tr>\") & vbCrLf
response.write(\" </table>\") & vbCrLf
response.write(\"</div>\") & vbCrLf
list.movenext
loop
end if
if coment.EOF then
Response.Write(\"Der er ingen kommentarer til denne sourcecode\") & vbCrLF
else
do while not list.EOF
response.write(\"<div align=\'left\'>\") & vbCrLf
response.write(\" <table border=\'0\'>\") & vbCrLf
response.write(\" <tr>\") & vbCrLf
response.write(\" <td>\" & coment(\"overskrift\") & \"</td>\") & vbCrLf
response.write(\" <td>Tilføjet den \" & coment(\"dato\") & \"</td>\") & vbCrLf
response.write(\" </tr>\") & vbCrLf
response.write(\" <tr>\") & vbCrLf
response.write(\" <td>\" & coment(\"kommentar\") & \"</td>\") & vbCrLf
response.write(\" <td></td>\") & vbCrLf
response.write(\" </tr>\") & vbCrLf
response.write(\" </table>\") & vbCrLf
response.write(\"</div>\") & vbCrLf
loop
end if
%>
<%
rs.Close
coment.Close
myConn.Close
Set rs = Nothing
Set coment = Nothing
Set myConn = Nothing
%>
</font>
</body>
</html>
