ajax - Run long SAS stored proc from php without hanging browser -
i need call sas stored proc takes 5 minutes run without hanging browser. i'm using yii stack , calling sas through url. i'd attach code, i've tried many things @ point there's not version of code makes sense anymore. direction appreciated.
note: i've tried exec() , doesn't seem work. i've tried ajax, , prefer async ajax call, @ point i'll try anything. other information needed, let me know.
update: created controller action in php completes stored process if go directly controller action in url of browser. however, if call controller action ajax get, stored process doesn't execute.
ajax should work fine! if stored process called without parameters, can try using h54s (html5 sas) javascript library. wrote guide on here. example code - once configured - follows:
var adapter = new h54s(); // need 1 instance var myparams = {}; // create empty object if no parameters var jstablesobject = new h54s.tables([myparams],'sascontroltable'); //make h54s dataset adapter.call('/webapp/example',jstablesobject,function(err,res) {// call stp here //we submitted stp request, deal response alert(res); // code here execute after stored proc finished }); // code here execute
Comments
Post a Comment