Re: Getting the first value out of a string.

Have you tried changing

htp.FormSelectOption (loc.location||' -> '||loc.description,cattributes=>'maint_location="'||loc.location||'"');

to

htp.FormSelectOption
(loc.location,cattributes=>'maint_location="'||loc.location||'"');

/???

"Craig Burtenshaw" <crb_at_amsa.gov.au> wrote in message news:uDBh8.34$V33.1034_at_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 Thu Mar 07 2002 - 13:20:31 CST