that people would always pass all of the parameters to
all of their stored procedures?
Makes me wish I could write my own version of CFStoredProc and have it
override the one MM has in there. What's that called again?
Okay, well I know the easy way to fix it so I'll just work that into
the code
I could write my own version of CFStoredProc and have it
override the one MM has in there. What's that called again?
Okay, well I know the easy way to fix it so I'll just work that into
the code... and double check the order of my procparam's in the rest
of the cfstoredproc's I've gotten
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
Why does this strike me as MM saying It's not a bug, it's a feature!
??? I wonder what convinced MM to do away with that little tidbit...
did they think that people would always pass all of the
parameters to all of their stored procedures?
What is forcing you to pass all of the parameters to your procedures?
I am not following you here... Are you reusing procedures for different
operations in your application whereby one operation might need to deal
with a subset of what the procedure was intended for? Named parameters
in your
the CFSTOREDPROC
tag vs. a CFQUERY with CFQUERYPARAMs? Is the CFSTOREDPROC call as efficient?
Better? What's the advantage? Anyone from MM want to comment?
Thanks
I've seen some strange behavior with cfstoredproc, and our DBA has
requested that we don't use it. If you trace your database (tested on
sql2k
I've seen some strange behavior with cfstoredproc, and our DBA has
requested that we don't use it. If you trace your database (tested on
sql2k), you will see cfstoredproc creates and compiles a procedure,
calls that procedure a number of times (depending on how many recordsets
you
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
It's a preference of mine... I don't like to write three
stored procedures that do the same thing... I want one up_get
procedure that will return either the entire recordset, those
that match a text lookup or a single record based on PK
Michael Dinowitz wrote:
Can I see any stats you have backing this up or the steps you took. I'd like
to test it out more. Thanks
Stats... no.
1) Any data I have is strongly protected by the 'ol company
2) Tests were about a year ago, don't have the data
Steps... Yeah, I think I can help,
me if I'm wrong but we have
1. CFQUERY straight
2. CFQUERY straight with CFQUERYPARAM
3. CFQUERY on a SP
4. CFQUERY on a SP with CFQUERYPARAM
5. CFSTOREDPROC
Any others?
-Original Message-
From: Nathan Strutz [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 21, 2004 4:00 PM
To: CF
straight with CFQUERYPARAM
3. CFQUERY on a SP
4. CFQUERY on a SP with CFQUERYPARAM
5. CFSTOREDPROC
Any others?
None others that I can think of.
I found Steve Nelson's old blog entries on the subject:
http://www.google.com/search?q=site%3Asteve.secretagents.com+cfstoredproc
Parts 1 2 should
with CFQUERYPARAM
5. CFSTOREDPROC
Any others?
None others that I can think of.
I found Steve Nelson's old blog entries on the subject:
http://www.google.com/search?q=site%3Asteve.secretagents.com+cfstoredproc
Parts 1 2 should be the first 2 links.
-nathan strutz
http://www.dopefly.com
Stephen Moretti (cfmaster) wrote:
Oh! Meant to say.
You should still be able to access that :B1 column inside a
cfloop/cfoutput, like this : searchResults[:B1]
Stephen
Thanks.
To give you some background I don't have any control over the SP. I'm using the
user credentials that gives
I'm using the following stored procedure and using cfdump to see the output.
This is the stored procedure:-
cfstoredproc procedure=mysp
dataSource=mydsn
username=myusername
password=mypassword
cfprocparam value=#Form.username# cfsqltype=CF_SQL_INTEGER type=In
cfprocparam value
queryName.columnList ?
-Adam
On Tue, 30 Nov 2004 11:18:03 -0400, Ian Littlefair
[EMAIL PROTECTED] wrote:
I'm using the following stored procedure and using cfdump to see the output.
This is the stored procedure:-
cfstoredproc procedure=mysp
dataSource=mydsn
username=myusername
password
queryName.columnList ?
-Adam
On Tue, 30 Nov 2004 11:18:03 -0400, Ian Littlefair
[EMAIL PROTECTED] wrote:
~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com
Message:
Thanks Adam. Could you be a bit more specific please?
Ian
~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185683
Archives:
Ian Littlefair wrote:
Thanks Adam. Could you be a bit more specific please?
If you output searchResults.columnlist after you've called your stored
procedure it should give you the list of columns returned.
However, from your cfdump I would hazard that the column names will be
:B1 and
Stephen Moretti (cfmaster) wrote:
Ian Littlefair wrote:
Thanks Adam. Could you be a bit more specific please?
If you output searchResults.columnlist after you've called your stored
procedure it should give you the list of columns returned.
However, from your cfdump I would hazard
- Original Message -
From: Robertson-Ravo, Neil (RX)
To: CF-Talk
Sent: Thursday, September 30, 2004 1:01 AM
Subject: RE: CFStoredProc vs CFQuery
Yeah if you must cache, then use CFQUERY but you can also just duplicate
the
results into a new query object and cache that.
_
From: Dave Watts
Yeah if you must cache, then use CFQUERY but you can also just duplicate the
results into a new query object and cache that.
_
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: 29 September 2004 20:35
To: CF-Talk
Subject: RE: CFStoredProc vs CFQuery
Are there any benefits to calling stored
Are there any benefits to calling stored procedures using CFStoredProc vs.
CFQuery? All the stored procs return a single record set.
The limitation I am running in to is how to cache the results of a query
that is created calling CFStoredProc.
TIA,
Duane
[Todays Threads]
[This Message
The major benefit of using cfquery to call is that you can cache the
results. There are no cachedwithin or cachedafter attributes in
cfstoredproc (which I think MM should address!!!). The only way to cache
the results is to put them into a shared scope or use QoQ... Which is a
waste.. Just use
What are the disadvantages of putting them into a shared scope?
-Adam
- Original Message -
From: Tangorre, Michael [EMAIL PROTECTED]
Date: Wed, 29 Sep 2004 15:07:34 -0400
Subject: RE: CFStoredProc vs CFQuery
To: CF-Talk [EMAIL PROTECTED]
The major benefit of using cfquery to call
Are there any benefits to calling stored procedures using
CFStoredProc vs. CFQuery? All the stored procs return a
single record set.
The limitation I am running in to is how to cache the results
of a query that is created calling CFStoredProc.
In this case, I'd recommend using CFQUERY
I think the best part of CFSTOREDPROC is the ability to return multiple
recordsets.You could run a stored procedure that runs 4 queries and
keep track of them separately.
Joe
_
From: Duane Boudreau [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 29, 2004 2:59 PM
To: CF-Talk
Subject
The larger problem is that I can't get Access DSNs to verify in the CFMX Administrator.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
I can't get cfstoredproc to work with Access on my development machine. It
works fine with SQL, but I need to use Access for this job.
I suspect it might have something to do with the DSN. The driver labeled
Microsoft Access won't verify in the CFMX administrator. I have been
using Microsoft
I suspect it might have something to do with the DSN.
You suspect right: Access does not support stored procedures.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL
You suspect right: Access does not support stored procedures.
While that's correct, Access does have parameter queries, which can be
invoked by the CFSTOREDPROC tag as if they're stored procedures.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
Hi all...This is my first time using a stored procedure.I am getting this error
[Macromedia][Oracle JDBC Driver]Incorrect parameter bindings for stored procedure call. Check your bindings against the stored procedure's parameters.
Here is my code
cfstoredproc procedure
Dave,
Just wondering if you were able to find that white paper.If so, I can
post my email address.Our software architect wants to wrap CFSTOREDPROC
with a CFX and use a JDBC driver that supports named parameters.
Thanks..
I am working on a migration from CF5 to MX.I was working on
determining
CFSTOREDPROC with a CFX?Other ideas?There are different camps in our office and I am wondering what other people on the list did?
Thanks.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
?Replacing
CFSTOREDPROC with a CFX?Other ideas?There are different
camps in our office and I am wondering what other people on
the list did?
We never used named parameters, so it was never a problem. However, at our
users group, someone gave a very interesting presentation on how they wrote
On Thursday 12 February 2004 09:45 am, Thomas Chiverton wrote:
I know I should be able to work this out, but it's wall butting time.
Note to self: Using log4Plsql will swallow any exception that occurs in your
stored procedure code :-(
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel:
On Thursday 12 February 2004 17:50 pm, Plunkett, Matt wrote:
What version of CF are you using?
MX6.1 via Weblogic.
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel:
On Thursday 12 February 2004 20:16 pm, Plunkett, Matt wrote:
Unless it changed from 6.1 to 6.0, you do not have to have a cfprocparam
for the ref cursor as someone else suggested.
Didn't think so - there is a technote about that change in 6.1.
We put our Oracle stored procedures in this
-Original Message-
From: Thomas Chiverton
Sent: Friday, February 13, 2004 4:30 AM
To: CF-Talk
Subject: Re: the oracle, the stored procedure and the cfstoredproc
We put our Oracle stored procedures in this format:
It seems very similar to yours, so not sure if that is any help
On Friday 13 February 2004 15:19 pm, Plunkett, Matt wrote:
IS
possible though, we use Oracle stored procs extensively from CF MX and 5.0.
That return ref cursor-type result sets ?
If so, could you just c+p one so I can check neither of us is going mad...
--
Tom Chiverton
Advanced ColdFusion
If so, could you just c+p one so I can check neither of us is going mad...
Including the Oracle spec for the procedure ?
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
-Original Message-
From: Thomas Chiverton
Sent: Friday, February 13, 2004 10:24 AM
To: CF-Talk
Subject: Re: the oracle, the stored procedure and the cfstoredproc
On Friday 13 February 2004 15:19 pm, Plunkett, Matt wrote:
IS
possible though, we use Oracle stored procs extensively
);
and I'm having no luck getting the result set back.
I though, based on the docs and a recent Macromedia.com article, that
cfstoredproc dataSource=#request.dsn#
procedure=bf_report.client_facade_pkg.get_available_reports
cfprocparam dbVarName=user_name_in value=#iUserId#
cfsqltype=CF_SQL_VARCHAR
On Thursday 12 February 2004 09:45 am, Thomas Chiverton wrote:
Anyone fancy pointing out the early morning obvious ?
And it all works if I log in directly as the CF user and do:
declare
type ref_curr is REF CURSOR;
ret_curr ref_curr;
begin
bf_report.client_facade_pkg.get_available_reports
so it must be CF screwing up somewhere - argh !
And if I use the CF ORacle drivers (rather than a WebLogic JDBC pool), and the
code which should work according to the docs:
cfstoredproc dataSource=#request.dsn#
procedure=bf_report.client_facade_pkg.get_available_reports debug=Yes
cfprocparam
have you checked to see if procparam are in same order they are in stored
procedure.
MM JDBC driver does not support named parameters only positional, meaning
the order you set them in cfstoredproc must be same as order in Oracle Proc.
:(
-Kevin Marino
--
Webmaster
On Thursday 12 February 2004 17:20 pm, Kevin Marino wrote:
have you checked to see if procparam are in same order they are in stored
procedure.
Yup.
I posted the spec of the procedure earlier.
I got a message about profanty or some such nonsense too, but my post also
showed up - are you
What version of CF are you using?
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 12, 2004 4:46 AM
To: CF-Talk
Subject: the oracle, the stored procedure and the cfstoredproc
I know I should be able to work this out, but it's wall butting
/12/04 09:11AM
so it must be CF screwing up somewhere - argh !
And if I use the CF ORacle drivers (rather than a WebLogic JDBC pool), and the
code which should work according to the docs:
cfstoredproc dataSource=#request.dsn#
procedure=bf_report.client_facade_pkg.get_available_reports debug=Yes
.
**
-Original Message-
From: Plunkett, Matt [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 12, 2004 12:50 PM
To: CF-Talk
Subject: RE: the oracle, the stored procedure and the cfstoredproc
What version of CF are you using?
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL
Unless it changed from 6.1 to 6.0, you do not have to have a cfprocparam for
the ref cursor as someone else suggested.
We put our Oracle stored procedures in this format:
cfstoredproc procedure=bf_report.client_facade_pkg.get_available_reports
datasource=#request.dsn#
returncode
Hi All,
I'm actually rather excited. I just posted another entry to my blog
about a breakthrough I've just had with the cfstoredproc tag. In the
past, the fact that the dbvarname attribute of the cfprocparam tag is
ignored by the ColdFusion Server has really frustrated me at times. I
believe I've
)
IF @@ERROR 0
BEGIN
PRINT 'ERROR: Duplicate entry.'
RETURN -2
END
ELSE
BEGIN
PRINT 'Success.'
RETURN 0
END
Then, I'm calling it via the following CFML in a UDF (the fact that this is
in a UDF shouldn't matter, just thought I'd mention it):
cfstoredproc procedure=quiz_results_insert datasource
-Talk
Subject: cfstoredproc, status codes, trapping errors
I've searched around on google but have come up empty.I'm running SQL
Server 2K and CFMX 6.1.I have a stored procedure that handles database
inserts.It looks something like this (trimmed):
INSERT INTO quiz_results (user_id, question_id
This is a bizzare one.I have a stored procedure that updates a status field as soon as it is called and when called through SQLPlus works just fine.When I call it from ColdFusion I get neither an error message nor any indication the procedure runs.Any ideas?
Here is the code:
cfstoredproc
or recordset and dump it.
-Original Message-
From: Sam Farmer [mailto:[EMAIL PROTECTED]
Sent: 04 December 2003 14:56
To: CF-Talk
Subject: cfstoredproc yields no response
This is a bizzare one.I have a stored procedure that updates a status
field as soon as it is called and when called
:
cfstoredproc datasource=#Request.DSN_InSite# procedure=Get_Claims
returncode=Yes
cfprocresult name=Get_Claims
cfprocparam cfsqltype=CF_SQL_INTEGER dbvarname=@active null=No
type=In value=#active#
cfprocparam cfsqltype=CF_SQL_INTEGER dbvarname=@litigated null=No
type=In value=#litigated#
cfprocparam
Ok... This is kind of odd...
I have a CFSTOREDPROC that works fine with IE but when we try to call it
with Netscape 7.X it crashed...Has anyone else had this sort of
problem?? Anyone have any ideas as to how to fix this?
Thanks
Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd
have you/can you verify the data that is getting passed to the cfstoredproc.
browser shouldn't matter
apart from the data getting to the cfstored proc.form driven data? url
driven data?
id look there.
cf is server side, so it shouldn't matter
...tony
tony weeg
senior web applications
I have outputted the variables on the page so I can see them it is
the weirdest thing works fine in IE but not NS
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 9:39 AM
To: CF-Talk
Subject: RE: Netscape 7.x and CFSTOREDPROC
:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 9:42 AM
To: CF-Talk
Subject: RE: Netscape 7.x and CFSTOREDPROC
I have outputted the variables on the page so I can see them it is the
weirdest thing works fine in IE but not NS
-Original Message-
From: Tony Weeg [mailto:[EMAIL
I ficed it... had NO-CACHE on the action page... seems to have corrected
thr problems by removing it
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 9:47 AM
To: CF-Talk
Subject: RE: Netscape 7.x and CFSTOREDPROC
that's odd...i cant
Kris Pilles said:
I have outputted the variables on the page so I can see them it
is the weirdest thing works fine in IE but not NS
Does it work from telnet?
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
I tend to use stored procs even for select queries (especially ones
involving views, and many tables) and always use cfstoredproc over calling
the procedures using cfquery. The downside is that there is no direct way to
cache the result set(s). So... Yesterday I started working on a CFC to load
: Wednesday, October 15, 2003 9:21 AM
To: CF-Talk
I tend to use stored procs even for select queries (especially ones
involving views, and many tables) and always use cfstoredproc over
calling
the procedures using cfquery. The downside is that there is no direct
way to
cache the result set(s). So
Yes I have thought about it and it is not a bad idea by any means. However,
on code that makes use of the cfstoredproc tag, I was looking for a good way
to allow these to also get cached without having to go back into all the
code and switch the call from cfstoredproc to cfquery. Perhaps MM can
I do understand your need for this functionality especially if you have
to re-write a bunch of cfstoredproc to cfquery. Not fun. Someone else
here might weigh in with a different way to tackle this as well.
_
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003
Does anyone have a program that will generate cfstoredproc
statements for SQL Server stored procedures laying around? I had
one...and I even built one in the past but, I don't have mine here,
and the one from the (oh so reliable) dev exchange is not available
anymore apparently.
I have like 30
any attributes kind of
things when we use cfstoreproc in cfmx.
Really appreciated for your suggestions also..
=
cfstoredproc procedure=pkg_security.sp_check_security
datasource
we use cfstoreproc in cfmx.
Really I would appreciate even if you give your suggestions..
=
cfstoredproc procedure=pkg_security.sp_check_security
datasource=#defaults.dsn
use cfstoreproc in cfmx.
Really appreciated for your suggestions also..
=
cfstoredproc procedure=pkg_security.sp_check_security
datasource=#defaults.dsn
any attributes kind of
things when we use cfstoreproc in cfmx.
Really appreciated for your suggestions also..
=
cfstoredproc procedure=pkg_security.sp_check_security
datasource
we use cfstoreproc in cfmx.
Really I would appreciate even if you give your suggestions..
=
cfstoredproc procedure=pkg_security.sp_check_security
datasource=#defaults.dsn
the problem.
Ade
-Original Message-
From: Greg McDaniel
To: CF-Talk
Sent: 6/13/03 10:50 PM
Subject: How to call CFSTOREDPROC without parms
I have a simple stored procedure in Oracle that takes no parms and
returns no data.
I can run this proc in sqlplus, works great.
Run this from Coldfusion
I have a simple stored procedure in Oracle that takes no parms and
returns no data.
I can run this proc in sqlplus, works great.
Run this from Coldfusion
cfstoredproc name=cleanup datasource=#dsn#/cfstoredproc
returns:
ORA-06550: line 1, column 18: PLS-00222: no function with name 'CLEANUP
-
From: James Blaha [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 10:37 AM
To: CF-Talk
Subject: Re: Help SQL Sever CFSTOREDPROC Issue.
Thanks, for the reply. Unfortunately it didn't work.
Regards,
JB
admin wrote:
try running the cf service logged in as an admin account rather
CFSTOREDPROC Issue.
James,
Thanks for the reply. I do have the User Name and pass word in the CF
admin. And that account has dbo rights to the database. I think my issue
has to do with permission going to the UNC path. I still have a few more
things to try out.
Regards,
JB
James Ang wrote:
Check
Enterprise Manager. If I
try to execute the CFSTOREDPROC from my CF server that goes to the UNC
path a get an error from the SQL server. All permissions have been set
to gives the 3 machines rights for read and write access.
Any Ideas?
Regards,
James Blaha
These are the stored procs.
http
try running the cf service logged in as an admin account rather than local
system account
- Original Message -
From: James Blaha [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 9:53 AM
Subject: Help SQL Sever CFSTOREDPROC Issue.
Hello All:
I need some
9:53 AM
Subject: Help SQL Sever CFSTOREDPROC Issue.
Hello All:
I need some help please!
Im using a couple of neat stored procedures to call a DTS package and
write the output to a UNC path. My issue is that it only works when I
output to my local SQL server hard drive or output to the UNC
]
-Original Message-
From: James Blaha [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 10:37 AM
To: CF-Talk
Subject: Re: Help SQL Sever CFSTOREDPROC Issue.
Thanks, for the reply. Unfortunately it didn't work.
Regards,
JB
admin wrote:
try running the cf service logged
Has anyone got a script for generating the cf code CFSTOREDPROC etc...
from SQL Stored Procs ?
CF/Perl/Java whatever..
Thanks WG
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http
is there one?!
-Original Message-
From: Justin MacCarthy [mailto:[EMAIL PROTECTED]
Sent: 19 March 2003 10:41
To: CF-Talk
Subject: generating cfstoredproc from a stored Procs
Has anyone got a script for generating the cf code CFSTOREDPROC etc...
from SQL Stored Procs ?
CF/Perl/Java
Hey Folks,
First, the on-topic question. When using cfstoredproc is there an easy
way to return a recordcount like that which is returned by cfquery?
Now for the SOT question... Sorry for this question, but I have searched
high and low for this info and am now at my wits end so I am posting
: cfstoredproc questions SOT
Hey Folks,
First, the on-topic question. When using cfstoredproc is there an easy
way to return a recordcount like that which is returned by cfquery?
Now for the SOT question... Sorry for this question, but I have searched
high and low for this info and am now
Hmmm... didn't realize that you could do that in admin. Obviously haven't been
spending enough time in there lately... I agree that it makes sense. I was
disabling rights in SQL Server, not in CF admin. However, that confuses me. Then what
is the point of doing so? I assumed that this was
Hello All:
For all those out there using CFSTOREDPROC what do you do while youre
generating an output for your user's while its generating? Is there a
best practice to follow?
Regards,
James Blaha
~|
Archives: http
Hello All:
CFSTOREDPROC ?
Im on an adventure with my SQL 7.0 server and I have a question. What
Im attempting to do is run a CFSTOREDPROC that generates a large CSV
file from an executed DTS package and then output that file to a network
share which the DTS will take care of. Next Im going
-
From: James Blaha [EMAIL PROTECTED]
Date: Thursday, March 13, 2003 1:26 pm
Subject: CFSTOREDPROC ?
Hello All:
CFSTOREDPROC ?
Im on an adventure with my SQL 7.0 server and I have a question.
What
Im attempting to do is run a CFSTOREDPROC that generates a
large CSV
file from
] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 4:04 PM
To: CF-Talk
Subject: Re: CFSTOREDPROC ?
2) It is recommended that you always use cflock with
cffile. You would do an exclusive lock for
writing/deleting/copying. You would do a readonly lock for reading.
I'm not sure about CFMX
, 2003 4:04 PM
To: CF-Talk
Subject: Re: CFSTOREDPROC ?
2) It is recommended that you always use cflock with
cffile. You would do an exclusive lock for
writing/deleting/copying. You would do a readonly lock for reading.
I'm not sure about CFMX though. I'm fairly certain that the
java.io classes
Hi,
How do we pass the result set of a cfstoredproc call to a cfc?
TIA,
Ro
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method
Pass it like any other parameter, the resultset from a stored proc is
still a query datatype.
--
jon
mailto:[EMAIL PROTECTED]
Tuesday, March 11, 2003, 1:50:03 PM, you wrote:
RS Hi,
RS How do we pass the result set of a cfstoredproc call to a cfc?
RS TIA,
RS Ro
Ok, gang,
The following stored proc call works beautifully:
cfstoredproc procedure=test datasource=#ds#
cfprocresult name=getAdID
/cfstoredproc
It inserts a record into our test table and returns the ADID (INTEGER, autonumber) and
DESC (CHAR, defaults to TEST) fields.
Then I try to pass
I've found that cfcprocresult should be last. (Oracle 8i/9i). Try that.
-Original Message-
From: Nuovo [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 3:13 PM
To: CF-Talk
Subject: CFStoredProc
Ok, gang,
The following stored proc call works beautifully
Thanks, but that didn't work. We're using DB2, Solaris 8, and Apache 2.13.
- Original Message -
From: Everett,Al [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, February 11, 2003 2:17 PM
Subject: RE: CFStoredProc
I've found that cfcprocresult should be last. (Oracle 8i
could it be because 'DESC' is a reserved term?
-- Ben Doom
Programmer General Lackey
Moonbow Software, Inc
: -Original Message-
: From: Ryan [mailto:[EMAIL PROTECTED]]
: Sent: Tuesday, February 11, 2003 3:26 PM
: To: CF-Talk
: Subject: Re: CFStoredProc
:
:
: Thanks
, February 11, 2003 2:47 PM
Subject: RE: CFStoredProc
could it be because 'DESC' is a reserved term?
-- Ben Doom
Programmer General Lackey
Moonbow Software, Inc
: -Original Message-
: From: Ryan [mailto:[EMAIL PROTECTED]]
: Sent: Tuesday, February 11, 2003 3:26 PM
: To: CF
I'm running CF5 on Win2k IIS5 with mssql2000 and getting
unknown exception condition
PCodeRuntimeContextImp::executeSQLTagCFStoredProc::endTag
The error occurred while processing an element with a general identifier of
(CFSTOREDPROC), occupying document position (40:1) to (41:64
Looks fine to me...
I'd try double-checking the data types and paraeters as well...
-Original Message-
From: S.Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 13, 2003 10:23 PM
To: CF-Talk
Subject: unknown exception condition within cfstoredproc - win2k iis5 cf5
: 770-446-8866
Team Macromedia Volunteer for ColdFusion
http://www.macromedia.com/support/forums/team_macromedia/
- Original Message -
From: jon hall [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, December 26, 2002 4:39 PM
Subject: Re: cfstoredproc code generator
Thanks
Does a free one of these exist? I faintly remember the topic coming
up in the past, but my searches are coming up empty.
I did find this one for $99.
http://www.netwebapps.com/Products/speedDB/introduction.cfm
--
jon
mailto:[EMAIL PROTECTED]
201 - 300 of 424 matches
Mail list logo
