Using HTML inside SQL Server

Hey guys and gals,

I want to be able to use HTML inside my SQL Server Database (Express 08). At the end of the day, I want to make the text in my cells hyperlinked to pages within my website. Being an amateur, I thought I could just put <a href=....etc. directly into my database and it would work. However, it does not. It just reads out on the webpage at straight text.

I hope that makes sense. Does anyone have a simple fix for this?

Thanks in advance

 

Hi,
Do you mean dumping and retrieving HTML syntax in SQL Server table records?
If so you might want to download some of the free forum packages and see how they handle that.
Reason being, it takes care since it is not only the correct data type but also certain things in HTML will need to be caressed, i.e. any quote tags, direction arrows, etc.
It's tricky at times but it is common and once you have filters/practices in place it rolls well.
All the best,
Mark

 

I mean, I want the user to be able to come on the website and search, let's say, upper body exercises. The database gives them a list of ten upper body exercises. Each Upper Body exercise is hyperlinked to another page on the website that contains the exercise description.

Now, if we are talking about the same thing and I think we are, by your answer I'm assuming this is not going to be an easy task.

 

Hi,
That is common, many sites store pages and content in DBes with ID values.
You'll see the pages load something like this:
http://www.somesite.com/?id=007

Search Codeplex and you'll find a ton of free projects with source code:
http://www.codeplex.com/
All the best,
Mark