|
wizard_oz -> Problem with fies from database (6/14/2006 11:58:33)
|
Hi I have a table and I would like to add an HTML file inside the <TD> tags The reason I am doing that is because every time a click on the menu I need to change to page and the page include pictures. the problem is at the section of the if ID="1" then Response.Write rs3("story") end if At the database (mdb) I create a field with OLE type this doesn't work can someone help me? Thanks, Elen <%
ID=Request.QueryString("id")
dim conn3,rs3,sql3
set conn3=server.CreateObject("ADODB.connection")
conn3.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\WebSite\MagenLi\magenli.mdb"
set rs3=server.CreateObject("ADODB.recordset")
sql3="select * from RightMenu where category=1"
rs3.Open sql3,conn3
'Response.Write ID
%>
<link href="../css/magen.css" type="text/css" rel="stylesheet">
<body>
<table width="765" border="0" align="right" cellpadding="0" cellspacing="0">
<tr>
<td colspan=2><!-- #include file="../Template/FloorTemplate.asp"--></td>
</tr>
<tr><td width=645>
<table align=center width=550 border=0 cellpadding=1 cellspacing=1>
<tr>
<td>
<%
if ID="1" then
Response.Write rs3("story")
end if
%>
</td></tr>
</table>
<td width="120" height="700" bgcolor="#666666" valign=top align=right> <!-- #include file="leftmenu.asp" --></td>
</tr>
</table>
<%
rs3.Close
set rs=nothing
conn3.Close
set conn3=nothing
%>
|
|
|
|