It is stated that the query attribute of queryData is RunTimeExpression.
It is expected that following piece of JSP should work:
<db:select fieldName="CONTRACT_ID" >
<db:queryData name="contractQuery"
query="SELECT CONTRACT.ID, CUSTOMER.NAME
FROM CONTRACT,CUSTOMER WHERE CUSTOMER.ID=CONTRACT.CUSTOMER_ID AND
CUSTOMER.ID=<%= customerID %>"
/>
</db:select>
The problem is that the scriptlet is not evaluated and <%= customerID %> is
passed in the request to the DB server instead of its value (50).
It is not possible to use workaround, because this is used in "create form"
(receiver of the navNew event).
It will be nice if the problem is fixed.
greetings
Ivo
_______________________________________________________________
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
