Question
Stored Procedure Only Returns First Character
I am having an issue with ColdFusion MX7 and a MSSQL 2005 DB.
I am able to duplicate my development issue with the following simple example
-- SQL Code
CREATE PROCEDURE myTestProc
@myString varchar(36) OUT
AS
BEGIN
set @myString = 'This is my test';
END
GO
-- CFCode
<cfstoredproc procedure="myTestProc" datasource="#dsName#">
<cfprocparam cfsqltype="cf_sql_varchar"
type="out"
variable="vars.myString" />
</cfstoredproc>
<cfdump label="testProcReturn" var="#vars#" />
<cfabort />
This is what it returns
| testProcReturn - struct | |
|---|---|
| myString | T |
I have tried many, many, many variations of CFSQLTYPE and the datatype in the procedure and not once have I got it to return more than just the first character.
AdChoices