Re: PL/SQL and Oracle Webserver

From: <lbo_at_NOSPAM.iol.it>
Date: 1998/02/06
Message-ID: <34da6cbc.9533208@news.iol.it>#1/1

>I have the problem of not knowing exactly the number of parameters which
>will be passed to the pl/sql procedure, so I can not specify the
>procedure header which is going to process the request. Take for example
>the case where you use a multiple selection list box, where you don't
>know how many of them are going to be selected, so you can not write a
>procedure to process the request. Is there a solution other then writing
>a procedure for all of the cases?

oh my, I had the same problem and I'm so glad i solved it today!

so, you have to give all the checkboxes the same Name, say Langs.

this way the selected checkboxes will send their Value in an array.

say you have a form in which to choose a spoken language:

(now I don't remember the syntax to write a checkbox, sorry...)

... name="Langs" value="Italian"
... name="Langs" value="English"
... name="Langs" value="French"
... name="Langs" value="German"
... name="Langs" value="Spanish"

and say you choose Italian, English and German, your "array" will be composed of these three elements, and not, as I tought, true, true, false, true, false.

now you have to build a procedure that will catch this array after you submit it.

but pl/sql does not do arrays, right? but it can simulate them. now sorry but in this moment I just forget anything, it's very late. but tomorrow morning I'll repost from the office.

per rispondermi rimuovere NOSPAM. dall'indirizzo email to answer me remove NOSPAM. from email address

Received on Fri Feb 06 1998 - 00:00:00 CST