There are plenty of ways to do this but this is the first one that came to mind.
You could assign your output values to a structure and then use the function
structkeylist to traverse the items in the structure. So your procparam tag would
look like:
<CFPROCPARAM TYPE="OUT" CFSQLTYPE=CF_SQL_DATE
VARIABLE=mystruct.FOO DBVARNAME=@param2>
In the example below, I create a structure with just two keys. Then, without knowing
what those keys are, I use structkeylist to find them, build the variable names and
evalueate them. The output will be "fred,n/a".
Hope this helps,
Roger
<CFSET mystruct=StructNew()>
<CFSET mystruct.firstname = "fred">
<CFSET mystruct.lastname = "">
<cfset keylist = #StructKeyList(mystruct)#>
<cfoutput>
<cfloop index = "bKey" list = "#keylist#">
<cfset shortfldname = "mystruct." & #bKey#>
<cfset fldname = "##" & #shortfldname# & "##">
<cfif #trim(evaluate(fldname))# is "">
<cfset result = #SetVariable(shortfldname, "n/a")#>
</cfif>
<cfset fldval = #evaluate(fldname)#>
#fldval#,
</cfloop>
</cfoutput>
-----Original Message-----
From: Nathan T Haley [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, December 14, 2000 10:22 AM
To: '[EMAIL PROTECTED]'
Subject: [KCFusion] output
Can anyone give a hint where to look about checking output values(many) from
procs for empty and assigning a value like 'n/a'?
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
