commit 69d15deb476a850556b8f1ed1b7c141f523b6cc2
author Nabin Hait <nabinhait@gmail.com> Wed Sep 07 15:09:51 2011 +0530
committer Nabin Hait <nabinhait@gmail.com> Wed Sep 07 15:09:51 2011 +0530
tree 59fb2bae2710f5efed50672cd8b6cfd2d45ec5d2
parent dabc4b1966bf45354c6cf166a52211474f2eae34

fixed sql syntax

stock/doctype/delivery_note/delivery_note.py

diff --git a/stock/doctype/delivery_note/delivery_note.py b/stock/doctype/delivery_note/delivery_note.py
index e5acd16..00711978 100644
--- a/stock/doctype/delivery_note/delivery_note.py
+++ b/stock/doctype/delivery_note/delivery_note.py
@@ -444,7 +444,7 @@
   def update_pack_nett_weight(self):
       for d in getlist(self.doclist, 'delivery_note_details'):
         if d.item_name:
-          item_wt = sql("select nett_weight from `tabItem` where item_name = '%s'" % (d.item_name))
+          item_wt = sql("select nett_weight from `tabItem` where item_name = %s", (d.item_name))
           d.pack_nett_wt = item_wt and flt(item_wt[0][0])*flt(d.qty) or 0
 
   # ==========================================