CFStoredProc Returns 1 Character of a longer string

[UKJools]

Hi,

I am using this code:

<cfstoredproc datasource="x" procedure="rUserRoles">
<cfprocparam type = "IN" CFSQLType="CF_SQL_VARCHAR" value =
"#session.User#" dbVarName = "@UID">
<cfprocparam type = "OUT" CFSQLType="CF_SQL_VARCHAR" dbVarName = "@Role"
variable="sMasterRole">
<cfprocparam type = "OUT" cfsqltype="cf_sql_integer" dbVarName =
"@PersonID" variable="PersonID">
<cfprocparam type = "OUT" cfsqltype="CF_SQL_VARCHAR" dbVarName = "@OPName"
variable= "fName">
</cfstoredproc>


---------------------------
The output variable from fName is only ever one character. For example, if the
name is 'Joe', the output is J. Querying SQL does return the full name, so I
suspect the problem is with CF....

Does anyone know why this might be and how to solve it?

[UKJools]

Hi,

I am using this code:

<cfstoredproc datasource="x" procedure="rUserRoles">
<cfprocparam type = "IN" CFSQLType="CF_SQL_VARCHAR" value =
"#session.User#" dbVarName = "@UID">
<cfprocparam type = "OUT" CFSQLType="CF_SQL_VARCHAR" dbVarName = "@Role"
variable="sMasterRole">
<cfprocparam type = "OUT" cfsqltype="cf_sql_integer" dbVarName =
"@PersonID" variable="PersonID">
<cfprocparam type = "OUT" cfsqltype="CF_SQL_VARCHAR" dbVarName = "@OPName"
variable= "fName">
</cfstoredproc>


---------------------------
The output variable from fName is only ever one character. For example, if the
name is 'Joe', the output is J. Querying SQL does return the full name, so I
suspect the problem is with CF....

Does anyone know why this might be and how to solve it?

[paross1]

Some possibly related threads that you might want look at.

[url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=6&threadid=983630[/url]

Phil

[UKJools]

Thanks, I did do a search...!! :)

there appears to be no solution to this problem yet :|