:
Sent: Friday, July 15, 2005 4:16 PM
Subject: SV: multiple delete in sqlmap
Hi there!
Is it related rows you are trying to delete ?
Then you should define FK's between the NUM_OBJ's
on the tables and use casade delete, and delete
the row in the main table (FUN_OBJECT ??)
= only
Take care,
Erlend
-Opprinnelig melding-
Fra: olivier ZILLER [mailto:[EMAIL PROTECTED]
Sendt: 13. juli 2005 17:47
Til: user-java@ibatis.apache.org
Emne: multiple delete in sqlmap
hello,
i'm using sqlmap and mysql and try to execute a delete statement like this :
Maybe it's a limitation of MySql...
Fab
Da: olivier ZILLER
[mailto:[EMAIL PROTECTED] Inviato: venerdì 15 luglio
2005 15.50A: user-java@ibatis.apache.orgOggetto: Re:
multiple delete in sqlmap
you're right : it doesn't works...it seems i'll have to create
mutlip
you're right : it doesn't works...
it seems i'll have to create mutliple delete statements...
thanks
Larry Meadors a écrit :
did you try to do this through JDBC?
Larry
On 7/13/05, olivier ZILLER <[EMAIL PROTECTED]> wrote:
hello,
i'm using sqlmap and mysql and try to execute a
did you try to do this through JDBC?
Larry
On 7/13/05, olivier ZILLER <[EMAIL PROTECTED]> wrote:
> hello,
>
> i'm using sqlmap and mysql and try to execute a delete statement like this :
>
>
> parameterClass="fr.unire.portal.channels.fun.csof.beans.Objet" >
> delete f
hello,
i'm using sqlmap and mysql and try to execute a delete statement like this :
delete from FUN_ERR_OBJ where NUM_OBJ = #numObj#;
delete from FUN_INFO_OBJ_LOV where NUM_OBJ = #numObj#;
delete from FUN_INFO_OBJ where NUM_OBJ = #numObj#;
delete from FUN_GRP_