Uploading Pictures According to the data

[baby]

Hi guys i got a question but i dunnoe if it fits in here.

I am told to do a function to allow user to upload a picture according to which record they are currently adding. So the picture is tie to the records. And when user do a search the picture that is link to the record will be show....

Any idea how to do it?

[honeybee]

One way is to store the picture in the database, along with other fields of the record. To know how to do that, you can check out Beacon's thread at the top of the Database Forum.

The other method is to have a field in the record store the path of the picture file on the disk. Better still if you could allocate a specific directory to store all such pictures.

.

[baby]

oh... regarding the storing of pathing is there anyway i can get the code? or EG?


Base on what you say, which of the mention 2 method is more easier to implement?

[baby]

i just downloaded beacon tutorial. But its based on VB.. What i am actually looking for is doing it on line. For users to upload pictures along with the database... ANy ideas where can i find the coding?

please help

[Danial]

Originally posted by baby
i just downloaded beacon tutorial. But its based on VB.. What i am actually looking for is doing it on line. For users to upload pictures along with the database... ANy ideas where can i find the coding?

please help

VB and asp is pretty much same, you have to change the code slightly to make it work in asp.


There are many free upload component available, and your host server should already have it installed, check it with them.

You could do it through code, but its quite advanced coding, if you wish i could pass it to you.

I would advice you use uploader component provided by your host or free one available for downloads.

Hope this helps.

[baby]

um.. i am not really sure if my this project will be put online but lets say right now i want it to work on my IIS. I am using the build in webserver INETPUB right now.

Is it possible? Can i get the coding for the upload of pictures to DB in asp format? cos i am not really sure how to convert VB -> asp..

[Danial]

Originally posted by baby
um.. i am not really sure if my this project will be put online but lets say right now i want it to work on my IIS. I am using the build in webserver INETPUB right now.

Is it possible? Can i get the coding for the upload of pictures to DB in asp format? cos i am not really sure how to convert VB -> asp..

I have posted this link in ASP forum many times . Here is a very good ASP tutorial. Look my post in this thread.

http://www.vbforums.com/showthread.p...ghlight=danial

Hope this helps.

Danial

[baby]

hi danial thx for the site.. But i realise its displaying images from datbase. Do you have the link that shows how to store images in to Database as OLE object?

Would really apperciate ur help

[Danial]

Originally posted by baby
hi danial thx for the site.. But i realise its displaying images from datbase. Do you have the link that shows how to store images in to Database as OLE object?

Would really apperciate ur help

Well you havent mentioned that you wanted to store as OLE object .

Here you go, i have just what you looking for, hope this servers your purpose.

Have fun

Danial

[baby]

great~

Let me try to see if i understand the coding haha.

Will post back if i got any problem =)

Thx alot danial

[baby]

um.. danial.. there are quite a number of files inside.

You mind telling me which are the files that is neccessary for the upload to database?

I am not really very good with asp coding. Is it possible that u can guide me thru

[abhijit]

if u are looking for a free upload component, i think dundas software might be able to help you there. i had a similar project 3 years ago. i had used that component to upload the files into the webserver and then copy them to respective user areas.

when you download the component, it comes with some sample asp pages.

cheers,
abhijit

[baby]

thx abhijit but i dun thinki can find the software u are referring to.


Danial - I went thru the coding u send me and i must say i dun really understand it. After some sourcing and google searching. I realise it actually can be done by storing the file name inside the database. Lets say under column pathname.

When u a user try to upload a file the path name will appear on the the text box EG: c:\mydocuments\pictures\image.jpg. Then just by taking the image.jpg store it in the database column pathname. And when displaying the page i will get the pathname and add in my server path and display the image.

Is it wise to do that?

Please help

[abhijit]

Originally posted by baby
thx abhijit but i dun thinki can find the software u are referring to.


Danial - I went thru the coding u send me and i must say i dun really understand it. After some sourcing and google searching. I realise it actually can be done by storing the file name inside the database. Lets say under column pathname.

When u a user try to upload a file the path name will appear on the the text box EG: c:\mydocuments\pictures\image.jpg. Then just by taking the image.jpg store it in the database column pathname. And when displaying the page i will get the pathname and add in my server path and display the image.

Is it wise to do that?

Please help

Hi,
You are right about storing the path and file name in the column of the database. Regarding the upload component, you can find plenty of other components to do the upload part for you.

Cheers!
Abhijit

[baby]

do you have anyone that i can use?

And do you have the coding for the storing of path into database and uploading of file into a folder?

[abhijit]

Here is the link for dundas component. You will get sample code also.

http://www.dundas.com/other/dundasup...&body=body.htm

Cheers,
Abhijit

[Danial]

Originally posted by baby
do you have anyone that i can use?

And do you have the coding for the storing of path into database and uploading of file into a folder?

You can store the files/image on the database, or you can upload the files on to the server and store only the file name. You can upload the file using Component or pure code(very advanced asp code!).

You need to decide which approach to take then i can guide you through. Its around 6.0 am here , so i'll hit the bed. I will try to explain the cod to you tomorrow when i get a chance.

In the mean time you make up your mind about which approach to take .

Good night. (Not sure what time zone you are in!)

[baby]

Hi Danial... After some thoughts on what you said i have decided to use the store into my server folder approach.

Which in my case i store it inside this path name "c:\inetpub\wwwroot\project\images"

Thx for your detail explanation i am in time zone GMT +8 and its 1426hrs right now.

The summary on what i am doing now is:
I have to upload a picture along with a record. Its bascially a system for user to enter Project specs and project code etc... along with a picture of the project. And in my case i will do the storing of path methods as it seems much more simpler to do.


I will list down what i will need you to guide me

[list=1][*]Coding on uploading pictures to my c:\inetpub\wwwroot\project\images"[*]Writting the path name into the MS-DB[*]getting the path name out from the DB and displaying it.[/list=1]

[baby]

Danial u back?

[Danial]

Originally posted by baby
Danial u back?

Hi baby,
Sorry for the delay, i have been a bit busy with thing few things.

Ok lets get started, is it possible to post your database? If not then do you want me to put together an example of how to upload the image file and store the path into the database and also display those image.


I am using the free component the one posted by abhijit. So download the component and install it.

Let me know soon, i wll put together something.

[baby]

hi Danial

thanks for replying and helping me =)

Yup its alright i will post the database

Really thanks for your help danial.

Edit: Yah i just installed the upload component from dundas

[Danial]

Hi Baby,
Here is something i put together quickly. It is mearly an example to get you started. Hope this helps. If you need more explanation of the code then let me know.

Things like form validation etc i have left it to you to do.


Hope this helps.

Danial

[baby]

hi danial... Thanks alot =)

I will go thru the coding. Will ask u if i have any question =)

Thx once again~

[baby]

hm.. after runnin i got this error

Error Type:
Dundas.Upload.2 (0x80004005)
Can't open file for writing.
/project_virtual/danial/Process.asp, line 29

[Danial]

Originally posted by baby
hm.. after runnin i got this error

Error Type:
Dundas.Upload.2 (0x80004005)
Can't open file for writing.
/project_virtual/danial/Process.asp, line 29

Make sure you have set up the folder to have write permission. What OS are you using? Are you using NTFS.

If you change the folder permission, it should work.

[baby]

i am using windows 2000 OS

Tried setting permission thru the Internet service manager. Changed the permission to allow all, but still have the same problem.

[Danial]

Are you using NTFS or FAT/FAT32 format? If its NTFS then right click on the folder and click on properties, go to security(see note) tab and add "Users" and give them write permission.

Note : If you are using simple file sharing then you need to: Open any folder, click Tools, Folder Options, Go to View Tab, Scroll down to the end, find "Use Simple File Sharing" and uncheck it.

[baby]

sorry didnt realise i didnt state what format the HD is.. Using fat 32.... So is it possible?

PS:When i install the dundas component i am able to view their samples page with no problem....

[Danial]

Originally posted by baby
sorry didnt realise i didnt state what format the HD is.. Using fat 32.... So is it possible?

PS:When i install the dundas component i am able to view their samples page with no problem....

It should work fine in FAT system. I think i might know why the error is occuring

dim Path
Path="c:\inetpub\wwwroot\project\images"

Did you change the path? Make sure the path exist. Or creae the folder anywhere in the wwroot folder and change the Path variable accordingly.

[baby]

oh yeah it worked after i changed the pathing =) thx danial

OK i will start going thru the coding now

Wish me luck~

[baby]

Hm.. after going thru the coding. I realise it doesnt allow user to post records only. Meaning every record have to have a picture.

How do i make it so that picture is not a must.

sorry really new to ASP

[abhijit]

check the design of the table. make sure that the path is allowing a null value to be stored.

cheers!
abhijit

[baby]

Originally posted by abhijit
check the design of the table. make sure that the path is allowing a null value to be stored.

cheers!
abhijit

yah its allowing null value all along

[abhijit]

Well in that case, I suggest that you need to do some validation.
Could you please post the script that you have written so far. I will try to see what I can do.

Cheers!
Abhijit

[baby]

currently i am using what danial did for me to do the upload.

See his post attached:baby.zip

its the Process.ASP i am using the coding

[abhijit]

Hi Baby,
I have added some code in the process.asp. Please replace the code inside your process.asp.
Let me know the results.

Cheers,
Abhijit

<%@ Language=VBScript %>
<% Response.Buffer = true
 
dim Path
Path="c:\inetpub\wwwroot\project\images"
 
'on error resume next
 
dim objUpload       'instance of Uplaod control
dim strMessage      'stores success/failure message sent back to main.asp
dim bFileLoaded 
bFileLoaded = true
 
set objUpload = server.CreateObject("Dundas.Upload.2")
 
if  err.number <> 0 then
    Response.Redirect "main.asp?Message=" & err.description
end if
 
objUpload.MaxFileSize = 1048576
objUpload.UseUniqueNames=false
 
dim NextFile
set NextFile = objUpload.GetNextFile
 
 
'check if the file is image
If InStr(1,NextFile.ContentType,"image") <> 0 Then
 
 
    NextFile.Save path
 
    if err.number <> 0 then
        strMessage = "The following error occurred: " & err.description
    else
        strMessage = "The upload operation was successfully performed"
    end if
 
    call AddToDB
    response.redirect "details.asp"
 
    set objUpload = nothing
else
    bFileLoaded = false
'   response.write "File is not a valid image file"
end if
 
%>
 
<%
Function AddToDB()
Dim Conn
Dim RS
Dim ConString
 
ConString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("projectDB.mdb")
 
Set conn = Server.CreateObject("ADODB.Connection")
Set RS = Server.CreateObject("ADODB.Recordset")
 
Conn.Open(ConString)
    RS.Open "ProjectLog", Conn, 3, 2
    RS.AddNew
        rs("Project_Code")=objUpload.Form("Code")
        rs("Date")=objUpload.Form("Date")
        rs("Company")=objUpload.Form("")
        rs("Project_Coordinator")=objUpload.Form("Coordinator")
        rs("Designers")=objUpload.Form("Designer")
        rs("Project_Description")=objUpload.Form("Description")
        if bFileLoaded = true then
            rs("Picture")=Path & "\" & NextFile.FileName
        end if
 
    RS.Update
 
Conn.close
 
set conn=nothing
 
End Function
%>

[baby]

hi is it possible for you to highlight the coding you changed?

[abhijit]

Originally posted by baby
hi is it possible for you to highlight the coding you changed?

Firstly, could you please tell me if its working.

Cheers,
Abhijit

[baby]

um... no =(

[Danial]

Originally posted by baby
Hm.. after going thru the coding. I realise it doesnt allow user to post records only. Meaning every record have to have a picture.

How do i make it so that picture is not a must.

sorry really new to ASP

No worries, i assumed user will always submit picture. I have modified the code(process.asp and details.asp). Try out the code and let me know if you have any porblem.