Re: populating years in a drop down menu in PL/SQL

> CURSOR inst_years IS
> Select 1979+rownum "MyYear"
> from all_objects
> where rownum < extract(YEAR from sysdate)-1979+1;
>
>
> htp.p('<TD>');
> htp.formSelectOpen('p_inst',NULL,'1');
> htp.formSelectOption('Not listed',NULL,'VALUE=XX');
>
> FOR year_rec IN inst_years LOOP
> htp.formSelectOption(year_rec.MyYear,NULL,
> 'VALUE=' || year_rec.MyYear);
> END LOOP;
>
> htp.p('</TD>');
>
> It doesnt work when I do that. If I comment out the "For loop", it
> doesnt give me an error atleast. Would you know what is wrong ?
>

This is just a shot in the dark as I have never used htp... but the column name could be causing you an error ("MyYear" <> MyYear). Could you try to remove the double quotes, and use upper case for the column name, in the cursor definition and the FOR loop; CURSOR inst_years IS
 Select 1979+rownum MYYEAR

    from all_objects
   where rownum < extract(YEAR from sysdate)-1979+1; and
htp.formSelectOption(year_rec.MYYEAR,NULL,

                                'VALUE=' || year_rec.MYYEAR);