The mgiAuthenticateDB Tag QueryUser Mode Return to the mgiAuthenticateDB Main Menu Tag Syntax The QueryUser mode of mgiAuthenticateDB has two required parameters and three optional parameters. The tag form is: <mgiAuthenticateDB mode="QueryUser" username="Name" odbcDatasource="Source Name" odbcUsername="Name" odbcPassword="Password"> Required Parameters: mode - The mode is the function that the mgiAuthenticateDB tag performs. In "queryUser" mode, the mgiAuthenticateDB tag checks the authentication database for the existence of the specified username in any group. If the username exists in any group, the value "Yes" is displayed. If the username does not exist, the value "No" is displayed. username - The username is the unique login (i.e., name) to check. The username is case-sensitive. Optional Parameters: odbcDatasource (NT only) - The odbcDatasource is the name of datasource on the server that provides access information for an external ODBC database. If the odbcDatasource parameter is included, authentication information will be queried from the specified ODBC database rather than the internal MGI database. Inquire with the server administrator for additional information about the use of ODBC databases. If you include the odbcDatasource parameter, the odbcUsername and odbcPassword parameters are required. odbcUsername (NT only) - The odbcUsername is the username required to access the ODBC datasource. The odbcUsername parameter is required if you include the odbcDatasource parameter. odbcPassword (NT only) - The odbcPassword is the code required to access the ODBC datasource. The odbcPassword parameter is required if you include the odbcDatasource parameter. Example Usage and Output <mgiSet name="QueryResult"> <mgiAuthenticateDB mode="queryUser" username={mgiPostArgument name="Username"}> </mgiSet> <mgiIf lhs={mgiGet name="QueryResult"} relationship="equals" rhs="No"> <mgiAuthenticateDB mode="AddUser" username={mgiPostArgument name="Username"} password={mgiPostArgument name="Password"} group="Subscriber" emailAddress={mgiPostArgument name="Email"}> Thank you. Your username and password are now active. <mgiElse> Error: Your username already exists. Please use the "Back" button on your browser and choose another username. </mgiIf> The queryUser mode of mgiAuthenticateDB checks the uniqueness of a username against existing usernames in the authentication database. In this example, users entered a desired username, password, and email address in a form that posts to the page containing these mgiAuthenticateDB tags. The username is first verified to insure that it is unique using the queryUser mode of mgiAuthenticateDB. If it is unique, the username is added to the authentication database using the addUser mode of mgiAuthenticateDB, otherwise an error message is displayed. Return to the mgiAuthenticateDB Main Menu