It should execute just fine. I don't see any reason why it wouldn't. Did you enable logging or debug your app and make sure it is actually getting called?
Brandon On 4/19/05, Miquel Angel Bada Zuazo <[EMAIL PROTECTED]> wrote: > I'm creating an Insert SQL statment woth the result of a selectsentence, > > it works fine as a SQL statment, but when I tray to execute with > IBatis, i don't know why, but it isn' executed, and there are no error > ... > > does anybody knows if I can execute the following statment? > > <typeAlias alias="copiarPlantilla" > type="stacks.domain.agenda.CopiarPlantilla"/> > > <insert id="insertItemCopiarPlantilla" > parameterClass="copiarPlantilla"> > INSERT INTO stk_plantillas_horarios > (PLA_ID, ACT_ID, IND_ID, DIASEMANA, HORA) > SELECT #agendaAlId#, ph.ACT_ID, ph.IND_ID, #diaSemana#, > ph.HORA > FROM stk_plantillas_horarios ph > WHERE ph.PLA_ID = #agendaDeId# > AND ph.DIASEMANA = #diaSemana# > </insert> > > Sincerely Yours, > > Miquel Angel >
