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

Euroiranian Co · Feb 11, 2004

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

Steve Easton · Feb 11, 2004

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 said:
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

Jim Buyens · Feb 11, 2004

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. said:
</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>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u- dbrgn2="../../_fpclass/fpdbrgn2.inc"
i-groupsize="5" clientside tag="TBODY" preview="<tr><td
colspan=64 bgcolor="#FFFF00" align="left"
width="100%"><font

color="#000000">This is

the end of a Database Results
region.</font></td></tr><TR><TD ALIGN=LEFT
VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT TYPE=Button
VALUE=" |< "><INPUT TYPE=Button VALUE="
< "><INPUT TYPE=Button VALUE=" >
"><INPUT TYPE=Button VALUE=" >| ">

[1/5]</NOBR><BR></td></tr>"

Click to expand...

startspan
-->
</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 · Feb 11, 2004

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 said:
*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" <[email protected]
wrote in
message news:[email protected]...

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

Click to expand...

Pages. said:

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

Click to expand...

Euroiranian Co

Euroiranian Co · Feb 11, 2004

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

Jim said:
*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

Click to expand...

Pages. said:

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

.
*

Click to expand...

Euroiranian Co

Jim Buyens · Feb 12, 2004

Euroiranian Co said:
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 Co · Feb 12, 2004

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 said:
*Euroiranian Co <[email protected]
wrote in messag

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

Jim Buyens · Feb 12, 2004

Euroiranian Co said:
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 · Feb 14, 2004

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 said:
*Euroiranian Co <[email protected]>
wrote in message

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

I am trying to understand this code...	3	Jul 26, 2008
@ my wits end	1	Sep 12, 2006
any ideas why I can update one table in my database but not the other?	2	Sep 22, 2006
Please help, FP generated code produces a "Too few parameters. Expected1" error!	7	Jun 6, 2005
Database Update Buttons	8	May 25, 2005
Select statement aanpassen in asp gedeelte middels variable	1	Mar 30, 2007
UPDATE database problems	10	Aug 13, 2004
DataBase results Error continued	1	Sep 10, 2004

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

Euroiranian Co

Steve Easton

Jim Buyens

Euroiranian Co

Euroiranian Co

Jim Buyens

Euroiranian Co

Jim Buyens

Euroiranian Co

Ask a Question

Similar Threads