Drop Down Box - Default Values [message #193268] |
Fri, 15 September 2006 08:58 |
pschar
Messages: 10 Registered: March 2006 Location: jersey
|
Junior Member |
|
|
i have a portlet that contains parameters that are passed onto some discoverer reports. The parmaters are from month, to month and bank.
the parameters are passed correctly to the discoverer worksheets (utilizing disco paramters) but after i choose a different bank on the drop down and hit submit, it goes back to the first bank on the list.
i would prefer it just stays on the bank selected instead of reseting.
is this something i can change in the html in the chart parameters or in the sql?
thanks
jason
|
|
|
Re: Drop Down Box - Default Values [message #195447 is a reply to message #193268] |
Thu, 28 September 2006 13:48 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
if you are building the HTML yourself - then yes you can control it.
I hacked this code - it may need tweaking.
htp.p('<select name="first_select">');
for x in (select category_code, category_value from category_lk order by category_code)
loop
-- the option to pre-select
if x.category_code=category_sel then
htp.p('<option value="'||x.category_code||'" selected>'||x.category_value||'</option>');
else
htp.p('<option value="'||x.category_code||'"> '||x.category_value||'</option>');
end if;
end loop;
htp.p('</select>');
|
|
|