Hi Dears I have to solve a problem which is
In my web pages a user come and enters his data which include his picture as wel which is uploaded and store on my server. But the problem is that when admin or he himself remove from my website then his data which is in data base is deleted but his picture is still on the server.
How can I delete this picture from the server ?

(*_*)

Numan
--------------------------------------------------
It is not important what you get But important is how you got it

__________________
(*_*)

Numan
--------------------------------------------------
It is not important what you get But important is  how you got it

You are storing the image in a directory. Isn't it ? let the relative path of that folder be \uploads (in relation to the folder of the page which deletes the user). You must store the file name in database. Let the filename of file corresponding to a person be pic_00213.jpg.

You can then delete this file using following script in your delete file. This uses file system object.

dim objFSO
Set objFSO=Server.CreateObject("scripting.filesystemob ject")
If(objFSO.FileExists(Server.MapPath(".") & "\uploads\pic_00213.jpg") then
    objFSO.DeleteFile Server.MapPath(".") & "\uploads\pic_00213.jpg"
End If
set objFSO=nothing

Dear if I should store these files in data base then please guide me that how can I store them in a data base and show them on front end



(*_*)

Numan
--------------------------------------------------
It is not important what you get But important is how you got it

You do not need to store the file in database. Actually the above code assumes that you are not storing it in database.

You need only store the name of the file in database. Store the file in a folder at server. This you can do with any standard file upload component like ASPUpload etc.

No dear if I want to store a picture in databse then how can I do this ?



(*_*)

Numan
--------------------------------------------------
It is not important what you get But important is how you got it

Here is a sample script. The table name is TBLFILESTORAGE. The upload component used is ASPUpload.

'getting uploaded files
            dim obj_upload
            Set obj_upload = Server.CreateObject("Persits.Upload.1")
            obj_upload.OverwriteFiles = true
            dim i_count ' the number of files uploaded
            i_count = obj_upload.Save(Server.MapPath(".") & "\uploadedfiles")
            if(i_count<1) then
                Response.Write("No file is uploaded or the uploaded file is empty.")
            end if

            'saving files to db
            dim i_loop
            dim rst_file_storage
            dim obj_file
            For i_loop = 1 to i_count
                'add file to db
                Set obj_file = obj_upload.Files(i_loop)
                dim file_content
                file_content = obj_file.Binary
                If Not obj_file Is Nothing Then ' If file is not enpty
                    Set rst_file_storage = Server.CreateObject("adodb.recordset")
                    rst_file_storage.Open "SELECT * FROM TBLFILESTORAGE", cnn_sql_blob, 2, 3
                    rst_file_storage.AddNew
                    rst_file_storage("file_name").Value = obj_file.Name
                    rst_file_storage("file_size").Value = obj_file.Size
                    rst_file_storage("file_content_type").Value = obj_file.ContentType
                    rst_file_storage("file_content").Value = obj_file.Binary
                    rst_file_storage.Update
                    rst_file_storage.close
                    set rst_file_storage = nothing
                    Response.Write("Successfully stored " & cstr(i_count) & " file(s) in DB.")
                else
                    Response.Write("The file was not selected or it was empty")
                end if
            next
----------------------------------------------------------

The field file_storage is of type image.

The above is for SQL 2000.

Here is the script to create db table.

qry_createtable="CREATE TABLE [TBLFILESTORAGE]("&_
        "[file_id] INT IDENTITY,"&_
        "[file_name] VARCHAR(250),"&_
        "[file_content_type] VARCHAR(1000),"&_
        "[file_size] INT,"&_
        "[file_content] IMAGE)"
cnn_sql_blob.Execute qry_createtable

Here you go.
http://stardeveloper.com/articles/di...1033101&page=1.
This is a nice article to insert images in database but however downloading files/images from database who are more than 4mb is a problem.
;)

iniro

Images and files are not stored in datastores in fact I do not believe its possible. If it is you will loose portability, bak files will get huge and....(lots of reasons why not)

madhukp's comment is very clear:
;;;You need only store the name of the file in database. Store the file in a folder at server. This you can do with any standard file upload component like ASPUpload etc.

In addition:
;;;This is a nice article to insert images in database but however downloading files/images from database who are more than 4mb is a problem.

Any image meant for a web page that is 4mb is crazy talk, the ASP upload object will handle a 4mb file without a problem (You should set the max size you want to allow though)



Wind is your friend
Matt