Of course it can be done in Oracle.
You can have multiple recorders produced from one procedure.
Here's the equivalent in pl/sql for the example below:
snippet
create or replace procedure test(
p_username in varchar2,
p_password in varchar2
)
is
v_user_idnumber;
select user_id
i
On Wed, 2004-03-24 at 11:23, Burns, John D wrote:
> I've done simple stored procedures before to "increase performance"
> (which I already heard today doesn't necessarily do that) but I'm
> wanting to get into using SQL stored procedures for more in depth stuff.
> One thing I'm not sure on how it w
You can use a subselect and do it with a single query. I'm not 100% this
syntax (don't use SQL Server) is correct, but it's close:
select somethingelse
from anothertable
where userID = (
select userID
from users
where username = '#form.username#' and password = '#form.password#'
)
> -O
I made a stored procedure that works great in the query analyzer. I do a
simple call to it with CF and it works fine. When I put it in a cfoutput
with the query defined I get 0 records back from the DB.
Thanks.
Here is some of the code
select id from dealers
where region = 'B
Phillip
Yes and yes... however, like hitting queries within a loop, you should be
careful or you will have a process that is slow and resource intensive - and
therefore not maintainable in the long run. As far as the cfoutput
query=""... that's no problem - except if you subsequently try to do a
> Can you call to a stored procedure in a cfloop and
have it work right?
Yes, as long as the procedure is called by cfquery or
cfstoredproc tag.
> Can you call to a stored procedure in a cfoutput with
the query named
> defined and have it work right?
Yes, as long as the procedure is called by
I've had the same problem with SP's and
What I did was change the data types for the input parameters to varchar
and do the checking before I enter the tag
I do a lot of dynamic SQL building in my sp's and I have had nothing but
headaches with tag is doing . That is one of
the things I don't
That was it. Thanks.
-- Original Message --
From: "Kwang Suh" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Tue, 20 Nov 2001 13:28:19 -0700
>Hmm. Try using CF_SQL_TIMESTAMP. I've NEVER been able to get CF_SQL_DATE
>to work properly.
>
>- Ori
Hmm. Try using CF_SQL_TIMESTAMP. I've NEVER been able to get CF_SQL_DATE
to work properly.
- Original Message -
From: "Bruce Sorge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, November 20, 2001 1:27 PM
Subject: Stored Procedure Question
> OK, I have been using
:37 PM
To: CF-Talk
Subject: Re: Stored Procedure Question
To add to this, you can also create multiple querysets from one query.
Just do:
In fact, you can also do:
Just so you can drive other developers crazy :)
- Original Message -
From: "Jared Stark" <[EM
TED]>
Sent: Thursday, October 04, 2001 9:35 AM
Subject: Re: Stored Procedure Question
> >
> >
> >
> >
>
> The only difference is you need to add the RESULTSET attribute, like
this...
>
>
>
> The RESULTSET attribute is what determines where the
close, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-Original Message-
From: Jared Stark [mailto:[EMAIL PROTECTED]]
Sent: 04 October 2001 16:36
To: CF-Talk
Subject: Re: Stored Procedure Question
>
>
>
>
The only difference is yo
>
>
>
>
The only difference is you need to add the RESULTSET attribute, like this...
The RESULTSET attribute is what determines where the results go. They
simply go in order
of where they are placed in your stored procedure, so if you have
Select * from people
Select * from animals
The
Try running this stored procedure within cfquery... I bet it will work..
-- Original Message --
from: "Bruce Sorge" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Tue, 21 Aug 2001 17:24:53 -0500
I have the following code:
I have the SP on
First of all it is probably getting confused because you have two parameters
with the same dbvarname
Also, I have never prefixed the dbvarname with @ symbol. I dont't know if
that makes a difference or not.
HTH
- Original Message -
From: "Bruce Sorge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[E
CREATE PROCEDURE qGetStates
@state_ID int
AS
SELECT
First you should only one input parameter for state_ID, as I assume you are
doing a select statement.. If you need the two values, than rename one of
the parameters. Second, make sure you've actually set the stored procedure
to expect pa
Let's see the SP.
- Original Message -
From: "Bruce Sorge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, August 21, 2001 4:24 PM
Subject: Stored Procedure Question
> I have the following code:
>
>
>
>
>
>
>
> I have the SP on the SQl Server and it works. Ho
01 15:08
To: CF-Talk
Subject: RE: Stored Procedure Question (Sybase)
I'm not sure about Sybase, I suppose it's the same principle as in SQL
Server. You have to either generate a dynamic query, by building a string
and running it via the execute function, or have a conditional statemen
I'm not sure about Sybase, I suppose it's the same principle as in SQL
Server. You have to either generate a dynamic query, by building a string
and running it via the execute function, or have a conditional statement to
select one query or another depending on the sort variable passed. The first
19 matches
Mail list logo