<font face='Verdana'>I want to be able to retrieve lines of HTML code/links from a record in a database but I can only get it to recognize record contents as TEXT or NUMBERS... <img src=../images/dmxzone/forum/icon_smile_question.gif border=0 align=middle> Anyone know what I need to do so that its Included as HTML and not text?</font id='Verdana'>

What kind of a DB?

(UD4|IIS5|WXP|ASP)
*Connman21*
www.conncreativemedia.com

I'm using Access.

thanks for any help!

How are you adding this info to the DB? Is how you are inputing getting rid of the HTML code?

'Text' should work also... but try setting your field as a 'Memo' field using the Display View in Access. Then when you output to your page, it should output exactly as you input.

(UD4|IIS5|WXP|ASP)
*Connman21*
www.conncreativemedia.com

Like Conman said, make your field a memo and then enter your code with tags included to get it display as html.

Access will ignore returns in text unless specified by a P or BR tag

"Nobody ever said this stuff was easy"

I think the field is set to MEMO not text, and includes a few &lt;BR&gt;'s but when retrieving the data its printing out the code in the web page. So I get a bunch of &lt;BR&gt;'s in the text instead of linebreaks. I got around this by located a bit of code that converts &lt;BR&gt; in db field to the appropriate character but i dont think this should be necessary for every bit of html.

My next project will require html retrieved from database (links, etc) so I am trying to figure out how to do.

SO...if I understand correctly. What you all are saying is the FIELD in the db needs to be set to MEMO not text and it should work? Do I need to set the FORMAT in the recordset in ? I noticed there is something for html encoding ?

thx

GrillCheese

I don't think we were saying exactly that, because it really depends on a bunch of things.

Based on what you said about all your tags being in the DB fine, just not showing up on your page...

In your Data Bindings Panel, locate the field that you are trying to display as HTML... then move over to the right where there are some pulldowns for more options (sorry, I am doing this from memory as I am away from my PC)... in one of those pulldowns, select the option 'HTML.Encode' and then rechcek your page - that should do the trick.


(UD4|IIS5|WXP|ASP)
*Connman21*
www.conncreativemedia.com

Thanks for the responses guys, I appreciate it.

GrillCheese