User Guide

756 Chapter 4: ColdFusion C++ CFX Reference
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
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" ) ;
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