OWS - using cgi env vars
From: Mark Aurit <mark_aurit_at_mail.northgrum.com>
Date: 1997/12/22
Message-ID: <01bd0f30$825b24a0$3d846380_at_NGW20072982.dssd.northgrum.com>#1/1
Date: 1997/12/22
Message-ID: <01bd0f30$825b24a0$3d846380_at_NGW20072982.dssd.northgrum.com>#1/1
I have some logic in a procedure that looks something like the below, where
I want to use the value of SERRVER_PORT in a query (Im using 'SERVER_PORT'
until I can start using "REMOTE_USER').
owa_util.print_cgi_env says that SERVER_PORT is 3333. When
my where clause is
WHERE sel_vendor_cd = '3333'
I get a valid query in the browser. But using SERVER_PORT the browser conks
out with a "Request Failed".
HELP!!!!
Thanks, Mark
mark_aurit at mail.northgrum.com
CURSOR cur_pohdr IS
SELECT purchase_order_nb FROM vwapo_base WHERE sel_vendor_cd = owa_util.get_cgi_env('SERVER_PORT');
htp.print(purchase_order_nb); Received on Mon Dec 22 1997 - 00:00:00 CET