Databse - ASP str" command help needed

Sorry if I'm being a bit dense here but why are you making these changes?

strusername and strpassword are just variables, not asp commands.

The code that you've mentioned in your original post won't need changing if you change the column names on the database.

What you need to be careful of is to change anything that looks like rsCommon.Fields("username") to rsCommon.Fields("intAccessUserName"). Do the same as well for the password column.

I know that I have changed all tables setting in and for database.

I only need to know if I need to change those variables !

and what they do and what the str command stand for ?

I know - I know - And that’s just what I’m doing right now...

I only need to know this last thing about the "str" command

but okay - let me try to ask another way -

What does the line strUsername do in those lines:

'Read in the users details from the form
strUsername = Trim(Mid(Request.Form("name"), 1, 15))
strPassword = LCase(Trim(Mid(Request.Form("password"), 1, 15)))
blnAutoLogin = CBool(Request.Form("AutoLogin"))

'Take out parts of the username that are not permitted
strUsername = Replace(strUsername, "password", "", 1, -1, 1)
strUsername = Replace(strUsername, "salt", "", 1, -1, 1)
strUsername = Replace(strUsername, "author", "", 1, -1, 1)
strUsername = Replace(strUsername, "code", "", 1, -1, 1)
strUsername = Replace(strUsername, "username", "", 1, -1, 1)

I have not yet tested the changes - I’m changing the name of the variables for every instance of the variable within the code and changing it right now .