Hello! I have the following problem with the whereClause:
I have the following dbform declaration: <db:dbform autoUpdate="false" followUp="/forms/TransferList.jsp" maxRows= "15" tableName="ORDERS" whereClause="WHERE CUSTOMER_ID IN (SELECT CUSTOMER_ID FROM CUSTOMER WHERE NAME LIKE 'Mr. Henkel')" captionResource= "true"> The problem is that the whereClause is working only when on first visit of the page. When I use the next and previous buttons they are working as if no whereClause exists. As it is seen from the code above I cannot use the filter attribute in this case. It would be really great if the whereClause was working together with the next and prevous buttons as this would bring a much more advanced filtering in the dbforms. Is there any other way to realize the upper mentioned filtering? Thank you in advance! Ivaylo Lambev _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
