Ok, here is a screenshot of one of my stored procs (sorry Mike, the pic is from EOModeler because it was quicker to open than eclipse for a quick screenshot :-) )

Attachment: Picture 2.png
Description: application/applefile

<<inline: Picture 2.png>>




The name is just my own internal name for things -- I use when binding my parameters via a dictionary. The Column is the database side for the stored procedure parameters. in this case, the output is just a String, so there is one out parameter, with Column of 000. The first parameter in my stored procedure has a Column of 001, and so on. That is how you get the order of things correct.

Hope this helps.



On Feb 1, 2008, at 12:23 PM, Mike Schrag wrote:

They should be three digit numbers?!? I don't understand.

Are you saying to ignore what the _actual_ parameter names are, just name them whatever ti takes to get them in the right order?
Yes. I believe the order of stored proc parameters must be in the same order as the sorted list of EOArguments defined for the storedproc in the model. Additionally, I believe the columns coming back must be in the correct order of the attributes of the entity you're trying to map it on to (alphabetically). Mind you I have never used stored procedures, but I believe these are the restrictions.

ms


 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to