Re: Bugs again! Thanks!

From: L120bj <l120bj_at_aol.com>
Date: 1997/03/09
Message-ID: <19970309132801.IAA15089@ladder01.news.aol.com>#1/1

You've aliased the two columns as u_file_url and u_year, so these are the names you must use to reference them in the each_object record. ie        

htp.tableData(htf.anchor(each_object.u_file_url,each_object.f_co_name));

        htp.tableData(each_object.u_year);

---

---

Subject: Bugs again! Thanks!
From: Wingyu <im_hwyaa_at_stu.ust.hk>
Date: Sun, 9 Mar 1997 15:42:46 +0800
Message-ID: <Pine.SUN.3.95L.970309152937.1605A-100000_at_uststu5.ust.hk>

Hello all,

I found bugs again... how to fix them this time....

The message is .....

---

*

LINE/COL ERROR

-------- -----------------------------------------------------------------
19/4     PL/SQL: Statement ignored
19/41    PLS-00302: component 'FILE_URL' must be declared
20/2     PL/SQL: Statement ignored

20/28 PLS-00302: component 'YEAR' must be declared

---

*

and the program is .....

---

*

-- interface
create or replace package newchi2 is

procedure fyp_scna;
end ;
/
show errors

create or replace package body newchi2 is

procedure fyp_scna is

    cursor all_object is select f.co_id f_co_id,f.co_name f_co_name,c.co_id c_c$
u.year u_year,u.file_url u_file_url from firms f,FileUrl u,Co_bg c where f.co_name like 'A%' and f.co_id=c.co_id and f.co_id=u.co_id order by f_co_name;

 begin

 htp.bodyopen('http://imsu11.ust.hk:9000/ar/img/t2.gif');
 htp.p('The Companies with "A" as the first character:');
 htp.nl;
 htp.tableOpen('yes');
 htp.tableRowOpen;
 htp.tableData(htf.strong('Company Name'));
 htp.tableData(htf.strong('Year'));
 htp.tableRowClose;

 for each_object in all_object
 loop

        htp.tableRowOpen;

htp.tableData(htf.anchor(each_object.file_url,each_object.co_name));

        htp.tableData(each_object.year);
        htp.tableRowOpen;

 end loop;
 htp.tableClose;
 end; -- end of fyp_scna
 end newchi2;
/

---

*

Thanks!

Connie

                                                            ..::''''::..
                                                          .;''        ``;.
       Name => Ho Wing Yu, Wingyu                        ::    ::  ::   
::
 Department => Information and Systems Management, Yr 3 ::     ::  ::    
:: 
   Email => im_hwyaa_at_stu.ust.hk                      :: .:' ::  :: `:.
::
            wingyu_at_susis.ust.hk                      ::  :          : 
::
     URL => http://home.ust.hk/~im_hwyaa              :: `:.      .:'
::
               				                  `;..``::::''..;'
                                                            ``::,,,,::''
 

   --`--,{@ --`--,{@ --`--,{@ --`--,{@ @}`--,-- @}`--,-- @}`--,-- @}`--,-- Received on Sun Mar 09 1997 - 00:00:00 CST