To: CF-Talk
Subject: RE: Returning value from a stored procedure?
Would help if I start reading the whole email before
responding. I'm having
a rough day here
SET @AffiliateName = ''
Why did you do this in your stored proc?? Won't this
automatically always
set
Get rid of the null=yes. That is setting it to ''.
-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 10:06 AM
To: CF-Talk
Subject: Returning value from a stored procedure?
Are there any SQL guru's that can help me with this stored procedure?
Subject: RE: Returning value from a stored procedure?
Get rid of the null=yes. That is setting it to ''.
-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 10:06 AM
To: CF-Talk
Subject: Returning value from a stored procedure?
Are there any SQL
Ps.
Guess I should have rewritten this for you
for an out variable this is all you need- no dbvarname either- that goes
with the in type. for type=in you need dbvarname, value, cfsqltype.
for type=out use cfsqltype, variable.
Also don't use the null=yes unless you KNOW for a fact that it will be
, July 03, 2003 10:16 AM
To: CF-Talk
Subject: RE: Returning value from a stored procedure?
There's still a problem with the sp because when I execute it in query
analyzer it prints a empty string.
Some reason the query value is not getting put in the variable.
-Original Message-
From
there is is no real overhead and wont effect anything...
-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]
Sent: 03 July 2003 15:35
To: CF-Talk
Subject: RE: Returning value from a stored procedure?
Would help if I start reading the whole email before responding. I'm
6 matches
Mail list logo
