[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SF.net SVN: ledger-smb:[3219] trunk/LedgerSMB/OE.pm



Revision: 3219
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3219&view=rev
Author:   ehuelsmann
Date:     2011-06-11 14:24:47 +0000 (Sat, 11 Jun 2011)

Log Message:
-----------
Add an additional parameter, as there are 13 values to be inserted.

Modified Paths:
--------------
    trunk/LedgerSMB/OE.pm

Modified: trunk/LedgerSMB/OE.pm
===================================================================
--- trunk/LedgerSMB/OE.pm	2011-06-11 14:15:34 UTC (rev 3218)
+++ trunk/LedgerSMB/OE.pm	2011-06-11 14:24:47 UTC (rev 3219)
@@ -499,13 +499,11 @@
             @queryargs = ();
 
             # save detail record in orderitems table
-            $query = qq|INSERT INTO orderitems (|;
-            $query .= qq|
-				trans_id, parts_id, description, qty, sellprice,
-				discount, unit, reqdate, project_id, ship, 
-				serialnumber, notes, precision)
-                   		VALUES (|;
-            $query .= qq| ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)|;
+            $query = qq|INSERT INTO orderitems (
+		          trans_id, parts_id, description, qty, sellprice,
+		          discount, unit, reqdate, project_id, ship, 
+		          serialnumber, notes, precision)
+                        VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)|;
             $sth = $dbh->prepare($query);
             push( @queryargs,
                 $form->{id},                $form->{"id_$i"},


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.