<cfprocparam cfsqltype="CF_SQL_INTEGER" dbvarname="client_id"
value="#request.client_id#" type="In">
<cfprocparam cfsqltype="CF_SQL_VARCHAR" dbvarname="appname"
variable="request.appname" type="Out">
</cfstoredproc>
The above call returns the OUT variable (request.appname) padded with
nulls when I use an OLEDB datasource. When I use ODBC the nulls are
stripped. DB = SQL Server 2000.
It's easy enough to call a UDF to strip them but I was wondering if there
is a setting somewhere that can do this automatically.
TIA
Don
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
