NO, you can't. You can define a view in your database which uses the destinct. Or you can define a <query> in your config file which uses the distinct either.
Cheers, Henner > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von Audun V. Nes > Gesendet: Montag, 14. März 2005 14:50 > An: jdbforms-interest@lists.sourceforge.net > Betreff: [dbforms] SELECT DISTINCT in dbform tag ? > > Hi > > I am currently rewriting an application to use DBForms 2.5, > and on one of my JSP pages I need to display DISTINCT values. > Is there a way I can specify SELECT DISTINCT using the > <db:dbforms ...> tag ? > > This is what I have atm which shows a SELECT ALL page: > > <db:dbform multipart="false" autoUpdate="false" > followUp="/hr_submissions.jsp" maxRows="*" tableName="PS2HR" > orderBy="SUBMITINDEX desc" filter="PAID=1"> <db:header> > <db:errors/> > <table> > <tr> > <th>#</th> > <th>Run by</th> > <th>Date</th> > </tr> > </db:header> > <db:body> > <tr> > <td><db:label fieldName="SUBMITINDEX" /></td> > <td><db:label fieldName="PAIDBY" /></td> > <td><db:dateLabel fieldName="PAYDATE" > pattern="dd.MM.yyyy" /></td> > </tr> > </db:body> > <db:footer> > </table> > </db:footer> > </db:dbform> > > best regards > Audun > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide Read honest & > candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > _______________________________________________ > DbForms Mailing List > > http://www.wap-force.net/dbforms > ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_ide95&alloc_id396&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
