Error?

[wweidner]

Does anyone know why this would be giving me a runtime error? This is the line that it is saying has the problem.

Set recordSet=cn.Execute(sqlStatement),1,2

If you need to know more of the code just let me know and i will gladly provide it.

[wweidner]

ok here goes

"user_name"
text
field size (50)
Required (no)
Allow zero length (yes)
indexed (no)
Unicode Compression (yes)
IME (no control)
IME Sentence Mode (none)

"password"
text
field size (50)
Required (no)
Allow zero length (yes)
indexed (no)
Unicode Compression (yes)
IME (no control)
IME Sentence Mode (none)

That is everything in the database to those 2 fields. nothing about duplicating, i do know that it is being allowed because i have my name in the database 2 times from testing the page.

[wweidner]

Sorry for got something ...they are not in any other row

[Spooky]

"password" is a reserved word.
Use brackets as below so the drivers interpret it correctly.

INSERT INTO users (user_name, [password], first_name,

[wweidner]

Thank you ...that fixed it .....finally...now on to the next part of working on the site.
Again thank you all very much and for being patient with me.