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?
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
3:06 PM, kbutte...@yahoo.com kbutte...@yahoo.com wrote:
>
> 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
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 for
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
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" wrote:
I don't believe it is supported. I did a quick search on the CFBuilder
7;d vote for it.
On Tue, Jun 1, 2010 at 10:13 AM, Paul Alkema
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 tab
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.
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
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
gt; Subject: RE: stored procedures
>
>
> When you say you "modified" the stored proc and "executed it" do you
> mean you executed an ALTER statement on the proc?
>
> If you re-open the proc and the new parameter shows up, then I'm sure it
> is saved.
>
.
~Brad
Original Message
Subject: stored procedures
From: "Chad Gray"
Date: Wed, November 18, 2009 10:43 am
To: cf-talk
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&qu
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 to my CFStoredProc tag.
I get the error "Procedure or function I_Orders has too many arguments
specified."
Did I not edit the st
e.com
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
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
Any help would be most welcome
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
ed by Reed Exhibitions."
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
(yu
> 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
~|
Cre
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
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
ubject: RE: CFQUERY 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 int
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
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 to
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
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
] [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
D
~|
Create Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs.
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 SQ
gt;
> 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 sometime
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
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 ins
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 n
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,
o
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 ?
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.
r-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 with the dreamweaver
> connection? how did you set up your conne
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 with the
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,
up-t
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
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
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?
&g
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
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 to
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:
HTH
Cheers
Bryan Stevenson B.Comm.
VP & Director of E
If it is pure functions you are talking about, I am sure this will work:
Select some_oracle_user_defined_function(arg) from dual
-Original Message-
From: Shawn McKee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 9:27 AM
To: CF-Talk
Subject: Stored procedures
I have used
, 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 procedur
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 &#x
here's how ya get at a fucntion that is part of a package:
HTH
Cheers
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
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
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]>
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
e-mail
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 but my DBA
> has now written se
What do the functions return?
On 4/25/06, Shawn McKee <[EMAIL PROTECTED]> wrote:
>
> I have used lots of Oracle stored procedures using but my
> DBA
> has now written several functions that I need to use. I have never had
> any
> luck accessing these via and was wo
I have used lots of Oracle stored procedures using but my DBA
has now written several functions that I need to use. I have never had any
luck accessing these via and was wondering if it was a) not
possible or b) there is some clever trick involved. Using MX 6.1 on Linux.
Thanks,
Shawn McKee
> 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 so
: 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 it
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...
>
>password="#R
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
ike 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
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
ECTED]>
wrote:
>
> 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,
>
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 of
>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 m
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: http://www.houseoffusion.c
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...
SELECT TOP 2 products.product_id, products.product_code
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/lin
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 whe
From: "James Holmes" <[EMAIL PROTECTED]>
To: "CF-Talk"
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, w
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 so
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)
>
>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:
>
>
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
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 proced
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, I"m not sure why you're botheri
Michael,
My experience has been that the easiest way to do this is:
select selRandomQuestionIDs() from dual;
Others will likely suggest , which I'm told is meant for
just your situation. That said, I still prefer to select from dual
(for no particular reason).
Andrew
On 12/7/05, Michae
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:
BEGIN selRa
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]>
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:
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 s
, Web 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 Procedu
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 t
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
> 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
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
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 =
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
res
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 = @pa
this information... I don't remember
off the top 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&
processing, 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 b
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
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 myGroup
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 reco
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
supp
connection 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
Stor
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
> I use structures to pass back multiple things from
> functions, but I'm not so
> sure you're right about not using an array. An array maps
> to the
> cfprocresult's resultset attribute(as it could equally to
> it's name attrib)
> but with the array you don't need to know the name used
> only the
1 - 100 of 501 matches
Mail list logo
