Retrieving text from database and writing back as url

[wheatus]

Hi I am very new to this - I am trying to retrieve data stored in a text field of an access database then response write it as a url that links. How do I code this?

These are my pathetic attempts:
<% Response.Write "">Fees: 2005 - 2006"%>

or

">Fees 2005 - 2006

Cringe - like I say I am a bit green around the gills

[da_stimulator]

I'm assuming you have a recordset named rstSearch for this...

Code: Select all

<%
response.write("Fees: 2005-2006")
%>

[wheatus]

Yes - I have just solved the problem by coding html into the database field, ie.

Fees 2005-2006 (in my access database)

then in the detail.asp page coded:
<%= rstSearch.Fields("int_student_fees")& "" %>

but please let me know if there is another way (or the correct way should I say),

[Smokie]

That is definately the wrong way to do it, if you need to use that data anywhere else you might have a problem because it is surrounded by html tags and therefore will not display correctly.

Your second attempt or da_stimulator's suggestion should have worked perfectly?

[wheatus]

Thank you Smokie and da_stimulator - I have now had time to go back and correct everything according to da_stimulator's code.
All works marvellously!

[Rob]

Never put MARKUP in a database unless absolutly nessesary.

These forum posts for instance are stored as markup because there is not really another way to do it, unless we switch to plain text. All other info on this site has markup applied to it AFTER being retrieved from the database.