Passing one value in a formselectoption.

From: Craig Burtenshaw <crb_at_amsa.gov.au>
Date: Thu, 7 Mar 2002 15:36:12 +1100
Message-ID: <b7Ch8.38$V33.1302@nsw.nnrp.telstra.net>

Hi,

I have a drop down box in a PL/SQL Web Application. It gets it's information from two columns.
I only want to pass the first column into the next procedure. However the program wants to pass both columns.
The statement is

htp.FormOpen ('sartest.show_maintequip'); htp.FormSelectOpen('maint_location',' Select a Location from list: '); FOR loc IN maintequip_list
LOOP
/*
Passes both values of loc.location and loc.description to sartest.show_maintequip procedure as ONE value */
htp.FormSelectOption (loc.location||' -> '||loc.description,cattributes=>'maint_location="'||loc.location||'"'); END LOOP;
htp.FormSelectClose;

The show_maintequip procedure is
PROCEDURE show_maintequip (maint_location in VARCHAR2)

The value that get's passed for example is RC2262 -> Depot 1
SARB-DROPPED -> Depot 2.

I would only like to pass the first value.

Thank you in advance.
Craig Burtenshaw
Unix Systems/Oracle Database Administrator Australian Maritime Safety Authority. Received on Wed Mar 06 2002 - 22:36:12 CST