Which version do you use? What's the resulting sql string? Cheers, Henner
> -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von > Kuntur > Gesendet: Samstag, 19. Juni 2004 14:32 > An: [EMAIL PROTECTED] > Betreff: [dbforms] delay when using whereClause and OR in dbform tag > > Hi all! > I am using "whereClause" into dbform tag, but when "OR" is include > into the whereClause the select never shows me the results. But if > there is "AND" I get to run successfully the results. > > Here my dbform sentence: > <db:dbform tableName="1_case" maxRows="5" followUp="/case_b.jsp" > whereClause="WHERE name1 like '%acme%' OR name2 like '%acme%'" > > > Any idea? > Thanks in advance. > > --kuntur > > > ------------------------------------------------------- > 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