Begginer with problems in OLE Object field (imagen) from MS Access. Please help.

's Computer Specifications

I'm a begginer in Web Design and I have a small but irritating problem.

I'm trying to include pictures (OLE objects field DataType) from MS
Access in a database results page in Frontpage, but it shows a "X" or
[#BINARY#]. I followed the instructions exactly, even I changed the
parameters | Insert Field Value in Pictures Properties.

The Frontpage's HTML wiev shows as follows:

<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>All Products</title>
</head>

<body>

<p> </p>
<table border="1">
<thead>
<tr>
<td><b>Picture</b></td>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web
must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM WorkArt ORDER BY ExpirationDate ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=1 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="artsHOODB"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

<tr>
<td><img border="0"
src="<%=FP_FieldLink(fp_rs,"Picture")%>"></td>
</tr>

</tbody>
</table>

</body>

</html>

Please, I would appreciate to much if anyone can help me .

Euroiranian Co
------------------------------------------------------------------------
Posted via http://www.forum4designers.com
------------------------------------------------------------------------
View this thread: http://www.forum4designers.com/message44055.html

's Computer Specifications

It's my understanding that images need
to be stored outside of a database and have
their location referenced in the database.

hth

--
Steve Easton
MS MVP FrontPage
95isalive
This site is best viewed..................
...............................with a computer

"Euroiranian Co" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> I'm a begginer in Web Design and I have a small but irritating problem.
>
> I'm trying to include pictures (OLE objects field DataType) from MS
> Access in a database results page in Frontpage, but it shows a "X" or
> [#BINARY#]. I followed the instructions exactly, even I changed the
> parameters | Insert Field Value in Pictures Properties.
>
> The Frontpage's HTML wiev shows as follows:
>
> <html>
>
> <head>
> <meta name="GENERATOR" content="Microsoft FrontPage 5.0">
> <meta name="ProgId" content="FrontPage.Editor.Document">
> <% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
> not Edit.
> FP_CharSet = "windows-1252"
> FP_CodePage = 1252 %>
> <meta http-equiv="Content-Type" content="text/html;
> charset=windows-1252">
> <title>All Products</title>
> </head>
>
> <body>
>
> <p> </p>
> <table border="1">
> <thead>
> <tr>
> <td><b>Picture</b></td>
> </tr>
> </thead>
> <tbody>
> 
> <% if 0 then %>
> <SCRIPT Language="JavaScript">
> document.write("<div style='background: yellow; color: black;'>The
> Database Results component on this page is unable to display database
> content. The page must have a filename ending in '.asp', and the web
> must be hosted on a server that supports Active Server Pages.</div>");
> </SCRIPT>
> <% end if %>
> <%
> fp_sQry="SELECT * FROM WorkArt ORDER BY ExpirationDate ASC"
> fp_sDefault=""
> fp_sNoRecords="<tr><td colspan=1 align=left width=""100%"">No records
> returned.</td></tr>"
> fp_sDataConn="artsHOODB"
> fp_iMaxRecords=256
> fp_iCommandType=1
> fp_iPageSize=5
> fp_fTableFormat=True
> fp_fMenuFormat=False
> fp_sMenuChoice=""
> fp_sMenuValue=""
> fp_iDisplayCols=1
> fp_fCustomQuery=False
> BOTID=0
> fp_iRegion=BOTID
> %>
> 
> <tr>
> <td><img border="0"
> src="<%=FP_FieldLink(fp_rs,"Picture")%>"></td>
> </tr>
> 
> </tbody>
> </table>
>
> </body>
>
> </html>
>
>
> Please, I would appreciate to much if anyone can help me .
>
>
> Euroiranian Co
> ------------------------------------------------------------------------
> Posted via http://www.forum4designers.com
> ------------------------------------------------------------------------
> View this thread: http://www.forum4designers.com/message44055.html
>

's Computer Specifications

Displaying pictures stored within an Access database is
difficult.

1. You have to make the Database Results Region create
the HTML for an <img> tag.
2. That <img> tag has to call an ASP or ASP.NET page,
passing the database record ID in a query string
variable (i.e. <img src="showpic.asp?dbid=1234">).
3. That ASP or ASP.NET page has to retrieve the
database record and get the picture bits. In the
case of ASP, this requries writing an ActiveX
control in VB6.
4. The ASP or ASP.NET page then has to send the picture
bits to the browser.

If you want to pursue this further, browse MSKB article
175261:
HOWTO: Retrieve Bitmap from Access and Display It in Web
Page
http://support.microsoft.com/default.aspx?scid=kb;en-
us;175261

The much more common solution, however, is to:

1. Store each picture as a stand-alone file.
2. Store the picture file name in the database.
3. Make the DRW create an <img> tag containing that
filename.

Step 3 requires that you code a custom query such as:

SELECT '<img src="' & [picfilename] & '">', ...

where picfilename is the name of the database field that
contains the picture file name.

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

>-----Original Message-----
>
>I'm a begginer in Web Design and I have a small but
irritating problem.
>
>I'm trying to include pictures (OLE objects field
DataType) from MS
>Access in a database results page in Frontpage, but it
shows a "X" or
>[#BINARY#]. I followed the instructions exactly, even I
changed the
>parameters | Insert Field Value in Pictures Properties.
>
>The Frontpage's HTML wiev shows as follows:
>
><html>
>
><head>
><meta name="GENERATOR" content="Microsoft FrontPage 5.0">
><meta name="ProgId" content="FrontPage.Editor.Document">
><% ' FP_ASP -- ASP Automatically generated by a Frontpage
Component. Do
>not Edit.
>FP_CharSet = "windows-1252"
>FP_CodePage = 1252 %>
><meta http-equiv="Content-Type" content="text/html;
>charset=windows-1252">
><title>All Products</title>
></head>
>
><body>
>
><p> </p>
><table border="1">
><thead>
><tr>
><td><b>Picture</b></td>
></tr>
></thead>
><tbody>
>
><% if 0 then %>
><SCRIPT Language="JavaScript">
>document.write("<div style='background: yellow; color:
black;'>The
>Database Results component on this page is unable to
display database
>content. The page must have a filename ending in '.asp',
and the web
>must be hosted on a server that supports Active Server
Pages.</div>");
></SCRIPT>
><% end if %>
><%
>fp_sQry="SELECT * FROM WorkArt ORDER BY ExpirationDate
ASC"
>fp_sDefault=""
>fp_sNoRecords="<tr><td colspan=1 align=left
width=""100%"">No records
>returned.</td></tr>"
>fp_sDataConn="artsHOODB"
>fp_iMaxRecords=256
>fp_iCommandType=1
>fp_iPageSize=5
>fp_fTableFormat=True
>fp_fMenuFormat=False
>fp_sMenuChoice=""
>fp_sMenuValue=""
>fp_iDisplayCols=1
>fp_fCustomQuery=False
>BOTID=0
>fp_iRegion=BOTID
>%>
>
><tr>
><td><img border="0"
>src="<%=FP_FieldLink(fp_rs,"Picture")%>"></td>
></tr>
>
></tbody>
></table>
>
></body>
>
></html>
>
>
>Please, I would appreciate to much if anyone can help me .
>
>
>Euroiranian Co
>----------------------------------------------------------
--------------
>Posted via http://www.forum4designers.com
>----------------------------------------------------------
--------------
>View this thread:
http://www.forum4designers.com/message44055.html
>
>.
>

's Computer Specifications

Yes, I have the Pictures in one file and the database in another one
But is not strictly need, I can store the pictures inside the databas
if that is better. I try to save disk space with this option. Lookin
forward for more information. Thomas.

Steve Easton wrote:
> *It's my understanding that images need
> to be stored outside of a database and have
> their location referenced in the database.
>
> hth
>
> --
> Steve Easton
> MS MVP FrontPage
> 95isalive
> This site is best viewed..................
> ...............................with a computer
>
> "Euroiranian Co" <(E-Mail Removed)
> wrote in
> message news:(E-Mail Removed)...
> >
> > I'm a begginer in Web Design and I have a small but irritatin
> problem.
> >
> > I'm trying to include pictures (OLE objects field DataType) fro
> MS
> > Access in a database results page in Frontpage, but it shows a "X
> or
> > [#BINARY#]. I followed the instructions exactly, even I change
> the
> > parameters | Insert Field Value in Pictures Properties.
> >
> > The Frontpage's HTML wiev shows as follows:
> >
> > <html>
> >
> > <head>
> > <meta name="GENERATOR" content="Microsoft FrontPage 5.0">
> > <meta name="ProgId" content="FrontPage.Editor.Document">
> > <% ' FP_ASP -- ASP Automatically generated by a Frontpag
> Component. Do
> > not Edit.
> > FP_CharSet = "windows-1252"
> > FP_CodePage = 1252 %>
> > <meta http-equiv="Content-Type" content="text/html;
> > charset=windows-1252">
> > <title>All Products</title>
> > </head>
> >
> > <body>
> >
> > <p> </p>
> > <table border="1">
> > <thead>
> > <tr>
> > <td><b>Picture</b></td>
> > </tr>
> > </thead>
> > <tbody>
> > 
> > <% if 0 then %>
> > <SCRIPT Language="JavaScript">
> > document.write("<div style='background: yellow; color: black;'>The
> > Database Results component on this page is unable to displa
> database
> > content. The page must have a filename ending in '.asp', and th
> web
> > must be hosted on a server that supports Active Serve
> Pages.</div>");
> > </SCRIPT>
> > <% end if %>
> > <%
> > fp_sQry="SELECT * FROM WorkArt ORDER BY ExpirationDate ASC"
> > fp_sDefault=""
> > fp_sNoRecords="<tr><td colspan=1 align=left width=""100%"">N
> records
> > returned.</td></tr>"
> > fp_sDataConn="artsHOODB"
> > fp_iMaxRecords=256
> > fp_iCommandType=1
> > fp_iPageSize=5
> > fp_fTableFormat=True
> > fp_fMenuFormat=False
> > fp_sMenuChoice=""
> > fp_sMenuValue=""
> > fp_iDisplayCols=1
> > fp_fCustomQuery=False
> > BOTID=0
> > fp_iRegion=BOTID
> > %>
> > 
> > <tr>
> > <td><img border="0"
> > src="<%=FP_FieldLink(fp_rs,"Picture")%>"></td>
> > </tr>
> > 
> > </tbody>
> > </table>
> >
> > </body>
> >
> > </html>
> >
> >
> > Please, I would appreciate to much if anyone can help me .
> >
> >
> > Euroiranian Co
> >
> ------------------------------------------------------------------------
> > Posted via http://www.forum4designers.com
> >
> ------------------------------------------------------------------------
> > View this thread: http://www.forum4designers.com/message44055.html
> > *

Euroiranian Co
------------------------------------------------------------------------
Posted via http://www.forum4designers.com
------------------------------------------------------------------------
View this thread: http://www.forum4designers.com/message44055.html

's Computer Specifications

Thank you, I will try. But What means DRW?

Jim Buyens wrote:
> *Displaying pictures stored within an Access database is
> difficult.
>
> 1. You have to make the Database Results Region create
> the HTML for an <img> tag.
> 2. That <img> tag has to call an ASP or ASP.NET page,
> passing the database record ID in a query string
> variable (i.e. <img src="showpic.asp?dbid=1234">).
> 3. That ASP or ASP.NET page has to retrieve the
> database record and get the picture bits. In the
> case of ASP, this requries writing an ActiveX
> control in VB6.
> 4. The ASP or ASP.NET page then has to send the picture
> bits to the browser.
>
> If you want to pursue this further, browse MSKB article
> 175261:
> HOWTO: Retrieve Bitmap from Access and Display It in Web
> Page
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;175261
>
> The much more common solution, however, is to:
>
> 1. Store each picture as a stand-alone file.
> 2. Store the picture file name in the database.
> 3. Make the DRW create an <img> tag containing that
> filename.
>
> Step 3 requires that you code a custom query such as:
>
> SELECT '<img src="' & [picfilename] & '">', ...
>
> where picfilename is the name of the database field that
> contains the picture file name.
>
> 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)
> |/---------------------------------------------------
> *----------------------------------------------------
>
>
>
>
>
>
>
> >-----Original Message-----
> >
> >I'm a begginer in Web Design and I have a small but
> irritating problem.
> >
> >I'm trying to include pictures (OLE objects field
> DataType) from MS
> >Access in a database results page in Frontpage, but it
> shows a "X" or
> >[#BINARY#]. I followed the instructions exactly, even I
> changed the
> >parameters | Insert Field Value in Pictures Properties.
> >
> >The Frontpage's HTML wiev shows as follows:
> >
> ><html>
> >
> ><head>
> ><meta name="GENERATOR" content="Microsoft FrontPage 5.0">
> ><meta name="ProgId" content="FrontPage.Editor.Document">
> ><% ' FP_ASP -- ASP Automatically generated by a Frontpage
> Component. Do
> >not Edit.
> >FP_CharSet = "windows-1252"
> >FP_CodePage = 1252 %>
> ><meta http-equiv="Content-Type" content="text/html;
> >charset=windows-1252">
> ><title>All Products</title>
> ></head>
> >
> ><body>
> >
> ><p> </p>
> ><table border="1">
> ><thead>
> ><tr>
> ><td><b>Picture</b></td>
> ></tr>
> ></thead>
> ><tbody>
> >
> ><% if 0 then %>
> ><SCRIPT Language="JavaScript">
> >document.write("<div style='background: yellow; color:
> black;'>The
> >Database Results component on this page is unable to
> display database
> >content. The page must have a filename ending in '.asp',
> and the web
> >must be hosted on a server that supports Active Server
> Pages.</div>");
> ></SCRIPT>
> ><% end if %>
> ><%
> >fp_sQry="SELECT * FROM WorkArt ORDER BY ExpirationDate
> ASC"
> >fp_sDefault=""
> >fp_sNoRecords="<tr><td colspan=1 align=left
> width=""100%"">No records
> >returned.</td></tr>"
> >fp_sDataConn="artsHOODB"
> >fp_iMaxRecords=256
> >fp_iCommandType=1
> >fp_iPageSize=5
> >fp_fTableFormat=True
> >fp_fMenuFormat=False
> >fp_sMenuChoice=""
> >fp_sMenuValue=""
> >fp_iDisplayCols=1
> >fp_fCustomQuery=False
> >BOTID=0
> >fp_iRegion=BOTID
> >%>
> >
> ><tr>
> ><td><img border="0"
> >src="<%=FP_FieldLink(fp_rs,"Picture")%>"></td>
> ></tr>
> >
> ></tbody>
> ></table>
> >
> ></body>
> >
> ></html>
> >
> >
> >Please, I would appreciate to much if anyone can help me .
> >
> >
> >Euroiranian Co
> >----------------------------------------------------------
> --------------
> >Posted via http://www.forum4designers.com
> >----------------------------------------------------------
> --------------
> >View this thread:
> http://www.forum4designers.com/message44055.html
> >
> >.
> > *

Euroiranian Co
------------------------------------------------------------------------
Posted via http://www.forum4designers.com
------------------------------------------------------------------------
View this thread: http://www.forum4designers.com/message44163.html

's Computer Specifications

Euroiranian Co <(E-Mail Removed)> wrote in message news:<(E-Mail Removed)>...
> Thank you, I will try. But What means DRW?

Database Results Wizard.

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

's Computer Specifications

Hi Jim Buyens!,

First at all, thank you for your advises. But I tried to do as yo
instructed and the problem persists (DRW method, the other one is to
complicate for me). I'm thinking that the problem maybe came from othe
application as IIS or ODBC. Maybe possible?

Jim Buyens wrote:
> *Euroiranian Co <(E-Mail Removed)
> wrote in messag
> news:<(E-Mail Removed)>...
> > Thank you, I will try. But What means DRW?
>
> Database Results Wizard.
>
> 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)
> |/---------------------------------------------------
> *----------------------------------------------------

Euroiranian C
-----------------------------------------------------------------------
Posted via http://www.forum4designers.co
-----------------------------------------------------------------------
View this thread: http://www.forum4designers.com/message44163.htm

's Computer Specifications

Euroiranian Co <(E-Mail Removed)> wrote in message news:<(E-Mail Removed)>...
> Hi Jim Buyens!,
>
> First at all, thank you for your advises. But I tried to do as you
> instructed and the problem persists (DRW method, the other one is too
> complicate for me). I'm thinking that the problem maybe came from other
> application as IIS or ODBC. Maybe possible?

No, it's just plain hard to display pictures from databases.

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

's Computer Specifications

Dear Jim Buyens, Thank you for your kind cooperation. I think it will be
impossible to me. In any case, thank you. Yours Thomas.

Jim Buyens wrote:
> *Euroiranian Co <(E-Mail Removed)>
> wrote in message
> news:<(E-Mail Removed)>...
> > Hi Jim Buyens!,
> >
> > First at all, thank you for your advises. But I tried to do as you
> > instructed and the problem persists (DRW method, the other one is
> too
> > complicate for me). I'm thinking that the problem maybe came from
> other
> > application as IIS or ODBC. Maybe possible?
>
> No, it's just plain hard to display pictures from databases.
>
> 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)
> |/---------------------------------------------------
> *---------------------------------------------------- *

Euroiranian Co
------------------------------------------------------------------------
Posted via http://www.forum4designers.com
------------------------------------------------------------------------
View this thread: http://www.forum4designers.com/message44163.html

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access OLE Object Field	tssw	Microsoft Access	0	26th Aug 2004 02:51 AM
Begginer-Field calculation	sph	Microsoft Access Forms	1	9th Dec 2003 08:48 PM
Access 2000 - Insert OLE object programatically into a forms OLE object field	jon	Microsoft Access Macros	0	15th Sep 2003 08:13 AM
Access 2000 - Insert OLE object programatically into a forms OLE object field	jon	Microsoft Access VBA Modules	0	15th Sep 2003 07:57 AM
Access begginer - autoenter date/time when exiting a form	Damir	Microsoft Access Getting Started	1	10th Aug 2003 01:12 PM