This feature is on the to-do list. I do not have time to work on this right now. If you are interested, you could go ahead and make to appropriate modifications...
Philip Grunikiewicz
Hydro-Qu�bec / Montr�al / Canada
-----Message d'origine-----
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Envoy� : jeudi 6 juin 2002 04:26
� : [EMAIL PROTECTED]
Objet : [dbforms] Problem with the whereClause!
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
