{"action":"created","issue":{"url":"https://api.github.com/repos/ADOdb/ADOdb/issues/351","repository_url":"https://api.github.com/repos/ADOdb/ADOdb","labels_url":"https://api.github.com/repos/ADOdb/ADOdb/issues/351/labels{/name}","comments_url":"https://api.github.com/repos/ADOdb/ADOdb/issues/351/comments","events_url":"https://api.github.com/repos/ADOdb/ADOdb/issues/351/events","html_url":"https://github.com/ADOdb/ADOdb/issues/351","id":235974666,"number":351,"title":"Help with OutParameter","user":{"login":"stccorp","id":8180135,"avatar_url":"https://avatars1.githubusercontent.com/u/8180135?v=3","gravatar_id":"","url":"https://api.github.com/users/stccorp","html_url":"https://github.com/stccorp","followers_url":"https://api.github.com/users/stccorp/followers","following_url":"https://api.github.com/users/stccorp/following{/other_user}","gists_url":"https://api.github.com/users/stccorp/gists{/gist_id}","starred_url":"https://api.github.com/users/stccorp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stccorp/subscriptions","organizations_url":"https://api.github.com/users/stccorp/orgs","repos_url":"https://api.github.com/users/stccorp/repos","events_url":"https://api.github.com/users/stccorp/events{/privacy}","received_events_url":"https://api.github.com/users/stccorp/received_events","type":"User","site_admin":false},"labels":[{"id":291935449,"url":"https://api.github.com/repos/ADOdb/ADOdb/labels/mysql","name":"mysql","color":"fef2c0","default":false},{"id":51306504,"url":"https://api.github.com/repos/ADOdb/ADOdb/labels/question","name":"question","color":"cc317c","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2017-06-14T18:47:33Z","updated_at":"2017-06-15T14:02:08Z","closed_at":"2017-06-15T09:09:30Z","body":"I cant get outParameter to work, Any idea Why?\r\n\r\n\r\nMy procedure:\r\nPROCEDURE myprocedure (IN `p_one` int,IN `p_two` int,OUT `p_three` int)\r\n\r\nCODE\r\n ```\r\n$parameter1Name = 'p_one';\r\n            $parameter1Value = \"1\";\r\n\r\n            $parameter2Name = 'p_two';\r\n            $parameter2Value = \"1\";\r\n\r\n            $parameter3Name = 'p_three';\r\n            $parameter3Value = '';\r\n\r\n               $procedure = $db->prepareSp('myprocedure');\r\n\r\n                if (!$procedure)\r\n                    die ('Invalid or inaccessible stored procedure name');\r\n\r\n                $db->inParameter($procedure,$parameter1Value,$parameter1Name);\r\n                $db->inParameter($procedure,$parameter2Value,$parameter2Name);\r\n                $db->outParameter($procedure,$parameter3Value,$parameter3Name);\r\n                $rs = $db->execute($procedure);\r\n```\r\n\r\n\r\nERROR\r\nQuery: myprocedure  failed. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'myprocedure ' at line 1\r\n`\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/ADOdb/ADOdb/issues/comments/308740461","html_url":"https://github.com/ADOdb/ADOdb/issues/351#issuecomment-308740461","issue_url":"https://api.github.com/repos/ADOdb/ADOdb/issues/351","id":308740461,"user":{"login":"dregad","id":449891,"avatar_url":"https://avatars2.githubusercontent.com/u/449891?v=3","gravatar_id":"","url":"https://api.github.com/users/dregad","html_url":"https://github.com/dregad","followers_url":"https://api.github.com/users/dregad/followers","following_url":"https://api.github.com/users/dregad/following{/other_user}","gists_url":"https://api.github.com/users/dregad/gists{/gist_id}","starred_url":"https://api.github.com/users/dregad/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dregad/subscriptions","organizations_url":"https://api.github.com/users/dregad/orgs","repos_url":"https://api.github.com/users/dregad/repos","events_url":"https://api.github.com/users/dregad/events{/privacy}","received_events_url":"https://api.github.com/users/dregad/received_events","type":"User","site_admin":false},"created_at":"2017-06-15T14:02:08Z","updated_at":"2017-06-15T14:02:08Z","body":"> Is this something that is almost impossible to do?\r\n\r\nI didn't say that... I only stated that ADOdb currently does not support it for MySQL, most likely because no one ever took the time to implement this functionality; there might be technical challenges, but as long as the underlying native php driver supports it, I'm sure it can be done.\r\n\r\nIn other words, if you are willing to spend the time and develop this functionality, your contribution (in the form of a pull request) will be very welcome.\r\n"}}
{"actor":{"display_login":"dregad"}}