RE: Returning value from a stored procedure?

2003-07-07 Thread Bill Grover
rsday, July 03, 2003 10:35 AM > 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

RE: Returning value from a stored procedure?

2003-07-03 Thread Robertson-Ravo, Neil (RX)
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&#

RE: Returning value from a stored procedure?

2003-07-03 Thread Janine Jakim
MAIL PROTECTED] Sent: Thursday, 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 variabl

RE: Returning value from a stored procedure?

2003-07-03 Thread Janine Jakim
riginal 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? I'm trying to return '@AffiliateName

RE: Returning value from a stored procedure?

2003-07-03 Thread Bosky, Dave
-Talk 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? Ar

RE: Returning value from a stored procedure?

2003-07-03 Thread Janine Jakim
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 s

Returning value from a stored procedure?

2003-07-03 Thread Bosky, Dave
Are there any SQL guru's that can help me with this stored procedure? I'm trying to return '@AffiliateName' but it always returns ''. I know the query matches one record but the value is never saved to the Out variable '@AffiliateName'. --