MACROMEDIA COLFUSION MX 7 - INSTALLING AND USING COLDFUSION MX, Reference

Page: 1081 / 1108

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