Apostrophe in a string property value
MATCH (O:Person) WHERE O.name = 'Nancy's Outbreak' RETURN O;
The apostrophe in "Nancy's" is breaking the statement. is there a way around it?
neo4j cypher
add a comment |
MATCH (O:Person) WHERE O.name = 'Nancy's Outbreak' RETURN O;
The apostrophe in "Nancy's" is breaking the statement. is there a way around it?
neo4j cypher
add a comment |
MATCH (O:Person) WHERE O.name = 'Nancy's Outbreak' RETURN O;
The apostrophe in "Nancy's" is breaking the statement. is there a way around it?
neo4j cypher
MATCH (O:Person) WHERE O.name = 'Nancy's Outbreak' RETURN O;
The apostrophe in "Nancy's" is breaking the statement. is there a way around it?
neo4j cypher
neo4j cypher
edited Nov 15 '18 at 19:31
cybersam
40.2k43152
40.2k43152
asked Nov 15 '18 at 14:12
sunil nairsunil nair
1
1
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
The simple way in this use-case is to use the double-quote around your string, like this : "Nancy's Outbreak"
Otherwise you have to escape it with a backslash : 'Nancy's Outbreak'.
Last information, if you use query paramters, Neo4j will do it for you.
Thank a ton !! that worked
– sunil nair
Nov 15 '18 at 14:29
add a comment |
You can try escaping the apostrophe in the name, this way:
MATCH (O:Person) WHERE O.name = 'Nancy's Outbreak' RETURN O;
thank you !! so much
– sunil nair
Nov 15 '18 at 14:32
If it works, consider accepting it to help future readers
– gratien asimbahwe
Nov 15 '18 at 14:34
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53321350%2fapostrophe-in-a-string-property-value%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
The simple way in this use-case is to use the double-quote around your string, like this : "Nancy's Outbreak"
Otherwise you have to escape it with a backslash : 'Nancy's Outbreak'.
Last information, if you use query paramters, Neo4j will do it for you.
Thank a ton !! that worked
– sunil nair
Nov 15 '18 at 14:29
add a comment |
The simple way in this use-case is to use the double-quote around your string, like this : "Nancy's Outbreak"
Otherwise you have to escape it with a backslash : 'Nancy's Outbreak'.
Last information, if you use query paramters, Neo4j will do it for you.
Thank a ton !! that worked
– sunil nair
Nov 15 '18 at 14:29
add a comment |
The simple way in this use-case is to use the double-quote around your string, like this : "Nancy's Outbreak"
Otherwise you have to escape it with a backslash : 'Nancy's Outbreak'.
Last information, if you use query paramters, Neo4j will do it for you.
The simple way in this use-case is to use the double-quote around your string, like this : "Nancy's Outbreak"
Otherwise you have to escape it with a backslash : 'Nancy's Outbreak'.
Last information, if you use query paramters, Neo4j will do it for you.
edited Nov 15 '18 at 20:58
answered Nov 15 '18 at 14:20
logisimalogisima
5,2661927
5,2661927
Thank a ton !! that worked
– sunil nair
Nov 15 '18 at 14:29
add a comment |
Thank a ton !! that worked
– sunil nair
Nov 15 '18 at 14:29
Thank a ton !! that worked
– sunil nair
Nov 15 '18 at 14:29
Thank a ton !! that worked
– sunil nair
Nov 15 '18 at 14:29
add a comment |
You can try escaping the apostrophe in the name, this way:
MATCH (O:Person) WHERE O.name = 'Nancy's Outbreak' RETURN O;
thank you !! so much
– sunil nair
Nov 15 '18 at 14:32
If it works, consider accepting it to help future readers
– gratien asimbahwe
Nov 15 '18 at 14:34
add a comment |
You can try escaping the apostrophe in the name, this way:
MATCH (O:Person) WHERE O.name = 'Nancy's Outbreak' RETURN O;
thank you !! so much
– sunil nair
Nov 15 '18 at 14:32
If it works, consider accepting it to help future readers
– gratien asimbahwe
Nov 15 '18 at 14:34
add a comment |
You can try escaping the apostrophe in the name, this way:
MATCH (O:Person) WHERE O.name = 'Nancy's Outbreak' RETURN O;
You can try escaping the apostrophe in the name, this way:
MATCH (O:Person) WHERE O.name = 'Nancy's Outbreak' RETURN O;
answered Nov 15 '18 at 14:20
gratien asimbahwegratien asimbahwe
1,12131123
1,12131123
thank you !! so much
– sunil nair
Nov 15 '18 at 14:32
If it works, consider accepting it to help future readers
– gratien asimbahwe
Nov 15 '18 at 14:34
add a comment |
thank you !! so much
– sunil nair
Nov 15 '18 at 14:32
If it works, consider accepting it to help future readers
– gratien asimbahwe
Nov 15 '18 at 14:34
thank you !! so much
– sunil nair
Nov 15 '18 at 14:32
thank you !! so much
– sunil nair
Nov 15 '18 at 14:32
If it works, consider accepting it to help future readers
– gratien asimbahwe
Nov 15 '18 at 14:34
If it works, consider accepting it to help future readers
– gratien asimbahwe
Nov 15 '18 at 14:34
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53321350%2fapostrophe-in-a-string-property-value%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown