navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

 

Problem with fies from database

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Problem with fies from database
Page: [1]
 
wizard_oz

 

Posts: 140
Joined: 9/3/2004
From: Ga,USA
Status: offline

 
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

 

Posts: 9280
From: Biddeford, ME USA
Status: offline

 
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.

_____________________________

Don't take you're eye off your final destination.

ASP Checkbox Function Tutorial.

(in reply to wizard_oz)
wizard_oz

 

Posts: 140
Joined: 9/3/2004
From: Ga,USA
Status: offline

 
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

(in reply to rdouglass)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
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

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)


(in reply to wizard_oz)
wizard_oz

 

Posts: 140
Joined: 9/3/2004
From: Ga,USA
Status: offline

 
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?

(in reply to Spooky)
wizard_oz

 

Posts: 140
Joined: 9/3/2004
From: Ga,USA
Status: offline

 
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

(in reply to wizard_oz)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Problem with fies from database
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts