MACROMEDIA COLFUSION MX 7-CFML, Справочник

Страница: 1059 / 1108

CCFXQuery class 1059
Example
The following example shows the addition of two rows to a three-column ('City', 'State', and
'Zip') query:
// First row
int iRow ;
iRow = pQuery->AddRow() ;
pQuery->SetData( iRow, iCity, "Minneapolis" ) ;
pQuery->SetData( iRow, iState, "MN" ) ;
pQuery->SetData( iRow, iZip, "55345" ) ;
// Second row
iRow = pQuery->AddRow() ;
pQuery->SetData( iRow, iCity, "St. Paul" ) ;
pQuery->SetData( iRow, iState, "MN" ) ;
pQuery->SetData( iRow, iZip, "55105" ) ;
CCFXQuery::GetColumns
Syntax
CCFXStringSet* CCFXQuery::GetColumns(void)
Description
Retrieves a list of the column names contained in a query.
Returns
Returns an object of
CCFXStringSet class
that contains a list of the columns in the query.
ColdFusion automatically frees the memory that is allocated for the returned string set, after the
request is completed.
Example
The following example gets the list of columns, then iterates over the list, writing each column
name back to the user:
// Get the list of columns from the query
CCFXStringSet* pColumns = pQuery->GetColumns() ;
int nNumColumns = pColumns->GetCount() ;
// Print the list of columns to the user
pRequest->Write( "Columns in query: " ) ;
for( int i=1; i<=nNumColumns; i++ )
{
pRequest->Write( pColumns->GetString( i ) ) ;
pRequest->Write( " " ) ;
}