Cursor on a PopUp WIndow
From: Patrice Fiset <pfiset_at_capitale.qc.ca>
Date: 2000/06/08
Message-ID: <H9T%4.19865$NS6.265588_at_news.globetrotter.net>#1/1
Date: 2000/06/08
Message-ID: <H9T%4.19865$NS6.265588_at_news.globetrotter.net>#1/1
I declare a cursor. then I have an image that when you click on this image it makes a popup window to open, on this window, I have a selectname and I make a loop that reads the informations on the database, so each options are a row. When I compile, I have no errors, but when I click on the image, the browser tell me that there's an error on the page. If I right click on the page to see the source, I actually see all the information I want but there's a error that just prevent the popup window to actually popup!
Here's the source:
create or replace package body TEST is
procedure prc_form_emplr
is
CURSOR cr_select_resp IS
select resp_refcontact, resp_lname, resp_fname
from cocf_tbl_respn
order by resp_refcontact;
begin
htp.htmlopen;
htp.headopen;
htp.title('Employer Section');
htp.p('
<Script Language="javascript">
function popUp()
myWin= open("", "displayWindow", "width=400,
height=450");
// open document for further output
myWin.document.open();
// create document
myWin.document.write("<html><head><title>Acronym");
myWin.document.write("</title></head><body>");
myWin.document.write("
<SELECTNAME="gr_contact" SIZE=3 MULTIPLE>');
for v_resp IN cr_select_resp loop
htp.p(' <OPTION> '|| v_resp.resp_refcontact ||' - '||
v_resp.resp_lname
||' ' || v_resp.resp_fname);
end loop;
htp.p(' </select>"); ');
htp.p(' myWin.document.write("</body></html>");
// close the document - (not the window!)
myWin.document.close();
}
</Script>
');
thx Received on Thu Jun 08 2000 - 00:00:00 CEST