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:
Non Mixed Case:
If you have a stor
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,
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 trou
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 :
50 :
51 :
52 :
SQL {call
>> 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.
Returns:
SQL {call P3DEVELOP
> 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
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 shoot a larger stored proc call, I've created a
very simple one to get working first. It just returns a value.
Platforms: Oracle11g /
> I want to limit the total execution time of a stored procedure being called
> from Coldfusion using 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.
>
>
Hi,
I want to limit the total execution time of a stored procedure being called
from Coldfusion using 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 want to
t;BEGIN
>
> IF badCondition is true
> BEGIN
> SET @outputMessage = 'Here is a detailed and useful error
> message'
> RETURN 75 -- Your special "code" for this error
> END
>
>-- otherwise...
>
>
>
On Wed, Aug 26, 2009 at 4:04 PM, Tony Bentley 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 really like t
> 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.
>
> W
r
message'
RETURN 75 -- Your special "code" for this error
END
-- otherwise...
SET @outputMessage = 'Execution Successful'
RETURN 0
END
The cfstoredproc tag give you the return code, and you can then check it
for whatever proble
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 - RAI
On Wed, Aug 26, 2009 at 2:14 PM, Tony Bentley 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.
You can send a n
gt; 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
> 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
&
Three issues that come to mind:
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 throws an error
too.
dbvarname is
Try to reproduce the problem using only one database column and a
three line database query. It is easier to troubleshoot three lines of
SQL than 100 lines of SQL.
-Mike Chabot
On Sun, Jan 11, 2009 at 6:45 PM, Mauro Luna wrote:
> Hi everybody, I have a problem with cfstoredproc and Infor
Hi everybody, I have a problem with cfstoredproc and Informix database, when I
invoke a stored procedure by cfstoredproc, it returns me several columns with
the same name (EXPRESSION) and repeat the value of first column.
I am running CFMX 8.0.1 Enterprise, with Informix 9.40 and built-in
cfprocparam's biggest
> benefit, protecting against injection.
>
> Adrian
>
> -Original Message-
> From: Aaron Rouse
> Sent: 30 October 2008 19:52
> To: cf-talk
> Subject: Re: cfqueryparam vs cfstoredproc?
>
>
> I do you feel it would defeat the point?
>
cf-talk
Subject: Re: cfqueryparam vs cfstoredproc?
I do you feel it would defeat the point?
On Thu, Oct 30, 2008 at 2:19 PM, Adrian Lynch
<[EMAIL PROTECTED]>wrote:
> Exactly, which kinda defeats the point I feel.
>
> I've got a few ways that I might try but for now I'm back to wri
gt;
>> Adrian
>> Building a database of ColdFusion errors at http://cferror.org/
>>
>> -Original Message-
>> From: [EMAIL PROTECTED]
>> Sent: 30 October 2008 18:28
>> To: cf-talk
>> Subject: RE: cfqueryparam vs cfstoredproc?
>>
>>
&
interested, I have the full DAO code here:
>
> http://adrianlynch.co.uk/post.cfm?postID=21
>
> Adrian
> Building a database of ColdFusion errors at http://cferror.org/
>
> -Original Message-
> From: [EMAIL PROTECTED]
> Sent: 30 October 2008 18:28
> To: cf-t
p://cferror.org/
-Original Message-
From: [EMAIL PROTECTED]
Sent: 30 October 2008 18:28
To: cf-talk
Subject: RE: cfqueryparam vs cfstoredproc?
exec()
or sp_executesql
You would need to pass in the arguments as a list to the procedure and
then do the looping and building of a dynamic query
ional steps to paramaterize it. (requires
sp_executesql)
FYI: My advice assumes MS SQL.
~Brad
Original Message
Subject: RE: cfqueryparam vs cfstoredproc?
From: "Adrian Lynch" <[EMAIL PROTECTED]>
Date: Thu, October 30, 2008 1:06 pm
To: cf-talk
cfqueryparam vs cfstoredproc?
My 2 cents
I use ORACLE stored procs exclusively (using a CFSTOREDPROC tag) and have
found them to be great. There are things I can do in stored procs that
would be difficult to do in a CFC. I can easily have multiple datasets
returned in one call. And the CFPROCPAR
My 2 cents
I use ORACLE stored procs exclusively (using a CFSTOREDPROC tag) and have
found them to be great. There are things I can do in stored procs that
would be difficult to do in a CFC. I can easily have multiple datasets
returned in one call. And the CFPROCPARAM gives me the same
30, 2008 11:28 AM
To: cf-talk
Subject: Re: cfqueryparam vs cfstoredproc?
Interesting...
I thought the same thing until I ran these tests. I analyzed the results
with ColdFusion debugging output, the Server Monitor in CF8 Ent, SeeFusion,
and watched them execute through SQL Profiler, all of the
Interesting, indeed. Wonder if there's an issue of table scan vs index and how
the initial execution plans are getting cached. Definitely something to keep
your eye on!
>Interesting...
>I thought the same thing until I ran these tests. I analyzed the results
>with ColdFusion debugging output
Interesting...
I thought the same thing until I ran these tests. I analyzed the results
with ColdFusion debugging output, the Server Monitor in CF8 Ent, SeeFusion,
and watched them execute through SQL Profiler, all of them showed better
execution times when I removed the CFQUERYPARAMs. Now, this wa
Alan,
SQL Server will create an execution plan for each query that gets run, where
the plan is specific to the final Query definition. From SQL Server's
perspective, these are 2 different queries, so each gets its own plan:
Query with both names:
>SELECT ID, FName, LName, Email
>FROM SomeTable
Let's hope you don't ever need to handle more than one result set. :)
Also, that requires you get the return code manually as well.
~Brad
Original Message
Subject: Re: cfqueryparam vs cfstoredproc?
From: "morgan l" <[EMAIL PROTECTED]>
We ca
Original Message
Subject: cfqueryparam vs cfstoredproc?
From: "Marie Taylore" <[EMAIL PROTECTED]>
> I realize with stored procedures you have a lot more power in terms of SQL
> scripting,
This is not really true. You can put anything you want in a cfqu
Marie,
In my experience with SQL Server there is zero notable performance difference
between well-formed SQL in a stored proc and the same well-formed SQL in a
CFQUERY with CFQUERYPARAM: both gain from the built-in performance tuning of
the data server. Also, note that you can run nearly any c
The only issue I have run into with CFQUERYPARAM is that is can degrade
performance on dynamic queries.
This is an inherent issue in what CFQUERYPARAM does, it essentially makes
your queries into stored procs, if you actually watch the traffic flow
through a MS SQL Server for example, you will see
cedures also solves. I
> realize with stored procedures you have a lot more power in terms of SQL
> scripting, but for basic queries, is CFQUERYPARAM just as fast as (or
> faster
> than) running CFSTOREDPROC?
>
> For a CFSTOREDPROC vs CFQUERYPARAM "debate" what would be th
: cfqueryparam vs cfstoredproc?
Question... the more I read about CFQUERYPARAM the more it seems it
mitigates many of the problems that using stored procedures also solves. I
realize with stored procedures you have a lot more power in terms of SQL
scripting, but for basic queries, is CFQUERYPARAM just as fast
) running CFSTOREDPROC?
For a CFSTOREDPROC vs CFQUERYPARAM "debate" what would be the "better thans"
on each side of the argument?
A few I can think of off the top of my head would be:
Stored Procedures - can contain advanced SQL & procedural code. Encapsulate
code outsid
I was having the same issue. I was getting a clob back and then couldn't
figure out out to get the content to display. One of our Java guys helped
me figure this out. So what I learned is that a CLOB is an object and
there are a lot of attributes to it, including the actual character values
whi
>> Actually, I'm gonna pick on you again Dave and challenge
>> this. (I'm hoping to add to my wall)
>>
>> If a someone is using MySQL ...
>
> Well, the original poster was asking about the current attack, which
> specifically targets MS SQL Server.
>
That might be true, but he didn't say that. He
Excellent points! Thanks Dave, and everyone who took the time to reply to /
read this thread.
Moral lessons learned:
1) Don't go crazy with tightening security around SQL statements. Only
secure the vulnerable;
2) Whenever possible, think of using native CF functions to simplify code.
:-)
BTW,
> Do you mind if I blog about that part where you said "Yeah,
> your right about that " That's got to be good for my
> cf_streetCred (ha).
I don't mind, no.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruct
> Actually, I'm gonna pick on you again Dave and challenge
> this. (I'm hoping to add to my wall)
>
> If a someone is using MySQL ...
Well, the original poster was asking about the current attack, which
specifically targets MS SQL Server.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.co
> As Mark pointed out, if you did have numeric inputs in your CFQUERY tag,
> those would still be vulnerable. If not, though, the rest of my statement
> still stands.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
Actually, I'm gonna pick on you again Dave and challenge this. (I
Sent: Tuesday, July 22, 2008 8:58 PM
Subject: RE: cfquery and cfstoredproc
> Dave,
>
> Do you mind if I blog about that part where you said "Yeah, your right
> about
> that " That's got to be good for my cf_streetCred (ha).
>
> -mk
>
RE: cfquery and cfstoredproc
> I never disagree with you (usually a fools errand)
Ha! I wish.
> but I want a clarification. I think you might mean that this
> particular use is safe because CF will escape the single quotes.
> But the code below is vulnerable in exactly the same as
> > So I'm hearing that it should be fine??
> >
> > Somehow their database columns values were appended the following
> > string
> > : ">http://1.verynx.cn/w.js";> >
> > What else could have caused this? Like you said the parameters are in
> > single quotes and the data type is varchar so it
> > Say you had a proc that looked like this:
> >
> > CREATE PROC sps_testproc
> > @AID int = null,
> > @BID int = null
> > as
> > IF @AID is not null
> > SELECT @AID
> > IF @AID is not NULL
> > SELECT @BID
> >
> > If I was using CFQUERY, unprotected-style, I might write t
> I never disagree with you (usually a fools errand)
Ha! I wish.
> but I want a clarification. I think you might mean that this
> particular use is safe because CF will escape the single quotes.
> But the code below is vulnerable in exactly the same as a CFQUERY.
>
> As a test I created an SP
o:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2008 6:07 PM
To: CF-Talk
Subject: RE: cfquery and cfstoredproc
> What about a semi-colon?
>
> Storedproc '#var1#','#var2#' ; *other code*
>
> Would the CFQUERY not allow this additional code to run?
It woul
o you do that with CFStoredProc?
>
> If I understand correctly, if you want to protect calls to
> stored procs (from SQL injection and the like), you have to
> use cfstoredproc and cfprocparam instead of cfquery and
> cfqueryparam. But apparently, you can't indicate what
>
> So I'm hearing that it should be fine??
>
> Somehow their database columns values were appended the
> following string
> : ">http://1.verynx.cn/w.js";>
> What else could have caused this? Like you said the
> parameters are in single quotes and the data type is varchar
> so it must have a
So I'm hearing that it should be fine??
Somehow their database columns values were appended the following string
: ">http://1.verynx.cn/w.js";>
> What about a semi-colon?
>
> Storedproc '#var1#','#var2#' ; *other code*
>
> Would the CFQUERY not allow this additional code to run?
It wouldn't allow any of the values after the stored procedure call
"storedproc" to run as code, because they would be placed in the input
parameters of the s
---
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2008 5:50 PM
To: CF-Talk
Subject: RE: cfquery and cfstoredproc
> > i have been asked to look at a possible sql injection attack.
> > as I look through the code I see stored procs being called by using
> > cf
> > i have been asked to look at a possible sql injection attack.
> > as I look through the code I see stored procs being called
> > by using cfquery like:
> >
> > cfquery name="asdf" datasource="asdf"
> >
> > storedproc '#var1#', '#var2#'
> >
> > cfquery
> >
> > I've read about using
ssage -
From: "Gaulin, Mark" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, July 22, 2008 4:34 PM
Subject: RE: cfquery and cfstoredproc
> Hi Brad
> Thanks for the links, those are interesting articles.
>
~~~
Thanks Adrian. That's cool. however, it is not useful DURING the execution
of the SQL though correct?
~Brad
- Original Message -
From: "Adrian Lynch" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, July 22, 2008 3:51 PM
Subject: RE: cfquery and
makes a ton of web sites vulnerable. (And yes, this
does provide an example of when back ticks are insufficient, so now I
know.)
Thanks for the info.
Mark
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2008 4:46 PM
To: CF-Talk
Subject: Re
F-Talk
Subject: Re: cfquery and cfstoredproc
> In all versions of CF, cfqueryparam effectively makes Sql Profiling with
> SQL Server useless and there is no workaround.
Please explain what you mean. Are you saying you can't run a trace and see
your SQL running. That is certainly not true.
]
Sent: Tuesday, July 22, 2008 3:46 PM
To: CF-Talk
Subject: Re: cfquery and cfstoredproc
(Depending
> on the version of CF, cfqueryparam disables cachedwithin caching.
This is true, but it doesn't prevent you from baking your own caching
mechanism as many have done.
In
> all ver
(Depending
> on the version of CF, cfqueryparam disables cachedwithin caching.
This is true, but it doesn't prevent you from baking your own caching
mechanism as many have done.
In
> all versions of CF, cfqueryparam effectively makes Sql Profiling with
> SQL Server useless and there is no worka
PM
To: CF-Talk
Subject: cfquery and cfstoredproc
i have been asked to look at a possible sql injection attack. as I look
through the code I see stored procs being called by using cfquery like:
cfquery name="asdf" datasource="asdf"
storedproc '#var1#
: cfquery and cfstoredproc
i have been asked to look at a possible sql injection attack. as I look
through the code I see stored procs being called by using cfquery like:
cfquery name="asdf" datasource="asdf"
storedproc '#var1#', '#var2#'
cf
i have been asked to look at a possible sql injection attack. as I look
through the code I see stored procs being called by using cfquery like:
cfquery name="asdf" datasource="asdf"
storedproc '#var1#', '#var2#'
cfquery
I've read about using cfstored procs and params to preve
In your example you are altering the behavior of the query based upon input
which does not affect injection attacks. The idea of protecting against
injection attacks is to stop invalid values from being executed within the
query/SP.
Take for example this query:
delete from customer where customer
True! I can certainly do this as well.
On Tue, Jul 22, 2008 at 10:40 AM, morgan l <[EMAIL PROTECTED]> wrote:
> What's wrong with using:
>
>
> exec sps_testproc
>
> @aid=
>
> @bid=
>
>
>
>
>
~~~
gt;
>
>
> Adrian
>
> -Original Message-
> From: Qing Xia [mailto:[EMAIL PROTECTED]
> Sent: 22 July 2008 15:21
> To: CF-Talk
> Subject: writing protected CF with CFStoredProc
>
>
> Hello folks:
>
> The discussion yesterday regarding using CFqueryparam to
What's wrong with using:
exec sps_testproc
@aid=
@bid=
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.double
Yup, you're making sense. The way around it is to pass NULL in using:
Adrian
-Original Message-
From: Qing Xia [mailto:[EMAIL PROTECTED]
Sent: 22 July 2008 15:21
To: CF-Talk
Subject: writing protected CF with CFStoredProc
Hello folks:
The discussion yesterday regarding
ng protected CF with CFStoredProc
Hello folks:
The discussion yesterday regarding using CFqueryparam to protect sites from
SQL Injection attacks got me thinking. Well, it is easy enough to use
CFQUERYPARAM everywhere inside CFQUERY tags, wherever a variable is passed
to the SQL query.
However, how
CFStoredProc?
If I understand correctly, if you want to protect calls to stored procs
(from SQL injection and the like), you have to use cfstoredproc and
cfprocparam instead of cfquery and cfqueryparam. But apparently, you can't
indicate what parameters you're actually passing. Am I missing somet
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 go
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.
CF Developer wrote:
> The storedProc only returns a single interget value not a
> database object or field.
> It runs a Quer
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
Friday, November 09, 2007 8:24 AM
To: CF-Talk
Subject: Re: CFStoredProc
It looks like you are missing the DBVAR name.
CF Developer wrote:
> This should have been simple as making a PB&J.
>
> I am calling a SP (SQL Server 2005) using the CFStoredProc function and to
> get the
erver 2005) using the
> CFStoredProc function and to get the result set returned as "nextval".
> Basically it should return an interget value.
>
>datasource="#applic
It looks like you are missing the DBVAR name.
CF Developer wrote:
> This should have been simple as making a PB&J.
>
> I am calling a SP (SQL Server 2005) using the
> CFStoredProc function and to ge
> 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 gue
This should have been simple as making a PB&J.
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
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
http://download
CF returns the value of the OUT variable as a regular variable, just
like you created it with cfset for example.
Try this:
#queryResult #
You'll notice that I removed the "@" from your variable name. You can
name the OUT variable whatever you want, regardless of what it's called
> Hi, i have the following code to call a stored procedure
> which is stored in mysql.
>
>
>value="#url.OneToOneFolder#" null="no">
>null="no">
> value="@queryResult">
>
>
>
> SELECT @queryResult;
>
>
> i have followed the instructions on mysql and the stored
> pr
Hi Eric, thanks for your reply
I did what you said but it is saying that queryResult is undefined
the code i used was
#queryResult#
and the mySQL procedure is as follows:
thanks again for your help
CREATE PROCEDURE portexdb.addOneToOneChildFolder(IN folderNameIn VARCHAR(
Hi, i have the following code to call a stored procedure which is stored in
mysql.
SELECT @queryResult;
i have followed the instructions on mysql and the stored procedure works fine
if i pass in the out as @queryResult. in mysql when i run SELECT @queryResult;
it g
reate a stored procedure that uses xp_cmdshell and sqlcmd/osql (sql
2005/2000) to
capture the messages and return them to cfstoredproc
Then parse the output messages
Janet
~|
ColdFusion MX7 and Flex 2
Build sales & marketing
expressed 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 rea
alk
> Subject: Re: Cfstoredproc message
>
> 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,
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
> Sent: 27 February 2007 07:45
> To: CF-Talk
> Subject: Re: Cfstoredproc message
>
> 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
> resul
e 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: Tue Feb 27 06:45:39 2007
Subject: Cfstoredproc message
Simple question, I hope
How does one get back to CF the message a s
Simple question, I hope
How does one get back to CF the message a stored proc normally puts in the
messages window when you run it in SQL Server management studio or enterprise
manager?
Thanks in advance
Richard
(I've hunted around but difficult to search for the word 'message'...)
~~~
-Talk
Sent: Sat 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 onl
> 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 t
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
Office of Research
Office 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
edexpo.com
-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 qu
Visit our 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
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
~~
1 - 100 of 403 matches
Mail list logo
