Re: SQL stored procedure question

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-Talk Subject: SQL stored procedure question OK, after hearing everybody say don't use Access and an converting

RE: SQL stored procedure question

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 question Stored procedures don't work the way you

SQL stored procedure question

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: cfquery Name=qrySignoffRequest

RE: SQL stored procedure question

-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 and an converting my Check Request System to MS SQL Server. And I am trying to use Stored

RE: SQL stored procedure question

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, October 08, 2004 2:06 PM To: CF-Talk Subject: SQL stored procedure question OK, after hearing

stored procedure question

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]

RE: stored procedure question

= '#form.password#' ) /cfquery -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 performance (which I already heard today doesn't

Re: stored procedure question

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 works

Re: stored procedure question

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 into

Stored Procedure question

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

Re: Stored Procedure question

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

RE: Stored Procedure question

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 cfloop and have

RE: Stored Procedure question

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 cfquery name=dealers datasource=#app.datasource#

Stored Procedure Question

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

Re: Stored Procedure Question

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 SP

Re: Stored Procedure Question

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 a while with no problems. Now I am encountering an issue. I have a stored procedure that looks like

Re: Stored Procedure Question

as this. - Original Message - From: Bruce Sorge [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 2:27 PM Subject: Stored Procedure Question OK, I have been using SP for a while with no problems. Now I am encountering an issue. I have a stored procedure

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 enough to show me a little pseudo code or a snippet of code on how to accomplish this? I assume in cf,

Re: Stored Procedure Question

be in result2. Pretty slick, eh? JS - Original Message - From: Mark Stewart [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, 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

RE: Stored Procedure Question

, 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 cfstoredproc procedure=procedure_name datasource=#maindsn

Re: Stored Procedure Question

PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 04, 2001 9:35 AM Subject: Re: Stored Procedure Question cfstoredproc procedure=procedure_name datasource=#maindsn# cfprocresult name=result1 cfprocresult name=result2 /cfstoredproc The only difference is you need to add

RE: Stored Procedure Question

: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: cfprocresult name=result1 resultset=1 cfprocresult name=result2 resultset=1 cfprocresult name=result3 resultset=1 cfprocresult name=result4 resultset=1

Re: Stored Procedure Question

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: cfstoredproc

Stored Procedure Question

I have the following code: cfstoredproc datasource=#WME.DSN# procedure=qGetStates returncode=Yes cfprocparam type=In dbvarname=@State_ID value=#license_state_ID# cfsqltype=CF_SQL_INTEGER cfprocparam type=In dbvarname=@State_ID value=#state_ID# cfsqltype=CF_SQL_INTEGER cfprocresult

Re: Stored Procedure Question

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: cfstoredproc datasource=#WME.DSN# procedure=qGetStates returncode=Yes

RE: Stored Procedure Question

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: cfstoredproc datasource=#WME.DSN# procedure=qGetStates returncode=Yes cfprocparam type

Re: Stored Procedure Question

PROTECTED] Sent: Tuesday, August 21, 2001 4:24 PM Subject: Stored Procedure Question I have the following code: cfstoredproc datasource=#WME.DSN# procedure=qGetStates returncode=Yes cfprocparam type=In dbvarname=@State_ID value=#license_state_ID# cfsqltype=CF_SQL_INTEGER cfprocparam type

COMPILATION - ODBC does not like Overloaded Stored Procedures Was : (Oracle stored procedure question.)

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 Win2K box

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 Win2K box (CF Pro 4.5.1 SP2). However, it does work with the Oracle native drivers

RE: Stored Procedure Question (Sybase)

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 I've run

RE: Stored Procedure Question (Sybase)

: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 statement to select one

RE: SQL Stored Procedure Question...

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 varchar(1

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 PROCEDURE GetContacts @alpha varchar(1) AS SELECT Contacts_Main.company FROM

RE: SQL Stored Procedure Question...

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 cant seem

RE: SQL Stored Procedure Question...

, 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 PROCEDURE

Re: SQL Stored Procedure Question...

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";