gateway applications now
I get an error saying that Executing stored procedures is not allowed.
How do you enable stored procedures in this version? Is it part of the
install or can it be changed within administrator?
Thanks v
In ColdFusion 10 when trying to access one of our gateway applications now I
get an error saying that âExecuting stored procedures is not allowed.â How
do you enable stored procedures in this version? Is it part of the install or
can it be changed within administrator?
Thanks v
In ColdFusion 10 when trying to access one of our gateway applications now I
get an error saying that Executing stored
procedures is not allowed. How do you enable stored procedures in this
version? Is it part of the install or can it be changed
within administrator?
CF 10 does
have a client for whom we are doing a bunch of refactoring of code. As
part of the QA, the client would like to know, for every page, what stored
procedures are called and how that page is accessed.
So what I would like to do is to log the call stack and the stored procedures
called
We have a client for whom we are doing a bunch of refactoring of code. As part
of the QA, the client would like to know, for every page, what stored
procedures are called and how that page is accessed.
So what I would like to do is to log the call stack and the stored procedures
called
In Cold Fusion I have a large array of struct I'm trying to pass into ORACLE
10g using stored procedures. I am hitting a performance wall inside ORACLE
(probably self inflicted).
I don't know of a way to transfer a complex array directly to ORACLE -- if
there is, I'd love to hear it.
So
Hi,
Does anyone know if there's a way to view a databases stored procedures from
inside CF builder's RDS Dataview pane? From what I see it displays tables,
views, synonyms and system tables but no way to display stored procedures
for easy use. This seems like a major flaw to me.
Any ideas
for it.
On Tue, Jun 1, 2010 at 10:13 AM, Paul Alkema
paulalkemadesi...@gmail.com wrote:
Hi,
Does anyone know if there's a way to view a databases stored procedures from
inside CF builder's RDS Dataview pane? From what I see it displays tables,
views, synonyms and system tables but no way to display
I'm pretty sure the data tools plungin from eclipse has this functionality,
if you are looking for a better integrated database experience in eclipse.
Sent from my mobile device
On 2 Jun 2010 01:29, Raymond Camden rcam...@gmail.com wrote:
I don't believe it is supported. I did a quick search
I have always had problem with the way ColdFusion reports errors in stored
procedures and I was wondering how other CFâers go about debugging the same
sort of errors (without costly software).
For example, the following ColdFusion error is generated on a stored
procedure...
Application
I am trying to add a field to a stored procedure. I modified the stored proc
in SQL Studio and executed it. It appears to have saved the changes.
Now I added cfprocparam dbvarname=@PromoCode value=#session.promocode#
cfsqltype=cf_sql_varchar to my CFStoredProc tag.
I get the error Procedure
Subject: stored procedures
From: Chad Gray cg...@careyweb.com
Date: Wed, November 18, 2009 10:43 am
To: cf-talk cf-talk@houseoffusion.com
I am trying to add a field to a stored procedure. I modified the
stored proc in SQL Studio and executed it. It appears to have saved
the changes.
Now I added
and now it is working.
Very confusing to have a stored proc on a table that is modifying another table.
Thanks for the input though!
Chad
-Original Message-
From: b...@bradwood.com [mailto:b...@bradwood.com]
Sent: Wednesday, November 18, 2009 12:26 PM
To: cf-talk
Subject: RE: stored
By table1 and table2 I actually meant database1 and database2.
Im on a roll today...
-Original Message-
From: Chad Gray [mailto:cg...@careyweb.com]
Sent: Wednesday, November 18, 2009 12:36 PM
To: cf-talk
Subject: RE: stored procedures
Never mind.. I was editing the wrong
hi, i am trying to et my head around stored procedures (using MySQL) I can get
a basic oe to work but having problems when trying to send parameters across
cfstoredproc procedure=spGetDetails datasource=#myDatasource#
cfprocparam type=In cfsqltype=CF_SQL_INTEGER value=#id#
null
www.necfug.com
-Original Message-
From: Rick Turner [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 21, 2008 2:27 PM
To: CF-Talk
Subject: Stored Procedures
hi, i am trying to et my head around stored procedures (using MySQL) I can
get a basic oe to work but having problems when trying to send
Ah, so we can use unix line feeds only? I wonder if that is the same
issue we've seen with running inline PL/SQL blocks; I'll try it out
and see what I can find. Thanks.
On Nov 3, 2007 12:57 AM, Ryan, Terrence [EMAIL PROTECTED] wrote:
In case anyone has this problem in the future. The solution
In case anyone has this problem in the future. The solution is to strip out all
chr(13)'s from the procedure creation code.
Terrence Ryan
I.T. Director
Wharton Computing and Information Technology
E-mail: [EMAIL PROTECTED]
I figure this is a pretty random problem, but I figured I would try to
ask here.
Does anyone know how to compile Oracle stored procedures from
ColdFusion?
I can successful write stored procedures in Oracle from ColdFusion, they
show up as uncompiled when I use Oracle Tools to view them
I am adding a lot of additional functionality to an existing application
(yuck). Basically taking a static survey application that generates a
word document and turning it into a dynamic survey application that puts
out multiple documents in multiple formats.
I have several large forms that I
I've seen passing in arrays spoken about, but I cannot seem to find a
definitive example of how that would work.
How about WDDX, can Oracle deal with that? There's a cfwddx tag that gives
you some options.
-- Josh
~|
.
Visit our website at http://www.reedexpo.com
-Original Message-
From: Heald, Timothy J
To: CF-Talk
Sent: Thu Apr 05 20:56:36 2007
Subject: Passing complex data into Oracle stored procedures
I am adding a lot of additional functionality to an existing application
(yuck). Basically
vs SQL Server Stored Procedures
There are two reasons my organization encourages/forces all SQL to be in
stored procedures. And they don't directly touch on performance.
1. A belief that keeping SQL code in the database is of itself a good thing.
By keeping the database interaction
Cached queries will execute faster than stored procedures in many cases.
The problem of queries inside of ColdFusion deals directly with looping over
the data of performing a Query of a Query against the data set.
I tend to stay away from Query of a Query as the performance is not to my
liking
At 11:17 AM 3/20/2007, D wrote:
Are cached queries as good as stored procedures?
Technically which are better?
Is it a significant difference?
Cached queries hold data in RAM so no call to the DB is necessary, so
they are always much faster than stored procedures (except for the
first call
There are two reasons my organization encourages/forces all SQL to be in stored
procedures. And they don't directly touch on performance.
1. A belief that keeping SQL code in the database is of itself a good thing. By
keeping the database interaction in the database you make it easier for DBA's
Opinions?
Are cached queries as good as stored procedures?
Technically which are better?
Is it a significant difference?
Thanks
D
~|
Create Web Applications With ColdFusion MX7 Flex 2.
Build powerful, scalable RIAs. Free
] [mailto:[EMAIL PROTECTED]
Sent: 20 March 2007 16:30
To: CF-Talk
Subject: CFQUERY vs SQL Server Stored Procedures
Opinions?
Are cached queries as good as stored procedures?
Technically which are better?
Is it a significant difference?
Thanks
D
Opinions?
Are cached queries as good as stored procedures?
Technically which are better?
Is it a significant difference?
Thanks
If you are just using stored procedures to cache the data, it is
probably a relatively even trade off.
But, of course a stored procedure can do a lot more then just
Thanks guys. I ijust found this article on Adobe.com that helped if anyone had
similar questions to my original questions.
http://www.adobe.com/devnet/coldfusion/articles/beg_storedproc.html
D
Opinions?
Are cached queries as good as stored procedures?
Technically which are better
What is the preferred method for calling CR files from CF when the
underlying rpt file calls a stored procedure that requires one or more
parameters to be passed? That is, how do I pass parameters to a stored
procedure from within the cfreport tag? Anybody done this before?
thx,
-dante
On Thursday 11 January 2007 10:06, Simon Whittaker wrote:
I hope you can help us with a problem we are experiencing with execution of
stored procedures from coldfusion pages. Stored procedures are running very
slowly only when executed from cf pages, when they're run in the SQL 2000
query
All,
I hope you can help us with a problem we are experiencing with execution of
stored procedures from coldfusion pages. Stored procedures are running very
slowly only when executed from cf pages, when they're run in the SQL 2000
query analyser they run in sometimes less than a second but when
with a problem we are experiencing with execution
of
stored procedures from coldfusion pages. Stored procedures are running
very
slowly only when executed from cf pages, when they're run in the SQL 2000
query analyser they run in sometimes less than a second but when run from
coldfusion they can take
I think that hotfix added support for named parameters in cfprocparam
back in. Previously the dbvarname would be ignored. Make sure your
parameter names are correct. (And, depending on your database
settings, check the case as well.)
Cheers,
Kris
Anybody getting errors with the hotfix? I've
Anybody getting errors with the hotfix? I've instaled in one of my
servers today and the website went down after a few hours of running.
The error is very wierd and does not says anything to me:
Error Executing Database Query.[Macromedia][SQLServer JDBC
Driver][SQLServer]Line 1: Incorrect syntax
thanks greg, yes my hair is now growing back as we speak :)
and unfortunately for our company i am the DBA :) In fact me and my business
partner are the DBA's, programmers, designers, marketers, salesman etc.. but
thanks to all you guys on this site we are are getting better at other things,
hi greg thanks for your reply. I thought that may be it for a minute but yes it
is ticked - all of the allowed sql statements are ticked
Thanks
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
hi greg, just noticed that you said you were using a
mysql-connector-java-3.1.12.
i dont know if it makes any difference but i am using dreamweaver and have
setup a mysql connection through it. Queries work fine but not the stored
procedures. Do you think it may have something to do
work fine but not the stored
procedures. Do you think it may have something to do with the dreamweaver
connection? how did you set up your connection, maybe i can try it that way?
I have gone to the cf administrator and it is showing the database as a
datasource so assume it has been setup fine
hi greg, you are a diamond :) I changed the driver over to the connector j 5.0
and added a new datasource not with mysql connection but with 'other' and set
the configuration manually. I tried it and couldnt believe that it is now
working. It does make alot of sense now that we know what it is.
Richard,
Glad to be of help. I hope that now you will have a great weekend, happy
holidays, etc. (and that your hair will grow back :-)
And more than that, I hope that with Scorpio the MySQL drivers bundled with
CF will be upgraded. (Anyone from the CF team at Adobe lurking here on this
list ?
Richard,
Just to confirm background stuff ...
Is the following enabled:
In ColdFusion Administrator -- Data Sources -- {select data source in
question} -- Advanced Settings -- Allowed SQL -- Stored Procedures
I am running stored procs with no problem with MySQL 5.0.19 with ColdFusion
7.0.2
Hi i posted a problem a while ago as i couldnt get stored procedures stored in
mysql to work, it keeps coming up with a java.lang null pointer error.
previous thread:
http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:48365
i was wondering if any using mysql and cfstoredproc could
Can anyone recommend a good resource (book, online training, etc) for
learning how to write stored procedures in Transact-SQL?
Rick
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date
MSDN SQL Server 2005 Books Online: Stored Procedures
http://msdn2.microsoft.com/en-us/library/ms190782.aspx
Rick Root wrote:
Can anyone recommend a good resource (book, online training, etc) for
learning how to write stored procedures in Transact-SQL?
Rick
Hi, i have created a mysql database. I have included some stored procedures. I
have also created privileges and grants for the user on all tables, columns,
rows, procedures etc.
The table where i store the privileges for the stored procedures is procs_priv.
I have granted all privileges
I have used lots of Oracle stored procedures using cfstoredproc but my DBA
has now written several functions that I need to use. I have never had any
luck accessing these via cfstoredproc and was wondering if it was a) not
possible or b) there is some clever trick involved. Using MX 6.1 on Linux
What do the functions return?
On 4/25/06, Shawn McKee [EMAIL PROTECTED] wrote:
I have used lots of Oracle stored procedures using cfstoredproc but my
DBA
has now written several functions that I need to use. I have never had
any
luck accessing these via cfstoredproc and was wondering
I don't believe you can access functions directly from ColdFusion.
You'd have to write a stored proc that calls the function, I think.
On 4/25/06, Shawn McKee [EMAIL PROTECTED] wrote:
I have used lots of Oracle stored procedures using cfstoredproc but my DBA
has now written several functions
Are the functions part of an Oracle package? If so I can send ya the code to
use 'emjust a normal CFQUERYno use of CFSTOREDPROC
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
Integers, strings, etc. A single value for a given function.
-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 11:33 AM
To: CF-Talk
Subject: Re: Stored procedures
What do the functions return?
On 4/25/06, Shawn McKee [EMAIL PROTECTED] wrote
here's how ya get at a fucntion that is part of a package:
cfstoredproc procedure=schemaName.packageName.functionName
datasource=#datasource# username=#userid# password=#passwd#
cfprocparam type=In cfsqltype=CF_SQL_BIGINT dbvarname=varName1
value=varValue1
cfprocparam type=In
Yes they are part of an Oracle package.
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 11:46 AM
To: CF-Talk
Subject: ***SPAM*** Re: Stored procedures
Are the functions part of an Oracle package? If so I can send ya the code
to
use 'em
, Shawn McKee [EMAIL PROTECTED] wrote:
Integers, strings, etc. A single value for a given function.
-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 11:33 AM
To: CF-Talk
Subject: Re: Stored procedures
What do the functions return?
On 4
procedures
I have used lots of Oracle stored procedures using cfstoredproc but my
DBA
has now written several functions that I need to use. I have never had
any
luck accessing these via cfstoredproc and was wondering if it was a)
not
possible or b) there is some clever trick involved. Using MX 6.1
Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 11:55 AM
To: CF-Talk
Subject: ***SPAM*** Re: Stored procedures
here's how ya get at a fucntion that is part of a package:
cfstoredproc procedure=schemaName.packageName.functionName
datasource=#datasource
No benefit really. Not in this instance.
-Original Message-
From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED]
Sent: 01 March 2006 21:39
To: CF-Talk
Subject: Stored Procedures and when to use them
Hi guys,
I am just getting my head around stored procedures in SQL Server. One
:
No benefit really. Not in this instance.
-Original Message-
From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED]
Sent: 01 March 2006 21:39
To: CF-Talk
Subject: Stored Procedures and when to use them
Hi guys,
I am just getting my head around stored procedures in SQL Server. One
be
your vice as CF will choke on large sets like this.
-Original Message-
From: John C. Bland II [mailto:[EMAIL PROTECTED]
Sent: 02 March 2006 10:15
To: CF-Talk
Subject: Re: Stored Procedures and when to use them
Sprocs are faster if you are doing multiple things in 1 call. The idea
: John C. Bland II [mailto:[EMAIL PROTECTED]
Sent: 02 March 2006 10:15
To: CF-Talk
Subject: Re: Stored Procedures and when to use them
Sprocs are faster if you are doing multiple things in 1 call. The idea is
you are in the database already so go ahead and let the database do what
it
does
One of the nice things about stored procedures wv. inline sql is that
your database can tell you which procs are invalidated by a change to
your schema, which can be a big time saver in development.
/t
~|
Message: http
it basically.
Hi guys,
I am just getting my head around stored procedures in SQL Server. One of
the things I am trying to understand is when I should be using them.
For example, on my clients homepage I wish to pull 2 random product
records...
cfquery name=getRandomProducts datasource
: Martin Thorpe [mailto:[EMAIL PROTECTED]
Sent: 02 March 2006 10:49
To: CF-Talk
Subject: Re: Stored Procedures and when to use them
An example. I had a set of queries to delete an organisation from one table
and then all the relative data in the database for that organisation. I
wrote
From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED]
Is there any advantage having this type of query in a SP over
calling a simple CFC ??
Mike,
Stored Procedures were a good choice for me when I was working at a place
that had two, top-notch DBAs who could really analyze some of the more
Hi guys,
I am just getting my head around stored procedures in SQL Server. One of
the things I am trying to understand is when I should be using them.
For example, on my clients homepage I wish to pull 2 random product
records...
cfquery name=getRandomProducts datasource=#Request.App.dsn
to add to this question (and secretly bump it to the top of the list), how does
the newID() function work in this case?
mike
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233827
Archives:
Hi guys,
I am just getting my head around stored procedures in SQL Server. One of
the things I am trying to understand is when I should be using them.
I can't stand them myself. Used them in an application just for
*hits'n'giggles, then needed to go back and make a few changes later
Anyone have any experience calling stored procedures with CF? I can get
the procedure to run, but I'm running into snags passing parameters.
Thanks,
Daron Smith
PSEA
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4
Quite right, the Oracle thin driver won't automatically return a query
for each cursor as the CF Enterprise Oracle driver will (afaik).
On 12/9/05, Michael Bramwell [EMAIL PROTECTED] wrote:
[snip]
Now Ive got the procedure working it appears that the jdbc thin driver is
not up to the job when
Michael,
My experience has been that the easiest way to do this is:
cfquery ...
select selRandomQuestionIDs() from dual;
/cfquery
Others will likely suggest cfstoredproc, which I'm told is meant for
just your situation. That said, I still prefer to select from dual
(for no particular
Does that even work for you in sql plus? It compiles with errors for me. I
think you'd need this:
CREATE OR REPLACE PROCEDURE selRandomQuestionIDs AS
BEGIN
SELECT quizQuestionID, RANDOM_ORDER
FROM random_number
WHERE rownum = 20;
END;
Though, to be honest, Im not sure why you're
Not to mention that since there is no declared cursor you are relying
on an implicit cursor but;
1) this looks like it will return more than one row, which is a no-no
with an implicit cursor and
2) there is no INTO clause to store the result, so the procedure won't
run anyway.
Start with a
On 12/8/05, James Holmes [EMAIL PROTECTED] wrote:
Not to mention that since there is no declared cursor you are relying
on an implicit cursor but;
1) this looks like it will return more than one row, which is a no-no
with an implicit cursor and
2) there is no INTO clause to store the result,
I am having troubles getting even basic Oracle sp's to call
from my coldfusion pages.
Heres the procedure:
CREATE OR REPLACE PROCEDURE selRandomQuestionIDs() AS
IS
BEGIN
SELECT quizQuestionID, RANDOM_ORDER
FROM random_number
WHERE rownum = 20
END;
Heres the call:
cfquery
i tried answering this a few hours ago, but HOF seems to have eaten my
mail, so here goes again:
Michael,
1) Your proc is incorrect (that's what the error message is
complaining about). You need to fix a few things:
- don't use both AS and IS in the same declaration (just AS)
-
No I never said that it was bad - I said that it simply won't work if
the query returns more than one row, which it looks like it does.
On 12/8/05, Dave Carabetta [EMAIL PROTECTED] wrote:
Just a side note on your cursor comment, as you seem to suggest that
not using an explicit cursor is
: James Holmes [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, December 09, 2005 7:53 AM
Subject: Re: Calling Oracle Stored Procedures from CF
No I never said that it was bad - I said that it simply won't work if
the query returns more than one row, which it looks like it does
Hi
I am having troubles getting even basic Oracle sp's to call from my coldfusion
pages.
Heres the procedure:
CREATE OR REPLACE PROCEDURE selRandomQuestionIDs() AS
IS
BEGIN
SELECT quizQuestionID, RANDOM_ORDER
FROM random_number
WHERE rownum = 20
END;
Heres the call:
cfquery
I believe I have found where the problem is happening with ColdFusion 7 and
Oracle 10 stored procedures. It appears as if there's an endless loop going
on in the code as per this forum message...
http://www.jnetdirect.com/forum/viewtopic.php?t=156
When I take a snapshot of my JVM, I keep seeing
On 10/5/05, Steve Brownlee [EMAIL PROTECTED] wrote:
I believe I have found where the problem is happening with ColdFusion 7 and
Oracle 10 stored procedures. It appears as if there's an endless loop going
on in the code as per this forum message...
http://www.jnetdirect.com/forum
Currently using 1.0.2
-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 05, 2005 10:10 AM
To: CF-Talk
Subject: Re: CF7 and Oracle stored procedures problem
On 10/5/05, Steve Brownlee [EMAIL PROTECTED] wrote:
I believe I have found where
Can you use a Microsoft SQL Stored Procedure to populate a sub-report (cfr)
either by Embedded Stored Procedure(s) within the report builder or called by
a CFM template? If so, how is this accomplished? We know that you can use a
Microsoft SQL Stored Procedure in a CFM template to populate
Developer
Lone Jet Enterprises
Glendale, Arizona
www.LoneJet.com
-Original Message-
From: Andrew Peterson [mailto:[EMAIL PROTECTED]
Sent: Monday, April 11, 2005 8:26 AM
To: CF-Talk
Subject: Report Builder Subreports and Stored Procedures
Can you use a Microsoft SQL Stored Procedure
Can you use a Microsoft SQL Stored Procedure to populate a sub-report
(cfr) either by Embedded Stored Procedure(s) within the report builder
or called by a CFM template? If so, how is this accomplished? We know
that you can use a Microsoft SQL Stored Procedure in a CFM template to
populate the
Hi,
Is there a way to find out how many recordsets return by a stored procedure?
Or is there a way to merge all the recordsets in a stored procedure so that it
would only return 1 recordset?
I have a stored procedure that would return an unknown number of recordsets
depending on how many
If they have the same set of column names you could do a union of the
results creating a single recordset adding your own custom column to
identify which set of results you are looking at:
SELECT f_name, l_name, 'contact' as myGrouping
FROM contacts
UNION
SELECT f_name, l_name, 'clients' as
And unknown amount..can't you just return empty sets if now records exist
(unless you are using god awful dynamic SQL within the SP!
)
-Original Message-
From: Johnny Le [mailto:[EMAIL PROTECTED]
Sent: 04 April 2005 16:07
To: CF-Talk
Subject: recordsets return by stored procedures?
Hi
, just use the group attribute of cfoutput, or
use QoQ.
HTH,
Alex
-Original Message-
From: Johnny Le [mailto:[EMAIL PROTECTED]
Sent: 04 April 2005 16:07
To: CF-Talk
Subject: recordsets return by stored procedures?
Hi,
Is there a way to find out how many recordsets return by a stored
of my head, but the onTap framework has a tag designed to
execute stored procedures with named parameters (uses a structure,
i.e. the form scope for instance). I know it's designed to allow
multiple result sets, although unfortunately I don't remember offhand
if the automation is driven by the code
Hi,
Here is my stored procedure:
CREATE PROCEDURE dbo.sp_organizations
@parent_id int
AS
DECLARE @Name varchar(500)
DECLARE @Parent int
DECLARE cur_Level CURSOR LOCAL FOR
SELECT Organization_id AS ID, Organization_nm, Parent_organization_id
FROM Organization
WHERE Parent_organization_id =
You may want to check out Joe Celco's nested set model (no refs but google
should find it) for a neat way to handle this type of hierarchical
information storage. In the meantime you could keep the cursor but insert
the resulting recordsets into a working table before returning the complete
Oh hell, that's hideously simple...
CREATE PROCEDURE dbo.sp_organizations
@parent_id int
AS
DECLARE @Name varchar(500)
DECLARE @Parent int
DECLARE cur_Level CURSOR LOCAL FOR
SELECT Organization_id AS ID,
Organization_nm, Parent_organization_id
FROM Organization
WHERE Parent_organization_id =
Adam Howitt wrote:
You may want to check out Joe Celco's nested set model (no refs but google
should find it) for a neat way to handle this type of hierarchical
information storage. In the meantime you could keep the cursor but insert
the resulting recordsets into a working table before
Is there a way to find out how many recordsets return by a
stored procedure? Or is there a way to merge all the
recordsets in a stored procedure so that it would only return
1 recordset?
I have a stored procedure that would return an unknown number
of recordsets depending on how many
limit with multiple concurrent users.
Still doesn't explain why ColdFusion is not automatically releasing the
connections.
We've tried unchecking Maintain Database Connections and have set the
Connection Timeout very low, but neither seems to help as much as not using
Stored Procedures at all
I ran into something today/yesterday which might be the same problem.
When you use cfqueryparam coldfusion will 'pool' the sql statement -
meaning that db connection will stay open with 'a' cursor to that
pooled statement
I specifically was having problem with a max-open-cursors error, but I
Greetings, CF-Talkers.
We've recently been migrating a lot of our SQL code to our Oracle 8.1.7
database in the form of Stored Procedures. We currently run ColdFusion
5. Everything seemed to be going swimmingly.
Yesterday, we began noticing significant performance slowdowns.
Apparently
Dayum, dude...
And I thought *I* was long-winded... cl!
Someone who goes thru keyboards faster than I do! hehe
Heh. I dunno... I've had this little jobber here for several years. I
like it ... I actually got it at a little independant computer shop
around the corner from the place
No, not you, the other Jared!
Wow, how embarrassed must you be right now?!
:OD
-Original Message-
From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED]
Sent: 04 March 2005 03:43
To: CF-Talk
Subject: Re: Stored Procedures in a CFC
Well Ade, thankee...
Preachy doesn't float
1 - 100 of 482 matches
Mail list logo