Re: Getting the first value out of a string.

Hi Scott,

Yeah, but that only shows the location id in the pick list. I need to show both the location id and the description for that location.

But I only want to pass the location id to the next procedure.

Thanks for your input anyhow.
Craig.
"Scott Mattes" <ScottMattes_at_yahoo.com> wrote in message news:34Ph8.874$RB.289919_at_news1.news.adelphia.net...
> 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 - 21:56:45 CST