ASP error indicates that the database has the username, but the query always shows that the username

if not or not then

This sentence seems to be right.

if not and not then

You have to check if you have that record in your database?

For two databases, you need to create a connection between the two databases, e.g. conn1, conn2 can be passed by asp variable:

1.Define a variable strname

2.Take the username from the first repository and assign it to strname3Connect to the second database (blog) and query whether the username referred to by strname exists, and if it exists, ** will be displayed.

Define the variable strname

strname =

Remove the username from library 1.

set rs = "select username from library a user table where ...

if not then

strname = rs("Username")

end if

If the username is not empty, query whether the user has if strname <>then from database 2

set rs = "select * from the user table where user='"strname &

if not then

userexists = true

elseuserexists = false

end if

end if

It is processed differently depending on whether the user is present or not.

if userexists then

end if

It's your own server. Set IIS and tick the parent path.

Is the database information imported on the server? Check whether the content of the user table on the local database is the same as that of the database on the server! Or maybe your foreground stage variables aren't separate from those in the background.

session("key", value); Save the object you logged in to in the value, and then give the session a name, which is the key, via the class object = (cast) session("key");Get the object! I hope to adopt.

After logging in, put the username into the session and save it. You can call session directly when other pages are displayed.

Or read the username in the database and display it.

After you have successfully logged in.

Open the data table for this logged-in user.

i.e.: set rs="")

select * from datatable where user field"Users:"&session("username")&"

Personality:"&rs("Gender field")&"

Users:"&rs("Other fields")&""

Set up a session when you log in

For example, session("id") = User ID

Then join on a different page.

if session("id")<>""then displays the user's information, rs("username")end if

You can display the user name, everything else can be displayed, you can filter it, it's best if you post your **, and the user's field.

It's simple, first build a database, contain the information you want to display, and then write **implementation, it's very simple.

Pls loginid""How do I write the format of the table name?

Answer: This table name is your own balance, casually, such as "gg", "xce" and so on.

dataset ds = "select ,,from wldw a,ht b where and '"loginid+"'xcexcexcexce");

Change it to this, because loginid is string, and the group movement is done with ' '