[Quantproject-developers] QuantProject/b2_DataAccess/Tables Tickers_tickerGroups.cs, 1.7, 1.8

[Glauco S. <gla...@us...>]

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 );
      }