i used your "creating a members area in ASP" codes but i have a big problem its is that when a user registers in my site, even the username entered is used and alresdy exist in the database table it registers the user and add the username and password in the database. how can i correct this problem pls help me

an indian  is looking for help pls help me in this matter

hi guys,

i have been at this for a few days now. at first i was getting:

That username is already in use. Please choose another

then i got smart and read-up on the forums and discovered that i needed to share the folder in which the testdb.mdb file was contained in.
now i get this new error:

- An error occured. -2147217900 : The INSERT INTO statement contains the following unknown field name: 'username'. Make sure you have typed the name correctly, and try the operation again

and this is what i have for that section in the register.asp:

     '// create the SQL
     strSQL = "INSERT INTO members ([username],[password]) VALUES " & _
        "('" & fixQuotes(Request.Form("username")) & "','" & _
        fixQuotes(Request.Form("password")) & "')"
     '// run the SQL
     objConn.Execute strSQL
     '// check for an error
     '// ATTENTION: this should be changed depending on the database provider
     If Err.Number = -2147467259 Then
         strError = "- That username is already in use. Please choose another<br>" & vbNewLine
     ElseIf Err.Number <> 0 Then
         strError = "- An error occured. " & Err.Number & " : " & _
             Err.Description & "<br>" & vbNewLine



is there anyone else out there with the same problem or who can help.......

please help......

Hi,

I'm been think or missing something! Can you please tell me where i create the ASP SCRIPT inc-dbconnection.asp? Is it frontpage or ms access? and what is the ms access script
Thank you

Have you actually got a field in the database table called username?

can anybody help me with the codes on a login/logout session in ASP to SQL database? I'm just a beginner on ASP so im having hard time tackling on the syntax but in logic i think I can handle.. pls....post it here or just e-mail me at karlmarx_37@yahoo.com
tanx everyone    

Hello . . . I'm using your script, and it works, but only temporarily.  Once logged in, I get sent back to my login page after a seemingly random sequence and number of clicks through my members only area.  Everything will seem to work well and I can navigate the members area fine.  Then all of a sudden the next click will send me back to the login page.  There's no consistency as to when or where or what link I click on to cause this.  It seems like the session info is being lost.  Have you heard of this before?  What can I do to squash this issue?  Any help would be greatly appreciated!  The code is really good except for this issue.

Thanks,

Justin

I didn't see anyone posted the problem I had, so I thought I could give some contribution.

Look at red highlighted word that I had to change in order for it to work:

'// create the SQL
     strSQL = "SELECT id,password FROM members WHERE id='" & _
        fixQuotes(Request.Form("username")) & "'"

Everything else seems to work good except I didn't use register.asp just yet.

Do you have the following in all of your members pages?

<%
If Session("loggedin") <> True Then Response.Redirect "login.asp"
%>

with the registration.asp there seems to be a problem some of the code appears on the page
"<%=Server.HTMLEncode(Request.Form("username"))%>"
this code appears on the text box area
can anyone help on why this is happening?

I really don't understand how to make the register form. Could someone send me their registration form?
My email is intellistar@gmail.com

thanks,
Gil

I don't understand where the ASP code goes.

Hi, I've never used ASP before and just want to create a members area where I can view the members and their attributes in a simple non-relational database, for my website that is being updated (freebets4all.com).

Can anyone tell me is this tutorial written for Microsoft Visual Web Developer Expresss Edition as it doesn't seem to follow.

Where do I write the first bit of ASP code on the preparation page. The closest new file I can create is an aspx file not asp file. Any help regarding this would be appreciated. To help you reply i am 2nd year uni computer science level.

Hi there
I'm new to asp and thought i'd start applyinh what I've been reading by using this tutorial. When I attempt to use login.asp or register.asp I receive the following error:

Microsoft JET Database Engine error '80040e4d'

Not a valid password.

/inc-dbconnection.asp, line 12

I am using an MsAccess 2000 database.
Does anyone have any clues?

Nathan

If I look at the page in Dreamweaver or similar I also see the code.  However, when it is uploaded to my web server it appears without the code.
Are you sure your web server can run asp?

Hi, being a bit of a newbee to ASP but am quite up to speed with SQL and some web development. I am struggling a little with getting to grips with what I need to do with some of the code. In the tutorial it says that on the registration form after inputting the html code that we need to put some ASP code in. I am using dreamweaver and have created a basic page and cannot see how I need to add the ASP code, am I answering my own question when I say that I should be creating a dynamic ASP page?