Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Getting the first value out of a string.
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:02:32 CST