Parenthesis are not possible, change the sequence of your filters: (date_start<=2004-09-12),ISNULL,|date_end>=2004-09-29)
Shoud work.... I hope. Cheers Henner > Dear All, > of course this is a simple question... > I need to put a filter on a dbforms that generates somethin like > > ......... > select * > from table_with_dates > where (date_end is null or date_end>='2004-09-29') AND (date_start > >='2004-09-12') > ......... > > where the two dates are generated by a POJO beckend. > > so in the form I put: > > <db:dbform > .......... > .......... > filter="date_end ISNULL,|date_end>=2004-09-29" > > and it runs correctly... it generates the first part of my > where clause. > > But when I try to add the second condition I get errors, may > I write something > like: > > filter="(date_end > ISNULL,|date_end>=2004-09-29),(date_start<=2004-09-12)" ??? > > Or is there another way to express something like this filter > in the filter attribute? > > Thanks Ivan > > > > ---------------------------------------------------------------- > This message was sent using IMP, the Internet Messaging Program. > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on > ITManagersJournal Use IT products in your business? Tell us > what you think of them. Give us Your Opinions, Get Free > ThinkGeek Gift Certificates! Click to find out more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > DbForms Mailing List > > http://www.wap-force.net/dbforms > ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
