CCFXQuery::GetData  
 
 
LPCSTR CCFXQuery::GetData(int iRow, int lColumn)

Retrieves a data element from a row and column of the query. Row and column indexes begin with 1. You can determine the number of rows in the query by calling GetRowCount. You can determine the number of columns in the query by retrieving the list of columns using GetColumns and then calling CCFXStringSet::GetCount on the returned string set.

Returns the value of the requested data element.

iRow

Row to retrieve data from (1-based).

lColumn

Column to retrieve data from (1-based).

 
 
  Example  
 

The following example iterates over the elements of a query and writes the data in the query back to the user in a simple, space-delimited format:

int iRow, iCol ;
int nNumCols = pQuery->GetColumns()->GetCount() ;
int nNumRows = pQuery->GetRowCount() ;
for ( iRow=1; iRow<=nNumRows; iRow++ )
{
    for ( iCol=1; iCol<=nNumCols; iCol++ )
    {
    pRequest->Write( pQuery->GetData( iRow, iCol ) ) ;
    pRequest->Write( " " ) ;
    }
    pRequest->Write( "<BR>" ) ;
}



 
 
BackUp LevelNext
 
 

allaire     AllaireDoc@allaire.com
    Copyright © 1998, Allaire Corporation. All rights reserved.