topic javascript and mysql in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/javascript-and-mysql/m-p/42638#M23042 <HTML><HEAD></HEAD><BODY><SPAN>I need a hint, </SPAN><BR /><SPAN>when a user places a file in an inbound space i need to move it to another space based on its filename. I have over 400 filenames that can be placed in one of 36 subdirectories that sit under three directories.</SPAN><BR /><BR /><BR /><SPAN>I can just set a rule to call a javascript script, dump all the possible file names into an array and loop around it, but it would be nicer to send the filename to the mysql database that is already running and get the location of where to move the file from there.</SPAN><BR /><BR /><SPAN>Is there a simple way to query the mysql database from javascript? I could code this in PHP in my sleep, is there a way to call a PHP script from javascript to query the database and move the files in the alfresco space? Or am I overthinking this and missing a simple solution to this problem?</SPAN><BR /><BR /><SPAN>TIA</SPAN></BODY></HTML> Thu, 11 Jan 2007 21:00:44 GMT tonytony 2007-01-11T21:00:44Z javascript and mysql https://connect.hyland.com/t5/alfresco-archive/javascript-and-mysql/m-p/42638#M23042 I need a hint, when a user places a file in an inbound space i need to move it to another space based on its filename. I have over 400 filenames that can be placed in one of 36 subdirectories that sit under three directories.I can just set a rule to call a javascript script, dump all the possible fi Thu, 11 Jan 2007 21:00:44 GMT https://connect.hyland.com/t5/alfresco-archive/javascript-and-mysql/m-p/42638#M23042 tonytony 2007-01-11T21:00:44Z Re: javascript and mysql https://connect.hyland.com/t5/alfresco-archive/javascript-and-mysql/m-p/42639#M23043 <HTML><HEAD></HEAD><BODY><SPAN>There is no way to access an external MySQL DB from the JavaScript integration. However you could write a custom Action that does the work you need, and you can call any action from JavaScript:</SPAN><BR /><A href="http://wiki.alfresco.com/wiki/Custom_Actions" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Custom_Actions</A><BR /><A href="http://wiki.alfresco.com/wiki/JavaScript_API#Actions_API" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/JavaScript_API#Actions_API</A><BR /><BR /><SPAN>Hope this helps,</SPAN><BR /><BR /><SPAN>Kevin</SPAN></BODY></HTML> Fri, 12 Jan 2007 09:41:35 GMT https://connect.hyland.com/t5/alfresco-archive/javascript-and-mysql/m-p/42639#M23043 kevinr 2007-01-12T09:41:35Z