[#BINARY#] instead of picture

[Guest]

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 WebsUnlimited.com]

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

 

[Jim Buyens]

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