Web Server PL/SQL Problem

From: Jason Ekamper <jasek_at_bigpond.com>
Date: Sat, 25 Sep 1999 00:51:02 +0800
Message-ID: <7sgabd$4ee$1@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 Received on Fri Sep 24 1999 - 11:51:02 CDT