session variable

L

L

I am using the DRW in Frontpage and I need to create a session variable as to
restrict access to other pages. I have tried several tutorials and such by
Microsoft but it doesn't seem to work. Can anyone help me establishing a
session variable and also adding the correct script on the protected pages?

fp_sQry="SELECT * FROM tblCompany WHERE (Username = '::txtUsername::' AND
Password = '::txtPassword::')"
fp_sDefault=""
fp_sNoRecords="Please enter a valid username and password."
fp_sDataConn="VAR_Admin"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue="
fp_sColTypes="&CompanyID=3&CompanyName=202&ContactName=202&ContactAddress=202&ContactCity=202&ContactState=202&ContactZip=202&ContactPhone=202&ContactEmail=202&ContactURL=203&Username=202&Password=202&"
fp_iDisplayCols=4
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
</font></b>
<p>
<font face="Verdana"><b><font color="#FF0000" size="2">
<%Session("Username")=cStr(fp_rs("Username")) %>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top