ACCESS kun et record sæt?
Hej jeg har følgende kode der kun skriver billed kilden og resten gider den ikke hente:<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("tilbudsbasen.mdb")
Conn.Open DSN
%>
<body bgcolor="#f7f7f7">
<p align="center"><b><font face="Arial" size="5">Velkommen til pc2u.dk:)</font></b></p>
<hr>
<p align="center"><b><font size="5" face="Arial">Ugens tilbud:</font></b></p>
<%
sql = "SELECT * FROM varer WHERE id =1"
Set Rs = Conn.Execute(sql)
%>
<div align="center">
<center>
<table border="1" width="84%" height="133" bordercolorlight="#000000" cellspacing="0" cellpadding="0" bordercolordark="#FFFFFF" bgcolor="#FFFFFF">
<tr>
<td width="25%" height="1">
<p align="center"> <b><font face="Arial">Billed:</font></b></p>
</td>
<td width="53%" height="1">
<p align="center"><b><font face="Arial">Info: </font></b></p>
</td>
<td width="18%" height="1" colspan="2">
<p align="center"><b><font face="Arial"> Pris:</font></b></p>
</td>
</form></form>
</tr>
<tr>
<td width="25%" height="124" rowspan="2">
<p align="center"> <img src="<%=rs("billed")%>"></td>
<td width="53%" height="124" rowspan="2">
<p align="center"> <%=rs("info")%></p>
</td>
<td width="18%" height="112" colspan="2">
<p align="center"><%response.write rs("pris")%> </p>
</td>
</tr>
<tr>
<td width="9%" height="12">
<p align="center"><input type="submit" name="<%=rs("id")%>" value="info">
</td>
<td width="9%" height="12">
<p align="center"><input type="submit" name="<%=rs("id")%>" value="køb">
</td>
</tr>
</table>
</center>
</div>
<%
Conn.Close
Set Conn = Nothing
%>
Hvad skyldes det?
