-----Original Message-----
I have a database results page pulling info from an
access database based on a single criterium entered by
the user. It is working fine other than the fact that
one piece of returned information is a graphic which is
not displayed. Instead, it returns [#binary#] in its
place? Can anyone tell me what I'm doing wrong?
Yes, you can't display a picture that way.
Displaying a picture stored in a database is hard. You
have to write an ActiveX control that retrieves the
picture from Access, and then use that ActiveX control in
a special ASP page, and then make your database results
page create special <img> tags that display output from
the special ASP page rather than an ordinary picture file.
MSKB article 175261, HOWTO: Retrieve Bitmap from Access
and Display It in Web Page, describes this in more detail.
If you can, it's usually much better to store the pictures
as GIF or JPEG files, and then store only the filenames in
the database. You would then configure a custom query
somewhat like this:
SELECT '<img src=' & [picfile] & '>' as piclink, ...
where picfile is the name of the column that contains the
picture file names. You would also right-click the piclink
column in the finished Database Results Region, choose
Database Column Value Properties, and select Column Value
Contains HTML.
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
