User Guide

Query interface 1081
Example
The following example retrieves the number of rows in a query and writes it back to the user:
Query query = request.getQuery() ;
int rows = query.getRowCount() ;
response.write( "The number of rows in the query is "
+ Integer.ToString(rows) ) ;
setData
Description
Sets a data element in a row and column of a query. Row and column indexes begin with 1.
Before calling
setData for a given row, call addRow and use the return value as the row index for
your call to
setData.
Category
Query interface
Syntax
public void setData(int iRow, int iCol, String data)
Throws
IndexOutOfBoundsException
If an invalid index is passed to the method.
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() ;
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