Adobe ColdFusion 8

CCFXQuery::AddRow

Syntax

int CCFXQuery::AddRow(void)

Description

Add a row to the query. Call this function to append a row to a query.

Returns

Returns the index of the row that was appended to a query.

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