Hjælp behøves lige nu....
jeg få kun halvdelen af database indholdet trukket ud med følgende...Nugen som kan sige mig hvordan det skal se ud for jeg får det hele...
<% Response.Cookies(\"tgDate\") = now()%>
<body topmargin=\"0\" leftmargin=\"0\">
<center>
<%
Conn_String = \"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"link.mdb\")
Set Conn=Server.CreateObject(\"ADODB.Connection\")
Conn.Open Conn_String
sql = \"select * from cat order by cat\"
set rs = Conn.Execute (sql)
%>
<div align=\"left\">
<table border=\"0\" width=250 cellspacing=\"0\" cellpadding=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\">
<%
Do while NOT rs.EOF
ColNum = 1
Do while ColNum < 3
%>
<TD ALIGN=LEFT VALIGN=top><font face=\"Verdana\" size=1><b><%=rs(\"cat\")%> </a></b></font>
<%
ParentID = rs(\"id\")
sqlcount = \"SELECT count(url) FROM link2 where parentid=\'\" & rs(\"id\") & \"\' and show=yes\"
Set RScounts = Conn.Execute(sqlcount)
rcounts = RScounts(0)
Response.Write \"<br>\"
subsql = \"SELECT top 3 * FROM subcat where catID=\'\" & ParentID & \"\' order by subcatname\"
set rssubcat = conn.Execute(subsql)
count = rssubcat.RecordCount
count = 1
do while not rssubcat.EOF and count<=3
%><font face=\"Verdana\"> </font>
<font face=\"Verdana\" size=1><a href=\"showlink.asp?CatID=<%=rssubcat(\"subcatID\")%>&parentID=<%=rs(\"id\")%>&parentname=<%=server.urlencode(rs(\"cat\"))%>&Subname=<%=server.urlencode(rssubcat(\"Subcatname\"))%>\"><%=rssubcat(\"subcatname\")%></a><p style=\"margin-top: 0; margin-bottom: 0\"></font>
</p>
<%
rssubcat.movenext
loop
%><font face=\"Verdana\"> </font>
</td>
<%
if NOT rs.EOF then
rs.MoveNext
end if
ColNum = ColNum + 1
if NOT rs.EOF then
%>
</tr>
<%
end if
ColNum = ColNum + 1
Loop
%>
</TR>
<%
if NOT rs.EOF then
rs.MoveNext
end if
Loop
%>
</TABLE>
</div>
<% rs.close
Conn.Close
set Conn = nothing
%>
<CENTER>
<p style=\"margin-top: 0; margin-bottom: 0\"> </p>
</CENTER>
<center>
<p style=\"margin-top: 0; margin-bottom: 0\">
</p>
</center>
hvad har jeg lavet forkert ???
