Re: Need help in Stored procedures and functions

2005-04-07 Thread Peter Brawley
urn i_col3, i_col4, p_string1, p_string2 with resume; end foreach End foreach End function; Thank you for your help Dinesh From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, April 07, 2005 12:24 PM To: Anchan, Dinesh Cc: mysql@lists.mysql.com Subject: Re: Ne

RE: Need help in Stored procedures and functions

2005-04-07 Thread Anchan, Dinesh
PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 07, 2005 4:03 PM To: Anchan, Dinesh Cc: mysql@lists.mysql.com; [EMAIL PROTECTED] Subject: RE: Need help in Stored procedures and functions "Anchan, Dinesh" <[EMAIL PROTECTED]> wrote on 04/07/2005 03:44:07 PM: > Peter,

RE: Need help in Stored procedures and functions

2005-04-07 Thread SGreen
nk you for your help > > Dinesh > > > ____________ > > From: Peter Brawley [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 07, 2005 12:24 PM > To: Anchan, Dinesh > Cc: mysql@lists.mysql.com > Subject: Re: Need help in Stored procedures and func

RE: Need help in Stored procedures and functions

2005-04-07 Thread Anchan, Dinesh
From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, April 07, 2005 12:24 PM To: Anchan, Dinesh Cc: mysql@lists.mysql.com Subject: Re: Need help in Stored procedures and functions Dinesh, A stored func returns a scalar. To return multiple values, use an sproc

Re: Need help in Stored procedures and functions

2005-04-07 Thread Peter Brawley
Dinesh, A stored func returns a scalar. To return multiple values, use an sproc declaring the INOUT variables you need, & pick up their values in the calling code after the sproc has executed. Peter Brawley http://www.artfulsoftware.com - Anchan, Dinesh wrote: Hi,   I am