neo4j - {"SyntaxException: Invalid input '{': expected an identifier character, whitespace -
vb.net program loads few thousand nodes , set relationships between them. i'm using neo4j c# client (version 1.1.0.8)
one of commands
theconnection.graphclient.cypher.match( "(user1:startingpoint)", "(user2:committee)" ).where( function(user1 startingpoint) user1.id = knowsid ).andwhere( function(user2 committee) user2.id = knownid ).create( "user1-[r: knows ]->user2" ).executewithoutresults()
for various business logic reasons want match nodes fecidnumber (it's string, in example 'c00530767') instead of id. changed
- knownid long string
- user2.id = knownid
this gives me following query
theconnection.graphclient.cypher.match( "(user1:startingpoint)", "(user2:committee)" ).where( function(user1 startingpoint) user1.id = knowsid ).andwhere( function(user2 committee) user2.fecidnumber = knownid ).create( "user1-[r: knows ]->user2" ).executewithoutresults()
when executed throws
{"syntaxexception: invalid input '{':expected identifier character, whitespace, '?', '!', '.', node labels, '[', ""=~"", in, starts, ends, contains, is, '^', '*', '/', '%', '+', '-', '=', ""<>"", ""!="", '<', '>', ""<="", "">="", and, xor, or or ')' (line 3, column 23 (offset: 95))" & vblf & """and (user2.fecidnumber{p1}{p2} = {p3})" & vbcr & """" & vblf & " ^"}
when go neo4j browser , run
match (user:committee) user.fecidnumber = "c00530766" return user
it returns node expected.
i think important part of error seems
(line 3, column 23 (offset: 95)) " & vblf & """and (user2.fecidnumber{p1}{p2} = {p3})" & vbcr & """" & vblf & "
it looks neo4j c# client tossing in second parameter {p2}
, that's guess.
any suggestions?
edit 1
(i didn't know pull raw query text)
it's returning
match (user1:startingpoint), (user2:committee) (user1.id = 1) , (user2.fecidnumber"c00530766"false = 0) create user1-[r: knows ]->user2
clearly problem
user2.fecidnumber = knownid).create("user1-[r: knows ]->user2")
is somehow generating
user2.fecidnumber"c00530766"false = 0
ideas? there different syntax should using? need convert fecidnumber different type?
edit 2
the same code generates
match (user1:startingpoint), (user2:committee) (user1.id = 1) , (user2.fecidnumber = "c00530766") create user1-[r: knows ]->user2
and creates relationship expected.
winner.....
i have published version (1.1.0.26) should resolve you, it'll take few mins nuget index it, give 1/2 hour or when posted...
let me know!
Comments
Post a Comment