Just to butt in:
<cfargument name="workflowcode" required="no" default="">
<cfif len(arguments.workflowcode)>
AND WORKFLOW_CODE = '#ARGUMENTS.WorkFlowCode#'
</cfif>
my 2p
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Gerald Harper
Sent: 12 November 2004 16:33
To: [EMAIL PROTECTED]
Subject: RE: [CFCDev] CFC Error - "Name Can't be empty"
Try the following in your CFIF block:
<cfif isDefined("ARGUMENTS.WorkFlowCode") AND ARGUMENTS.WorkFlowCode neq
"">
AND WORKFLOW_CODE = '#ARGUMENTS.WorkFlowCode#'
</cfif>
I think that if an optional ARGUMENTS parameter isn't passed into the
CFC, it's not defined within it when it's invoked.
Gerald *
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Brent Nicholas
Sent: Friday, November 12, 2004 7:49 AM
To: [EMAIL PROTECTED]
Subject: [CFCDev] CFC Error - "Name Can't be empty"
Ok, so I've run into this from time to time and I can never seem to
really figure it out.
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]
----------------------------------------------------------
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]
----------------------------------------------------------
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]
