How do I display a graphic in a database search result using ASP?

[recursion23]

I'm building my first database driven site, and although I'm an expert with
MS Access and no stranger to FrontPage 2003, I'm having no luck figuring out
how to do this.
My ASP page is a search page with a search box and database results. I need
the database results to display two text fields and a picture for each
record. It pulls up the data all right, but the instead of a graphic it just
displays [BINARY]. What code do I use to make it display the graphic? this is
the current code:
<!--webbot bot="DatabaseResultColumn"
s-columnnames="CoachID,Name,Address,City,State,ZIP,Email,Username,Password,pic,bio,KeywordID,CoachID,Keyword"
s-column="pic" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>pic<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"pic")%><!--webbot bot="DatabaseResultColumn" endspan
i-checksum="5368" --><p> </td>

 

[Stefan B Rusynko]

Since you are using the DBRW see
http://support.microsoft.com/kb/825515

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| I'm building my first database driven site, and although I'm an expert with
| MS Access and no stranger to FrontPage 2003, I'm having no luck figuring out
| how to do this.
| My ASP page is a search page with a search box and database results. I need
| the database results to display two text fields and a picture for each
| record. It pulls up the data all right, but the instead of a graphic it just
| displays [BINARY]. What code do I use to make it display the graphic? this is
| the current code:
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="CoachID,Name,Address,City,State,ZIP,Email,Username,Password,pic,bio,KeywordID,CoachID,Keyword"
| s-column="pic" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE"
| clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>pic<font
| size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"pic")%><!--webbot bot="DatabaseResultColumn" endspan
| i-checksum="5368" --><p> </td>
|

 

[recursion23]

Thanks, that's exactly what I needed.