BackUp LevelNext

CCFXRequest::AddQuery

CCFXQuery* CCFXRequest::AddQuery(LPCSTR lpszName, CCFXStringSet* 
pColumns)

Adds a query to the calling template. This query can then be accessed by DBML tags (e.g., DBOUTPUT or DBTABLE) within the template. Note that after calling AddQuery, the query exists but is empty (i.e., it has 0 rows). To populate the query with data, you should call the CCFXQuery member functions CCFXQuery::AddRow and CCFXQuery::SetData.

Returns a pointer to the query that was added to the template (an object of class CCFXQuery). You are not responsible for freeing the memory allocated for the returned query (it will be automatically freed by ColdFusion after the request is completed).

lpszName

Name of query to add to the template (must be unique).

pColumns

List of columns names to be used in the query.

Example

The following example adds a query named 'People' to the calling template. The query has two columns ('FirstName' and 'LastName') and two rows:

// Create a string set and add the column names to it
CCFXStringSet* pColumns = pRequest->CreateStringSet() ;
int iFirstName = pColumns->AddString( "FirstName" ) ;
int iLastName = pColumns->AddString( "LastName" ) ;
 
// Create a query which contains these columns
CCFXQuery* pQuery = pRequest->AddQuery( "People", pColumns ) ;
 
// Add data to the query
int iRow ;
iRow = pQuery->AddRow() ;
pQuery->SetData( iRow, iFirstName, "John" ) ;
pQuery->SetData( iRow, iLastName, "Smith" ) ;
iRow = pQuery->AddRow() ;
pQuery->SetData( iRow, iFirstName, "Jane" ) ;
pQuery->SetData( iRow, iLastName, "Doe" ) ;

BackUp LevelNext

allaire

AllaireDoc@allaire.com
Copyright © 1998, Allaire Corporation. All rights reserved.