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
>/
>
Attachment: [text/html]
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
