Re: where-clause criteria for collection-descriptor?

2003-02-20 Thread Colin Kilburn
D'oh! Thanks Jakob, sorry everyone for the extra traffic. I should have seen those posts. Colin Jakob Braeuchi wrote: hi colin, this feature is already on our todo-list (see posts with subject '1:M querys constraints'). hth jakob Colin Kilburn wrote: Hi All, I'm sorry if this question

Re: where-clause criteria for collection-descriptor?

2003-02-20 Thread Jakob Braeuchi
hi colin, this feature is already on our todo-list (see posts with subject '1:M querys constraints'). hth jakob Colin Kilburn wrote: Hi All, I'm sorry if this question has been asked before, the archive search capability seems to be broken. This is my first project using OJB, and I enjoy th

Re: where-clause criteria for collection-descriptor?

2003-02-20 Thread Colin Kilburn
Pete, Thanks for your suggestion, it would be nice and clean too. Unfortunately, I'm pretty sure the target DB is mysql, which AFAIK doesn't support views. Colin McKinstry, Pete (HQP) wrote: Colin- I'm new to OJB, so i don't know of a way to do what you're attempting w/in OJB. (others may ch

RE: where-clause criteria for collection-descriptor?

2003-02-20 Thread McKinstry, Pete (HQP)
Colin- I'm new to OJB, so i don't know of a way to do what you're attempting w/in OJB. (others may chime in here) But you could use a view (assuming your DB supports them) & have the mapping point to the view table which only shows the valid/active rows. just a possible work-around... -pgm ---