Stored procedure help.

2008-02-11 Thread Craig Tataryn
Hi, relatively new to iBatis and have a question about a stored procedure I need to call that has one IN parameter and several OUT parameters. The idea is, someone would call this stored proc to return exactly 1 customer from the database. The IN parameter corresponds to the customer's id, the OU

RE: Nested Select Statement or Nested Select Elements

2008-02-11 Thread Clinton Begin
I think this is more of an issue with your understanding of SQL than it is with iBATIS. See, the nested SQL statement is not "exposed" to the caller. It can only be used internally (except perhaps if you had put it in the FROM clause and subsequently included it in the SELECT clause of the "parent

RE: AW: Ibatis xml problem - Document root element "sqlmapconfig", must match DOCTYPE root "sqlMap".

2008-02-11 Thread Dominic Edwards
Thanks Axel, that seems to have corrected that issue at least ! Subject: AW: Ibatis xml problem - Document root element "sqlmapconfig", must match DOCTYPE root "sqlMap".Date: Fri, 1 Feb 2008 16:28:33 +0100From: [EMAIL PROTECTED]: user-java@ibatis.apache.org I'm in a hurry, so I only had a

Re: Nested Select Statement or Nested Select Elements

2008-02-11 Thread kiran vuppla
Thanks for the info. I have seen the tutorial but I havent found it as I assume it might not documented regarding the nested select elements. I knew how to write the nested select query. I would like to know is it same or different in writing a nested select statement in IBatis config file that