How to handle singleQuotes in Variable for Cypher Statement

[CodeCase]

Hi together,

I try to save a value with a Cypher Query and Nei4j v4 and Neo4j.Driver in C#

My problem is that the value of my variable contains a singlequote, for example like:

ÖöÜüÄäßµ@€-&'.Sb34

Thats my Query:

var Name = "ÖöÜüÄäßµ@€-&'.Sb34";
var query2Neo = ("CREATE (p:Person { Name:'" + Name + "'})");

Are there another Way to avoid those kind of problems?

Best regards

[paulare · Accepted solution]

Hi @CodeCase

You don't have to use string building - read cypher manual:
https://neo4j.com/docs/cypher-manual/4.0/syntax/parameters/

CREATE (n:Person { name: $name })

[CodeCase]

Hi @paul.are,

thanks for your reply.
I need to use Neo4j.Driver v4 with the following Syntax

 IDriver driver = GraphDatabase.Driver("bolt://localhost:7687", AuthTokens.Basic("neo4j", "neo4j"));
 IAsyncSession session = driver.AsyncSession(o => o.WithDatabase("neo4j"));
 var name = "ÖöÜüÄäßµ@€-&'.Sonderbör";
 var query2Neo = ("CREATE (p:Person {name: $name})", new { name });
 IResultCursor cursor = await session.RunAsync(query2Neo.ToString());
 await cursor.ConsumeAsync().ConfigureAwait(true);
 await session.CloseAsync();
 await driver.CloseAsync();

dont know if thats the "best" approach for using the .Net Driver in neo4j. However its not working.neo4j

I get the following Error:

EXCEPTION: Neo4j.Driver.ClientException: Invalid input '(': expected (line 1, column 1 (offset: 0))
"(CREATE (p:Person {name: $name}), { name = ÖöÜüÄäßµ@€-&'.Sonderbör })"
^
at Neo4j.Driver.Internal.MessageHandling.ResponsePipelineError.EnsureThrownIf(Func`2 predicate)

[Kailash]

CodeCase:

name

Try this -

var name = "ÖöÜüÄäßµ@€-&'.Sonderbör";*
var query2Neo = "CREATE (p:Person {Name: $name})";
IResultCursor cursor = await session.RunAsync(query2Neo.ToString() , new { name });

Before this you need to create a param object for this to work.
I have tried with a java equivalent code and it works. - use only related part

Map<String, Object> parameters = new HashMap<String, Object>();
String name = "ÖöÜüÄäßµ@€-&'.Sonderbör";
String query2Neo = "CREATE (p:Person {Name: $name})";
parameters.put("name", name);
session.run(query2Neo, parameters);

Please follow this and if you still get the issue, please let me know

Neo4j Graph Database Platform

Neo4j Documentation

Read the latest Neo4j documentation to learn all you need to about Neo4j and graph databases, and start building your first graph database application.

[CodeCase]

Hi @Kailash & @paul.are , thank you for your examples that helps me to understand what Im doing here

It works!

[Kailash]

CodeCase:

'"

Hi @CodeCase - as @paul.are mentioned , the string concatenation is not the effective way of creating nodes now. Instead use the parameter.
For some reason if you have to use it then wrap it around double quote ( " " ) instread of ( ' ')

[Kailash]

Thanks , Happy to help!