to null is a starter but not good enough. Ponder on that, but if you don't want to do that, either follow up here or send me an email.
Cheers,
Don
> -Original Message-
> From: Pratte, Jeff [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 08, 2004 2:06 PM
> To: CF-Tal
job done, once you start
getting to complex
application development... cfQuery and SQL all over the application is
Messy.
Joe Eugene
-Original Message-
From: Gaulin, Mark [mailto:[EMAIL PROTECTED]
Sent: Friday, October 08, 2004 3:50 PM
To: CF-Talk
Subject: RE: SQL stored procedure
a real pain.
I'd suggest sticking with cfquery for now. SQL Server is going to better (faster,more stable) than Access even if you don't use stored procedures for everything.
Mark
-Original Message-
From: Pratte, Jeff [mailto:[EMAIL PROTECTED]
Sent: Friday, Octobe
use the code below - adding CFQUERYPARAM for speed and security.
-Mark
-Original Message-
From: Pratte, Jeff [mailto:[EMAIL PROTECTED]
Sent: Friday, October 08, 2004 1:06 PM
To: CF-Talk
Subject: SQL stored procedure question
OK, after hearing everybody say don't use Access
OK, after hearing everybody say don't use Access and an converting my
Check Request System to MS SQL Server. And I am trying to use Stored
Procedures. However, I am finding it more difficult then I anticipated.
For instance, I used to have a query like this:
blockfactor="100">
selec
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
assword = '#form.password#'
)
> -Original Message-
> From: Burns, John D [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 24, 2004 11:23 AM
> To: CF-Talk
> Subject: stored procedure question
>
> I've done simple stored procedures before to "increase perfo
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 works is as follows:
CREATE PROCEDURE [dbo].[sm_login]
@
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
ently try to do a
cfoutput within the cfoutput using a result set returned from the SP.
Mark
-Original Message-
From: Phillip Broussard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 2:23 PM
To: CF-Talk
Subject: Stored Procedure question
Can you call to a stored procedure in 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
Can you call to a stored procedure in a cfloop and have it work right?
Can you call to a stored procedure in a cfoutput with the query named
defined and have it work right?
Trying to use stored procedures for the first time and they are really
staring to tick me off. Gr
Thanks,
Phillip
of
the things I don't like about ColdFusion because sometimes it is very hard
to find out what is happening in cases as this.
- Original Message -
From: "Bruce Sorge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, November 20, 2001
L_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 SP for
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 P
OK, I have been using SP for a while with no problems. Now I am encountering an issue.
I have a stored procedure that looks like this:
CREATE PROCEDURE Next30Days
@Next30 DateTime,
@TodayDate DateTime
AS
SELECT Title, Copy, EventDate, EventTime
FROMCalendar
Where EventDate < @Next30 And
: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
ay, October 04, 2001 8:17 AM
Subject: Stored Procedure Question
> All,
>
> I've been using stored procedures for a while now but I've never really
> needed to create one that returned multiple result sets. My question is,
> how do you do that? Would someone be kind en
All,
I've been using stored procedures for a while now but I've never really
needed to create one that returned multiple result sets. My question is,
how do you do that? Would someone be kind enough to show me a little
pseudo code or a snippet of code on how to accomplish this?
I assume in cf, I
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
TED]>
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. However, when I run the
page, I recei
xpect params.
Darryl
-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 22, 2001 8:25 AM
To: CF-Talk
Subject: Stored Procedure Question
I have the following code:
I have the SP on the SQl Server and it works. However, when I run the page,
I re
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 following code:
I have the SP on the SQl Server and it works. However, when I run the page, I receive
the following error message:
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Proced
y 04, 2001 11:25 AM
To: CF-Talk (E-mail)
Subject: Oracle stored procedure question.
Hi All,
I need another set of eyes on a problem. I have a piece of code that calls
an Oracle stored procedure that just refuses to work with either the Oracle
or Microsoft ODBC drivers on my personal development
Hi All,
I need another set of eyes on a problem. I have a piece of code that calls
an Oracle stored procedure that just refuses to work with either the Oracle
or Microsoft ODBC drivers on my personal development Win2K box (CF Pro 4.5.1
SP2). However, it does work with the Oracle native drivers t
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
The first
option is more flexible the second more efficent.
-Original Message-
From: Sandi Benditt [mailto:[EMAIL PROTECTED]]
Sent: 27 February 2001 19:28
To: CF-Talk
Subject: Stored Procedure Question (Sybase)
We are in the process of moving all our queries to stored procedures, but
We are in the process of moving all our queries to stored procedures, but
I've run into a problem that maybe someone can help me with.
Take the following query. If I move it to a stored procedure and try to
pass the sort variable to it I get an error along the lines of you can't
use a varia
Peter & Nick...
You da'Man! Thanks a ton, worked perfectly...
John
-Original Message-
From: Peter Stolz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 26, 2000 5:09 PM
To: CF-Talk
Subject: RE: SQL Stored Procedure Question...
Try:
CREATE PROCEDURE GetContacts @alpha
This is a multi-part message in MIME format.
--B9336A7DD898E0D1B5936117
Content-Type: multipart/alternative;
boundary="778FA7AB3A393FFA7903E735"
--778FA7AB3A393FFA7903E735
Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854";
x-mac-creator="4D4F
t: Tuesday, September 26, 2000 3:36 PM
To: CF-Talk
Subject: SQL Stored Procedure Question...
Hey All,
Got a quick one for all of you...
I am implementing a stored procedure and I cant seem to get a LIKE clause to
work with a variable passed in:
SHORT VERSION OF CODE:
=
CREATE
LIKE @alpha + '%'
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 26, 2000 2:36 PM
To: CF-Talk
Subject: SQL Stored Procedure Question...
Hey All,
Got a quick one for all of you...
I am implementing a stored procedure and I ca
Hey All,
Got a quick one for all of you...
I am implementing a stored procedure and I cant seem to get a LIKE clause to
work with a variable passed in:
SHORT VERSION OF CODE:
=
CREATE PROCEDURE GetContacts @alpha varchar(1) AS
SELECT Contacts_Main.company
FROM Contact
37 matches
Mail list logo
