Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: accessing multiple values from an html form multi-select box

Re: accessing multiple values from an html form multi-select box

From: Daniel Askey <daniel_at_www.ecsinc.net>
Date: 1998/01/14
Message-ID: <34BD564F.D23E3B66@www.ecsinc.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US