<% fp_sQry="SELECT * FROM Shippers" fp_sDefault="" fp_sNoRecords="" fp_sDataConn="Sample" fp_iMaxRecords=256 fp_iCommandType=1 fp_iPageSize=5 fp_fTableFormat=True fp_fMenuFormat=False fp_sMenuChoice="" fp_sMenuValue="" fp_iDisplayCols=3 fp_fCustomQuery=False BOTID=0 fp_iRegion=BOTID %>
ShipperID CompanyName Phone
No records returned.
<%=FP_FieldVal(fp_rs,"ShipperID")%> <%=FP_FieldVal(fp_rs,"CompanyName")%> <%=FP_FieldVal(fp_rs,"Phone")%>

TO ENABLE ASP SCRIPTS TO RUN
(this is AFTER you have installed the ASP and the ASP support for WebSite) (there are other ways this is MY way - the easiest way)

1. Install FrontPage extensions on the
web in which you want to run the ASP script
(this is because FrontPage will add the
access control entries so you need to only
find the existing entry and click the
"Run in NT user context" instead of
having to CREATE the entry and THEN
clicking the box :)

2. In website mapping CLICK the
ASP ROOT *FOR EACH FOLDER YOU
WANT TO RUN ASP SCRIPTS IN*
(For example:

a) the domain is foofoo.com.
b) in mapping I see "/foofoo/ is mapped to
"C:\website\htdocs\foofoo\"
c) I want to run an ASP script in
"C:\website\htdocs\foofoo\myaspstuff\"
d) so I ADD A mapping entry:
"/foofoo/myaspstuff/" is mapped to
"C:\website\htdocs\foofoo\myaspstuff\"
*AFTER I ADD THE MAPPING ENTRY*
I then click the ASP ROOT box in the
mapping dialog and hit APPLY (again).

3. Now go on over to
ACCESS CONTROL and find:
"\Foofoo\myaspstuff\" and click the
"Run in NT user Context" box
(there is no APPLY button -
as the warning box says
CHANGES ARE IMMEDIATE -
all this just means WebSite is a
well written piece of software that
doesn't waste time).

4. Depending on which version
of FrontPage extensions you are using,
make sure the directory is set to allow
"executables" (this should be the default -
using the FrontPage client make sure
you haven't disabled "scripts or executables").

5. You're done. NO THIS IS NOT HARD,
It's basically:

Add mapping, click the ASP root box
and Click "run in NT user Context".
Any ASP script placed in the directory
will work period.

*(If using FrontPage 2000 database Wizard
(that generates ASP pages that interface
with your ODBC (or ADO ect.) data source,
the ROOT of the web (for example /foofoo/
is the ROOT) must have the ASP ROOT
box checked in mapping because
FrontPage will place the Global ASA file
that is needed for the ODBC info in the
root of the web and if you want a file with
an ".asp" or ".asa" extension to run you
have to set up the directory according to
these instructions (or better ones available
in the WebSite Knowledgebase)

*(Since I'm already being overly "explanatory"
let me just say that M$ forces us for one reason
or another to install NT OPTION PAC 4.
Contrary to popular belief you can install it
*************** AFTER ************** you have
ASP 1.0 configured and running on WebSite.
AFTER you install NT Option Pac 4
**** ASP FOR WEBSITE WILL STOP WORKING ****
-----BUT---- After you reboot (and put IIS WebServer
on port 81 or/and turn it off using
Services in the Control Panel).
Simply install ASP 1.0 AGAIN (find the link on:

http://adefwebserver.com/frontpage ).
Then everything will work.

Hope this helps.