RE: Drop-down box in PL/SQL? (kinda long!)

From: Jay Hostetter <jhostetter_at_decommunications.com>
Date: Fri, 05 May 2000 13:17:03 -0400
Message-Id: <10488.105088@fatcity.com>

I see that I am not the only person that just puts the html code directly = into an htp.print! I got tired of looking up the syntax of every little = htp procedure for the corresponding html tag.

Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA

>>> "Jamadagni, Rajendra" <rajendra.jamadagni_at_espn.com> 05/05/00 10:01AM =
>>>

This is what I do .....
<sample>

            htp.TableRowOpen;
               htp.print('<TD valign=3D"top" rowspan=3D"3">');
               -- First we should display list of networks
               htp.print('<SELECT  size=3D7 multiple name=3D"net">');
               open cur_log;
               loop
                  fetch cur_log into rec_log;
                  if cur_log%found then
                     if rec_log.log_number_desc =3D '"** ALL NETWORKS **"'
then
                        htp.print('<option value=3D"' ||
to_char(rec_log.log_number) ||
                                  '" SELECTED>' || rec_log.log_number_desc)=
;
                     else
                        htp.print('<option value=3D"' ||
to_char(rec_log.log_number) ||
                                  '">' || rec_log.log_number_desc);
                     end if;
                  else
                     exit;
                  end if;
               end loop;
               if cur_log%isopen then
                  close cur_log;
               end if;
               htp.print('</select>');
               htp.print('</TD>');
            htp.TableRowClose;

</sample>

In my case I allow them to choose multiple values that's all. One with SELECTED is the one that gets highlighted ....

HTH
Raj
--=20
Author: Jamadagni, Rajendra
  INET: rajendra.jamadagni_at_espn.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri May 05 2000 - 12:17:03 CDT