I managed to get it listed out correctly. But seems "ordering" and "filtering" doesn't work.
Correct. When you use a whereClause attribute, orderBy and filter attributes do not work. This is documented in the Sorting, Filtering and Searching chapter in the UsersGuide.
<db:dbform autoUpdate="false" followUp="/customer2.jsp" maxRows="5"
tableName="cos" tableList="customer,orders,service"
whereClause="WHERE customer.id=orders.customer_id AND orders.service_id=service.id"
filter="orders.order_id=0"
>
In this case, you need to put everything into your whereClause including order by statements.
Note: Navigation (ie navnext etc buttons only work with a whereClause if you are using datalist navigation.default from 1.1.4pr1 I think but)
If I were you, I would take a look at a new weekly build and see the filter tag (not filter attribute you tried). It's an improvement and simplification over whereClause, filter and orderBy attributes IMHO.
-- Shawn
Happily using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ DbForms Mailing List
http://www.wap-force.net/dbforms
