MACROMEDIA COLDFUSION MX 61-CFML, Reference

Page: 753 / 806

CCFXQuery class 753
CCFXQuery class
An abstract class that represents a query used or created by a ColdFusion Extension (CFX).
Queries contain one or more columns of data that extend over a varying number of rows.
Class members
CCFXQuery::AddRow
Syntax
int CCFXQuery::AddRow(void)
Description
Add a row to the query. Call this function to append a row to a query.
Returns
Returns the index of the row that was appended to a query.
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( iRow, iCity, "Minneapolis" ) ;
pQuery->SetData( iRow, iState, "MN" ) ;
pQuery->SetData( iRow, iZip, "55345" ) ;
// Second row
iRow = pQuery->AddRow() ;
pQuery->SetData( iRow, iCity, "St. Paul" ) ;
pQuery->SetData( iRow, iState, "MN" ) ;
pQuery->SetData( iRow, iZip, "55105" ) ;
virtual int AddRow()
CCFXQuery::AddRow
adds a row to a query.
virtual CCFXStringSet* GetColumns
CCFXQuery::GetColumns
retrieves a list of a
query's column names.
virtual LPCSTR GetData( int iRow, int
iColumn )
CCFXQuery::GetData
retrieves a data element
from a row and column of a query.
virtual LPCSTR GetName()
CCFXQuery::GetName
retrieves the name of a
query.
virtual int GetRowCount()
CCFXQuery::GetRowCount
retrieves the number of
rows in a query.
virtual void SetData( int iRow, int iColumn,
LPCSTR lpszData )
CCFXQuery::SetData
sets a data element within a
row and column of a query.
virtual void SetQueryString( LPCSTR
lpszQuery )
This function is deprecated. It might not work,
and might cause an error, in later releases.
virtual void SetTotalTime( DWORD
dwMilliseconds )
This function is deprecated. It might not work,
and might cause an error, in later releases.