Writing ASP Strings to SQL Server

I am creating some description blurbs where I want to include certain variables inside of the description. When I create the blurb, I set the variables where I want them.

example.... Find the best <%=Color%> Widgets in Town. We carry tons of <%=CategoryName%> Widgets for your <%=Color%> Widgitizer.

As it is written to the db, the dynamic chars are escaped. When the db writes to the page, it displays the tag on the screen instead of executing it. When I put the string ( <%=Color%> ) directly into SQL server, it does not output anything. The page still works, but the spot where I called that instance is blank.

I have assigned and tested all variabled when not written from the DB and they all work fine.

Any ideas on this one? Im stumped.

 

Nevermind, I got it.

Maybe this will help someone in the future.

Using JScipt / ASP, I used the variable name instad of an ASP variable.

so

response.write(string.replace("--Color--","Color"))

worked great where

response.write(string.replace("<%=Color%>","Color"))

did not.

Cant beleive I even tried that.... poor judgement.