Re: PL/SQL/HTML how to question

"stephen O'D" <stephen.odonnell_at_gmail.com> wrote in message news:1134582581.310286.196530_at_g14g2000cwa.googlegroups.com...
> dennishancy_at_eaton.com wrote:
>> I have a PL/SQL package that displays an HTML form like the following:
>>
>>
>> name | approved?
>> ------------------
>> Allen | x
>> -----------------
>> Betty | x
>> -----------------
>> Chuck |
>> ------------------
>>
>> where the "x" represent a checkbox.
>>
>> When the user clicks OK, I need to update the approved field in my
>> table.
>>
>>
>> So many questions about how to make this work. Hoping it's simpler
>> than I am thinking it is.
>>
>>
>> If I try to refer to the form values in the table, it only gives me
>> those that have been checked. I was hoping to loop through all entries
>> on the table so I can update the unapproved records too.
>>
>>
>> Any advice on how I can accomplish this?
>>
>> Thanks.
>>
>>
>> Dennis
>> Eaton Corporation
>> Cleveland, O
>

i would assume you're using flexible parameter passing (name_array, value_array)?

you'll probably need to just check which fields come actual get sent to the procedure, looking for the existing of the check-box field rather than the value of the field

++ mcs Received on Wed Dec 14 2005 - 12:08:32 CST