Aspmaker Web site Background production tools: column Rights Assignment

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

We are in the process of website construction, especially the government web site production, often encounter such problems, many columns to be assigned to different administrator management, administrators can only see, and modify the editor belongs to the scope of their own management of the column information. How do we make this function? Let me introduce

How to implement this function with Aspmaker.

The first step, the establishment of the background database, the other tables we do not explain in detail, here only a table is the administrator table. This table is specifically listed because you want to set a special field in the Table: Column permissions (LMQX). The chart of the table is listed below.

The second step, in Aspmaker to import the database, before a detailed explanation, not friends please see here http://www.muzisj.com/newview.asp?id=43

Step three, in Aspmaker, select the Administrator table (users), click the Column Permissions field (LMQX), select the CheckBox control in the field's Edit Tag option box, select the Use Lookup table option, and the right pop-up lookup The table option box is set as follows: Table Name:lm;linke Field:id;display field#1:lmmc. As pictured.

Step fourth, find the server events/client scripts option in Aspmaker, select the Other-user_loggingin, and add the following code to the left pop-up code, The value of assigning Administrator column permission field to the session.

' User Logging in Event
Function user_loggingin (usr, pwd)
If not ew_debug_enabled Then on Error Resume Next
' Enter Your code here
' To cancel, set return value to False
User_loggingin = True
Sql= "SELECT * from Users where usr= '" &usr& ""
Set Rs=conn.execute (SQL)
Do as not r2.eof
Session ("LMQX") =rs ("Lmqx")
R2.movenext:loop:set r2=nothing
End Function

Detailed setup as shown:

Fifth step, in Aspmaker, select the Tables/views shortcut button, in the Column table and content table in the Filter Options box to enter the code: ID in the session ("LMQX"), meaning in the column and news filter, Only tables within the administrator's purview can be seen and edited. Set the following figure in detail.

After the above five steps, you can implement in the background settings administrator can manage the column, after the administrator login, can only see modify delete their own rights in the columns and information.

木子鱼 Web Design http://www.muzisj.com hope this article will help the Web developers.