svn commit: r772064 - /incubator/stonehenge/trunk/stocktrader/php/business_service/business_processor.php

[shankar]

Author: shankar
Date: Wed May  6 06:11:48 2009
New Revision: 772064

URL: http://svn.apache.org/viewvc?rev=772064&view=rev
Log:
removing MSSQL specific query. 

Modified:
    
incubator/stonehenge/trunk/stocktrader/php/business_service/business_processor.php

Modified: 
incubator/stonehenge/trunk/stocktrader/php/business_service/business_processor.php
URL: 
http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/php/business_service/business_processor.php?rev=772064&r1=772063&r2=772064&view=diff
==============================================================================
--- 
incubator/stonehenge/trunk/stocktrader/php/business_service/business_processor.php
 (original)
+++ 
incubator/stonehenge/trunk/stocktrader/php/business_service/business_processor.php
 Wed May  6 06:11:48 2009
@@ -500,7 +500,7 @@
        $response = null;
        if($db)
        {
-               $query = "SELECT top ".TOP_ORDERS." orderid, ordertype, 
orderstatus, opendate, 
+               $query = "SELECT orderid, ordertype, orderstatus, opendate, 
                                completiondate, quantity, price, orderfee, 
quote_symbol FROM 
                                orders WHERE orders.account_accountid = (SELECT 
account.accountid 
                                FROM account  WHERE account.profile_userid = 
@@ -538,6 +538,10 @@
                                        symbol = $db->GetSQLValue($result, 
$rawNo, 8);
                                
                                $rawNo = $rawNo + 1;
+                               if ($rawNo == TOP_ORDERS)
+                               {
+                                       break;
+                               }
                        }
                }
                $db->CloseDatabase();