There was an error when ASP checked if the username had been registered

if not and then

Upstairs is so fast. Explain the problem that the landlord added:

'Note that you have stopped the script running, so, (see below) end if

So the recordset here is not closed, then, two consecutive submissions of data, not is not valid.

if not then

It can't be written like that here. This sentence means that the end of the recordset is not reached.

Write it like this: set rs="")

sqlcheck,conn,1,1 here should be the keyset cursor if rs("count")>0 then""

end if

if not then

This sentence is problematic and should be changed to.

if not or not then

Use the query database, for example, select username from user where username = seawindzhk'

In this way, it is then determined whether there is a record or not, and if not, it can be registered. If you have, you can't register.

<%searchdata=request("key") 'Get the keywords you entered from the text box.

if trim(searchdata)="" then 'If there is no keyword input or only a space is entered, warning!

end if

If you want to be more perfect, use JS AJAX to implement it.

Level 2 and above users can upload images after logging in.

<%dim username,paswd

username = "Name field variable")

paswd = "Password field variable")

if username="abc" and paswd="123" then

else"end if

This ** doesn't seem to be a problem, I think the problem is that you made a mistake at or before you assigned the two variables usename and paswd!

You just need to make sure that your username or paswd is not equal to abc and 123 can be executed.

user=trim("txtuser"))

psw=trim("txtpassw"))

Look at the names txtuser and txtpassw in the form.

ZhujunABC's reply is wrong, txtuser and txtpassw are form input domain name words, which can be regarded as variables.

To solve this kind of problem, generally look at the sql1 structure first, directly output sql1 to see, and then execute this sentence directly in access, to see what situation feels that your sql1 has less spaces, try it like this:

1. Suppose there is a link after the username, and it's ** like the detection username.

2. You can determine whether the user exists or not according to the username value passed in on this page, and take other actions.

The username information should be followed by a button, right?

The action is set to the page you want to pop up to receive the text box information of the text box.

Then check the database for the existence of the username, if it exists – "Congratulations, you can register", otherwise "Sorry, this username has already been registered!" ”

I don't know how to implement hyperconnectivity, sorry.

%@language="vbscript" codepage="936"%>

set conn = "")

set rs = "")

dim username

username = "txtusername")if username <>"" thensqlcmd = "select * from registration information table where username='"&username&"'"

sqlcmd,conn,1,1

if then

msg="Congratulations! Username"&username&"Non-existent! Can be used! "

else temperr=true

msg="I'm sorry! Username

username&"Already exists.

end if

end ifmsg

I haven't used Excel to do a database.

Look at the program doesn't look like there's a problem.

You try it this way instead.

if and then

end if

end if

You add a bof and use it not too big.

And then I added an else

You said you made an error searching for a user you didn't have.

The reason for this is that the server has to explain it before it is sent to the client, so the JS here will not be useful.

It's over after you judge that there is no user in Changcong, and the following ** is not in the judgment, that is to say, although it has been judged that there is no such user, the program will still execute the following **.

Rot-resistant

If that doesn't work, maybe it's the difference between excel and a standard database.

if then

end if

No problem, but the above ** can be written directly without judgment.

strsql, objconn, 1,3 can also be changed.

strsql, objconn, 1,1

What's the problem? You didn't even write your question on it, did you?