If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ASP > image appear via msaccess db on .asp pages....???

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-14-03, 07:47
blondini3 blondini3 is offline
Registered User
 
Join Date: Feb 2003
Location: new zealand
Posts: 17
image appear via msaccess db on .asp pages....???

hi there world,

I have an msaccess database with a field/column for product images. I want these images to appear on my webpages. I have successfully got all other fields to appear (i'm using dreamweaver mx .asp pages) but the image field appears as a square with red x in it !.

in the .asp file, the img srce = <%=(Recordset1.Fields.Item("Image").Value)%>

...via a recordset pointing to the databse.

you can view it at www.relief.co.nz/product.asp


i have tried the msaccess image field/column to be text and also tried it as a hyperlink ..

i have had this working before, but forgot to write it down !!!

thanks, any help appreciated.
angie.
Reply With Quote
  #2 (permalink)  
Old 05-14-03, 10:22
JonathanB JonathanB is offline
Registered User
 
Join Date: Feb 2002
Location: North Wales, UK
Posts: 114
Try using:
Quote:
response.binarywrite RecordSetName("image")
__________________
J^ - web | email
newsASP Developer
Reply With Quote
  #3 (permalink)  
Old 05-14-03, 17:51
blondini3 blondini3 is offline
Registered User
 
Join Date: Feb 2003
Location: new zealand
Posts: 17
okay I'll try that.

do i have the msaccess image field set to text or hyperlink ?? and if it is set to text, do i just put the name of the image file e.g. col30.jpg ?

angie.
Reply With Quote
  #4 (permalink)  
Old 05-14-03, 18:31
JonathanB JonathanB is offline
Registered User
 
Join Date: Feb 2002
Location: North Wales, UK
Posts: 114
Sorry I thought you had physically stored the image in a field.

Looking at your page source code the field appears to be blank in the table??

Quote:
<img name="colimage" src="" alt=""> </font></td>
The file should be text and should store the path the file file (ie. if the image (product1.jpg) was stored in the img/ folder the value of the field would be img/product1.jpg.

Ignore my previous post.
__________________
J^ - web | email
newsASP Developer
Reply With Quote
  #5 (permalink)  
Old 05-17-03, 06:26
blondini3 blondini3 is offline
Registered User
 
Join Date: Feb 2003
Location: new zealand
Posts: 17
thanks for that....all is now working great.
blondini.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On