I'm not passing WorkFlowCode param in and I shouldn't need to but it errors out. Something obvious I'm overlooking?
It throws up on: <cfif ARGUMENTS.WorkFlowCode neq "">
Code:
<!--- GetAuditWorkflow --->
<cffunction name="GetAuditWorkflow" access="public" returntype="query" output="No" displayname="Get workflow action id's and people for audit." hint="Get workflow action id's and people for audit and workflow type.">
<cfargument name="DATASOURCE" type="string" required="Yes" default="">
<cfargument name="IawpAuditSeq" required="Yes" type="string">
<cfargument name="WorkFlowCode" required="No" default="" type="string"> <cfquery name="GetAuditWorkflow" datasource="#ARGUMENTS.datasource#">
SELECT PERSON_ID
,WORKFLOW_ACTION_ID
,CREATED_BY
FROM IAWP_WORKFLOW
WHERE IAWP_AUDIT_SEQ = '#ARGUMENTS.IawpAuditSeq#' <cfif ARGUMENTS.WorkFlowCode neq "">
AND WORKFLOW_CODE = '#ARGUMENTS.WorkFlowCode#'
</cfif></cfquery>
<cfreturn GetAuditWorkflow> </cffunction>
Thanks for your time -
Brent Nicholas - EclecticDetroit, LLC. http://www.EclecticDetroit.com
[EMAIL PROTECTED] [EMAIL PROTECTED]
"On the other hand, you have different fingers."
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email
to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com).
An archive of the CFCDev list is available at [EMAIL PROTECTED]
