Hi all,
Here is a little background... CF: ColdFusion Server Enterprise 8,0,1,195765
SQL: Microsoft SQL Server 2008 R2
I have a stored procedure that when I run from SSMS it runs perfectly and
returns 2000 rows. When I run it from a cfstoredproc tag it returns no rows at
all. I just changed
Is it returning multiple recordsets perhaps? Or possibly returning a
cursor to the recordset?
Judah
On Wed, Nov 30, 2011 at 11:18 AM, DURETTE, STEVEN J sd1...@att.com wrote:
Hi all,
Here is a little background... CF: ColdFusion Server Enterprise 8,0,1,195765
SQL: Microsoft SQL Server 2008
: Wednesday, November 30, 2011 2:28 PM
To: cf-talk
Subject: Re: Weird SQL Query happenings...
Is it returning multiple recordsets perhaps? Or possibly returning a
cursor to the recordset?
Judah
~|
Order the Adobe Coldfusion Anthology
Anything unusual about the procedure like optional parameters?
(I know you said the input values are exactly the same, but ...) did you
compare the debug information from cfquery and cfstoredproc? Just to verify
everything truly is the same (values, data types, parameter position).
Another
don't return the same record set.
Hm.. on second thought I may have read that wrong. If the resultset you are
getting back contains the correct column names just no records - then ignore my
comment about NOCOUNT. It does not apply.
-Leigh
I checked, everything is exactly the same for both calls. Yes we do set NOCOUNT
ON.
Yes it returns the proper columns just no data.
Steve
-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com]
Sent: Wednesday, November 30, 2011 3:51 PM
To: cf-talk
Subject: Re: Weird SQL Query
Other than that the only thing I can think of would be tracing it or using the
profiler to see what is happening.at a db level. Because it does not make sense
the same parameters would return different results.
-Leigh
~|
If you run the profiler and it says that it is returning the correct
number of records in the sp that was run, you could also take a look
at FusionReactor and use their JDBC wrappers to see if something is
going on at the JDBC level.
Judah
On Wed, Nov 30, 2011 at 1:33 PM, Leigh
my memory is a little hazy on the subject, but I do recall some odd
issues like this with cfstoredproc.
Are you using cfstoredprocparam ?
if so, make sure you pass the params in in the exact same order as
they are defined in the stored proc itself, if I recall this is one of
the causes of such
On 12/1/2011 2:18 AM, DURETTE, STEVEN J wrote:
I have a stored procedure that when I run from SSMS it runs perfectly and
returns 2000 rows. When I run it from a cfstoredproc tag it returns no rows
seen something somewhat similar w/sql server 2008 datadirect drivers but this
was always w/sp
10 matches
Mail list logo