UniFileUpload

[Moegamat Alexander]

Hi

How do i get the file path from UniFileUpload

I have the following Mysql Store Procedure... I have hard coded the directory path ... but I would to get the path from from the loader

CREATE DEFINER=`root`@`localhost` PROCEDURE `ProcUpdDocs`(IN `StaffNo_in` varchar(10), Fname_in varchar(35))
BEGIN
insert into xfiles (staffno,filenames) values(StaffNo_in, Fname_in); /* Log file - will be removed */
 update gch_staffdocs
set gch_staffdocs.DocImage=LOAD_FILE(concat('c:/temp/',FName_in))
   where gch_staffdocs.StaffNo = staffno_in;

END

============== The Complete event looks like this ===============

    FileNam.Caption:='File Namex: ' +'c:\temp\'+ UniFileUpload1.FileName;
    UniMainModule.prUploadDoc.parambyname('Staffno_in').AsString :=
                   UniMainModule.tbPersonellStaffNo.AsString;
    UniMainModule.prUploadDoc.parambyname('Fname_in').AsString :=
                   UniFileUpload1.FileName;
    UniMainModule.prUploadDoc.execute;

At the moment its works with hardcoded path... but i want to use the path from Uploader..

Your assistance will be highly appreciated

Regards

Moegamat

[Sherzod]

Hello Moegamat,

If you mean the path on the client side, then no way. This is for security purposes.

[Moegamat Alexander]

Thank you for the prompt response Sherzod .. I could do a two step thingy in storing it in the upload directory on the server and pump it to the database form there

Thanks anyways ... 

Moegamat

[Sherzod]

You are welcome!