[Weberp-svn] SF.net SVN: weberp:[4238] trunk

[<tim...@us...>]

Revision: 4238
          http://weberp.svn.sourceforge.net/weberp/?rev=4238&view=rev
Author:   tim_schofield
Date:     2011-01-09 21:03:55 +0000 (Sun, 09 Jan 2011)

Log Message:
-----------
Correct foreign key in recurringsalesorders table

Modified Paths:
--------------
    trunk/RecurringSalesOrders.php
    trunk/SelectRecurringSalesOrder.php

Modified: trunk/RecurringSalesOrders.php
===================================================================
--- trunk/RecurringSalesOrders.php	2011-01-09 20:28:16 UTC (rev 4237)
+++ trunk/RecurringSalesOrders.php	2011-01-09 21:03:55 UTC (rev 4238)
@@ -179,7 +179,6 @@
 	exit;
 }
 If (isset($_POST['Process'])) {
-	$Result = DB_Txn_Begin($db);
 	$InputErrors =0;
 	If (!Is_Date($_POST['StartDate'])){
 		$InputErrors =1;
@@ -267,7 +266,7 @@
 						discountpercent,
 						narrative)
 					values ('";
-echo $StartOf_LineItemsSQL;
+
 			foreach ($_SESSION['Items'.$identifier]->LineItems as $StockItem) {
 
 				$LineItemsSQL = $StartOf_LineItemsSQL .
@@ -305,7 +304,6 @@
 	exit;
 
 	}
-	$result = DB_Txn_Commit($db);
 }
 
 echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/customer.png" title="' . _('Search') .

Modified: trunk/SelectRecurringSalesOrder.php
===================================================================
--- trunk/SelectRecurringSalesOrder.php	2011-01-09 20:28:16 UTC (rev 4237)
+++ trunk/SelectRecurringSalesOrder.php	2011-01-09 21:03:55 UTC (rev 4238)
@@ -66,7 +66,7 @@
 				recurringsalesorders.lastrecurrence,
 				recurringsalesorders.stopdate,
 				recurringsalesorders.frequency";
-
+echo $SQL;
 	$ErrMsg = _('No recurring orders were returned by the SQL because');
 	$SalesOrdersResult = DB_query($SQL,$db,$ErrMsg);
 


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