![]() ![]() ![]() |
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).
Name of query to add to the template (must be unique).
List of columns names to be used in the query.
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" ) ;
![]() ![]() ![]() |
AllaireDoc@allaire.com
Copyright © 1998, Allaire Corporation. All rights reserved.