XWeb: GetQuery ColdFusion Sample1
Sample Code
<!---
//////////////////////////////////////////////////////////////
// //
// author = Derek T. Versteegen //
// organization = American Academy of Pediatrics //
// date added = 10/18/2007 //
// date last modified = 10/18/2007 - DTV //
// //
// notes = code examples of consuming netFORUM baseline //
// xweb methods by way of ColdFusion Components //
// //
// dependancies = netforum_xweb.cfc //
// //
//////////////////////////////////////////////////////////////
--->
<!--- xWeb:GetIndividualInformation --->
<cfparam name="session.nfws_token" default="00000000-0000-0000-0000-000000000000">
<cfparam name="ind_cst_key" default="00000000-0000-0000-0000-000000000000">
<cfinvoke component="/xxxxxx/netforum_xweb" method="xweb_GetIndividualInformation" returnvariable="qryXML">
<cfinvokeargument name="nfws_token" value="#session.nfws_token#" omit="no">
<cfinvokeargument name="ind_cst_key" value="#ind_cst_key#" omit="no">
</cfinvoke>
<cfdump var="#session.nfws_token#" label="nfws_token">
<cfdump var="#qryXML#" label="qryXML">
Note: The szObjectName can be obtained from iWeb in netFORUM. The szColumnList should be a comma delimited list of column names that you want to be returned - just like a regular inline query. This node DOES NOT accept an asterisk (*) wild card, you must specify your fields. When using szWhereClause be sure to add the appropriate single quotes for non-integer expressions. The szOrderBy node, just like the szWhereClause, is optional but must be supplied. Pass an empty field if you have no criteria for either one.