Let me try query and tells the result later.
BTW, can whereClause be used together with searches (1.1.3) (not using attribute but by HTML inputs)? I've tried the following thing but seems clicking on "Applica!" gives no effect on the SQL prepared statement generated by dbforms:
<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">
<INPUT type="text" name="<%= searchFieldNames_cos.get("orders.order_id") %>">
<input type="button" value="Applica!" onClick="javascript:document.dbform.submit()">
THX! --bee
Shawn wrote:
Am I doing a correct way to put the "join relationship" in the whereClause? Or shall I put it elsewhere?
Or should I use "query" instead of "table"?
Um I think you should use a query for this:
------------------------------------------------------- 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
