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

Page: 1061 / 1108

CCFXQuery class 1061
Example
The following example retrieves the name of a query and writes it back to the user:
CCFXQuery* pQuery = pRequest->GetQuery() ;
pRequest->Write( "The query name is: " ) ;
pRequest->Write( pQuery->GetName() ) ;
CCFXQuery::GetRowCount
Syntax
int CCFXQuery::GetRowCount(void)
Description
Returns the number of rows contained in a query.
Example
The following example retrieves the number of rows in a query and writes it back to the user:
CCFXQuery* pQuery = pRequest->GetQuery() ;
char buffOutput[256] ;
wsprintf( buffOutput,
"The number of rows in the query is %ld.",
pQuery->GetRowCount() ) ;
pRequest->Write( buffOutput ) ;
CCFXQuery::SetData
Syntax
void CCFXQuery::SetData(int iRow , int iColumn , LPCSTR lpszData )
Description
Sets a data element within a row and column of a query. Row and column indexes begin with 1.
Before calling
SetData
for a given row, call
CCFXQuery::AddRow
and use the return value as the
row index for your call to
SetData
.
Parameters
Parameter Description
iRow Row of data element to set (1-based)
iColumn Column of data element to set (1-based)
lpszData New value for data element