tracker issue : CF-4001377

select a category, or use search below
(searches all categories and all time range)
Title:

cfstoredproc problem in cf11 update 3

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/Duplicate

Reporter/Name(from Bugbase): Erik Voldengen / Erik Voldengen (Erik Voldengen)

Created: 06/04/2015

Components: Database

Versions: 11.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Win 2012 Server x64

Vote Count: 0

Duplicate ID:	CF-3865064

Problem Description:
CFSTOREDPROC using dbVarName parameter results in SQL Server error, now uses sp_prepExec

Steps to Reproduce:
use dbVarName in cfprocparam.

Actual Result:
Incorrect syntax near '='

Expected Result:
exec <name of sp>

Any Workarounds:
remove dbVarName from cfprocparam tags

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	4001377

External Customer Info:
External Company:  
External Customer Name: Erik
External Customer Email:  
External Test Config: My Hardware and Environment details:

CF11 update 3

Attachments:

Comments:

dbVarName can be rather important and backwards compatability should be maintained.
Comment by External U.
7245 | June 04, 2015 01:32:17 PM GMT
Can you post a repro case, Erik? You're not giving anyone much to go on here.
Comment by External U.
7246 | June 04, 2015 01:55:36 PM GMT
CREATE PROCEDURE sumTwoNumbers -- Add the parameters for the stored procedure here @firstNumber int = 0, @secondNumber int = 0 AS BEGIN SET NOCOUNT ON; select @firstNumber + @secondNumber as [result] END GO
Comment by External U.
7247 | June 04, 2015 04:10:13 PM GMT
<cfstoredproc dataSource = "scratch" procedure = "sumTwoNumbers"> <cfprocparam cfsqltype="cf_sql_integer" value="3" dbVarName="firstNumber" /> <cfprocparam cfsqltype="cf_sql_integer" value="5" dbVarName="secondNumber" /> </cfstoredproc> <cfdump var="#variables#" />
Comment by External U.
7248 | June 04, 2015 04:10:20 PM GMT
This is for a SQL Server DSN. If you look at the SQL executed on the server, it's buggy when using the dbVarName parameter of <cfprocparam>
Comment by External U.
7249 | June 04, 2015 04:12:40 PM GMT
This bug was withdrawn and marked as a duplicate issue. However, I can't find the duplicate bug. Can you please provide the bug ID? This is an important issue and updater 5 did not fix it.
Comment by External U.
7250 | June 05, 2015 09:50:50 AM GMT
I have already provided the duplicate bug ID. It should be available on the top right corner.
Comment by Nimit S.
7251 | June 05, 2015 11:14:45 AM GMT
Ah, thanks. I am new here.
Comment by External U.
7252 | June 05, 2015 11:16:47 AM GMT