{"action":"created","issue":{"url":"https://api.github.com/repos/cfwheels/cfwheels/issues/564","labels_url":"https://api.github.com/repos/cfwheels/cfwheels/issues/564/labels{/name}","comments_url":"https://api.github.com/repos/cfwheels/cfwheels/issues/564/comments","events_url":"https://api.github.com/repos/cfwheels/cfwheels/issues/564/events","html_url":"https://github.com/cfwheels/cfwheels/issues/564","id":115305646,"number":564,"title":"SQL IN ('string','string') doesn't pull correct results.","user":{"login":"leeish","id":3846878,"avatar_url":"https://avatars.githubusercontent.com/u/3846878?v=3","gravatar_id":"","url":"https://api.github.com/users/leeish","html_url":"https://github.com/leeish","followers_url":"https://api.github.com/users/leeish/followers","following_url":"https://api.github.com/users/leeish/following{/other_user}","gists_url":"https://api.github.com/users/leeish/gists{/gist_id}","starred_url":"https://api.github.com/users/leeish/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/leeish/subscriptions","organizations_url":"https://api.github.com/users/leeish/orgs","repos_url":"https://api.github.com/users/leeish/repos","events_url":"https://api.github.com/users/leeish/events{/privacy}","received_events_url":"https://api.github.com/users/leeish/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-11-05T15:17:50Z","updated_at":"2015-11-05T15:35:58Z","closed_at":"2015-11-05T15:35:58Z","body":"Upgrading from 1.1.7 to 1.4.3. We have a findAll call and in the where clause we have:\r\n\r\ncertifyStatus IN  ('Certified', 'Expired')\r\n\r\nHowever when I dump out the query it results in Cerfitied','Expired as the param. Note the missing quotes at the start and end of the list. So I tried:\r\n\r\ncertifyStatus IN  (''Certified', 'Expired'')\r\n\r\nIt put them in there and still bad results. So I changed the query to (certifyStatus = 'Certified' OR certifyStatus = 'Expired') for the time being, but this query worked fine in 1.1.7. Is this intended behavior? How should I be building these queries in 1.4.3."},"comment":{"url":"https://api.github.com/repos/cfwheels/cfwheels/issues/comments/154095628","html_url":"https://github.com/cfwheels/cfwheels/issues/564#issuecomment-154095628","issue_url":"https://api.github.com/repos/cfwheels/cfwheels/issues/564","id":154095628,"user":{"login":"leeish","id":3846878,"avatar_url":"https://avatars.githubusercontent.com/u/3846878?v=3","gravatar_id":"","url":"https://api.github.com/users/leeish","html_url":"https://github.com/leeish","followers_url":"https://api.github.com/users/leeish/followers","following_url":"https://api.github.com/users/leeish/following{/other_user}","gists_url":"https://api.github.com/users/leeish/gists{/gist_id}","starred_url":"https://api.github.com/users/leeish/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/leeish/subscriptions","organizations_url":"https://api.github.com/users/leeish/orgs","repos_url":"https://api.github.com/users/leeish/repos","events_url":"https://api.github.com/users/leeish/events{/privacy}","received_events_url":"https://api.github.com/users/leeish/received_events","type":"User","site_admin":false},"created_at":"2015-11-05T15:35:58Z","updated_at":"2015-11-05T15:35:58Z","body":"Ah..... I figured it out. In my code there originally, I had a space after the comma, which wheels it looks like saw and knew it should be a string and not a list.\r\n\r\nHowever, it never did/would put in the quotes for me.\r\n\r\nSo I changed certifyStatus IN ('Certified', 'Expired') to certifyStatus IN ('Certified','Expired'). It looks like the older version just accepted it, which is valid SQL, but I at least I understand what wheels is trying to do that is tell the difference between a list and a string based on the spaces outside the quotes.\r\n"}}