Re: Calling MySQL stored procedure
Re: Calling MySQL stored procedure
- Subject: Re: Calling MySQL stored procedure
- From: email@hidden
- Date: Wed, 05 Dec 2007 18:17:23 +0800
Besides using the MCPKit_bundle,
can anyone please suggest a simple way to call MySQL stored procedures??
I really hope I can use stored procedure rather than hard code many
SQL statements inside the Objective-C program...
Quoting Chris Williams <email@hidden>:
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