Stack Overflow
Stack Overflow

Questions tagged [cfstoredproc]

19 questions
8
votes
1 answer

cfstoredproc no longer returns results after CF11 update 5

I have several SQL Server 2008 stored procedures. I am calling them via cfstoredproc. After I run a CF server update on April 17th, CF does not get the results anymore. Here is one of the calls:
CFNinja
  • 3,571
  • 4
  • 38
  • 59
3
votes
1 answer

array or list into Oracle using cfprocparam

I have a list of values I want to insert into a table via a stored procedure. I figured I would pass an array to oracle and loop through the array but I don't see how to pass an array into Oracle. I'd pass a list but I don't see how to work with…
genericHCU
  • 4,394
  • 2
  • 22
  • 34
2
votes
2 answers

Cache results

Is there any way to cache the results of a tag? The tag makes it easy with the cachedwithin attribute but there doesn't seem to be anything for . Am I missing something simple or is this functionality just…
Jason
  • 17,276
  • 23
  • 73
  • 114
2
votes
1 answer

Creating stored procedure using cfstoredproc

Is is possible to create a stored procedure using cfstoredproc? When I run the following I get Incorrect syntax near 'GO'.
david-l
  • 623
  • 1
  • 9
  • 20
2
votes
2 answers

Timeout issue using codefirststoredprocs in MVC5/EF 6. Error reading from stored proc dbo.[...]: Timeout expired

In order to process nearly 70K records at a time, I use codefriststoredprocs 2.5.0 with my application. With few records everything works fine but with large set of data, I receive "The wait operation timed out" exception. I tried modifying default…
prashantchalise
  • 496
  • 1
  • 5
  • 12
2
votes
2 answers

Accessing RAISEERROR message from cfstoredproc

I have a SQL stored procedure which under some situations will return a result of -1 if it fails, but also returns a message via the RAISERROR command e.g.: BEGIN RAISERROR ('Error %i has occurred', 11, 1, 0) RETURN -1 END I am accessing…
Loftx
  • 1,760
  • 4
  • 29
  • 50
2
votes
3 answers

Coldfusion CFSTOREDPROC does not return a table

I am using Coldfusion 9 and SQL Server 2008. I'm trying to learn the platforms and really learn how to effectively leverage both platforms for a reporting solution. I've had some big challenges with stored procedures, or sprocs. All I want is a…
Brad Hines
  • 107
  • 2
  • 15
1
vote
2 answers

What is a bound variable?

There is a cffunction (in a cfc document) which authenticates a user. It references a stored procedure and has a cfprocparam which is of type "out". On the Adobe CFML reference it says that means that "the parameter is used to receive data from the…
dmr
  • 21,811
  • 37
  • 100
  • 138
1
vote
3 answers

Managing database queries that are used across entire website

As my application has grown, I've noticed that I am reusing a lot of database queries across multiple webpages. At the moment I have done it using a .CFM file which has many tags that gets included on every page that needs database…
volume one
  • 6,800
  • 13
  • 67
  • 146
1
vote
0 answers

cfstoredproc, cfprocparam issue with mysql order by

I've been trying to set a simple cfstoredproc with cfc component which passes two parameters to mysql stored proc and order by query. here is the test code: test.cfm
user2595617
  • 219
  • 3
  • 13
1
vote
2 answers

CFStoredProc Timing Out

I have a very basic app that plugs data into a stored procedure which in turn returns a recordset. I've been experiencing what I thought were 'timeouts'. However, I'm now no longer convinced that this is what is really happening. The reason why is…
user2274650
  • 11
  • 3
1
vote
2 answers

Different results with cfstoredproc and cfquery

When I execute a stored proc via cfstoredproc, I am getting a different result than calling that stored proc via cfquery. I am passing in the same exact parameter values to each call. And also, when I run the stored proc in SQL Studio, I get the…
RHPT
  • 2,560
  • 5
  • 31
  • 43
0
votes
1 answer

locating SELECT statements in SQL Stored Procedure and corresponding query in ColdFusion

In ColdFusion, I have the following cfstoredproc being called with 3 inputs and 6 outputs. …
HPWD
  • 2,232
  • 4
  • 31
  • 61
0
votes
1 answer

Can I add a button to a CFGRID that lets a user export the grid to an XLSX file? How?

I'm a coldfusion developer working on a reporting application to display information from a CFSTOREDPROC process. I've been able to get the data from my query to display correctly in a CFGRID, and I'm really happy with the display of the data. The…
Brad Hines
  • 107
  • 2
  • 15
0
votes
2 answers

Use an if statement inside a stored procedure query?

I'm trying to convert a ColdFusion query into a stored procedure. My original query is as follows UPDATE Products SET Active = 1, Pounds = #lbs#, Ounces = #ozs#, Qty = #Qty#, PrevQty = #GetItem.Qty#, PrevWMQty = #GetItem.Qty#, …
Renshi
  • 77
  • 7
1
2