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


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

Original text of this message