Re: Calling MySQL stored procedure
Re: Calling MySQL stored procedure
- Subject: Re: Calling MySQL stored procedure
- From: Simon Wilson <email@hidden>
- Date: Wed, 5 Dec 2007 12:04:31 +0100
As others have already mentioned, posts about Core Data/MySQL/MCPKit
are way off-topic on this list.
Please direct your MySQL/Cocoa/MCPKit requests to a more appropriate
forum.
Thanks,
Simon
On Dec 5, 2007, at 11:17, email@hidden wrote:
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:
@clwill.com
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
_______________________________________________
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