Adobe ColdFusion 8

CCFXQuery::SetData

Syntax

void CCFXQuery::SetData(int iRow, int iColumn, LPCSTR lpszData)

Description

Sets a data element within a row and column of a query. Row and column indexes begin with 1. Before calling SetData for a given row, call CCFXQuery::AddRow and use the return value as the row index for your call to SetData.

Parameters

Parameter

Description
iRow

Row of data element to set (1-based)
iColumn

Column of data element to set (1-based)
lpszData

New value for data element

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( iCity, iRow, "Minneapolis" ) ;
    pQuery->SetData( iState, iRow, "MN" ) ;
    pQuery->SetData( iZip, iRow, "55345" ) ;
     
    // Second row
    iRow = pQuery->AddRow() ;
    pQuery->SetData( iCity, iRow, "St. Paul" ) ;
    pQuery->SetData( iState, iRow, "MN" ) ;
    pQuery->SetData( iZip, iRow, "55105" ) ;