{"action":"created","issue":{"url":"https://api.github.com/repos/tediousjs/node-mssql/issues/654","repository_url":"https://api.github.com/repos/tediousjs/node-mssql","labels_url":"https://api.github.com/repos/tediousjs/node-mssql/issues/654/labels{/name}","comments_url":"https://api.github.com/repos/tediousjs/node-mssql/issues/654/comments","events_url":"https://api.github.com/repos/tediousjs/node-mssql/issues/654/events","html_url":"https://github.com/tediousjs/node-mssql/issues/654","id":322460668,"number":654,"title":"Template Literal Tagging","user":{"login":"saragee3","id":15040665,"avatar_url":"https://avatars2.githubusercontent.com/u/15040665?v=4","gravatar_id":"","url":"https://api.github.com/users/saragee3","html_url":"https://github.com/saragee3","followers_url":"https://api.github.com/users/saragee3/followers","following_url":"https://api.github.com/users/saragee3/following{/other_user}","gists_url":"https://api.github.com/users/saragee3/gists{/gist_id}","starred_url":"https://api.github.com/users/saragee3/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/saragee3/subscriptions","organizations_url":"https://api.github.com/users/saragee3/orgs","repos_url":"https://api.github.com/users/saragee3/repos","events_url":"https://api.github.com/users/saragee3/events{/privacy}","received_events_url":"https://api.github.com/users/saragee3/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-05-11T23:26:10Z","updated_at":"2018-05-12T19:53:01Z","closed_at":null,"author_association":"NONE","body":"```js\r\nconst value = 123;  // int\r\nsql.query`select * from myTable where id = ${value}` \r\n```\r\n\r\nWhen trying to use template literal tagging, this method does not work as expected. \r\nIn `myTable`, `id` column constrained to INTs - `${value}` will throw a syntax error even if it I am passing an int.\r\n\r\nIn terms of a string:\r\n\r\n```js\r\nconst value = \"123\"; \r\nsql.query`select * from myTable where id = '${value}'` \r\n```\r\n\r\nI have to wrap `${value}` in single quotes but template literal tagging _should_ take care of that. Is any one else experiencing this issue?\r\n\r\n\r\n`Error: \"Incorrect syntax near ','.\"`"},"comment":{"url":"https://api.github.com/repos/tediousjs/node-mssql/issues/comments/388578870","html_url":"https://github.com/tediousjs/node-mssql/issues/654#issuecomment-388578870","issue_url":"https://api.github.com/repos/tediousjs/node-mssql/issues/654","id":388578870,"user":{"login":"CragVFX","id":11527278,"avatar_url":"https://avatars0.githubusercontent.com/u/11527278?v=4","gravatar_id":"","url":"https://api.github.com/users/CragVFX","html_url":"https://github.com/CragVFX","followers_url":"https://api.github.com/users/CragVFX/followers","following_url":"https://api.github.com/users/CragVFX/following{/other_user}","gists_url":"https://api.github.com/users/CragVFX/gists{/gist_id}","starred_url":"https://api.github.com/users/CragVFX/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CragVFX/subscriptions","organizations_url":"https://api.github.com/users/CragVFX/orgs","repos_url":"https://api.github.com/users/CragVFX/repos","events_url":"https://api.github.com/users/CragVFX/events{/privacy}","received_events_url":"https://api.github.com/users/CragVFX/received_events","type":"User","site_admin":false},"created_at":"2018-05-12T19:53:01Z","updated_at":"2018-05-12T19:53:01Z","author_association":"NONE","body":"Yes I am experiencing the same exact issue with the INTs in template literal with `Error: \"Incorrect syntax near ','.\"`"}}
{"actor":{"display_login":"CragVFX"}}