0
CFC Error -pass parameters
Participant
,
/t5/coldfusion-discussions/cfc-error-pass-parameters/td-p/910756
Oct 06, 2008
Oct 06, 2008
Copy link to clipboard
Copied
Can anyone point out a solution this error? Thank you in
advance...the BossEID is not blank...
The parameter CCFBOSSEID to function update is required but was not passed in.
The error occurred in C:\Inetpub\wwwroot\Scorecard33\admin\ccf\bridge\act_csv.import.cfm: line 82
Called from C:\Inetpub\wwwroot\Scorecard33\parsed\bridge.csv.cfm: line 30
Called from C:\Inetpub\wwwroot\Scorecard33\fusebox5\Application.cfc: line 228
Called from C:\Inetpub\wwwroot\Scorecard33\fusebox5\Application.cfc: line 218
Called from C:\Inetpub\wwwroot\Scorecard33\fusebox5\fusebox5.cfm: line 57
Called from C:\Inetpub\wwwroot\Scorecard33\index.cfm: line 3
80 : <cfset MyCSV.update(EID, ccfLevel, CCFRole, CCFTeamID,CCFlocationID, status,
81 : CSGID, SalesRep_id, Peoplesoftid, AvayaID,
82 : first_name, mi, last_name, hiredate, CCFBossEID)>
83 : <cfelse>
84 : <li>Adding...</li>
The parameter CCFBOSSEID to function update is required but was not passed in.
The error occurred in C:\Inetpub\wwwroot\Scorecard33\admin\ccf\bridge\act_csv.import.cfm: line 82
Called from C:\Inetpub\wwwroot\Scorecard33\parsed\bridge.csv.cfm: line 30
Called from C:\Inetpub\wwwroot\Scorecard33\fusebox5\Application.cfc: line 228
Called from C:\Inetpub\wwwroot\Scorecard33\fusebox5\Application.cfc: line 218
Called from C:\Inetpub\wwwroot\Scorecard33\fusebox5\fusebox5.cfm: line 57
Called from C:\Inetpub\wwwroot\Scorecard33\index.cfm: line 3
80 : <cfset MyCSV.update(EID, ccfLevel, CCFRole, CCFTeamID,CCFlocationID, status,
81 : CSGID, SalesRep_id, Peoplesoftid, AvayaID,
82 : first_name, mi, last_name, hiredate, CCFBossEID)>
83 : <cfelse>
84 : <li>Adding...</li>
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
LEGEND
,
/t5/coldfusion-discussions/cfc-error-pass-parameters/m-p/910757#M83741
Oct 06, 2008
Oct 06, 2008
Copy link to clipboard
Copied
If you are convinced that it's not blank, make sure that you
have an exact match between the variables you are sending to your
function and the cfargument tags. I notice one of them was
commented out.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
emmim44
AUTHOR
Participant
,
/t5/coldfusion-discussions/cfc-error-pass-parameters/m-p/910758#M83742
Oct 06, 2008
Oct 06, 2008
Copy link to clipboard
Copied
Lets say if some of the CCFBossEID are blank, what do you
suggest then?
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Advocate
,
/t5/coldfusion-discussions/cfc-error-pass-parameters/m-p/910759#M83743
Oct 06, 2008
Oct 06, 2008
Copy link to clipboard
Copied
Always put any arguments that aren't required as the last
arguments in your <cffunction>
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
LEGEND
,
/t5/coldfusion-discussions/cfc-error-pass-parameters/m-p/910763#M83747
Oct 06, 2008
Oct 06, 2008
Copy link to clipboard
Copied
quote:
Originally posted by: emmim44
Lets say if some of the CCFBossEID are blank, what do you suggest then?
What do your business rules say about that?
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
emmim44
AUTHOR
Participant
,
/t5/coldfusion-discussions/cfc-error-pass-parameters/m-p/910760#M83744
Oct 06, 2008
Oct 06, 2008
Copy link to clipboard
Copied
Are the order of cfarguments important when sending the
parameters to the function?
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
LEGEND
,
/t5/coldfusion-discussions/cfc-error-pass-parameters/m-p/910762#M83746
Oct 06, 2008
Oct 06, 2008
Copy link to clipboard
Copied
quote:
Originally posted by: emmim44
Are the order of cfarguments important when sending the parameters to the function?
Only when you use the method you attempted.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Advocate
,
/t5/coldfusion-discussions/cfc-error-pass-parameters/m-p/910761#M83745
Oct 06, 2008
Oct 06, 2008
Copy link to clipboard
Copied
How else do you think Coldfusion matches up what you're
passing in?
When you call it using <cfinvoke...>, you explicitly tell CF which argument each parameter applies to in your <cfinvokeargument...> tags. When you call it as you do, using a comma-delimited list of variables, the only thing CF has to go on is the order of the parameters you're passing in, and the order of the arguments defined in the function.
When you call it using <cfinvoke...>, you explicitly tell CF which argument each parameter applies to in your <cfinvokeargument...> tags. When you call it as you do, using a comma-delimited list of variables, the only thing CF has to go on is the order of the parameters you're passing in, and the order of the arguments defined in the function.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
emmim44
AUTHOR
Participant
,
/t5/coldfusion-discussions/cfc-error-pass-parameters/m-p/910764#M83748
Oct 06, 2008
Oct 06, 2008
Copy link to clipboard
Copied
They said leave it null or blank... depends on db ...
Also, even I set a default value for status, how come 'Work_status' is not being updated with the default value = 'FTE' ??
<cfargument name="status" type="string" required="false" default="FTE">
<cfif arguments.status NEQ "">
Work_status = <cfqueryparam cfsqltype="CF_SQL_CHAR" value="#arguments.status#">,
<cfelse>
Work_status = '#arguments.status#',
</cfif>
Also, even I set a default value for status, how come 'Work_status' is not being updated with the default value = 'FTE' ??
<cfargument name="status" type="string" required="false" default="FTE">
<cfif arguments.status NEQ "">
Work_status = <cfqueryparam cfsqltype="CF_SQL_CHAR" value="#arguments.status#">,
<cfelse>
Work_status = '#arguments.status#',
</cfif>
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Advocate
,
/t5/coldfusion-discussions/cfc-error-pass-parameters/m-p/910765#M83749
Oct 06, 2008
Oct 06, 2008
Copy link to clipboard
Copied
Because the default value is only used if status isn't being
passed into the function. If it's being passed in, even if it's
null or an empty string, the function is going to use what you
passed in.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
LEGEND
,
/t5/coldfusion-discussions/cfc-error-pass-parameters/m-p/910766#M83750
Oct 06, 2008
Oct 06, 2008
Copy link to clipboard
Copied
quote:
Originally posted by: emmim44
They said leave it null or blank... depends on db ...
Also, even I set a default value for status, how come 'Work_status' is not being updated with the default value = 'FTE' ??
<cfargument name="status" type="string" required="false" default="FTE">
<cfif arguments.status NEQ "">
Work_status = <cfqueryparam cfsqltype="CF_SQL_CHAR" value="#arguments.status#">,
<cfelse>
Work_status = '#arguments.status#',
</cfif>
Kronin555's earlier reply explains it.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
emmim44
AUTHOR
Participant
,
LATEST
/t5/coldfusion-discussions/cfc-error-pass-parameters/m-p/910767#M83751
Oct 06, 2008
Oct 06, 2008
Copy link to clipboard
Copied
You are right man...Thank you guys...
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

