Fosters

I believe you are the man when it comes to ASP.:) I am still in the middle of my first ASP project (well, nearly complete actually), but I am struggling with uploading images to the DB. I want the user to be able to browse their C Drive, click add, and the image is then stored in an "image" field, to be displayed on the web page when called.

I understand it needs to be stored as Binary Data, but is there an easy way of doing it?

My reckoning is: (these images are for used cars)

* form with current car data, and "add picture" button.
* asp process page, takes carid from form page, and submitted image - inserts it as binary data into field.
* display page then calls image when referencing record using carid.

Sound any good?

Also, is there a way to resize or scale said image, or will the user need to do this beforehand?

DW :)

I'll have a look at work tomorrow if I have time. I wrote some code to do this sort of thing. Its been a while since I did it. Basically its just an admin asp page that allows the user to upload images to a sql database (blob field).

H

Which bit are you struggling with?

to browse/Upload the users files...
<input type=file name=sFileName value=""><input type=button value="Add" onClick="addsong()">

the actual upload is another matter!
I have bits of code that I'll post as I find them
here's a piece of code that'll upload any file...
http://www.btinternet.com/~madtoye/saveany.asp
more to follow...

I found this one - you'll need to specify your ADO connection, but it's pretty self contained...

http://www.btinternet.com/~madtoye/fileuploader.zip