Tornado - DB Login Problem

[paul mancuso]

There seems to be an issue with the Tornado DB login system.

I can successfully get it working if an email account string is exactly the length of the database field. e.g. field length = 35 of type char/nchar and the users email address is 35 characters long. If the email string is less then 35 it fails with an invalid email address message.
I'm using MS SQL 2000.

thanks, paul

[Frank]

post the exact error message.

FK

[Frank]

also... I assume that the problem is in the email password (forget password). Address stored on SQL2000. If length of address <> length of field then it'll fail?

FK

[paul mancuso]

Yes Frank, the length of the email address needs to be exactly the size of the MS SQL2000 field it is stored in.
e.g. field length = 35, email address = 35, the system works. If not, you get this error message.

(1105:77)Message
Invalid user email address

Transversely, if I tailor the field to the length of the email address, it recongizes the string as a valid address and sends the information.

paul

[Frank]

this is very strange.. I'll look into it..

Frank

[Frank]

Paul,
YOu are right... retriving the field of 35 nchar address returns a string padded with spaces... now it is fixed.

Apologize for taking so long... V0104+ will have the fix..


Frank