Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rlong04
Starting Member
2 Posts |
 Posted - 2005-10-24 : 10:58:31
|
| Hi everyone, Here is what I need to do:I need to make an online image gallery for a realtor website; it must be updateable with a regular insert/update/delete form which is normally quite easy, however he wants to be able to add as many images as he needs to the database, so I'm not sure how to setup the database so that he can update the images and relate them to the correct listing. I am using the following software:· Windows XP Pro/IIS/ASP/VBScript· Access Database· Dreamweaver MX 2004· ASP Upload from DMXzone (enables me to upload images)· Smart Image Processor also from DMXzone (resizes and makes thumbs of uploaded images.Example from another site:http://www.macanthonyrealty.com/property.asp?id=2079#imgph I need to make it so that my clients can upload as many images as they need to. The first 6 will be shown on the details page, and the rest will be stored in an image gallery. When a small image is clicked it must switch the larger image. I almost completed this but I am stuck on the database development end. I don’t know if I need the images in their own table and if I do then how do I relate them to the main listings table so that it all updates correctly when a client inserts a new property listing with lots of images, and when they update or delete a record. I would guess I create a link between tables but I'm new at DB development so please help.Thanks very much in advance!!! |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-24 : 15:17:41
|
| I would suggest that you store the Path / Filename of the image in the database, and the physical image file using the filesystem.Kristen |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-10-26 : 08:48:51
|
| Kristen is right, images stored in a db are known as BLOB (Binary large objects) which is actually a bad designDreamweaver has a certain feature that allows you to do that with thier inbuilt wizard.Dont know about DMXZone's upload component, but the one which we use dundas allows you to manipulate the file name and save it as anything you want.AFrika |
|
|
|
|
|
|
Trying to build ASP/Access Image Gallery