User Guide

776 Chapter 5: ColdFusion Java CFX Reference
See also
getData
, addRow
Parameters
Example
The following example demonstrates the addition of two rows to a query that has three columns,
City, State, and Zip:
// Define column indexes
int iCity = 1, iState = 2, iZip = 3 ;
// First row
int iRow = query.addRow() ;
query.setData( iRow, iCity, "Minneapolis" ) ;
query.setData( iRow, iState, "MN" ) ;
query.setData( iRow, iZip, "55345" ) ;
// Second row
iRow = query.addRow() ;
query.setData( iRow, iCity, "St. Paul" ) ;
query.setData( iRow, iState, "MN" ) ;
query.setData( iRow, iZip, "55105" ) ;
Parameter Description
iRow Row of data element to set (1-based)
iCol Column of data element to set (1-based)
data New value for data element