hallå någon vet väl hur man gör??? kolla på hela koden, vad är fel?
<%
Set Databas = Server.CreateObject("ADODB.Connection")
Set Databas2 = Server.CreateObject("ADODB.Connection")
Set Databas3 = Server.CreateObject("ADODB.Connection")
Set Databas4 = Server.CreateObject("ADODB.Connection")
MdbFilePath="F:\members\groda\db\kompis.mdb"
MdbFilePath="F:\members\groda\db\mess.mdb"
MdbFilePath="F:\members\groda\db\news.mdb"
MdbFilePath="F:\members\groda\db\users.mdb"
Databas.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ= " & MdbFilePath & ";"
[b]Databas2.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ= " & MdbFilePath2 & ";"[/b]
Databas3.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ= " & MdbFilePath3 & ";"
Databas4.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ= " & MdbFilePath4 & ";"
strsql1 = "select count(*) as antalpolare from kompisar where username = '" & session("username") & "'"
strsql2 = "select count(*) as antalnya from meddelande where till = '" & session("username") & "' and status='oläst'"
SQL = "SELECT * FROM nyheter ORDER BY [datum] DESC"
SQL4 = "Select * From users Where username = '" & session("username") & "'"
set rs1=Databas.execute(strsql1)
set rs2=Databas2.execute(strsql2)
set rsNews=Databas3.execute(sql)
Set rsAndra = Databas4.Execute(SQL4)
polare = rs1("antalpolare")
nyameddelanden = rs2("antalnya")
%>
<%
'######### Skriver ut vem som är inloggad
%>
<%
Response.Write"Välkommen in till grodan, " & Session ("Username") & "<br><br><br><br><br><font face=""Verdana"" size=""1"" color=""white""><a href=""visapolare.asp"">Du har totalt " & "polare" & " kompisar på din kompislista.</a></font><br><font face=""Verdana"" size=""1"" color=""white""><a href=""mejl.asp"">Du har " & rs2("antalnya") & " nya meddelanden också</a></font><br>"
Response.Write "<font face=""Verdana"" size=""1""><a href=""hamta.asp"">Ändra min info</a><br><a href=""javascript:ny_sida('20fragor.asp','400','275');"">Svara på ""20 Frågor""</a></font>"
%>
<br><br><br>
<div align="left">
<table border="0" cellpadding="0" cellspacing="3" bgcolor="#F7F7E7" style="border-width:1; border-color:black; border-style:solid;">
<tr><div align="left">
<td width="262"><p><font face="Verdana" size="1" color="black">
<h5><%=rsNews("rubrik")%>
<%=rsNews("datum")%></h5>
<%=rsNews("nyhet")%> </font>
</td>
</tr></b>
</table></div>
<% rs1.close %>
<% rs2.close %>
<% rsNews.close %>
<% rsAndra.close %>
</font> </td>
</tr>
</table></div>
asså, jag fattar inte ngt!
rad 95 = markerad med fetstil
[Redigerat av crisse6 den 10 mar 2001]
