Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: accessing multiple values from an html form multi-select box
Try using arrays (pl/sql tables) as the "in" parameter of your procedure
for each multiple select.
Note: checkboxes may need special handling also.
Multiple select boxes return a name=value pair for each selection
Checkboxes return 0 if not checked or 1 name=value pair when checked
Also note: the same method might be used to handle multiple form objects with
the same name
I haven't tested this out yet, so good luck.
Daniel Askey
Todd Hale wrote:
> If I have an html form with a SELECT box with MULTIPLE select turned on, how
> do I access these multiple items in the PL/SQL procedure that receives them?
> When I use VARCHAR2, I only see the first item. But, if I force an error page
> (wrong procedure name in the form 'action'), I can see that multiple values
> are being sent. (I have the error level bumped up on the server to help with
> debugging.)
>
> Any help would be greatly appreciated!
>
> Todd Hale --> dolthead
Received on Wed Jan 14 1998 - 00:00:00 CST
![]() |
![]() |