Database i Javascript
HejHvorfor kan jeg ikke få dette til at virke?
Det er en .js fil
---
document.write('<p class=linered><b>Link collection</b></p><br><br>')
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "links.mdb;Driver={Microsoft Access Driver (*.mdb)};"
set rs=conn.execute("SELECT DISTINCT maingroup FROM [table1] ORDER BY maingroup")
i = 0
%>
<% Do until rs.Eof
i = i + 1
%>
document.write('<A class=sektion HREF="index.asp?maingroup=<% = rs("maingroup")%>"><% = rs("maingroup")%></a><br>')
<% rs.Movenext
Loop
Rs.Close
conn.close %>
document.write('<hr id=linered_dotted noshade size=1>')
<% group=Request.Querystring("maingroup") %>
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "DBQ=links.mdb;Driver={Microsoft Access Driver (*.mdb)};"
set rs=conn.execute("SELECT DISTINCT secondgroup FROM table1 where maingroup = '" & group & "' ORDER BY secondgroup")
%>
<%Do until rs.Eof%>
document.write('<a class=sektion href="links_list.asp?maingroup=<% Response.Write "" & group & "" %>&secondgroup=<% = rs("secondgroup")%>"><img src="arrowgoldback.gif" width="8" height="8" alt="" border="0"> <% = rs("secondgroup")%></A><br>')
<% rs.Movenext
Loop
Rs.Close
conn.close %>
document.write('<hr noshade size=1 color="#CC0000">')
---
som hentes med:
<script language="JavaScript" src="menu.js" type="text/javascript"></script>
