Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DB Info displays as Text in ASP not Hyperlink

Status
Not open for further replies.

mishbaker

Technical User
Jan 17, 2004
94
US
My HTML stored in a SQL database is coming out text. Here is what I have on my index.asp
Code:
response.write "<p><table align='center' width='100%' cellspacing='0' cellpadding='0' border='0' class='box'><tr><td width='125' align='center' class='box_top'>" + rs.fields("Header") + "</td></tr><tr><td class='box_midt'>" + rs.fields("Contents") + "</td></tr><tr><td width='125' class='box_bot'>" + rs.fields("Footer") + "</td></tr></table></p>"

The Contents fields right now just have a Google anchor in them <a href=". It's an SQLExpress Backend.
The data type for the Contents field is ntext.

When it displays on the page it only shows up as the word Google (non-hyperlink). When I "view source" it looks right, but it's not a hyperlink, just text.

I'm new to ASP so I'm not sure if there is something I am missing.

All lessons learned from the School of Hard Knocks........at least tuition is cheap.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top