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
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 &
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,
>
>
ons and the
has been the only solution we have found.
Mark
-Original Message-
From: Frank Mamone [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 1:12 PM
To: CF-Talk
Subject: Stored Procedure Problem
Hi,
I'm trying to call a an stored procedure to MS SQL 2000 using Named n
Hi,
I'm trying to call a an stored procedure to MS SQL 2000 using Named notation for the
parameters. There's always an error, so we did a trace and found that the parameter
names are not passed.
Any ideas?
Frank Mamone
__
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
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
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
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
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
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
lk
Subject: stored procedure problem
Our previous DBA created a table and used (gasp) spaces in the field names
(believe or don't, this person did it more than once and used ALL KINDS of
naming conventions). When I called the SP, the #columnList# lists a field
that looks like this:
PROTECTED]]
Sent: Thursday, May 10, 2001 11:44 AM
To: CF-Talk
Subject: stored procedure problem
Our previous DBA created a table and used (gasp) spaces in the field names
(believe or don't, this person did it more than once and used ALL KINDS of
naming conventions). When I called the SP, the #colum
Our previous DBA created a table and used (gasp) spaces in the field names
(believe or don't, this person did it more than once and used ALL KINDS of
naming conventions). When I called the SP, the #columnList# lists a field
that looks like this:
A OR B
We've got some VB developers who c
pier with
cfquery for running stored procs.
Time to go home now,
Bob
-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]]
Sent: February 3, 2001 6:11 PM
To: CF-Talk
Subject: Stored Procedure Problem
I am having problems passing to variables to a stored procedur
I am having problems passing to variables to a stored procedure. Am i doing
this right? The only time it updates is if the ID and Entry are the same
number.
Bob Everland
~~
> 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
Greetings all
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
resul
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
Created a stored procedure about a week ago that has been running fine up to
now. Suddenly (for no apparent reason) it has stopped working and I have
this error.
ODBC Error Code = S1000 (General error)
[Microsoft][ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
Process 13 generated
01-424-3300 x1396#
E-Mail: [EMAIL PROTECTED]
WWW:www.euservices.com
>--
>
>Date: Tue, 15 Aug 2000 14:18:38 +0100
>From: Anthony Geoghegan <[EMAIL PROTECTED]>
>To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED
agreed.it's much better to have it as an SP. That way SQL doesn't have
to parse the SQL before executing it.
-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: 15 August 2000 14:40
To: '[EMAIL PROTECTED]'
Subject: RE: SQL Server Stored Proced
> much better to build up your sql string dynamically and then execute
> it...takes less code in the long run if you have to do lots of if
> statements.
If speed is a consideration, isn't it better to code the SQL explicitly
where possible so that SQL Server can store an optimised query plan?
Ni
ing you've already built up.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 15 August 2000 14:26
To: [EMAIL PROTECTED]
Subject: Re: SQL Server Stored Procedure problem
> IF ( @type IS NULL )
> BEGIN
>
> IF ( @type IS NULL )
> BEGIN
> AND DirectType = @type
> END
you can't execute dynamic sql like that, either you parse the
TSQL together & use EXEC (or sp_executesql) or run this
sql from cfquery. though i suppose you could also test @Type
for NULL
To: [EMAIL PROTECTED]
Subject: RE: SQL Server Stored Procedure problem
It's just not legal in Microsoft SQL (assuming you mean Microsoft SQL
Server); the SQL statement is compiled when the SP is created, and can't be
dynamic in that way. You have two options:
1) rewrite in a way
Hi Paul,
You said:
|Someone tell me why this isn't working. It's annoying me now:
|
|
|SELECT 'name not given', *
|FROM Directory
|WHERE CountryID = @country
|IF ( @type IS NULL )
|BEGIN
|AND DirectType = @type
|END
SQL do
e not given'
since it does not have a column name associated with it.
DC
- Original Message -
From: "Paul Johnston" <[EMAIL PROTECTED]>
To: "Cf-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, August 15, 2000 13:07
Subject: SQL Server Stored Procedure problem
..'
exec @mysql
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 15, 2000 9:08 AM
To: Cf-Talk
Subject: SQL Server Stored Procedure problem
Someone tell me why this isn't working. It's annoying me now:
Someone tell me why this isn't working. It's annoying me now:
SELECT 'name not given', *
FROM Directory
WHERE CountryID = @country
IF ( @type IS NULL )
BEGIN
AND DirectType = @type
END
Only if a value is passed into the S
30 matches
Mail list logo
