Michael, Please help me how to solve this. -Sukaant Chaudhary <http://in.linkedin.com/pub/sukaant-chaudhary/33/ba8/479>
On Mon, Dec 22, 2014 at 2:31 PM, Michael Hunger < [email protected]> wrote: > 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. > -- 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.
