{"action":"created","issue":{"url":"https://api.github.com/repos/neo4jrb/neo4j/issues/873","labels_url":"https://api.github.com/repos/neo4jrb/neo4j/issues/873/labels{/name}","comments_url":"https://api.github.com/repos/neo4jrb/neo4j/issues/873/comments","events_url":"https://api.github.com/repos/neo4jrb/neo4j/issues/873/events","html_url":"https://github.com/neo4jrb/neo4j/issues/873","id":95389089,"number":873,"title":"Single quote error in Cypher ","user":{"login":"arikan","id":6969,"avatar_url":"https://avatars.githubusercontent.com/u/6969?v=3","gravatar_id":"","url":"https://api.github.com/users/arikan","html_url":"https://github.com/arikan","followers_url":"https://api.github.com/users/arikan/followers","following_url":"https://api.github.com/users/arikan/following{/other_user}","gists_url":"https://api.github.com/users/arikan/gists{/gist_id}","starred_url":"https://api.github.com/users/arikan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arikan/subscriptions","organizations_url":"https://api.github.com/users/arikan/orgs","repos_url":"https://api.github.com/users/arikan/repos","events_url":"https://api.github.com/users/arikan/events{/privacy}","received_events_url":"https://api.github.com/users/arikan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-07-16T09:15:41Z","updated_at":"2015-07-27T21:12:03Z","closed_at":null,"body":"We are having error in cypher property match for single quote.\r\n\r\n```\r\ncypher = \"MATCH (h:Hub {_id: '#{self.id}'})-[:NODES]->(n:Node {name: '#{name}'}) RETURN n\"\r\nresult = Neo4j::Session.query(cypher)\r\n```\r\nthrows error: \r\n```\r\n(n:Node {name: 'Festival d'Automne'})`\r\nNeo4j::Server::CypherResponse::ResponseError (Invalid input 'u': expected 'n/N\r\n```\r\nBut whe we escape the single quote it works fine:\r\n\r\n```\r\nname = name.gsub(\"'\", %q(\\\\\\'))\r\ncypher = \"MATCH (h:Hub {_id: '#{self.id}'})-[:NODES]->(n:Node {name: '#{name}'}) RETURN n\"\r\n```\r\n\r\nCypher doc says the String Literals can be escaped. Should the neo4jrb escape these by default?\r\n\r\nhttp://neo4j.com/docs/stable/cypher-expressions.html"},"comment":{"url":"https://api.github.com/repos/neo4jrb/neo4j/issues/comments/125344540","html_url":"https://github.com/neo4jrb/neo4j/issues/873#issuecomment-125344540","issue_url":"https://api.github.com/repos/neo4jrb/neo4j/issues/873","id":125344540,"user":{"login":"cheerfulstoic","id":301415,"avatar_url":"https://avatars.githubusercontent.com/u/301415?v=3","gravatar_id":"","url":"https://api.github.com/users/cheerfulstoic","html_url":"https://github.com/cheerfulstoic","followers_url":"https://api.github.com/users/cheerfulstoic/followers","following_url":"https://api.github.com/users/cheerfulstoic/following{/other_user}","gists_url":"https://api.github.com/users/cheerfulstoic/gists{/gist_id}","starred_url":"https://api.github.com/users/cheerfulstoic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cheerfulstoic/subscriptions","organizations_url":"https://api.github.com/users/cheerfulstoic/orgs","repos_url":"https://api.github.com/users/cheerfulstoic/repos","events_url":"https://api.github.com/users/cheerfulstoic/events{/privacy}","received_events_url":"https://api.github.com/users/cheerfulstoic/received_events","type":"User","site_admin":false},"created_at":"2015-07-27T21:12:03Z","updated_at":"2015-07-27T21:12:03Z","body":"Thoughts?  I say we close, but I could be misunderstanding the issue"}}