Help with saving files and images into a database

[Mario2002]

HI,

I was wondering if anyone has any experience saving uploaded files and images into a database (either Oracle or SQLServer). I what I need to do is allow the users to upload files but the files need to be saved into a database and retrieved from the database as needed. I was wondering if there is a way to do this with out having to use Java. I have been told that it can only be done with java, but I hope this is incorrect.

If anyone has any examples or knows of a website that might explain how to do it, I would appreicate the help.

Thanks in advance

Mario

 

[MsChelle]

Would storing the files in a directory and saving only the filename to the database do what you need it to do?

 

[Mario2002]

I was hoping that I could do that but I was told that the documents must be stored in a database so that no one but the admin will have the ability to add/delete documents.

The problem is that everyone is worried because people are changing the documents to make the numbers look better and so on. The admins would like to have the original stored someplace where no one can get to it. The original in the db would have datetime stamp and the id of who put it in there and everytime a new version was uploaded the old version is surposed to be move to a history table.

I have been investigating different ways of doing this but I have not had any luck.

Mario

 

[paron]

Could you use sprocs on the back end? Upload directly into a temp table, add a timestamp and ID, and move to the permanent table?