Hi All,
I'm getting my head stuck on the following error message:
ClientException: Invalid input '.': expected 'o/O' (line 9, column 2 (offset: 203))
I'm using the following query and I don't know what i'm doing wrong, hopefully someone can help me.
Thanks in advance!
Quincy
MATCH (p:Project {ProjectID:$project})
MERGE (l:Invoice {Unique_Invoice_ID:$uniqueInvoiceID})
ON MATCH SET
l.Project=$project,
l.Project_Name=$projectName,
l.Object=$object,
l.Description=$description
l.Billing_Event=$billingEvent
l.Estimated_Completion_Date=$estimatedCompletionDate
l.Date_Completed=$dateCompleted
l.Due_Date=$dueDate
l.Invoice_Number=$invoiceNumber
l.Invoice_Type=$invoiceType
l.Project_Manager=$projectManager
l.Project_Service=$projectService
l.Contract_Type=$contractType
l.Unique_Invoice_ID=$uniqueInvoiceID
ON CREATE SET
l.Project=$project,
l.Project_Name=$projectName,
l.Object=$object,
l.Description=$description
l.Billing_Event=$billingEvent
l.Estimated_Completion_Date=$estimatedCompletionDate
l.Date_Completed=$dateCompleted
l.Due_Date=$dueDate
l.Invoice_Number=$invoiceNumber
l.Invoice_Type=$invoiceType
l.Project_Manager=$projectManager
l.Project_Service=$projectService
l.Contract_Type=$contractType
l.Unique_Invoice_ID=$uniqueInvoiceID
MERGE (p)-[:BILL]-(l);