Re: PL/SQL Problem - Urgent

You cannot force, the checkbox to have an unchecked value - this is a drawback of HTML forms.

But what you can do is to define the procedure that receives the submitted form such that the paramater that receives it is defined as null..

create or replace procedure p_receive_monday(i_monday in default null) is begin
htp.p('Parameter received '||nvl(i_monday,'Nothing')); end;

... or you could define the default as something else !!

--
regards

Jason
----------------------------------------------------------------------------
Jason Pepper
Snr Product Manager Enterprise Internet Tools
Oracle Corporation

Jason Ekamper <jasek_at_bigpond.com> wrote in message
news:7sgaac$4ed$1_at_news.cowan.edu.au...


> Having a bit of a problem with the following code. This is a checkbox for


> passing whether a resource is availible on monday or not.

>

> DECLARE BLOCK

>     MON varchar2(4):='';

>

> BEGIN BLOCK

>   htp.tablerowopen;

>   htp.tabledata('Monday', cattributes => ' width="77%"');

>   htp.tabledata(htf.formcheckbox('MON', cvalue => '', cchecked => MON),

> calign => 'left');

>   htp.tablerowclose;

>   htp.tableclose;

>

> PROBLEM DESCRIPTION

> Mon is then passed to another procedure. If user select monday, no

problems.


> If the user doesn't select monday, then the procedure fails. Overloading


not


> a problem, but there is 7 variables like this (Mon - Sun). I have tried an


> array etc but no luck.

>

> Is there any way to set the value of the checkbox to 'N' if the user does

> not select it, and set it to 'Y' if the user does select it?

>

> Any help much appreciated. Thanks

>

> Jason Ekamper

> Jasek_at_bigpond.com

>

>