Can't Display A Picture From Database Field

J

Jon

Hi all,

I have succesfully integrated my access database into a
webpage. It includes a table that shows "Item Number,
Product, Price". I am then able to click and get details
of each item showing on a seperate page. Know comes the
problem I have a field in Access that stores the related
pictures to these Items. When I display the details I get
all but the PICTURE to display. This is what I get:
ACA1 Acacia Flowers ?$ The first is the Item# the
second is the Product Name and the ?$ i suppose to be
the picture. Am I doing something wrong in Access or
Frontpage?

Thanks In Advance
Jon
 
M

Mike Mueller

Jon-
Are you storing the images in the DB or just a link? It is recommended
not to store images in Access, regardless if it is a web application or not.
Generally you would store the image location (eg URL) to get the picture.
MS has an article on how to do this...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;216285

HTH
Mike

Hi all,

I have succesfully integrated my access database into a
webpage. It includes a table that shows "Item Number,
Product, Price". I am then able to click and get details
of each item showing on a seperate page. Know comes the
problem I have a field in Access that stores the related
pictures to these Items. When I display the details I get
all but the PICTURE to display. This is what I get:
ACA1 Acacia Flowers ?$ The first is the Item# the
second is the Product Name and the ?$ i suppose to be
the picture. Am I doing something wrong in Access or
Frontpage?

Thanks In Advance
Jon
 
J

Jon

First off I am not sure of the best way to save a picture
in an Access Database.



Thanks for you input although I was not able to get it to
work. After saving as it says in step 6 I still have
broken links when I view the webpage. I'm not sure how
versed you are in Frontpage but what I am trying to do
may be different then what you are showing me. If I show
you my code maybe you would be able to help me out.





Here goes: There is a page before this that selects
the "Item Number" and uses it in a hyperlink to the "Herb
Details" Page



<html>



<head>

<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">

<title>New Page 1</title>

<meta name="Microsoft Theme" content="ricepapr 1011,
default">

</head>



<body>

<%

Dim conn, ItemNum, ConnectionString, Query,
HDetails 'Command Object

ConnectionString = "Driver={Microsoft Access Driver
(*.mdb)};Dbq=c:\Inetpub\wwwroot\fpdb\Customers2000_be.mdb;
Uid=admin;Pwd="

'ConnectionString = "DSN=Customer"

set conn = server.createobject("adodb.connection")

conn.open ConnectionString

ItemNum = (Request("[Item Number]"))

If ItemNum = " " Then

Response.Write "No Item Number Was Sent.<p>"

else

Query = "SELECT * FROM tblHerbs WHERE [Item Number]= '" &
ItemNum & "'"

Set HDetails = conn.Execute(Query)

%>



<tr>

&nbsp;</td>
Click to expand...

&nbsp;</td>
Click to expand...

&nbsp;</td> **THIS IS WHERE I WOULD LIKE MY
Click to expand...
PICTURE CODE**

&nbsp;</td>
Click to expand...







</tr>



<% =ItemNum %>

<% End If %>



</body>

</html>

<html></html>



Thanks Again

Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

picture link in database 0
Unable to display values in 2nd list box from 1st list box selection 2
Report with pictures 6
Hyperlink to detail view .asp 2
Displaying Pictures on Forms 2
Some mail merge fields not pulling into document 2
how do I attach a value to a check box in access 2007? 4
Printing or Not Printing Pictures 0

Top