Did you try dropping it and recreating it?
JM
-Original Message-
From: Paul Johnston
To: Cf-Talk
Cc: Andy Ewings
Sent: 23/08/00 12:45 PM
Subject: Stored Procedure Problem
Created a stored procedure about a week ago that has been running fine
up to
now. Suddenly (for no apparent reason
Frank,
Here's my experience:
You must pass the parameters in the same order as they are declared in SQL.
The named parameter feature (as I understand it) applies to Oracle - I also
believe it to be deprecated in CFMX. The parameters must be in the same
order - If you are assigning default value
That kinda sucks!
Thanks alot for your input Mark.
- Original Message -
From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 05, 2002 2:29 PM
Subject: RE: Stored Procedure Problem
> Frank,
>
>
Would trying to put an empty string into the agendatime cause any problems?
-Original Message-
From: angela alston [mailto:[EMAIL PROTECTED]]
Sent: 29 June 2002 05:08
To: CF-Talk
Subject: Re: Stored procedure problem
Thanks Joshua.
I ran the proc in the analyzer as you suggested &
a
varchar and let SQL do the work.
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
Sent: 01 July 2002 10:30
To: CF-Talk
Subject: RE: Stored procedure problem
Would trying to put an empty string into the agendatime cause any problems?
-Original Message-
From: ang
> I am having problems with a db2 stored procedure and I am
> guessing the problem is on the cf server side though I am
> not sure.
>
> The first time the stored procedure is run, it brings back
> the right result set. After the procedure is run the first
> time though, it takes the first res
do the same thing... use [brackets ]
~Simon
Simon Horwith
Macromedia Certified Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com
-Original Message-
From: Greg Jordan [mailto:[EMAIL PROTECTE
you should be able to do the same thing. It's not the VB that interprets
the brackets it's the SQL itself. I assume you are passing in a field list
into a SP as a param so you know what fields to update?just put brackets
around the field names.
A
P.S. shoot your DBA..before he goes co
Rename the column in your query as so:
SELECT A OR B as A_OR_B
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
-Original Message-
From: Greg Jordan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 10:44 AM
To: CF-Talk
Subject: stored procedure pro
Simon
would you use brackets in the output when ref. the field or in the SQL?
Greg
-Original Message-
From: Simon Horwith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 11:09 AM
To: CF-Talk
Subject: RE: stored procedure problem
do the same thing... use [brackets ]
~Simon
meone else as well. AND thanks to all who responded.
Greg
-Original Message-
From: Simon Horwith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 11:09 AM
To: CF-Talk
Subject: RE: stored procedure problem
do the same thing... use [brackets ]
~Simon
Simon Horwith
Macromedia
I've been using stored procedures extensively in my latest app, so I thought
I'd pass on some observations and opinions:
Firstly, I don't think you should be appending the @ symbol to your variable
names. Use dbvarname="ID", rather than dbvarname="@ID". As well, it has
been my experience that,
check everywhere a datatype is declared, DB, CF stored proc, the SP..
it's usually somewhere, just check the lot
-Original Message-
From: Ryan Edgar [mailto:[EMAIL PROTECTED]]
Sent: 16 April 2002 15:31
To: CF-Talk
Subject: RE:Stored Procedure problem (was Stored Process)
I am worki
Try using execute(@thestatement)
-Original Message-
From: Ryan Edgar [mailto:[EMAIL PROTECTED]]
Sent: 16 April 2002 15:31
To: CF-Talk
Subject: RE:Stored Procedure problem (was Stored Process)
I am working alongside Jerry on this and we are still running into
problems.
The Stored Proc is
methods to automate the insert statements.
HTH,
Chris
--
Original Message
From: ""<[EMAIL PROTECTED]>
Subject: RE: Stored Procedure problem (was Stored Process)
Date: Tue, 16 Apr 2002 16:22:41 +0100
>Try using execute(@thestatemen
15 matches
Mail list logo