Show inventory pictures in database results page.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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


HLarkin said:
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 said:
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/
Click to expand...
Click to expand...
 
Do you mean the picture field data type? It's set to text at the moment.

Thanks for your help.

Kathleen Anderson said:
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/


HLarkin said:
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 said:
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!!
Click to expand...
Click to expand...
Click to expand...
 
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

Kathleen Anderson said:
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/


HLarkin said:
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 said:
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!!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top