Re: dynamic where clause with mapping

Sorry to all, I've found it in the developers guide. Really nice, iBATIS rocks =) -- Eugene N Dzhurinsky

RE: Temporary table causing problems?

Did you try to escape the # using ##? Niels -Original Message- From: Bing Qiao [mailto:[EMAIL PROTECTED] Sent: dinsdag 2 augustus 2005 11:26 To: user-java@ibatis.apache.org Subject: Temporary table causing problems? This problem seems to only exist after 2.0.9b.550 I use queryForList

Re: docs for discriminator tag

thanks! richard On 8/2/05, Roberto R [EMAIL PROTECTED] wrote: Here's an example mapping found in SVN: http://svn.apache.org/repos/asf/ibatis/trunk/java/mapper/mapper2/test/com/ibatis/sqlmap/maps/Documents.xml On 8/1/05, rich oates [EMAIL PROTECTED] wrote: Hi, can anyone point

Re: Result set map to multiple object

Hi Guna, Have you read iBATIS DevGuide? It has all the info you need to solve your issue. Point your browser to http://ibatis.apache.org and get it. It's been way useful for me ;-) Cheers, Daniel Silva. On 8/2/05, Meindert [EMAIL PROTECTED] wrote: Did you have a look at the jpetstore as an

Retrieving next page using pagenatedList

Hi All, I looked at PagenatedList for implementing "Next" and "Previous" features on JSP page. I am getting the list for first time to display a subset of records in the list, when user clicks Next button, I called isNextPageAvailable() and then nextPage(), but nothing happens. My

Re: Example of a queryForMap() call

queryForMap(getStudentNames, parameterMap, studentId, studentName);On 8/2/05, Nathan Maves [EMAIL PROTECTED] wrote:In the given example below select id=getStudentNames parameterClass=map select student_id as studentId student_name as studentName from students where student_id in( iterate

Re: Stored procedure with queryForList skipresults and maxresults

I wonder if it is possible to use skip/max in sql statement. Every database has it's own solution for limiting rows: - sql server has top - postgresql : limit and offset - mysql: also limit and offset ( if I have a good memory:) - oracle prior to 9i combination of: rownum, order like this:

Executing stored procedures

Title: Executing stored procedures I have a query with 3 input parameters to the WHERE clause and the query returns a list. Some of the input parameters are optional (i.e. they can be NULL). The select entry is shown below select id=getList resultMap=list-result SELECT col1,

stored procedure multiple resultsets

Hi, Does iBatis support stored procedure calls which return multiple resultsets? Could someone plz post an example? I couldnt find it over the internet or the forum. Help please! ~ Nilesh

Re: stored procedure multiple resultsets

Short answer - not suported (sorry). See: http://issues.apache.org/jira/browse/IBATIS-28 For some discussion about this. Jeff Butler On 8/2/05, Nilesh Bhattad [EMAIL PROTECTED] wrote: Hi, Does iBatis support stored procedure calls which return multiple resultsets? Could someone

Re: Retrieving next page using pagenatedList

Hi, 1) you can use some code like below to get next page if(results.isNextPageAvailable()){ results.nextPage(); } 2) If you pass pageSize to the call: queryForPaginatedList(java.lang.String id, java.lang.Object parameterObject, int pageSize), first time it will fetch at most 2*pageSize