Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=3369214
By: tankdriver
I want to do something similar such as populate a select box given what a user
selected in another select box on the same form. I am able to get the second
select box to populate but the value that the user selected in the first select
goes back to the original value after the form is submitted. I cannot figure
out how to keep the new value in the first select after the form gets submitted.
Another question is why do I have to use the wierd syntax "[EMAIL PROTECTED]" to
access a request parameter? I would assume that "SERVICE_NAME" would be the
parameter name but when I interogate the request it is called "[EMAIL
PROTECTED]".
I do have the table name specified in the form tag.
This is the code for the two selects.
<db:message key="SERVICE_NAME"/></td>
<db:select fieldName="SERVICE_NAME" onChange="this.form.submit();">
<db:tableData disableCache="true"
name="SERVICE_NAME"
visibleFields="SERVICE_NAME"
foreignTable="sre_service_info"
storeField="SERVICE_NAME"
/>
</db:select>
<db:message key="OPTION_SET_NAME"/></td>
<% String myselect = "SELECT option_set_name, option_set_name " +
"from sre_service_option_set " +
"WHERE service_name = '" +
org.dbforms.util.ParseUtil.getParameter(request, "[EMAIL PROTECTED]", "") +
"'";
%>
<db:select fieldName="OPTION_SET_NAME" >
<db:queryData disableCache="true"
name="OPTION_SET_NAME"
query="<%= myselect
%>"
/>
</db:select>
Any help would be appreciated. Thanks!
______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit:
https://sourceforge.net/forum/unmonitor.php?forum_id=55830
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
