Moegamat Alexander Posted August 10, 2022 Share Posted August 10, 2022 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 Quote Link to comment Share on other sites More sharing options...
Sherzod Posted August 10, 2022 Share Posted August 10, 2022 Hello Moegamat, If you mean the path on the client side, then no way. This is for security purposes. Quote Link to comment Share on other sites More sharing options...
Moegamat Alexander Posted August 10, 2022 Author Share Posted August 10, 2022 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 Quote Link to comment Share on other sites More sharing options...
Sherzod Posted August 10, 2022 Share Posted August 10, 2022 You are welcome! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.