Sorry, my fault... I do not mean the filter attribute. This is always anded. If you or you get a bad perfomance in the database - oring needs a full table scan mostly.
Better is to switch between to sql statments. I use the whereClause attribute for this purpose. The problem with this solution is that the whereClause is the leading attribute - if it's setted it will be always used. So you must set it to an empty string after the first call of your form.. Or you have an better idea? Cheers, Henner > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von Shawn > Gesendet: Montag, 21. Juni 2004 04:09 > An: Henner Kollmann > Cc: 'dbf interest' > Betreff: Re: AW: [dbforms] Re: figuring out NavNext position > > > On Sat, 19 Jun 2004 10:15:20 +0200, Henner Kollmann > <[EMAIL PROTECTED]> wrote: > > > You can use the good old filter attribute to do so. This > attribute is > > ignored if some other filter is in use. So you can set it > to something > > like id=-1 (nether satisfied!) and use your filter. > > On startup you will get nor records then... > > > > Cheers, > > Henner > > > > Ah, yes do not forget old friends! However, I always get a > null result > set that way. > > the sql debugging shows both filters being applied > ... WHERE ( translation LIKE ? ) AND ( ( ( translation = > ? ) ) ) > ... > > ...(1)filter tag AND (2)filter attribute in dbforms tag [set > to always > return a null set]... > > So is that a bug or should I add a sqlFilterOR attribute to > dbforms tag > (otherwise the sqlFilter attribute and db:filter tag will > always be ANDed > just like the filter attribute and sqlFilter attribute seem > to be doing). > > -- > Shawn > > Happily using M2, Opera's revolutionary e-mail client: > http://www.opera.com/m2/ > > > ------------------------------------------------------- > This SF.Net email is sponsored by The 2004 JavaOne(SM) > Conference Learn from the experts at JavaOne(SM), Sun's > Worldwide Java Developer Conference, June 28 - July 1 at the > Moscone Center in San Francisco, CA REGISTER AND SAVE! > http://java.sun.com/javaone/sf Priority Code NWMGYKND > _______________________________________________ > DbForms Mailing List > > http://www.wap-force.net/dbforms > ------------------------------------------------------- This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
