FP db results only returning before the space

The following is a snippet from a password validate page:

Set RS = Conn.Execute ("SELECT * From Users WHERE username =
'"&Request.Form("username")&"' AND password =
'"&Request.Form("password")&"'")

Do until RS.EOF
Pass = RS("password")
Name = RS("username")  'this is only returning Tom when the table field
contains Tom Campbell
acct = RS("account")
agt = RS("agent")
br = RS("brokerage")  'this is only returning Tom's when the table field
contains Tom's Realty
br_ph = RS("broker_phone")
RS.MoveNext
loop

RS.Close
Conn.Close

IF pass = "" Then
Message = "The Password you entered is either wrong or not found in our
database. Please press the BACK button and try again."
Else
Session("password") = Pass
Session("username") = Name
Session("account") = acct
Session("Brokerage") = br
Session("broker_phone") = br_ph
Session("agent") = agt

Any thoughts on why I can't seem to get info past the 'space' returned?



Tom Campbell
Select Signposts, Inc

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA