Problemer med include
Hej,Jeg har et problem med at includerer en fil i flg. kode:
<%
If Request(\"vnr\") = \"\" Then
response.write(\"<!--#include file=\'forside_inc.asp\'-->\")
ELSE
Set myConn = Server.CreateObject(\"ADODB.Connection\")
myConn.Open \"DSN=egvare\"
SQL = \"SELECT * FROM tbl_Cat WHERE SQL like \'\"& Request(\"vnr\") &\"\'\"
Set rs = myConn.Execute(SQL)
Response.Write \"<div align=\'center\'>Kategori: <b>\"& Replace(rs(\"Cat_navn\"), \"-\",\"\") &\"</b></div><br>\"
myConn.Close
Set myConn = Nothing
Set myConn = Server.CreateObject(\"ADODB.Connection\")
myConn.Open \"DSN=egvare\"
SQL = \"SELECT * FROM tbl_Vare WHERE VareNR like \'\"& Request(\"vnr\") &\"%\'\"
Set rs = myConn.Execute(SQL)
IF rs.eof THEN
response.write \"<center><b>Der er ingen varer i denne kategori.</b></center><br>\"
ELSE
%>
<div align=\"center\">
<center>
<table border=\"0\" cellspacing=\"0\" cellpadding=\"2\" bgcolor=\"#FFFFFF\">
<tr>
<td width=\"75\" bgcolor=\"#FFFFFF\" class=\"shoptbl\">Vare nr.</td>
<td width=\"200\" bgcolor=\"#FFFFFF\" class=\"shoptbl\">Beskrivelse</td>
<td width=\"100\" bgcolor=\"#FFFFFF\" class=\"shoptbl\" align=\"right\">eksl. moms</td>
<td width=\"100\" bgcolor=\"#FFFFFF\" class=\"shoptbl\" align=\"right\">inkl. moms</td>
<td width=\"100\" bgcolor=\"#FFFFFF\" class=\"shoptbl\" align=\"center\">Lager status</td>
</tr>
<%
Dim color
color = \"#F0F0F0\"
Do while not rs.EOF
response.write \"<tr>\"
response.write \"<td bgcolor=\'\"& color &\"\' class=\'shoptbl\'>\"& rs(\"VareNR\") &\"</td>\"
response.write \"<td bgcolor=\'\"& color &\"\' class=\'shoptbl\'>\"& rs(\"Varetekst\") &\"</td>\"
response.write \"<td bgcolor=\'\"& color &\"\' class=\'shoptbl\' align=\'right\'>\"& FormatCurrency(rs(\"Pris_udsalg\"),2) &\"</td>\"
prismoms = rs(\"Pris_udsalg\") * 1.25
response.write \"<td bgcolor=\'\"& color &\"\' class=\'shoptbl\' align=\'right\'>\"& FormatCurrency(prismoms,2) &\"</td>\"
response.write \"<td bgcolor=\'\"& color &\"\' class=\'shoptbl\' align=\'center\'>\"& rs(\"Status\") &\"</td>\"
response.write \"</tr>\"
if color = \"#F0F0F0\" then
color =\"#FFFFFF\"
else
color = \"#F0F0F0\"
end if
RS.MoveNext
LOOP
response.write \"</table>\"
myConn.Close
Set myConn = Nothing
End if
End if
%>
</center>
<br>
<%
If Request(\"vnr\") = \"\" THEN
Response.Write \" \"
ELSE
Response.write \"<center>For mere info om den enkelte vare, klik på varenummeret !</center>\"
END IF
%>
Include filen indeholder flg.:
<p>Include til forside</p>
^bare som en lille test...
