[#BINARY#] instead of picture

I'm retrieving images from a SQLServer database in BLOB
format. When I use the Database Results wizard the images
are displayed as text [#BINARY#] instead of the images.

What do I have to do to display the database info as
pictures?

Thank you.

MD
Mon Feb 02 12:26:29 CST 2004

Hi,

It is highly recommended that images be stored outside of the database and
that the database contain a link to the stored images location.

--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
Need to add Meta Tags to your web pages NOW with Google Bot controls.
http://www.websunlimited.com/order/Product/MTM2002/mtm2002_help_dir.htm
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible


<anonymous@discussions.microsoft.com> wrote in message
news:820101c3e993$4d4e7e80$a301280a@phx.gbl...
> I'm retrieving images from a SQLServer database in BLOB
> format. When I use the Database Results wizard the images
> are displayed as text [#BINARY#] instead of the images.
>
> What do I have to do to display the database info as
> pictures?
>
> Thank you.

Jim
Mon Feb 02 12:53:49 CST 2004

>-----Original Message-----
>I'm retrieving images from a SQLServer database in BLOB
>format. When I use the Database Results wizard the images
>are displayed as text [#BINARY#] instead of the images.
>
>What do I have to do to display the database info as
>pictures?

Please refer to MSKB article 173308:

HOWTO: Display Images Stored in a BLOB Field
http://support.microsoft.com/default.aspx?scid=kb;en-
us;173308

Warning: It's ugly.

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)
|/---------------------------------------------------
*----------------------------------------------------