CPT
|
| Posted: 01/29/2003, 7:18 AM |
|
Hi,
I am interested in using my database to store .zip files and images. Just wondering if anyone can help me with this, I am trying to create a way of uploading the files to the database as well as showing the pictures or downloading the .zip files.
I have looked at the article on storing images in the database and I do not really understand it, probably because I am using ASP with an access database.
If you have an example file or something that would be great.
I am using ASP with templates in CCS - with an access database.
Thanks
|
|
|
 |
CPT
|
| Posted: 01/29/2003, 7:49 AM |
|
Me again,
I have found an article about doing this sort of thing in ASP, I'm just not sure about how to do this with CCS. Ideally I would like the file upload to be a part of the same form that the information would be placed in, if you see what I mean. Else I would have to have the return page set to a form that uploads the pictures/files.
Help me pleeeeease!
CPT
|
|
|
|
Peter
|
| Posted: 01/29/2003, 9:19 AM |
|
How about sharing the article (URL) with others?
|
|
|
|
CPT
|
| Posted: 01/29/2003, 9:35 AM |
|
Oh yeah, I meant to include that;
http://stardeveloper.com/articles/display.html?article=2001033101&page=1
I basically want to know how I would create a record in CCS where I can update the info, like file name, category etc as well as upload the file to the database. Another page that will download the file, and a page that will display the pictures.
I could use the tutorial to do it in just ASP, but I want to be able to do it from CCS.
Can you help?
recedo@eurobell.co.uk
CPT
|
|
|
|
me
|
| Posted: 01/29/2003, 10:08 AM |
|
http://www.vision.to/index.php?page_id=14
|
|
|
|
CPT
|
| Posted: 01/29/2003, 3:09 PM |
|
Thanks for that, I would probably buy it if it was in ASP with MS Access and in CCS, the rest of my project is built like that and I do not plan to change it, as I like using ASP with access and am quite happy with it.
I am really looking for someone who can help me through the process of doing it, so I can learn at the same time.
Thanks anyway
CPT
|
|
|
|
Jim Miotke
|
| Posted: 01/29/2003, 4:54 PM |
|
I would recommend using a text field to store a relative path to the files. As an example, you could use %root%/zips, and %root%/images, and in your database, call the relative paths to actual files. That way, you don't eat-up database space with large binaries, and your links point directly to images, or actual zipfiles, which can prompt for save simply by clicking.
For this example, you will need both a frames-enabled browser and JavaScript turned on. As an example, go to "http://www.idbdeveloper.com/Ecommerce/webstore.asp"
Once there, select a product from the nav, or toc on left.
Click on any of the "more info" hyperlinks/buttons, and an individual item record is displayed.
Here, the database simply has an IMAGE field defined as 255/Text, where a relative path is the field data. The root from the server defaults, and the appended --
''' <img src="/Ecommerce/Graphics/IMAGE_NAME.gif.or.jpg.or.png.or.etc"> '''
The same could be done for a ZIP file, where the link, in HTML, is the field data, and an anchor reference in the "click me" link.
Hope that helps ;^)
Jim Miotke
idbDeveloper.com
|
|
|
|
CPT
|
| Posted: 01/30/2003, 3:41 AM |
|
Hi,
Thanks for that, I am currently using that method, but did really want to centralise all the files and images as they are not very large file sizes.
But, I would us that method, if I can get some help on uploading the images/files and automatically updating the links in the databse, ie. I currently have a Root/images/templates folder and in the DB the files are liked to like this images/templates/imagename.gif but, I would like it so I could have a page in the admin section where I could fill in all the information (price, details etc) as well as upload the images (2 per item) and/or files and have the DB update the image locations automatically.
At the moment I have no upload system working, but I can implement a simple thing as I have ASPupload, but by doing this I have to update the DB fields by hand, I would like this automated.
Hope you understand what I mean.
Thanks
|
|
|
|
|
