{"action":"created","issue":{"url":"https://api.github.com/repos/liveforeverx/mariaex/issues/10","labels_url":"https://api.github.com/repos/liveforeverx/mariaex/issues/10/labels{/name}","comments_url":"https://api.github.com/repos/liveforeverx/mariaex/issues/10/comments","events_url":"https://api.github.com/repos/liveforeverx/mariaex/issues/10/events","html_url":"https://github.com/liveforeverx/mariaex/issues/10","id":57490830,"number":10,"title":"Support for parameters on queries","user":{"login":"laurocaetano","id":611891,"avatar_url":"https://avatars.githubusercontent.com/u/611891?v=3","gravatar_id":"","url":"https://api.github.com/users/laurocaetano","html_url":"https://github.com/laurocaetano","followers_url":"https://api.github.com/users/laurocaetano/followers","following_url":"https://api.github.com/users/laurocaetano/following{/other_user}","gists_url":"https://api.github.com/users/laurocaetano/gists{/gist_id}","starred_url":"https://api.github.com/users/laurocaetano/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/laurocaetano/subscriptions","organizations_url":"https://api.github.com/users/laurocaetano/orgs","repos_url":"https://api.github.com/users/laurocaetano/repos","events_url":"https://api.github.com/users/laurocaetano/events{/privacy}","received_events_url":"https://api.github.com/users/laurocaetano/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-02-12T17:20:29Z","updated_at":"2015-02-12T17:53:19Z","closed_at":null,"body":"Hi!\r\n\r\nIt doesn't seem that Mariaex supports parameters on queries such as documented here: https://github.com/liveforeverx/mariaex/blob/master/lib/mariaex/connection.ex#L112\r\n\r\n```elixir\r\niex(1)> {:ok, p} = Mariaex.Connection.start_link(username: \"root\", database: \"ecto_test\")\r\n{:ok, #PID<0.95.0>}\r\niex(2)> Mariaex.Connection.query(p, \"CREATE TABLE test_1 (id serial, title text)\")\r\n:ok\r\niex(3)> Mariaex.Connection.query(p, \"SELECT id FROM test_1 WHERE title like $1\", [\"%my%\"])\r\n{:error,\r\n %Mariaex.Error{mariadb: %{code: 1054,\r\n    message: \"Unknown column '$1' in 'where clause'\"}, message: nil}}\r\n```\r\n\r\nIs there anything we can do to help fixing it? Thanks :)\r\n"},"comment":{"url":"https://api.github.com/repos/liveforeverx/mariaex/issues/comments/74118182","html_url":"https://github.com/liveforeverx/mariaex/issues/10#issuecomment-74118182","issue_url":"https://api.github.com/repos/liveforeverx/mariaex/issues/10","id":74118182,"user":{"login":"jquadrin","id":2413373,"avatar_url":"https://avatars.githubusercontent.com/u/2413373?v=3","gravatar_id":"","url":"https://api.github.com/users/jquadrin","html_url":"https://github.com/jquadrin","followers_url":"https://api.github.com/users/jquadrin/followers","following_url":"https://api.github.com/users/jquadrin/following{/other_user}","gists_url":"https://api.github.com/users/jquadrin/gists{/gist_id}","starred_url":"https://api.github.com/users/jquadrin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jquadrin/subscriptions","organizations_url":"https://api.github.com/users/jquadrin/orgs","repos_url":"https://api.github.com/users/jquadrin/repos","events_url":"https://api.github.com/users/jquadrin/events{/privacy}","received_events_url":"https://api.github.com/users/jquadrin/received_events","type":"User","site_admin":false},"created_at":"2015-02-12T17:53:19Z","updated_at":"2015-02-12T17:53:19Z","body":"hmm looks like encoders need some work, I'm looking into this. @liveforeverx what needs to be done?"}}