{"action":"created","issue":{"url":"https://api.github.com/repos/cflint/CFLint/issues/65","labels_url":"https://api.github.com/repos/cflint/CFLint/issues/65/labels{/name}","comments_url":"https://api.github.com/repos/cflint/CFLint/issues/65/comments","events_url":"https://api.github.com/repos/cflint/CFLint/issues/65/events","html_url":"https://github.com/cflint/CFLint/issues/65","id":91046416,"number":65,"title":"Problem with dynamic table and field names","user":{"login":"laserbyte","id":8138559,"avatar_url":"https://avatars.githubusercontent.com/u/8138559?v=3","gravatar_id":"","url":"https://api.github.com/users/laserbyte","html_url":"https://github.com/laserbyte","followers_url":"https://api.github.com/users/laserbyte/followers","following_url":"https://api.github.com/users/laserbyte/following{/other_user}","gists_url":"https://api.github.com/users/laserbyte/gists{/gist_id}","starred_url":"https://api.github.com/users/laserbyte/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/laserbyte/subscriptions","organizations_url":"https://api.github.com/users/laserbyte/orgs","repos_url":"https://api.github.com/users/laserbyte/repos","events_url":"https://api.github.com/users/laserbyte/events{/privacy}","received_events_url":"https://api.github.com/users/laserbyte/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-06-25T18:52:53Z","updated_at":"2015-06-25T19:33:32Z","closed_at":null,"body":"I have some queries like the following where the same operation needs to be done on multiple tables so the table name or field name is a variable.\r\n\r\n    <cfquery name=\"queryName\" datasource=\"#datasourceName#\">\r\n        update #tableName#\r\n        set fieldName = 'foo';\r\n    </cfqeuery>\r\n\r\nHowever this throws an error like this:\r\n\r\n    <cfquery name=\"#tableName#\"> should use <cfqueryparam/> for security reasons.\r\n\r\nHow can I work around this?"},"comment":{"url":"https://api.github.com/repos/cflint/CFLint/issues/comments/115371410","html_url":"https://github.com/cflint/CFLint/issues/65#issuecomment-115371410","issue_url":"https://api.github.com/repos/cflint/CFLint/issues/65","id":115371410,"user":{"login":"jerronjames","id":8227532,"avatar_url":"https://avatars.githubusercontent.com/u/8227532?v=3","gravatar_id":"","url":"https://api.github.com/users/jerronjames","html_url":"https://github.com/jerronjames","followers_url":"https://api.github.com/users/jerronjames/followers","following_url":"https://api.github.com/users/jerronjames/following{/other_user}","gists_url":"https://api.github.com/users/jerronjames/gists{/gist_id}","starred_url":"https://api.github.com/users/jerronjames/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jerronjames/subscriptions","organizations_url":"https://api.github.com/users/jerronjames/orgs","repos_url":"https://api.github.com/users/jerronjames/repos","events_url":"https://api.github.com/users/jerronjames/events{/privacy}","received_events_url":"https://api.github.com/users/jerronjames/received_events","type":"User","site_admin":false},"created_at":"2015-06-25T19:33:32Z","updated_at":"2015-06-25T19:33:32Z","body":"It's looking for for a parameter type. However, if you do not want it to display, I would suggest setting up a config file https://github.com/cflint/CFLint/wiki/Include-Exclude-Rules-Using-Exteral-XML-File"}}