Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 images from a database link
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

merdok
Junior Member

United Kingdom
129 Posts

Posted - 10 April 2002 :  06:43:44  Show Profile  Visit merdok's Homepage  Send merdok an ICQ Message
Hi guys.

Does anyone know how I can get an asp file to pull an image from a database link...

ie I can upload an image to a folder and then add a record to a database (using a web interface) which will link to the image and then display it on the database.

(if I didnt explain that very well then looking at my testbed might help )http://zones.filteredreality.co.uk/trial

thanks

Al.

---------------------
Visit the entertainment system: http://www.filteredreality.co.uk

Kat
Advanced Member

United Kingdom
3065 Posts

Posted - 10 April 2002 :  07:09:43  Show Profile  Visit Kat's Homepage
Yes in short.

You can upload your image to a set directory, then add the image relative path to the database, then reference the image path in your asp page after you have read the record from the database.

e.g. image is "bob.gif"
you put it in the "images" directory
its path is then "images\bob.gif"

in your asp page, get the record from the db and then refer to it and your page should insert "images\bob.gif" where you asked it to.

KatsKorner

Installation Help | http://ls3k.com/snitz/" target="_blank">Snitz Mods | Forum Hosting
Go to Top of Page

merdok
Junior Member

United Kingdom
129 Posts

Posted - 10 April 2002 :  07:27:32  Show Profile  Visit merdok's Homepage  Send merdok an ICQ Message
Cool!

Now I'm a complete novice at ASP so how exactly would i refrence it from the database?

Come to think of it... how do I add the image relative path to the database as well!

thanks for your help btw.

---------------------
Visit the entertainment system: http://www.filteredreality.co.uk
Go to Top of Page

Kat
Advanced Member

United Kingdom
3065 Posts

Posted - 10 April 2002 :  08:11:56  Show Profile  Visit Kat's Homepage
Well fist of all you need a database..

.. then you need a database table for the images to be stored on..

Have you got that?

KatsKorner

Installation Help | http://ls3k.com/snitz/" target="_blank">Snitz Mods | Forum Hosting
Go to Top of Page

merdok
Junior Member

United Kingdom
129 Posts

Posted - 10 April 2002 :  15:59:02  Show Profile  Visit merdok's Homepage  Send merdok an ICQ Message
yep.. I got that far...

This is what I've got so far:

http://zones.filteredreality.co.uk/trial/

---------------------
Visit the entertainment system: http://www.filteredreality.co.uk
Go to Top of Page

@tomic
Senior Member

USA
1790 Posts

Posted - 10 April 2002 :  16:18:50  Show Profile  Visit @tomic's Homepage  Send @tomic an ICQ Message
You are almost there. Where it is showing the link to the image add the html image tag around it. A good example of how this works is to check out the Snitz code for profile images. Both the entering into the database and display.

@tomic

http://www.skepticfriends.org
Go to Top of Page

merdok
Junior Member

United Kingdom
129 Posts

Posted - 11 April 2002 :  07:29:36  Show Profile  Visit merdok's Homepage  Send merdok an ICQ Message
FANTASTIC!!!
it worked! :) I expected it to be a LOT harder than that... thanx guys! :)

---------------------
Visit the entertainment system: http://www.filteredreality.co.uk
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.22 seconds. Powered By: Snitz Forums 2000 Version 3.4.07