OK,

am creating a simple asp page on a website which will display images from an Access database. I am using Dreamweaver. I have succesfully pulled user info (name, address, job, email) from a database table and displayed in a web page.

What I want to know is what is the best way to pull images from an Access database and display them in a table?

Basically, all that will be in the table will be a picture (or reference to it) of a product and price of the product.

Maximusimo

p.s. even if you could point me in the direction of an extension which could help me, e.g. a shopping cart kind of idea but without the ability to "add to cart"

Edited by - maximusimo on 01 Nov 2005 13:59:43

have a field in access to hold the image as text.

then link to the images relatively in the db.

../img/myimage.jpg is an example.

make sure all the images are uploaded to the correct folder, and then just create a repeat region on the table once youve dragged the data bindings in.

regards

Dave Thomas
<b>DMX Zone Manager</b>

Thanks Dave

I tried this earlier on today but when output all i got was the actual path to the image although have a funny feeling my repeat region could have been wrong. Will give it a whirl when i get home from work and post back

maximusimo

sorry forgot a bit.

where you want to insert the image, do it as normal.

insert &gt; image.

Then

in the Select file from bit, choose Data Sources. This will now pop up a window with your recordset info in it. choose the field where you have the image link, and now thats it <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>



regards

Dave Thomas
<b>DMX Zone Manager</b>

Dave,

I can't thank you enough - it worked first time!!!!!

One more thing, is there anyway i can make the images resize to that of the size of the Dreamweaver table? I did put in Width and Height in the table but didnt seem to work.

Maximusimo

when the image is inserted, it comes up as the default 'tree' symbol.
ok, now in the 'properties' panel, if you click the little refresh icon next to width/height, it will set the image to 32x32, or you can set your own size in here.

only problem with this is, no matter the size of your image it will come out as big as you stipulate. it's a good thing to do though, if you have prepared images to be all the same size.



regards

Dave Thomas
<b>DMX Zone Manager</b>

Hi... I'm trying to do the exact same thing here and finally know there is an easy way to do it. Problem. I need some help! I'm not as well versed in dreamweaver and access as what I could be but i have some basic knowledge.

For this i have created a simple db with name, comments, and image all as text and image with reference "/images/image.jpg" in the image field. From here I am a little stuck. How do i create a repeat region for the table and data bindings?

Maybe my setting in dreamweaver aren't right and it is slowing me down.

Any help on this would be awesome...

Hi Reuben

Just select the table you wish to repeat and hit the plus sign in Server Behaviors.
Select Repeat Region.

Make sure you select the right recordset to be repeated in the meny that pops up.

Voila!



Help is only a click away...
~~~~~~~~~~~~~~~~~
DWMX2004 | ASP | Access

hi - i don't know if anyone will be able to help me with this, but it's connected to the original question -

i can get to the point where i "select image source", then click on "data source".

problem is, when i try to expand the recordset to select the correct field, dreamweaver says "an unidentified error has occurred",

and only gives me an "ok" button to click to close the "error" message.

i'm a real novice when it comes to asp and databases, but i'm trying to do stuff for my work's pre-existing website, which is based around it.

i'm now trying to add a picture to an asp page which already shows news articles.

this "error" is really frustrating, because it doesn't give me any information to work with, so i'm hoping that someone has a shot in the dark i can try???

hi, i`m still stuck at the level of trying to get the images on the server from the user.
please any help would be appreciated.
i tried jacob giley`s post but the files did not upload even though the page showed succesful upload.

i have received help from a fellow dmxzoner regarding my earlier, and thought i should share it in case it could benefit anyone having a similar problem.

it seems that xp's service pack 2 causes problems with database connectivity in dreamweaver.

there is a fix available on macromedia's website, here:

www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19515#aspnet_db

note: read the instructions!

thanks again to jenny rigby for the help!

hi there guys im new to dmxzone.

im having the same problem (extracting images from an access database and presenting them in a webpage.)

if someone could give me a step-by-step guide id be very grateful.

ive embedded the images in the database.

i need to know what to do once ive created the recordset in dreamweaver.

what i would like to do is have a drop down list from which the user can select a product line. then once the user has selected, the corresponding images are displayed.

thanks

Edited by - choobakka on 26 Mar 2006 16:45:10