$rsAcc=new Recordset
                  ("exec dbo.ga_get_code_list @SortObj = '".$sortObj."'
                          ,@SortType = '".$sortType."'"
                            ,$dbconn); 

  error_log(" sql code:".$rsAcc->sql."\n",3,'/home/agp/7loc/public_html/pg.log');
  if ($rsAcc->result == true) {     
    error_log("   good query\n",3,'/home/agp/7loc/public_html/pg.log');
    error_log("nRows/nCols:".$rsAcc->rowcount.'/'.$rsAcc->fieldcount."\n",3,'/home/agp/7loc/public_html/pg.log');
    error_log(mssql_get_last_message()."\n",3,'/home/agp/7loc/public_html/pg.log');

  }
  if ($rsAcc->result == false)  {
    error_log(mssql_get_last_message()."\n",3,'/home/agp/7loc/public_html/pg.log');
  }

/*  Recordset class for using MS SQL query                              */
/************************************************************************/

class Recordset 
{ 
  var $result,     // result id 
      $rowcount,   // number of rows in result 
      $curpos,     // index of current row (begin=0, end=rowcount-1) 
      $fieldcount, // number of fields in result 
      $fn,         // Array of fields names 
      $rowset,     // Array of fields with keys on field name 
      $connection, // connection id 
      $sql;        // sql query 

  //Constructor 
  function Recordset($Sql,$Conn) 
  { 
    $this->connection=$Conn; 
    $this->sql=$Sql; 
    $this->fn=array(); 
    $this->rowset=array(); 
    $this->Query(); 
  } 

  // Execute query 
  function Query() 
  { 
    $this->Close(); 
    $this->result = @mssql_query($this->sql,$this->connection);   <--------------------------------------------------
    if (!$this->result) 
      return(0); 
    $this->rowcount = @mssql_num_rows($this->result); 
    $this->fieldcount = @mssql_num_fields($this->result); 
    for ($i=1;$i<=$this->fieldcount;$i++) 
    { 
       $f=@mssql_fetch_field($this->result,$i-1); 
       // Fill fields names array 
       $this->fn[$i]=$f->name; 
    } 
    $this->curpos=0; 
  } 

GO
ALTER PROCEDURE [dbo].[ga_get_code_list] 
 @SortObj varchar(32),
 @SortType varchar(32)
 AS
 begin try
   declare @ExecStr varchar(8000)
   set @ExecStr = 'select rtrim( convert( varchar(64), id) ) as ' + CHAR(39)  + 'id' + CHAR(39) 
                   + ', txt, type, status' 
                   + '  
   from code order by ' + @SortObj + ' ' + @SortType
   exec ( @ExecStr )
   print 'aaa'
 end try
 begin catch
    DECLARE @ErrorMessage NVARCHAR(4000);
    DECLARE @ErrorSeverity INT;
    DECLARE @ErrorState INT;
    SELECT @ErrorMessage = + 'raise error: '+ERROR_MESSAGE() ,@ErrorSeverity = ERROR_SEVERITY(),@ErrorState = ERROR_STATE();
    RAISERROR (@ErrorMessage,@ErrorSeverity,@ErrorState);
 end catch