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
