Problem with fies from database (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message


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
%>





rdouglass -> RE: Problem with fies from database (6/14/2006 12:06:49)

quote:

the page include pictures


When you say that, do you mean just standard IMG tags? If so, why does the field have to be an object? Just make it a memo field and put your page code in there (without <head>,<body>, and other unnecessary tags).

Either that or consider an iframe.




wizard_oz -> RE: Problem with fies from database (6/14/2006 12:12:06)

But a memo field I can't edit it, such as I can't make red color or different font size




Spooky -> RE: Problem with fies from database (6/14/2006 12:28:49)

Yes you can - its just saving text that will be converted to html




wizard_oz -> RE: Problem with fies from database (6/14/2006 12:30:56)

What do you mean? do I have to change the field in my database (mdb file) to memo ?
If so, I do I convert it to HTML?




wizard_oz -> RE: Problem with fies from database (6/14/2006 12:52:42)

Thanks I got it it is w o r k i n g
thanks you again




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875