alex_wareing
asked on
Uploading files and adding filename to db
Hey i'm creating an web application in ASP to manage my clients and make invoices, quotes etc avaliable to them in a PDF format.
I have created the basis of the application, each job done for a client is stored in table called jobs (Access backed db) and has a number of fields. A few of which are text feilds which i intend to have the filename for the pdf document located (eg: invoiceclient18.pdf) i will then use this feild as a link on the page.
However the problem i have is i want to be able to upload the pdf documents to server via a form, and i want the form to add the name of the pdf file into the correct field in the db. at the moment all i have is a form, what code can i use for the upload part and then what is the code to use to get the filename of the file uploaded? all uploads can go into the same folder.
I am on shared hosting so i can set rights for folders but i can't install .dlls etc. what upload code can i use? needs to be freeware or similar.
Thanks
I have created the basis of the application, each job done for a client is stored in table called jobs (Access backed db) and has a number of fields. A few of which are text feilds which i intend to have the filename for the pdf document located (eg: invoiceclient18.pdf) i will then use this feild as a link on the page.
However the problem i have is i want to be able to upload the pdf documents to server via a form, and i want the form to add the name of the pdf file into the correct field in the db. at the moment all i have is a form, what code can i use for the upload part and then what is the code to use to get the filename of the file uploaded? all uploads can go into the same folder.
I am on shared hosting so i can set rights for folders but i can't install .dlls etc. what upload code can i use? needs to be freeware or similar.
Thanks
alorentz
Who is the host? They probably already have an upload component installed with sample code available. Check with them first!
ASKER
host in 1and1.co.uk can't find any documentation about an
1and1 definitely provide upload components, and they definitlety have sample code in the FAQ section. The compnent is called FileUp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
PS, that code is used on 1and1.com, so should work for you.
ASKER
>alorentz
errrm all that codes a bit confusing for me! i guess i just need to know what function returns the file name? i just need the filename though not the path.
errrm all that codes a bit confusing for me! i guess i just need to know what function returns the file name? i just need the filename though not the path.
oFileUp.Form("myFile"),
It appear you have this working already for the PDF in the other question...
It appear you have this working already for the PDF in the other question...
ASKER
thanks