Re: URGENT: htf.formselectoption() IN htp.tabledata()

From: <bonanos_at_yahoo.com>
Date: Wed, 22 Apr 1998 07:11:22 -0600
Message-ID: <6hkmpa$9b$1@nnrp1.dejanews.com>

Hi

> i need solution for this problem urgently, project hand in date
> approaching...
>
> how do i put this statements in htp.tabledata?
>
> for m in (select distinct (cMakNam) as cMakNam from maker order by cMakNam)
> loop
> htp.formselectoption (m.cMakNam);
> end loop;
>
> or any other way to generate selectOption from a database and put in
> htp.TableData()?
>
> thanks.

here is quick example

---

procedure emp_choose is

cursor emp is select * from emprec;

BEGIN

htp.htmlopen;
htp.headopen;
htp.title('Employee details');
htp.headclose;

htp.tableopen;

    htp.tablerowopen;

       htp.('<TD>');
          htp.p('Please select an employee:');
       htp.('</TD>');

    htp.tablerowclose;

    htp.tablerowopen;

       htp.('<TD>');

       htp.formopen('emp_show_details');
       htp.formselectopen('emp_name');
		FOR emprec IN emp loop
		htp.formSelectOption(emprec.name);
		end loop;
       htp.formselectclose;
       htp.formsubmit;
       htp.formclose;

       htp.('</TD>');

    htp.tablerowclose;
    htp.tableclose;

END; -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Apr 22 1998 - 08:11:22 CDT