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

From: Jamadagni, Rajendra <rajendra.jamadagni_at_espn.com>
Date: Fri, 5 May 2000 08:49:48 -0400
Message-Id: <10488.105043@fatcity.com>

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

            htp.TableRowOpen;
               htp.print('<TD valign="top" rowspan="3">');
               -- First we should display list of networks
               htp.print('<SELECT  size=7 multiple name="net">');
               open cur_log;
               loop
                  fetch cur_log into rec_log;
                  if cur_log%found then
                     if rec_log.log_number_desc = '"** ALL NETWORKS **"'
then
                        htp.print('<option value="' ||
to_char(rec_log.log_number) ||
                                  '" SELECTED>' || rec_log.log_number_desc);
                     else
                        htp.print('<option value="' ||
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 .... Received on Fri May 05 2000 - 07:49:48 CDT