Show inventory pictures in database results page.

[Guest]

I have started a product catalog online. I used both database interface
wizzard & database results wizzard to make products search page. I am using
ASP & access 2003 for the database. I have the table fields: picture (ole
object), name, description, price. With some work I was able to get database
working. When someone types in a product then it shows them the results.
However, how do I get the picture to load up. When I put it the picture ole
field #binary# shows up in the picture field of the frontpage results page
instead of the picture.

So close but sooo far away. Any help!!

 

[Kathleen Anderson [MVP - FrontPage]]

Store the images in your web site and put a link to them in your database:
http://support.microsoft.com/kb/216285/en-us

 

[Guest]

I found that site after I posted the message (at least the 2003). I wasn't
sure how to follow the 312638 (http://support.microsoft.com/kb/312638/EN-US/)
FP: What You Need to Use Active Server Pages (ASP) in FrontPage 2000 part of
it.

I followed the "How to display a picture by using an Access database in
FrontPage 2003", but got the following error:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name
or ordinal.

/_fpclass/fpdblib.inc, line 48


Line 48 is: If Not IsEmpty(rs) And Not (rs Is Nothing) and Not
IsNull(rs(fldname)) Then
Select Case rs(fldname).Type
Case 128, 204, 205 ' adBinary, adVarBinary, adLongVarBinary
FP_Field = "[#BINARY#]"

I think I need to change something in the HTML, but unsure which section. I
am not much of a programmer or html writter. I understand the basics, just
not the advanced stuff.

 

[Kathleen Anderson [MVP - FrontPage]]

Try changing the data type in the database and reimport the database into
your FP web.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

I found that site after I posted the message (at least the 2003). I wasn't
sure how to follow the 312638
(http://support.microsoft.com/kb/312638/EN-US/)
FP: What You Need to Use Active Server Pages (ASP) in FrontPage 2000 part
of
it.

I followed the "How to display a picture by using an Access database in
FrontPage 2003", but got the following error:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name
or ordinal.

/_fpclass/fpdblib.inc, line 48


Line 48 is: If Not IsEmpty(rs) And Not (rs Is Nothing) and Not
IsNull(rs(fldname)) Then
Select Case rs(fldname).Type
Case 128, 204, 205 ' adBinary, adVarBinary, adLongVarBinary
FP_Field = "[#BINARY#]"

I think I need to change something in the HTML, but unsure which section.
I
am not much of a programmer or html writter. I understand the basics,
just
not the advanced stuff.

Store the images in your web site and put a link to them in your
database:
http://support.microsoft.com/kb/216285/en-us

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Guest]

Do you mean the picture field data type? It's set to text at the moment.

Thanks for your help.

Try changing the data type in the database and reimport the database into
your FP web.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

I found that site after I posted the message (at least the 2003). I wasn't
sure how to follow the 312638
(http://support.microsoft.com/kb/312638/EN-US/)
FP: What You Need to Use Active Server Pages (ASP) in FrontPage 2000 part
of
it.

I followed the "How to display a picture by using an Access database in
FrontPage 2003", but got the following error:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name
or ordinal.

/_fpclass/fpdblib.inc, line 48


Line 48 is: If Not IsEmpty(rs) And Not (rs Is Nothing) and Not
IsNull(rs(fldname)) Then
Select Case rs(fldname).Type
Case 128, 204, 205 ' adBinary, adVarBinary, adLongVarBinary
FP_Field = "[#BINARY#]"

I think I need to change something in the HTML, but unsure which section.
I
am not much of a programmer or html writter. I understand the basics,
just
not the advanced stuff.

Store the images in your web site and put a link to them in your
database:
http://support.microsoft.com/kb/216285/en-us

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


I have started a product catalog online. I used both database interface
wizzard & database results wizzard to make products search page. I am
using
ASP & access 2003 for the database. I have the table fields: picture
(ole
object), name, description, price. With some work I was able to get
database
working. When someone types in a product then it shows them the
results.
However, how do I get the picture to load up. When I put it the
picture
ole
field #binary# shows up in the picture field of the frontpage results
page
instead of the picture.

So close but sooo far away. Any help!!

 

[Guest]

Kathleen,

I did figure it out. This might help out other people. I used just the
results wizzard. When I followed the "how to display a picture... fp 2003"
in place of images/mycat.jpg, I used my entire address.
http://www.mydomain.com/images/mycat.jpg

Also, I didn't delete the " around the favoriteimage under the insert field
parameter. It worked. yehhhhhhhhhhh

Try changing the data type in the database and reimport the database into
your FP web.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

I found that site after I posted the message (at least the 2003). I wasn't
sure how to follow the 312638
(http://support.microsoft.com/kb/312638/EN-US/)
FP: What You Need to Use Active Server Pages (ASP) in FrontPage 2000 part
of
it.

I followed the "How to display a picture by using an Access database in
FrontPage 2003", but got the following error:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name
or ordinal.

/_fpclass/fpdblib.inc, line 48


Line 48 is: If Not IsEmpty(rs) And Not (rs Is Nothing) and Not
IsNull(rs(fldname)) Then
Select Case rs(fldname).Type
Case 128, 204, 205 ' adBinary, adVarBinary, adLongVarBinary
FP_Field = "[#BINARY#]"

I think I need to change something in the HTML, but unsure which section.
I
am not much of a programmer or html writter. I understand the basics,
just
not the advanced stuff.

Store the images in your web site and put a link to them in your
database:
http://support.microsoft.com/kb/216285/en-us

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


I have started a product catalog online. I used both database interface
wizzard & database results wizzard to make products search page. I am
using
ASP & access 2003 for the database. I have the table fields: picture
(ole
object), name, description, price. With some work I was able to get
database
working. When someone types in a product then it shows them the
results.
However, how do I get the picture to load up. When I put it the
picture
ole
field #binary# shows up in the picture field of the frontpage results
page
instead of the picture.

So close but sooo far away. Any help!!