Re: Spaces after login id...

2003-07-08 Thread Matthew Schumacher
Gustavo, Use a database sting function to trim this data during insert. I use: lower(trim('%{SQL-User-Name}')) in postgresql but there should be something similar in mysql if that is what your using. schu Gustavo Lozano wrote: This one goes for the developers... When a user tries to login in

Re: Spaces after login id...

2003-07-08 Thread Keith Yoder
Gustavo Lozano wrote: This one goes for the developers... When a user tries to login in putting spaces after his login name it passes: Tue Jul 8 14:03:12 2003 : Auth: Login OK: [customer ] (from client 192.168.254.1 port 477 cli 55512345) I would suspect you're using MySQL. For some reas

Re: Spaces after login id...

2003-07-08 Thread Gustavo Lozano
here: > # > # Default is 'no' (don't remove spaces) > # Valid values = "before" / "after" / "no" (explanation above) > # > nospace_user = before > nospace_pass = no > > Omachonu Ogali > DialAssurance, Inc. > [EMAIL PROTECT

Re: Spaces after login id...

2003-07-08 Thread Omachonu Ogali
space_pass = no Omachonu Ogali DialAssurance, Inc. [EMAIL PROTECTED] (888) 524-2551 - Original Message ----- From: "Gustavo Lozano" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 08, 2003 3:43 PM Subject: Spaces after login id... > This one goe

Re: Spaces after login id...

2003-07-08 Thread Alan DeKok
Gustavo Lozano <[EMAIL PROTECTED]> wrote: > This one goes for the developers... > When a user tries to login in putting spaces after his login name it > passes: > Tue Jul 8 14:03:12 2003 : Auth: Login OK: [customer ] (from client > 192.168.254.1 port 477 cli 55512345) Which database are y

Spaces after login id...

2003-07-08 Thread Gustavo Lozano
This one goes for the developers... When a user tries to login in putting spaces after his login name it passes: Tue Jul 8 14:03:12 2003 : Auth: Login OK: [customer ] (from client 192.168.254.1 port 477 cli 55512345) So when the record go to the database it is stored like "customer " a