From: Peter Brawley Date: April 7 2005 4:24pm Subject: Re: Need help in Stored procedures and functions List-Archive: http://lists.mysql.com/mysql/182293 Message-Id: <42555EB8.7090506@earthlink.net> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=======AVGMAIL-42555EB9083C=======" --=======AVGMAIL-42555EB9083C======= Content-Type: multipart/alternative; boundary=------------000604050207080104050709 --------------000604050207080104050709 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 trying to write a function which returns multiple values. I > don't know if this is allowed or not but i am not able to create this > function. I get the following error: > > ERROR 1064 (42000): You have an error in your SQL syntax; check the > manual that corresponds to your MySQL server version for the right > syntax to use near ' > integer, > integer, ' at line 7 > I have attached the function i am trying to create. Please refer to > the attached thread for contract related information. > > I would appreciate if somebody can give me a call so that i can clear > few other questions. > > Thanks > Dinesh Anchan > 212-231-7187 > > ------------------------------------------------------------------------ > *From:* Pam Keen [mailto:pkeen@stripped] > *Sent:* Thursday, April 07, 2005 10:21 AM > *To:* Marcus, Jeff > *Cc:* Pisula, Mike; Pedersen, Mads; Mishkind, Scott; Anchan, Dinesh; > robert.tas@stripped; 'Philip Antoniades'; 'Kenneth Moses' > *Subject:* RE: MySQL/24/7 Real Media support contract renewal > > Jeff, > > What is your availability to discuss/resolve the below and to discuss > the Informix migration effort. I am available early next week - > Monday all day and Tuesday, late morning,early afternoon. As an > interim measure, I extended support till the end of this week for your > team's development efforts. > > Thank you, > > Pam Keen > 212 566 2714 > // > >/ >/ >------------------------------------------------------------------------ >/ >No virus found in this incoming message. >Checked by AVG Anti-Virus. >Version: 7.0.308 / Virus Database: 266.9.4 - Release Date: 4/6/2005 >/ > --------------000604050207080104050709 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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 trying to write a function which returns multiple values. I don't know if this is allowed or not but i am not able to create this function. I get the following error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
   integer,
   integer,                  ' at line 7

I have attached the function i am trying to create. Please refer to the attached thread for contract related information.

I would appreciate if somebody can give me a call so that i can clear few other questions.

Thanks

Dinesh Anchan

212-231-7187

From: Pam Keen [mailto:pkeen@stripped]
Sent: Thursday, April 07, 2005 10:21 AM
To: Marcus, Jeff
Cc: Pisula, Mike; Pedersen, Mads; Mishkind, Scott; Anchan, Dinesh; robert.tas@stripped; 'Philip Antoniades'; 'Kenneth Moses'
Subject: RE: MySQL/24/7 Real Media support contract renewal

Jeff,

What is your availability to discuss/resolve the below and to discuss the Informix migration effort. I am available early next week - Monday all day and Tuesday, late morning,early afternoon. As an interim measure, I extended support till the end of this week for your team's development efforts.

Thank you,

Pam Keen

212 566 2714
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.4 - Release Date: 4/6/2005

--------------000604050207080104050709-- --=======AVGMAIL-42555EB9083C======= Content-Type: text/plain; x-avg=cert; charset=us-ascii Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Content-Description: "AVG certification" No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.4 - Release Date: 4/6/2005 --=======AVGMAIL-42555EB9083C=======--