p2p.wrox.com: Archives - asp

asp_databases thread: OLE Object from MS Access to ASP page

Message #1 by "Valentino Osterwalder" <valentino@t...> on Fri, 11 Jan 2002 22:36:01

With an ASP page I want to retrieve a record from a MS Access Table called 

Personal. In this record there is a field as DataType OLE Object 

containing a picture. I would like to show this field in a table in the 

ASP page. When I display it in HTML I write the following code 



--<IMG BORDER="0" SRC="../../../images/Pictures/AD_BM.gif" ALT="Foto 135 x 

155" WIDTH="135" HEIGHT="155"><BR>-- 



and want to replace it with this 



--<IMG BORDER="0" SRC="<%=objRSPlayer("PictureMember")%>" ALT="Foto 135 x 

155" WIDTH="135" HEIGHT="155">-- 



but it does not work. I just get the window but no image in it. I checked 

the SQL string and it works fine. In the access DB, when I open a form,I 

can see the picture.



The picture is stored in a directory outside de DB and the OLE Object 

field has a link to it.



How can I manage that when the record is chosen the ASP page shows its 

picture?

Message #2 by "Kim Iwan Hansen" <kimiwan@k...> on Fri, 11 Jan 2002 23:47:35 +0100

Just use a text field to store the url for the images.



For added flexibility, you can add height and width (number) fields, or use

a component or some script to determine the height and width of the images.



-Kim







> -----Original Message-----

> From: Valentino Osterwalder [mailto:valentino@t...]

> Sent: 11. januar 2002 22:36

> To: ASP Databases

> Subject: [asp_databases] OLE Object from MS Access to ASP page

>

>

> With an ASP page I want to retrieve a record from a MS Access

> Table called

> Personal. In this record there is a field as DataType OLE Object

> containing a picture. I would like to show this field in a table in the

> ASP page. When I display it in HTML I write the following code

>

> --<IMG BORDER="0" SRC="../../../images/Pictures/AD_BM.gif"

> ALT="Foto 135 x

> 155" WIDTH="135" HEIGHT="155"><BR>--

>

> and want to replace it with this

>

> --<IMG BORDER="0" SRC="<%=objRSPlayer("PictureMember")%>" ALT="Foto 135 x

> 155" WIDTH="135" HEIGHT="155">--

>

> but it does not work. I just get the window but no image in it. I checked

> the SQL string and it works fine. In the access DB, when I open a form,I

> can see the picture.

>

> The picture is stored in a directory outside de DB and the OLE Object

> field has a link to it.

>

> How can I manage that when the record is chosen the ASP page shows its

> picture?

>




> $subst('Email.Unsub').

>

Message #3 by "Drew, Ron" <RDrew@B...> on Fri, 11 Jan 2002 18:17:55 -0500

Maybe try...

--<IMG BORDER=3D"0" SRC=3D"<%=3DobjRSPlayer("PictureMember")%>.gif" 

ALT=3D"Foto

135 x

155" WIDTH=3D"135" HEIGHT=3D"155">--



-----Original Message-----

From: Valentino Osterwalder [mailto:valentino@t...]

Sent: Friday, January 11, 2002 5:36 PM

To: ASP Databases

Subject: [asp_databases] OLE Object from MS Access to ASP page





With an ASP page I want to retrieve a record from a MS Access Table

called

Personal. In this record there is a field as DataType OLE Object

containing a picture. I would like to show this field in a table in the

ASP page. When I display it in HTML I write the following code



--<IMG BORDER=3D"0" SRC=3D"../../../images/Pictures/AD_BM.gif" 

ALT=3D"Foto 135

x

155" WIDTH=3D"135" HEIGHT=3D"155"><BR>--



and want to replace it with this



--<IMG BORDER=3D"0" SRC=3D"<%=3DobjRSPlayer("PictureMember")%>" 

ALT=3D"Foto 135

x

155" WIDTH=3D"135" HEIGHT=3D"155">--



but it does not work. I just get the window but no image in it. I

checked

the SQL string and it works fine. In the access DB, when I open a form,I



can see the picture.



The picture is stored in a directory outside de DB and the OLE Object

field has a link to it.



How can I manage that when the record is chosen the ASP page shows its

picture?






$subst('Email.Unsub').

Message #4 by "Valentino Osterwalder" <valentino@t...> on Sat, 12 Jan 2002 12:54:20

Hi, I tried but does not work. But I wonder what the meaning of "3D" is 

and "=20" as well.Have you got an explaination or an address to find some 

documents about?



What I want to do is open an ASP page showing the personal data of a 

single person, its picture as well, chosen from a list of people. Where 

can I find docu's about OLE in ASP?



Many thanks in advance for your help, and I hope I wont bother you to much.



Regards

Valentino





> Maybe try...

> --<IMG BORDER=3D"0" SRC=3D"<%=3DobjRSPlayer("PictureMember")%>.gif" 

> ALT=3D"Foto

> 135 x

> 155" WIDTH=3D"135" HEIGHT=3D"155">--

> 

> -----Original Message-----

> From: Valentino Osterwalder [mailto:valentino@t...]

> Sent: Friday, January 11, 2002 5:36 PM

> To: ASP Databases

> Subject: [asp_databases] OLE Object from MS Access to ASP page

> 

> 

> With an ASP page I want to retrieve a record from a MS Access Table

> called

> Personal. In this record there is a field as DataType OLE Object

> containing a picture. I would like to show this field in a table in 

the

> ASP page. When I display it in HTML I write the following code

> 

> --<IMG BORDER=3D"0" SRC=3D"../../../images/Pictures/AD_BM.gif" 

> ALT=3D"Foto 135

> x

> 155" WIDTH=3D"135" HEIGHT=3D"155"><BR>--

> 

> and want to replace it with this

> 

> --<IMG BORDER=3D"0" SRC=3D"<%=3DobjRSPlayer("PictureMember")%>" 

> ALT=3D"Foto 135

> x

> 155" WIDTH=3D"135" HEIGHT=3D"155">--

> 

> but it does not work. I just get the window but no image in it. I

> checked

> the SQL string and it works fine. In the access DB, when I open a form,I

> 

> can see the picture.

> 

> The picture is stored in a directory outside de DB and the OLE Object

> field has a link to it.

> 

> How can I manage that when the record is chosen the ASP page shows its

> picture?

> 




> $subst('Email.Unsub').

Message #5 by "Phil Sayers" <philipsayers@m...> on Sat, 12 Jan 2002 11:34:22 -0500

I think 3D is a space (sames as &nbsp;) and =20 is a new line character.

Can someone else confirm?





-----Original Message-----

From: Valentino Osterwalder [mailto:valentino@t...] 

Sent: Saturday, January 12, 2002 12:54 PM

To: ASP Databases

Subject: [asp_databases] RE: OLE Object from MS Access to ASP page



Hi, I tried but does not work. But I wonder what the meaning of "3D" is 

and "=20" as well.Have you got an explaination or an address to find

some 

documents about?



What I want to do is open an ASP page showing the personal data of a 

single person, its picture as well, chosen from a list of people. Where 

can I find docu's about OLE in ASP?



Many thanks in advance for your help, and I hope I wont bother you to

much.



Regards

Valentino





> Maybe try...

> --<IMG BORDER=3D"0" SRC=3D"<%=3DobjRSPlayer("PictureMember")%>.gif" 

> ALT=3D"Foto

> 135 x

> 155" WIDTH=3D"135" HEIGHT=3D"155">--

> 

> -----Original Message-----

> From: Valentino Osterwalder [mailto:valentino@t...]

> Sent: Friday, January 11, 2002 5:36 PM

> To: ASP Databases

> Subject: [asp_databases] OLE Object from MS Access to ASP page

> 

> 

> With an ASP page I want to retrieve a record from a MS Access Table

> called

> Personal. In this record there is a field as DataType OLE Object

> containing a picture. I would like to show this field in a table in 

the

> ASP page. When I display it in HTML I write the following code

> 

> --<IMG BORDER=3D"0" SRC=3D"../../../images/Pictures/AD_BM.gif" 

> ALT=3D"Foto 135

> x

> 155" WIDTH=3D"135" HEIGHT=3D"155"><BR>--

> 

> and want to replace it with this

> 

> --<IMG BORDER=3D"0" SRC=3D"<%=3DobjRSPlayer("PictureMember")%>" 

> ALT=3D"Foto 135

> x

> 155" WIDTH=3D"135" HEIGHT=3D"155">--

> 

> but it does not work. I just get the window but no image in it. I

> checked

> the SQL string and it works fine. In the access DB, when I open a

form,I

> 

> can see the picture.

> 

> The picture is stored in a directory outside de DB and the OLE

Object

> field has a link to it.

> 

> How can I manage that when the record is chosen the ASP page shows

its

> picture?

> 




> $subst('Email.Unsub').






$subst('Email.Unsub').

Message #6 by "Valentino Osterwalder" <valentino@t...> on Mon, 14 Jan 2002 22:44:37

Many thanks for all answers! Eventhough they gave me some hints I could 

manage it by having a look to "Beginning ASP Databases" which is quite 

helpful.



Thanks again!







> I think 3D is a space (sames as &nbsp;) and =20 is a new line character.

> Can someone else confirm?

> 

> 

> -----Original Message-----

> From: Valentino Osterwalder [mailto:valentino@t...] 

> Sent: Saturday, January 12, 2002 12:54 PM

> To: ASP Databases

> Subject: [asp_databases] RE: OLE Object from MS Access to ASP page

> 

> Hi, I tried but does not work. But I wonder what the meaning of "3D" is 

> and "=20" as well.Have you got an explaination or an address to find

> some 

> documents about?

> 

> What I want to do is open an ASP page showing the personal data of a 

> single person, its picture as well, chosen from a list of people. Where 

> can I find docu's about OLE in ASP?

> 

> Many thanks in advance for your help, and I hope I wont bother you to

> much.

> 

> Regards

> Valentino

> 

> 

> > Maybe try...

> > --<IMG BORDER=3D"0" SRC=3D"<%=3DobjRSPlayer("PictureMember")%>.gif" 

> > ALT=3D"Foto

> > 135 x

> > 155" WIDTH=3D"135" HEIGHT=3D"155">--

> > 

> > -----Original Message-----

> > From: Valentino Osterwalder [mailto:valentino@t...]

> > Sent: Friday, January 11, 2002 5:36 PM

> > To: ASP Databases

> > Subject: [asp_databases] OLE Object from MS Access to ASP page

> > 

> > 

> > With an ASP page I want to retrieve a record from a MS Access Table

> > called

> > Personal. In this record there is a field as DataType OLE Object

> > containing a picture. I would like to show this field in a table in 

> the

> > ASP page. When I display it in HTML I write the following code

> > 

> > --<IMG BORDER=3D"0" SRC=3D"../../../images/Pictures/AD_BM.gif" 

> > ALT=3D"Foto 135

> > x

> > 155" WIDTH=3D"135" HEIGHT=3D"155"><BR>--

> > 

> > and want to replace it with this

> > 

> > --<IMG BORDER=3D"0" SRC=3D"<%=3DobjRSPlayer("PictureMember")%>" 

> > ALT=3D"Foto 135

> > x

> > 155" WIDTH=3D"135" HEIGHT=3D"155">--

> > 

> > but it does not work. I just get the window but no image in it. I

> > checked

> > the SQL string and it works fine. In the access DB, when I open a

> form,I

> > 

> > can see the picture.

> > 

> > The picture is stored in a directory outside de DB and the OLE

> Object

> > field has a link to it.

> > 

> > How can I manage that when the record is chosen the ASP page shows

> its

> > picture?

> > 




> > $subst('Email.Unsub').

> 




> $subst('Email.Unsub').

>

Return to Index

P2P Archives