{"action":"created","issue":{"url":"https://api.github.com/repos/Torndeco/extdb/issues/116","labels_url":"https://api.github.com/repos/Torndeco/extdb/issues/116/labels{/name}","comments_url":"https://api.github.com/repos/Torndeco/extdb/issues/116/comments","events_url":"https://api.github.com/repos/Torndeco/extdb/issues/116/events","html_url":"https://github.com/Torndeco/extdb/issues/116","id":55591462,"number":116,"title":"Request: New input / Output option \"QUOTE\" to quote without the strip that String does.","user":{"login":"RimBlock","id":7549280,"avatar_url":"https://avatars.githubusercontent.com/u/7549280?v=3","gravatar_id":"","url":"https://api.github.com/users/RimBlock","html_url":"https://github.com/RimBlock","followers_url":"https://api.github.com/users/RimBlock/followers","following_url":"https://api.github.com/users/RimBlock/following{/other_user}","gists_url":"https://api.github.com/users/RimBlock/gists{/gist_id}","starred_url":"https://api.github.com/users/RimBlock/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RimBlock/subscriptions","organizations_url":"https://api.github.com/users/RimBlock/orgs","repos_url":"https://api.github.com/users/RimBlock/repos","events_url":"https://api.github.com/users/RimBlock/events{/privacy}","received_events_url":"https://api.github.com/users/RimBlock/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-01-27T08:57:26Z","updated_at":"2015-01-28T08:01:55Z","closed_at":"2015-01-27T10:56:56Z","body":"Request for enhancement.\r\nItem\r\nINPUT / OUTPUT added option -QUOTE.  \r\nReason\r\nAllow the SQL input parameters or output fields to be quoted (add \" at each end) to allow for easy management of items we want with quotes for easy compile in SQF back to their ARMA datatypes.\r\n\r\nie.\r\nIf I have some SQL that requires 4 input parameters of \r\n\r\n0 (int)\r\n\"Dog\" (String)\r\n[\"cat\", 0 , 0.436, [17, \"fish\", \"Rabbit\", 90], \"wet\"]\r\n16\r\n\r\nIf I pass these as an array to the SQF function which is used to create the ext call and param list for it then it will receive;\r\n\r\n_this = [0,\"Dog\",[\"cat\", 0 , 0.436, [17, \"fish\", \"Rabbit\", 90], \"wet\"], 16]\r\n\r\nI will then need to go through each element in order to work out which ones are arrays and therefore need quotes.\r\n\r\nBy adding a QUOTE option in the extDB.ini to quote inputs (without the strip) then I can just say;\r\n\r\nINPUT 1, 2, 3, 4-QUOTE, 5\r\n\r\nAnd do not have to do any investigation at an SQF level.\r\n\r\nWould have thought it would just be the same as is being done with string but without the strip first so should be pretty easy to implement."},"comment":{"url":"https://api.github.com/repos/Torndeco/extdb/issues/comments/71794942","html_url":"https://github.com/Torndeco/extdb/issues/116#issuecomment-71794942","issue_url":"https://api.github.com/repos/Torndeco/extdb/issues/116","id":71794942,"user":{"login":"RimBlock","id":7549280,"avatar_url":"https://avatars.githubusercontent.com/u/7549280?v=3","gravatar_id":"","url":"https://api.github.com/users/RimBlock","html_url":"https://github.com/RimBlock","followers_url":"https://api.github.com/users/RimBlock/followers","following_url":"https://api.github.com/users/RimBlock/following{/other_user}","gists_url":"https://api.github.com/users/RimBlock/gists{/gist_id}","starred_url":"https://api.github.com/users/RimBlock/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RimBlock/subscriptions","organizations_url":"https://api.github.com/users/RimBlock/orgs","repos_url":"https://api.github.com/users/RimBlock/repos","events_url":"https://api.github.com/users/RimBlock/events{/privacy}","received_events_url":"https://api.github.com/users/RimBlock/received_events","type":"User","site_admin":false},"created_at":"2015-01-28T08:01:55Z","updated_at":"2015-01-28T08:01:55Z","body":"Yep, gotcha.  Is working as hoped now.\r\n\r\nThanks"}}