Re: Re: persistent.delete() ?

The last time I checked though, setCustomWhere clause is not available in the
interface of a Persistent.....

Quoting Michael Nash <[email protected]>:

> Vince:
> 
> Custom where clause should do the job! Just use
> setCustomWhereClause(String) before calling delete...
> 
> Mike
> 
> On Tue, 2004-08-24 at 15:03, Vince Bono wrote:
> > Steve, Mike,
> > 
> > I see some "customWhereClause" code in
> >
> svc-persist-default/src/java/org/keel/services/persist/defaultpersist/Defaul
> > tPersistent.java
> > 
> >         sqlCommand.append("DELETE FROM ");
> >         sqlCommand.append(myMetaData.getTableName());
> >         if (customWhereClause != null) {
> >             sqlCommand.append(customWhereClause);
> >         } else {
> >             sqlCommand.append(buildWhereClauseBuffer(false));
> >         }
> > 
> > 
> > 
> > Or would using svc-query-jdbc  be the better solution ?
> > 
> > 
> > Vince
> > 
> > 
> > 
> > "Stephen Davidson" <[email protected]> wrote in
> > message news:[email protected]
> > > Hi Mike.
> > >
> > > I do object to the Database overhead that your suggestion would entail.
> > >
> > > Vince, if you send me a patch, I will be happy to apply it (after some
> > > general testing, and making sure it does not break any Unit tests, of
> > > course).  Or, if you want to open a Feature Request on SourceForge and
> > > assign it to me, I will tackle it when I get a few minutes (probably
> > > later this week).
> > >
> > > Regards,
> > > Steve
> > >
> > > Michael Nash wrote:
> > >
> > > >Vince:
> > > >
> > > >delete is key-based, not criteria-based, so the only way (I can think
> > > >of) to do what you want would be as follows:
> > > >
> > > >p.setField("id1", id1);
> > > >p.retrieve();
> > > >p.delete()
> > > >
> > > >then
> > > >
> > > >p.setField("id2", id2)
> > > >p.retrieve()
> > > >p.delete
> > > >
> > > >Of course you can do this in a loop, if there are lots of ids you want
> > > >to delete...
> > > >
> > > >Mike
> > > >
> > > >On Mon, 2004-08-23 at 10:02, Vince Bono wrote:
> > > >
> > > >
> > > >>I have a question with persists.delete()
> > > >>I have a table - myTable
> > > >>id1, id2, field1, field2 ... fieldn
> > > >>
> > > >>The  id fields are not unique.
> > > >>I want to delete all rows where   id1=val1 and id2=val2
> > > >>if I set
> > > >>p.setField("id1", id1);
> > > >>p.setField("id2", id2);
> > > >>p.delete();       // will generate the command      DELETE FROM
> myTable;
> > > >>and delete all records
> > > >>p.deleteAll();    //  will not generate any  "DELETE" command
> > > >>
> > > >>prefixing with p.query()  doesnt appear to work either
> > > >>any suggestions ?
> > > >>
> > > >>Thanks,
> > > >>
> > > >>
> > > >
> > > >_______________________________________________
> > > >User mailing list
> > > >[email protected]
> > > >http://lists.keelframework.org/listinfo.cgi/user-keelframework.org
> > > >
> > > >
> > > >
> > >
> > >
> > > -- 
> > > Java/J2EE Developer/Integrator
> > > Stephen Davidson and Associates, Inc.
> > > Chair, Dallas/FortWorth J2EE Sig
> > > 214-724-7741
> > 
> > 
> > 
> > _______________________________________________
> > User mailing list
> > [email protected]
> > http://lists.keelframework.org/listinfo.cgi/user-keelframework.org
> 
> _______________________________________________
> User mailing list
> [email protected]
> http://lists.keelframework.org/listinfo.cgi/user-keelframework.org
>