Tornado API Library - V12.30.08

z.dbLogin Property

Setup and activate Multi-User Login.

Product Version

EP, Gold
[VisualBasic]
PublicPropertydbLoginAsString
[C#]
publicstringdbLogin{set;}

Property Value

Obj.dbLogin="(;,)Type | Dsn | SQL | PassList | PassFile | TitleTxt | RejectTxt | FromAddr | EmailSubject | EmailBody | ChangePasswrodURL| SMTPserver| HelpButton| ForgotPasswordButton| ChangePasswordButton| LogoutButton"

KeywordDescription
TypePoorman(Def) or DB type user datasource.
DsnDSN source for DB type. DB holding user id and password.
SQL SQL=SELECT MyPassword, MyEmail FROM TABLE WHERE MyID = '[[ID]]'

e.g. MyPassword is the fieldname for Password and MyEmail is the fieldname for Email. and MyID is the fieldname for ID.

This is the SQL macro used to retrieve the password from the DB for login validation. You must have MyID, MyPassword and MyEmail fields in the login DB.

PassListList of id,password,email. Passlist=frank,kwong,frank@aspdb.com; John,Crombe,john@aspdb.com; ...repeat.

Delimier is the field delimiter.

PassFilePassfile=filename,<block>id,password,email list in a file within a block. You can assign different block/group od users for different application. Filename is physical filename. The reason is that you should place this password ascii file outside of the web environment for security purpose.
TitleTxtTitle text for the login box. Defaults to "Login"
RejectTxtCustom error message for login when name+pass is not valid. This message is sensitive enough that needs customization.
FromAddrIn order to implement Forgot Password, the is the "from" address of the dbMail.

e.g. FromAddr=frank@aspdb.com

EmailSubjectEmail Subject text. EmailBody=Your Forgotten Password
EmailBodyEmail Body Text.

EmailBody=Your password for [[LoginID]] is [[password]]

This text must contain the two [[macro tags]]

ChangePasswrodURLRedirect URL address. Change password involves local DB and policy management and is not covered by dbLogin. However, a Change Password button is furnished with couple with this redirect URL, you have enough to implement this task.
SMTPserverWhen you are developing in loaclhost mode, SemdMail will use your local SMTP server. You must specify the mail server when you deploy.
HelpButton(T/F) Default is True. When set to false, this button will not be displayed.
ForgotPasswordButton(T/F) Default is True. When set to false, this button will not be displayed.

Note: ForgetPasswordButton is not implemented. Images for this button is available. Use (add) this button to customize your own ForgetPassword.

ChangePasswordButton(T/F) Default is True. When set to false, this button will not be displayed.

Note: ChangePasswordButton is not implemented. Images for this button is available. Use (add) this button to customize your own ChangePassword.

LogoutButton(T/F) Default is True. When set to false, the Logout button will not be displayed. This is the case for a stand alone login in which the page security is not required.

QuickProp Keyword Abbreviation

li

Remarks

Example

<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim GD As New Tornado.GetData
Dim LOG1 As New Tornado.z
  With LOG1
    .dbQP = "U=50| S=gold| M=g!sys=t| Xf=0,1| D=Nwind.mdb| Q=Orders| Gdf=0,1,2,3|" & _
      " Th=tit=Single Access Login!Sub=Use asp/db; hello/world; John/Doe; Mary/Jane to login"
    Dim Li As String = "type=PoorMan|passfile=/bin/pass.txt,application1| titletxt=Tornado Login|"
    Li &= " FromAddr=frank@aspdb.com| EmailSubject=Your Password| Email Body=Your password for "
    Li &= "[[LoginID]] is [[password]]| SMTPServer=Your_SMTP_Server"
    .dbLogin = Li
    .ASPdbNET()
  End With
End Sub
</script>

See Also

z Class | Tornado Namespace | dbLoginTemplate | ASPdbLogin | ASPdbClearLogin | Special Topic - Login