commit a90e7e32a42362f5a03ad1467c7a1e5757fe95fe
author Ankush Menat <ankush@frappe.io> Sun Apr 24 20:05:36 2022 +0530
committer Ankush Menat <ankush@frappe.io> Tue Apr 26 11:47:05 2022 +0530
tree 8d0679ffce9ede20508ba060d6cdf79b27565338
parent 7e555d3d8c47bc7f304905a3d52b02e9da6b0283

fix: proper quoting in sql queries

erpnext/accounts/party.py

diff --git a/erpnext/accounts/party.py b/erpnext/accounts/party.py
index b0b3049..ac1dfec 100644
--- a/erpnext/accounts/party.py
+++ b/erpnext/accounts/party.py
@@ -881,11 +881,11 @@
 		"""
 			SELECT dl.parent, c.is_primary_contact, c.is_billing_contact
 			FROM `tabDynamic Link` dl
-			INNER JOIN tabContact c ON c.name = dl.parent
+			INNER JOIN `tabContact` c ON c.name = dl.parent
 			WHERE
 				dl.link_doctype=%s AND
 				dl.link_name=%s AND
-				dl.parenttype = "Contact"
+				dl.parenttype = 'Contact'
 			ORDER BY is_primary_contact DESC, is_billing_contact DESC
 		""",
 		(doctype, name),