NULL matching my displaygroup...
NULL matching my displaygroup...
- Subject: NULL matching my displaygroup...
- From: email@hidden
- Date: Wed, 17 Mar 2004 20:10:01 +0100
hi!
i am new to webobjects - sorry if this question is simple - but
i did not find anything in the documentation or on the web that helped
me.
i have a table in a mysql database that contains usernames and passwords
as CHAR.
i would like to use this for a login page.
i use a WODisplaygroup an connect username and password textfields
to the querymatches of the displaygroup like shown in many examples.
however, not only correct combinations of usernames and passwords
lead to matches after a qualifydatasource!
if one or both textfields are empty (null) they will match as well.
both fields empty matches EVERY entry in my table.
correct username but empty password matches the ENTRY with the matching
username.
not very good ;-)
wrong passwords or usernames lead to no matches as it should be.
i even used:
usersDisplayGroup.queryOperator().takeValueForKey("=", "username");
usersDisplayGroup.queryOperator().takeValueForKey("=", "password");
because otherwhise parts of passwords (tom instead of tomtom) would
also match.
i found no way to prevent empty textfields - nor a way to change the
qualifier
to NOT match nulls.
is this a mysql problem or is there something i missed?
how can i configure this so that only correct username/password
combinations generate a match?
thanks and regards
WONewbie thomas= new WONewbie("thomas"); ;-)))))
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.