Michael, Please help me in this issue. -Sukaant Chaudhary <http://in.linkedin.com/pub/sukaant-chaudhary/33/ba8/479>
On Tue, Dec 23, 2014 at 4:33 PM, Sukaant Chaudhary < [email protected]> wrote: > 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.
