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

Page: 1077 / 1108

Query interface 1077
Parameters
Query interface
public abstract interface Query
Interface to a query used or created by a custom tag. A query contains tabular data organized by
named columns and rows.
Methods
addRow
Description
Adds a row to a query. Call this method to append a row to a query.
Returns the index of the row that was appended to the query.
Category
Query interface
Syntax
public int addRow()
See also
setData
,
getData
Example
The following example demonstrates the addition of two rows to a query that has three columns,
City , State , and Zip :
// Define column indexes
Parameter Description
request Parameters (attributes, query, and so on.) for this request
response Interface for generating response to request (output, variables, queries, and so on)
Returns Method Description
int
addRow ()
Adds a row to the query
int
getColumnIndex (String name )
Gets the index of a column given its name
String[]
getColumns ()
Gets a list of the column names in a query
String
getData (int iRow, int iCol)
Gets a data element from a row and column of a
query
String
getName ()
Gets the name of a query
int
getRowCount ()
Gets the number of rows in a query
void
setData (int iRow, int iCol,
String data)
Sets a data element in a row and column of a
query