Re: select with iterate

2005-04-23 Thread Ron Grabowski
can be used in any tag. and are extensions of the tag. For readability and maintainablity, I would make seperate calls in your dao class. I suppose you could make up some kind of giant INSERT statment using : INSERT INTO content (ListId, Body) VALUES (#idList[]#, null); GO that would gene

Re: select with iterate

2005-04-23 Thread Jason Punzalan
Ahh...very helpful. thank you. what about inserts? can you use iterate to execute multiple inserts or updates? or do i have to make separate calls in my dao class? On 4/23/05, Ron Grabowski <[EMAIL PROTECTED]> wrote: I believe your code would incorrectly generate the following sqlstatements (all o

Re: sql-map file

2005-04-23 Thread Clinton Begin
They're where they always are... http://www.ibatis.com/dtd/sql-map.dtd http://www.ibatis.com/dtd/sql-map-config.dtd Cheers, Clinton On 4/23/05, Sergey Livanov <[EMAIL PROTECTED]> wrote: > > Clinton, > Could you, please, send me 1.2.8 version sql-map.dtd file ? > > -- > regards, > Sergey

Re: select with iterate

2005-04-23 Thread Ron Grabowski
I believe your code would incorrectly generate the following sql statements (all on one line): select * from content where id = 1 select * from content where id = 2 select * from content where id = 3 ... Take a look at the these test cases: http://tinyurl.com/dadn5 http://svn.apache.org/repos/as

select with iterate

2005-04-23 Thread Jason Punzalan
Can someone show me an example of doing a select with iterate? Is it possible to do the following                                         select * from content where                 id = #idList[]#                         I'm currently getting an java.sql.SQLException...running mysql.

sql-map file

2005-04-23 Thread Sergey Livanov
Clinton, Could you, please, send me 1.2.8 version sql-map.dtd file ? -- regards, Sergey mailto:[EMAIL PROTECTED]

RE: Ibatis DAO

2005-04-23 Thread Richard Yee
Is the reader null? I don't see the "Could not initialize DaoConfig." in your stack trace. To help you debug, you might try putting the code in the init() method instead of a static initializer. Then at least the class would get loaded. -Richard At 09:09 PM 4/22/2005, you wrote: Yes thats true,