Re: cursor or multiple parameters

2007-07-13 Thread Koka Kiknadze
Well, if you want to do it with domain object, think yuo can do it with three sql statements instead of two - Select for update returning you domain object. Delete the row using selected object. Change the desired field of the object and run insert. Of course it will work unless your table h

Re: cursor or multiple parameters

2007-07-13 Thread Larry Meadors
With that database design, there is really no other way. You could use a Map, I suppose. Larry On 7/13/07, Severin Ecker <[EMAIL PROTECTED]> wrote: hi Larry, yes or course, but there i need either a new type that i hand over to the sqlmap unless i can use more than one parameters.. or a list

Re: cursor or multiple parameters

2007-07-13 Thread Severin Ecker
hi Larry, yes or course, but there i need either a new type that i hand over to the sqlmap unless i can use more than one parameters.. or a list. your solution (which is the one i'm using atm) requires another type definiton since i can't use the domain object public class Bla { String hell

Re: cursor or multiple parameters

2007-07-13 Thread Larry Meadors
update foo set bar = #newBar# where foo = #foo# and bar = #bar# Larry On 7/13/07, Severin Ecker <[EMAIL PROTECTED]> wrote: hi all, i have a problem (which i think i need to resolve with cursors but maybe you know another way in ibatis) let's say i have a table ( hello VARCHAR, world VARCHAR

cursor or multiple parameters

2007-07-13 Thread Severin Ecker
hi all, i have a problem (which i think i need to resolve with cursors but maybe you know another way in ibatis) let's say i have a table ( hello VARCHAR, world VARCHAR ) both fields form the primary key together. what i need is, selecting one specific entry (by specifying values for both f