Environment variables in IDC files??

[Richard Cardona]

I received a set of IDC and HTX files for a demo, but I can seem to get
them to work.

One problem I'm having is that environment variables like REMOTE_USER and
REMOTE_ADDR are being used in the SQL query. I have my pages protected
with Basic authentication so those values are defined. So statements like
the following should work:

SELECT ... FROM table where username = '%REMOTE_USER%'

I know that <%REMOTE_USER%> and other environment variables _are_
evaluated in the HTX file, but what about IDCs??

I looked at 4 books on IIS, IIS 2.0 at the bookstore and there's no
'depth' with regard to IDC files and environment variables.

Interestingly, if I post the value of %REMOTE_USER% to a database via an
UPDATE I get a blank, so my guess is that they are not available. The HTX
files I have look like they came out of FrontPage, does anyone know if
FrontPage generates IDC files too?

I can also kludge REMOTE_USER into having a value by passing it as
argument to the IDC, e.g. url.idc?REMOTE_USER=test. Or pass it in has a
hidden form element, but I really want the environment variable.

please respond via e-mail, thanks,
Richard