Thanks to everyone for their replies.
If someone is searching for this in the future the solution seems to be as
follows:
If you have a stored proc that DOES NOT require params in or out of the stored
proc, the string to call looks like this
Mixed Case:
cfset storedProcVar = SCHEMANAME.
Been awhile since I had to use Oracle, but is sysdate a function? Can you try:
datetext := to_char(sysdate(), '-mm-dd');
Hi all,
So I'm very stuck and tired of saying mean things to my computer... so
I hope you are able to see something I'm missing.
In short, in order to trouble
This may not be what you're after, but try replacing
datetext := to_char(sysdate, '-mm-dd');
with
SELECT TO_CHAR(sysdate, '-mm-dd') INTO datetext FROM dual;
Thanks,
Eric Cobb
ECAR Technologies, LLC
http://www.ecartech.com
http://www.cfgears.com
Brent Nicholas wrote:
Hi all,
returncode=yes
What's with the param 1 in front of the call? then another
param 2??
A complete guess from a non-Oracle person, but ... could it be for the return
code?
~|
Order the Adobe Coldfusion Anthology now!
returncode=yes
What's with the param 1 in front of the call? then another
param 2??
A complete guess from a non-Oracle person, but ... could it be for the return
code?
Ok, I've removed returncode and debug and now have the following.
cfstoredproc procedure=#storedProc#
I had incorrect information in my error in the previous two posts.
It should read:
The error: (nemisis)
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00900: invalid SQL statement
The error occurred in D:\somepath\act_updateProgramFund.cfm: line 50
48 :
49 : cfstoredproc
I want to limit the total execution time of a stored procedure being called
from Coldfusion using cfstoredproc to 90 seconds.
With cfquery there is a parameter timeout, but there is no equivalent in
cfstoredproc. Can anyone think of an alternative to
accomplishing this.
The trick is, I
That is very nice Brad. Thanks for that perspective.
First of all, it is my preference to explicitly check for an existing
duplicate value prior to insertion instead of allowing SQL server to
throw the error. The column constraint is my fall-back.
Either way, if you want your stored
Three issues that come to mind:
You've really only listed two issues.
Cannot access transaction errors because a coldfusion exception is thrown so
any validation exceptions must be
handled through cftry/cfcatch instead of the CFSTOREDPROC. If en error occurs
in SQL, it means coldfusion
According to LiveDocs, in MX 6 Changed the dbvarname attribute
behavior: it is now ignored for all drivers. ColdFusion uses JDBC 2.2
and does not support named parameters.
Thanks,
Eric Cobb
http://www.cfgears.com
Dave Watts wrote:
Three issues that come to mind:
You've really only
On Wed, Aug 26, 2009 at 2:14 PM, Tony Bentleyt...@tonybentley.com wrote:
dbvarname is completely useless. It would be nice to be able to send values
across out of order or not send a value if it is not needed (NULL). It would
also be nice to have those values in the debugging to reference.
Sorry, only two issues really.
A real world scenario is when a user tries to insert a value that must be
unique in the database. If a duplicate is found, SQL can return a reference
code and a message stating that there is a duplicate found, an exception is
thrown and an id is passed back -
the value of
@outputMessage to return to the user if you so choose.
~Brad
Original Message
Subject: Re: CFSTOREDPROC kind of sucks
From: Tony Bentley t...@tonybentley.com
Date: Wed, August 26, 2009 3:04 pm
To: cf-talk cf-talk@houseoffusion.com
Sorry, only two issues
A real world scenario is when a user tries to insert a value that must be
unique in the database. If a duplicate
is found, SQL can return a reference code and a message stating that there is
a duplicate found, an exception
is thrown and an id is passed back - RAISERROR @@ERROR.
When
On Wed, Aug 26, 2009 at 4:04 PM, Tony Bentleyt...@tonybentley.com wrote:
When this is thrown, the message states [Macromedia][SQLServer JDBC Driver]
and then the RAISERROR message following. Nice for debugging but not so nice
for passing the message and error code to a handler.
I would
I am calling a SP (SQL Server 2005) using the
CFStoredProc function and to get the result
set returned as nextval. Basically it should
return an interget value.
...
What is it I am missing?
Without seeing the SP code, who can say? My guess is that your SP is
returning an output
It looks like you are missing the DBVAR name.
cfstoredproc datasource=#application.datasource#
procedure=usp_select_nextval
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=DataTrack_Block
dbvarname=insertfieldnamehere
cfprocresult name = nextval
/cfstoredproc
CF Developer wrote:
cfprocresult is for returning a query result set. If you're not
returning query, then you should use:
cfprocparam type=OUT cfsqltype=CF_SQL_INTEGER variable=nextval
CF Developer wrote:
This should have been simple as making a PBJ.
, November 09, 2007 8:24 AM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: CFStoredProc
It looks like you are missing the DBVAR name.
CF Developer wrote:
This should have been simple as making a PBJ.
I am calling a SP (SQL Server 2005) using the CFStoredProc function and to
get the result
cfstoredproc.statuscode
-Original Message-
From: CF Developer [mailto:[EMAIL PROTECTED]
Sent: Friday, November 09, 2007 10:40 AM
To: CF-Talk
Subject: Re: CFStoredProc
The storedProc only returns a single interget value not
a database object or field.
It runs a Query
If you arent returning a result set then you should use a procparam with
type=out.
--
Gary Gilbert
http://www.garyrgilbert.com/blog
~|
ColdFusion is delivering applications solutions at at top companies
around the world in
You are right. I misread your issue. Since you are only wanting an
output variable, you need to change the type to OUT and use the
Variable attribute.
cfprocparam cfsqltype=CF_SQL_INTEGER variable=nextval type=OUT
CF Developer wrote:
The storedProc only returns a single
Hi Eric, thanks for your reply
I did what you said but it is saying that queryResult is undefined
the code i used was
cfstoredproc procedure=addOneToOneChildFolder datasource=portexdb
cfprocparam type=in cfsqltype=cf_sql_varchar value=Hello null=no
cfprocparam type=in
CF returns the value of the OUT variable as a regular variable, just
like you created it with cfset for example.
Try this:
cfstoredproc procedure=addOneToOneChildFolder datasource=portdb
cfprocparam type=in cfsqltype=cf_sql_varchar
value=#url.OneToOneFolder# null=no
cfprocparam type=in
Hi, i have the following code to call a stored procedure
which is stored in mysql.
cfstoredproc procedure=addOneToOneChildFolder datasource=portdb
cfprocparam type=in cfsqltype=cf_sql_varchar
value=#url.OneToOneFolder# null=no
cfprocparam type=in cfsqltype=cf_sql_bigint value=1
Thanks Dave your a superstar!!!
I changed the value to variable and it worked fine :)
Thanks again
~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
-Original Message-
From: Richard Meredith-Hardy
To: CF-Talk
Sent: Wed Feb 28 04:58:19 2007
Subject: RE: Cfstoredproc message
I suppose it's really a mssql question
I suppose it's really a mssql question of trapping the generated message(s)
and putting them in a var which can be returned to CF.
How to do it though?
There may be better alternatives but two possibilities are
- capture the warnings using java/jdbc as Dinner suggested
- create a stored
'xx_log' on file 1.
RESTORE DATABASE successfully processed 10241 pages in 11.732 seconds (7.150
MB/sec).
How do I capture that?
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 27 February 2007 07:45
To: CF-Talk
Subject: Re
If you use java DB stuff, I assume it would be available...
Probably not from the built in CF DB stuff tho. :-/
On 2/27/07, Richard Meredith-Hardy [EMAIL PROTECTED] wrote:
Not quite what I'm looking for, I think.
This is actually a sp which contains a RESTORE DATABASE command and I'm
I suppose it's really a mssql question of trapping the generated message(s)
and putting them in a var which can be returned to CF.
How to do it though?
-Original Message-
From: Dinner [mailto:[EMAIL PROTECTED]
Sent: 28 February 2007 00:38
To: CF-Talk
Subject: Re: Cfstoredproc
Well if it is success or not then you just use the return codes. If you want
a specific user defined message you will have to select it into a var and
return it as an OUT or as a resultset.
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United
Feb 24 22:46:09 2007
Subject: RE: cfstoredproc vs cfquery
Thanks for your input, Dave. My concern is the processing
overhead that is incurred by using CFSTOREDPROC. Do you know
of any way to access multiple recordsets in CFQUERY? As it
stands now, CFQUERY only returns the 1st recordset while
Thanks for your input, Dave. My concern is the processing
overhead that is incurred by using CFSTOREDPROC. Do you know
of any way to access multiple recordsets in CFQUERY? As it
stands now, CFQUERY only returns the 1st recordset while
ignoring the rest. The ability to pull multiple
Thanks for your input, Dave. My concern is the processing overhead that is
incurred by using CFSTOREDPROC. Do you know of any way to access multiple
recordsets in CFQUERY? As it stands now, CFQUERY only returns the 1st recordset
while ignoring the rest. The ability to pull multiple recordsets,
The only one I can think of, but then I don't use SP's very often; IIRC is that
the cfstoredProc tag can handle more complex procedures.
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
-
| 1 | |
- Binary Sudoku
| | |
-
None come to mind that can't be executed via cfquery. What do you mean by
more complex?
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.3/697 - Release Date: 2/22/2007
11:55 AM
PROTECTED]
Sent: Thursday, February 22, 2007 11:31 AM
To: CF-Talk
Subject: RE: cfstoredproc vs cfquery
None come to mind that can't be executed via cfquery. What do you mean
by more complex?
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database
Anyone know if there is an advantage either way when it comes
to calling a stored procedure?
In the example you provided, there's no difference, but stored procedures
can be much more complex than a single SQL statement. Stored procedures can
return multiple recordsets, they can accept and
-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 22, 2007 9:44 AM
To: CF-Talk
Subject: RE: cfstoredproc vs cfquery
Anyone know if there is an advantage either way when it comes
to calling a stored procedure?
In the example you provided, there's no difference, but stored
I've found that they work really well together. I generally develop an app with
cfquery, and change them all to cfstoredproc before I put it into production.
I just want to point out that the topic of this thread is that one can CALL
simple stored procedures with cfquery... tags, so what is the
ok...
question.
i have always used a stored proc to initally grab my data set.
but then use cfquery to re-sort the data as well as page though it..
i am not that quick at dba stuff, but is the way you guys do it?
or do you pass your sort orders paging back to the proc..
thx
website at http://www.reedexpo.com
-Original Message-
From: Ian Skinner
To: CF-Talk
Sent: Thu Feb 22 18:12:12 2007
Subject: RE: cfstoredproc vs cfquery
I've found that they work really well together. I generally develop an app
with cfquery, and change them all to cfstoredproc before I put
-Original Message-
From: Paul Ihrig
To: CF-Talk
Sent: Thu Feb 22 18:34:49 2007
Subject: Re: cfstoredproc vs cfquery
ok...
question.
i have always used a stored proc to initally grab my data set.
but then use cfquery to re-sort the data as well as page though it..
i am not that quick at dba stuff
of Graduate Studies
University of California, Irvine
http://www.rgs.uci.edu/
949.824.6363
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 22, 2007 10:35 AM
To: CF-Talk
Subject: Re: cfstoredproc vs cfquery
ok...
question.
i have always used a stored proc
I recommend you check out this article by Samuel Neff:
Learning Stored Procedure Basics in ColdFusion MX
http://www.adobe.com/devnet/coldfusion/articles/stored_procs.html
Most ColdFusion applications center around a database. The key to
creating efficient and secure ColdFusion applications is
Hi Terry,
Hope this helps I have popped some cf code together and a dummy stored
procedure:
-
!--- *** COLDFUSION CODE: CALL THE STORED PROCEDURE AND PASS IN SOME
DATA***
cfstoredproc procedure=sp_SomeStoredProcedureName
datasource=YourDatabase
cfprocparam value=21
cfstoredproc procedure=NAME OF STORED PROC
datasource=ColdFusion Datasource RETURNCODE=Yes
cfprocparam type=In cfsqltype=VariableType
dbvarname=Input Param Name from SP value=#ColdFusion Var Name# null=No
cfprocparam type=In
Shouldnt the storedproc be...
WHERE studentEmail = @email
-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 19, 2006 9:36 AM
To: CF-Talk
Subject: cfstoredproc
Hi, i am getting a problem when i try to use stored procedures that are
stored in
Does the stored proc work in MySQL (not running it from CF)? I wonder
if the problem might be the cfsqltype. You could try a different type,
to narrow it down some.
-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 19, 2006 7:36 AM
Hi, i am
thanks for the replies, i have tested it in mysql and it executes fine and
displays the results.
if the stored procedure expects a varchar do you have any suggesstions on what
i may try
i am just wondering also why it is saying null pointer, it sounds like its not
detecting the stored
i have also checked the privileges in mysql, i have no idea why this is
happening. Can anyone else using mysql and the stored procedure tag see a
problem with the code or provide advice on what i need to check.
Id really appreciate some help, ive been on this all day with no luck :(
thanks
i have tried a very simple example with getStudentDetails just being select
studentFirstName from students, this stored procedure took no parameters. and
it is still coming out with the error null pointer
it looks like for some reason the cfstoredproc is not finding the stored
procedure in
The quick difference between the Cfquery and cfStoreproc is you can deal
with multiple recordset returned from the stored procedure which was not
possible using cfquery .With CfstoredProc you can deal with the return
values from the stored procedures.
The Only drawback I see using
PROTECTED]
Sent: Friday, October 13, 2006 7:45 AM
To: CF-Talk
Subject: Re: CFStoredProc vs CFQUERY
The quick difference between the Cfquery and cfStoreproc is you can deal
with multiple recordset returned from the stored procedure which was not
possible using cfquery .With CfstoredProc you can deal
, January 19, 2006 10:45 AM
To: CF-Talk
Subject: RE: cfstoredproc and cache
You can put the results into the session/application scope and manage it
yourself or call the stored procedure using cfquery tags and make use of
the cache attributes of the cfquery tag.
Mike
From: Peterson, Andrew S. [mailto
I'm sure there many ways to do this. If there is a query result that I want to
use over and over again, I will put it into a memory variable. Usually
application or session.
Bob
~|
Message:
Not on MX 6.1 natively I do not think - but you could take each resultant
query and put it into the session scope.
-Original Message-
From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED]
Sent: 19 January 2006 16:26
To: CF-Talk
Subject: cfstoredproc and cache
Is there a way to cache
You can put the results into the session/application scope and manage it
yourself or call the stored procedure using cfquery tags and make use of the
cache attributes of the cfquery tag.
Mike
From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED]
Is there a way to cache the results of a stored
Try it without putting the out variable in the procparam - just use the
procresult.
On 9/20/05, Quinn Ng [EMAIL PROTECTED] wrote:
Hi all,
I am trying to call a stored procedure which has 3
input params and 1 out apram which is a refcursor.
I am using CF MX 7
I am getting this error -
On Tuesday 20 September 2005 14:24, Quinn Ng wrote:
CFPROCPARAM type = OUT
CFSQLType = CF_SQL_REFCURSOR
variable = METADATA_CURTYPE
CFPROCRESULT name = metadataResult
/CFSTOREDPROC
One or t'other, not both :-)
--
Tom Chiverton
Advanced
Thanks Deanna and Tom for replying.
I have tried with either OUT or CFprocresult (i.e. not both) and I still get
the same error :-
Error when I remove the OUT PARAM :-
SQL: {call METADATA.get_Metadata( (param 1) , (param 2) , (param 3) )}
CFQueryParam values: (param 1) = [type='IN',
Hm...IIRC, there's an issue with some versions of CF with some Oracle
Drivers. I think it's been talked about before...try doing a search on
houseoffusion.com http://houseoffusion.com and see what you come up with.
On 9/20/05, kugh ng [EMAIL PROTECTED] wrote:
Thanks Deanna and Tom for
I assume that you are talking about just a couple of problem
characters.
Once identified you can do a replace and replace the offending
character with the ascii equivalent. Once you've run the replace they
should go in the database ok. Hope that helps.
j
Yep thanks that worked. It's a workaround though because I replaced the
characters with the #acii equivalent this made the total amount of characters
greater and I had to resize the varchar fields in the database. Also I get
problems now with sorting and had to update also the input search
I assume that you are talking about just a couple of problem characters.
Once identified you can do a replace and replace the offending character with
the ascii equivalent. Once you've run the replace they should go in the
database ok. Hope that helps.
j
Ron Jonk wrote:
When I use cfstoredproc to insert a nvarchar string and use
cf_sql_longvarchar or cf_sql_varchar as cfprocparam i receive a '?' for
every nonlatin character into the SQL stored procedure. Can someone
help me how i can recieve special characters like polonian characters
On Thu, 3 Feb 2005 15:53:11 -0500, Greg Luce [EMAIL PROTECTED] wrote:
I'm cleaning up some old code, can anyone say why this returns records:
cfquery datasource=#SESSION.Datasource# name=Cases
execute SearchCases '#Search#', '#ReferralType#', '#CaseType#', '#NumberType#'
/cfquery
And this
I thought this returned a resultset:
cfprocresult name=Cases resultset=1
Please advise.
On Thu, 3 Feb 2005 16:09:26 -0500, Dave Carabetta [EMAIL PROTECTED] wrote:
On Thu, 3 Feb 2005 15:53:11 -0500, Greg Luce [EMAIL PROTECTED] wrote:
I'm cleaning up some old code, can anyone say why this
From: Greg Luce [mailto:[EMAIL PROTECTED]
CREATE PROCEDURE [SearchCases]
@Search varchar( 20),
@ReferralType varchar(5),
@CaseType int,
@NumberType varchar(4)
You cfprocparam tags use CHAR for the SQL Type. Switch it to VARCHAR.. maybe
your values are getting truncated.
Thanks Mike! That did it.
On Thu, 3 Feb 2005 16:23:18 -0500, Michael T. Tangorre
[EMAIL PROTECTED] wrote:
From: Greg Luce [mailto:[EMAIL PROTECTED]
CREATE PROCEDURE [SearchCases]
@Search varchar( 20),
@ReferralType varchar(5),
@CaseType int,
@NumberType varchar(4)
You
From: Greg Luce [mailto:[EMAIL PROTECTED]
Thanks Mike! That did it.
np.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or
and perform SQL passing...
No big deal, just what we have noticed and what we measure - its been a good
thread so far ;-)
-Original Message-
From: Nathan Strutz [mailto:[EMAIL PROTECTED]
Sent: 22 December 2004 16:59
To: CF-Talk
Subject: Re: CFStoredProc bug?
Robertson-Ravo, Neil (RX
Here is a useful link on Stored Procedures:
http://www.sql-server-performance.com/stored_procedures.asp
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message:
Hmmm, I know I still pass in @varname in dbvarname as it doesn't fail so at
least it is backward supported!!
-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
Sent: 21 December 2004 19:41
To: CF-Talk
Subject: Re: CFStoredProc bug?
The dbvarname attribute
constantly.
HTH
Neil
-Original Message-
From: Nathan Strutz [mailto:[EMAIL PROTECTED]
Sent: 21 December 2004 20:32
To: CF-Talk
Subject: Re: CFStoredProc bug?
Michael Dinowitz wrote:
Thank you for pointing that out. It looks like I missed that. So
basically,
the order
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,
Hmm, I find this hard to swallow and I would question your 'DBA' without
seeing the facts.
Robertson-Ravo, Neil (RX) wrote:
Based on the comments - I ran a quick test with an SP which basically ran
the following (where iLanguageID and iEventID were @ variables passed in via
dbvarname):
How did you call the procedure, with cfquery or with cfstoredproc? Did
you use cfqueryparam's?
You should change your cSearch to @cSearch
-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
Sent: 21 December 2004 17:02
To: CF-Talk
Subject: CFStoredProc bug?
Okay, I just ran across this and I'm not sure if it's something that
has been looked into before but it
It's normal and not buggy.
CFStoredproc passes values in the order that they are declared. I
believe the variable attribute to the cfprocparam tag tells CF what
the variable name will be (for OUT and IN/OUT variables)
Stored procedures can be called by name
sp_proc @two='xyz', @one='abc'
Or
If you mean in the CFPROCPARAM tag, no you should not. @cSearch is not the
variable. @cSearch is the internal holder for the variable being passed in
which is cSearch.
You should change your cSearch to @cSearch
-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
Oh yeahsorry my bad = you only need it with @ if you are using
@dbvarname.
Thanks MD, was a little out on that one ;-)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 21 December 2004 17:23
To: CF-Talk
Subject: RE: CFStoredProc bug?
If you mean
As an aside for info purposes, the variable attribute in cfprocparam is for
info sent from the SP to CF. To bind a passed value to a SP variable, you
use dbvarname.
It's normal and not buggy.
CFStoredproc passes values in the order that they are declared. I
believe the variable attribute to
bad = you only need it with @ if you are using
@dbvarname.
Thanks MD, was a little out on that one ;-)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 21 December 2004 17:23
To: CF-Talk
Subject: RE: CFStoredProc bug?
If you mean in the CFPROCPARAM
Eh? what so you remove it altogether in for dbvarname?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 21 December 2004 17:36
To: CF-Talk
Subject: RE: CFStoredProc bug?
It's one that throws everyone due to a bad example somewhere in the past.
Actually
in for dbvarname?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 21 December 2004 17:36
To: CF-Talk
Subject: RE: CFStoredProc bug?
It's one that throws everyone due to a bad example somewhere in the past.
Actually, the @ should never be used in either variable
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
Yep.
cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=Order_ID
value=#Arguments.Order_ID# null=no
This binds to the Order_ID inside the SP which is defined
(inside) as @Order_ID. The reason for the @ inside is to show
it's a SQL
with CFQUERYPARAMs? Is the CFSTOREDPROC call as efficient?
Better? What's the advantage? Anyone from MM want to comment?
Thanks
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 21, 2004 12:48 PM
To: CF-Talk
Subject: RE: CFStoredProc bug?
From
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
Thank you for pointing that out. It looks like I missed that.
So basically, the order of cfprocparams being passed is all
that matters and no parameter can be missed when writing
cfprocparam tags.
Is there any performance (i.e. binding)
But not at the same time as using CFQUERYPARAM. :(
One major advantage of using the cfquery tag to call the stored
procedure is the fact that you can use the cachediwthin and cachedafter
attributes whereas cfstoredproc does not have them.
Michael T. Tangorre
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
But not at the same time as using CFQUERYPARAM. :(
I thought that if you used cfqueryparam for constants the results were
cache-able.
~|
Special thanks to the CF Community
The dbvarname attribute is no longer used in CFMX: it is now ignored
for all drivers ColdFusion MX does not support named parameters.
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
It was a change in DB drivers that took part in the whole CF 5 to CF MX
(i.e. CF on Java). I dislike it as it makes my code less exact and adds in
more lines that are really not necessary. :(
The dbvarname attribute is no longer used in CFMX: it is now ignored
for all drivers ColdFusion
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
Michael Dinowitz wrote:
Thank you for pointing that out. It looks like I missed that. So basically,
the order of cfprocparams being passed is all that matters and no parameter
can be missed when writing cfprocparam tags.
Is there any performance (i.e. binding) savings to using the
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 are
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,
-Talk
Subject: Re: CFStoredProc bug?
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
1 - 100 of 200 matches
Mail list logo