I'm trying to get the multiple values from multiselct list in custom tablular form, but it returns only one value. I'm using the below statetment to display multislect list in each row of tabular form. I would appreciate your thoughts on how to set this item and process the the item to returm multiple values in the process.

HTMLDB_ITEM.SELECT_LIST_FROM_LOV_XL(3,name,''test_name'',''multiple size = "3");

thanks for your help,
surya

As you probably figured out, the multiselect list is rendered fine but when you select multiple items from it, the g_fNN arrays get confused. Instead of storing each entry g_f01(i) as a colon-delimited list of values, it creates multiple entries g_f01(1), g_f01(2) and there is no way to tell which entry belongs to which row on the tabular form.

Maybe someone from Oracle has some ideas, but I think this is not doable in APEX. Accept processing expects just 1 value per g_fNN array entry.

See http://apex.oracle.com/pls/otn/f?p=24317:13

Run the page in debug mode, select bunch of values from each select list, click Submit button and see the debug entries written by the process

for i in 1..apex_application.g_f01.count

loop 

  wwv_flow.debug('i='||i||',f01(i)='||apex_application.g_f01(i));

end loop;

Well, the workaround is ugly.

You could

a. render a hidden apex_item.hidden(2,...) field on the tabular form.
b. Write some onClick Javascript on your multiselect list to take the selected value(s) of the multi-select list, concatenate them together using some delimiter and assign them to the hidden item
c. Use the hidden array apex_application.g_f02 in your accept processing, parse them on the delimiter and do whatever you need with the individual values

Like I said, not pretty!

thanks for valuable suggestions. I'm just wondering, if anyone has tried the javascript solution and works, wheather it is possible to share the solution. I really appreciate your help.

thanks,
Surya

Vikas,

thank you very much for your help. "onClick" event was not able to trigger the javascirpt in both IE and mozilla, then I tried with "onChange" event, then it triggers the javascript function, but passes only one value to the function and the same one value is available in the array also for me to parse in the page process.

I just put this javascript statement to check the value passed to the function.

alert(p_this.value) and it prints one value eventhough multiple values are selected.

could you please throw some light on this?

thanks for your time and help,

Surya

Vikas,

thanks. my problem is even with firefox, I'm getting only one value passed to the hidden item when I tried to access that item in the page process. In the process of debugging, then I put a alert statement in the javascript to see the value passed to the function after clicking submit button. but in the javascript also, only one value is returned, even though multiple values are selected in LOV. I think I'm mssing something, appreciate your help.

thanks,
Surya

Vikas,

I have created a sample page. The first query region contains the "empno" and "lov value". the second region is just a report to display the updated values after submitting the first region. as an example, I'm selecting the following values in LOV for testing

empno lov_value
7369 one
7499 one and two
7521 one, two and three

after selecting the above values in the first region and submitted, I'm picking the hidden value and written into the test_table in the page process. I was expecting the following values in the table in the format below, but all the three rows single value.

7369 one
7499 one:two
7521 one:two:three

http://apex.oracle.com/pls/otn
workspace:surya
username/password - surya_godavarthi@yahoo.com/testapp

page #4 in test application has the query region and the process

http://apex.oracle.com/pls/otn/f?p=17278:4

thanks for your help,
Surya

Vikas,

thank much. right, I should use g_f03. I was using g_f03 earlier and changed it to g_f02 for testing. Now, I found the main problem is HTMLDB version 2.2 which somehow does not like the javascript , may be missing some js functions?. the same page which is on APEX site with 3.0 does not work in HTMLDB 2.2 on my dev instance, but works fine 3.0 version on my test instance. I think it's something to do with the javascript funcion calls, could you please throw some light on this?

thanks,
Surya