Re: Calling MySQL stored procedure
Re: Calling MySQL stored procedure
- Subject: Re: Calling MySQL stored procedure
- From: Chris Williams <email@hidden>
- Date: Tue, 04 Dec 2007 12:38:16 -0800
- Thread-topic: Calling MySQL stored procedure
1) This is WAY off-topic for the Xcode list, but...
2) Begin/End is how you create store procedures, not how you call them
3) The problem is attempting to return a result set. Check the MySQL stored
procedure FAQ, specifically Q #28.4.14 which can be found here:
http://dev.mysql.com/doc/refman/5.0/en/faqs-stored-procs.html
Which deals specifically the contexts in which you can return a result set.
On 12/4/07 11:26 AM, "Toplica Tanasković" <email@hidden> wrote:
>
> On 04.12.2007., at 14.14, email@hidden wrote:
>
>>
>> theResult = [theConnection queryString:@"CALL getAllOperation()"];
>>
>
> Don't know much about MySQL syntax but for Oracle databases you have
> to write @"begin call foo(); end;". I think that this is SQL standard
> but do not trust me on that.
>
> --
> Regards,
> Toplica Tanaskovic
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Xcode-users mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Xcode-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden