How many rows does this return:
MATCH (entryFrom:EntryFrom {from: "9788"}),
(gender:Gender {gender: "MALE", programId: "9788", date: "2014-12-03"}),
(program:Program {programId: "9788"}), (channel:Channel {serviceId: "2000"}),
(genre:Genre {name: "EnglishCookingandRecipeShow"})
return count(*)
The MERGE statement is run for each row above.
Not sure why your Gender type has so many properties to match on?
Michael
On 12/22/14, Sukaant Chaudhary <[email protected]> wrote:
> Hi,
> I'm using the following query, here I want to increment the value of count
> by 1 but it is incrementing more. Please help me where I'm doing wrong.
>
> MATCH (entryFrom:EntryFrom {from: "9788"}),
> (gender:Gender {gender: "MALE", programId: "9788", date: "2014-12-03"}),
> (program:Program {programId: "9788"}), (channel:Channel {serviceId:
> "2000"}),
> (genre:Genre {name: "EnglishCookingandRecipeShow"})
> MERGE
> (entryFrom)<-[relationEntry:HAS_PROGRAM_ENTRY_FROM]-(gender)<-[relationGender:HAS_GENDER]-(program)<-[relationProgram:HAS_PROGRAM]-(channel)<-[relationChannel:HAS_CHANNEL]-(genre)
>
>
> *ON CREATE SET relationEntry.count = 1 ON MATCH SET relationEntry.count =
> relationEntry.count + 1*
> RETURN relationEntry.count;
>
> Initial Value In The DB:
>
>
> *relationEntry.count = 20385*Value Getting Stored:
>
> *relationEntry.count = 30585*
>
> *relationEntry.count = 40785*Expected Value To Be Stored:
> *relationEntry.**count = 20386*
>
>
> *relationEntry.count = 20387*
> -Sukaant Chaudhary
> <http://in.linkedin.com/pub/sukaant-chaudhary/33/ba8/479>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
