I have a SQL database that I am grabbing data from using Frontpage
2002.  Not the best approach, but it will do if I can just get one
little thing to work.

I can search the database and query the data just fine - the DSN is
set etc.

I can easily link from the preliminary search results to a detail page
which shows more detail on each product.

Problem:  In the database, I have a couple of fields that contain HTML
and I can't seem to figure out how to get it to process the HTML from
these fields after it pulls it from the database.

It will pull it out just fine, but it then displays it as text, rather
than processing the HTML.  I figure it is something easy like changing
it to a response.write to get it to process the HTML rather than just
spit it out as text.

The second part of the problem is that Frontpage gets a bit testy
about changing the results of the database results wizard.  I tried to
get around that by editing the page in notepad.  I might be getting
close but no matter what I have tried it still won't process the HTML
from that field.

This is where I am at right now:

<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan -->

<%
text=FP_FieldVal(fp_rs,"LONG_DESCRIPTION")
%>
.......
.......
.......

<%
response.write text

OR 


response.write FP_FieldVal(fp_rs,"LONG_DESCRIPTION")
%>

Any ideas?

Best regards,

WebDesignGuy