[Quantproject-developers] QuantProject/b2_DataAccess/Tables Tickers_tickerGroups.cs, 1.7, 1.8
Brought to you by:
glauco_1
|
From: Glauco S. <gla...@us...> - 2008-04-07 20:46:49
|
Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv6162/b2_DataAccess/Tables Modified Files: Tickers_tickerGroups.cs Log Message: The Sql statement has been assigned to a local variable, to allow an easier debugging Index: Tickers_tickerGroups.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Tickers_tickerGroups.cs,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** Tickers_tickerGroups.cs 7 Sep 2005 06:45:17 -0000 1.7 --- Tickers_tickerGroups.cs 7 Apr 2008 20:46:43 -0000 1.8 *************** *** 130,137 **** public static DataTable GetTickers( string groupID) { /// TO DO use a join in order to return a table with tiTicker and company name ! return SqlExecutor.GetDataTable("SELECT DISTINCT " + Tickers_tickerGroups.Ticker + " FROM tickers_tickerGroups " + "WHERE " + Tickers_tickerGroups.GroupID + "='" + ! groupID + "'"); } --- 130,140 ---- public static DataTable GetTickers( string groupID) { + /// TO DO use a join in order to return a table with tiTicker and company name ! string sql = ! "SELECT DISTINCT " + Tickers_tickerGroups.Ticker + " FROM tickers_tickerGroups " + "WHERE " + Tickers_tickerGroups.GroupID + "='" + ! groupID + "'"; ! return SqlExecutor.GetDataTable( sql ); } |