I noticed that this problem happens only in junction tables (just foreign keys columns), and when these columns are optional (can be null) ...
-Vjeran ----- Original Message ----- From: "T E Schmitz" <[EMAIL PROTECTED]> To: "Apache Torque Users List" <[EMAIL PROTECTED]> Sent: Sunday, July 04, 2004 6:32 PM Subject: Re: URGENT!! Optinanal foreign key column not deleting > Hello, > I am not quite sure why criteria / doSelect should return a result while > criteria / doDolete doesn't for the same values. > > But bear in mind that for doDelete and doUpdate "no hits" is not an > error. Therefore no exception is thrown. In fact, you don't get any > feedback at all. This in itself is a problem for some applications. > > You mention that you use "object" types rather than primitive. Have you > tried using new Integer(95) as a Criteria parameter? > > > > Criteria crit = new Criteria(); > > crit.add(TmModelProfilePeer.MODEL_ID, 95); > > List list = TmModelProfilePeer.doSelect(crit); > > > > and eveything works fine. But when I want to delete these rows by same > > criteria : > > Criteria crit = new Criteria(); > > crit.add(TmModelProfilePeer.MODEL_ID, 95); > > TmModelProfilePeer.doDelete(crit); > > it doesn't work. No exception, just no deletion. ??!! > > -- > > > Regards/Gru�, > > Tarlika Elisabeth Schmitz > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
