RE: Stored Procedure Problem

2000-08-23 Thread Milks, Jim
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

RE: Stored Procedure Problem

2002-06-05 Thread Mark A. Kruger - CFG
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

Re: Stored Procedure Problem

2002-06-05 Thread Frank Mamone
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, > >

RE: Stored procedure problem

2002-07-01 Thread Adrian Lynch
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 &

RE: Stored procedure problem

2002-07-01 Thread Andy Ewings
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

RE: Stored Procedure Problem

2000-10-23 Thread Dave Watts
> 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

RE: stored procedure problem

2001-05-10 Thread Simon Horwith
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

RE: stored procedure problem

2001-05-10 Thread Andy Ewings
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

RE: stored procedure problem

2001-05-10 Thread Larry Juncker
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

RE: stored procedure problem

2001-05-10 Thread Greg Jordan
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

RE: stored procedure problem

2001-05-10 Thread Greg Jordan
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

RE: Stored Procedure Problem

2001-02-03 Thread Bob Silverberg
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,

RE: Stored Procedure problem (was Stored Process)

2002-04-16 Thread Adrian Lynch
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

RE: Stored Procedure problem (was Stored Process)

2002-04-16 Thread Kevan . Windle
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

RE: Stored Procedure problem (was Stored Process)

2002-04-16 Thread Chris Terrebonne
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