Zzz
|
| Posted: 06/27/2002, 1:36 AM |
|
I am trying to use my members_ID field as the login field as well. but i can't use it for some reason.
I have 3 fields in a table members_id(autonumber) members_name Members_pin
when i define members__id as primary key , members_name as login field and members_pin as password login works and let me login.
but if i use members__id as primary key , members_id as login field and members_pin as password it never let me login.
Please Help
|
|
|
 |
Zzz
|
| Posted: 06/27/2002, 5:57 PM |
|
AnyONE ?????????
Comon Guys i am depending on YOU
I am trying to use my members_ID field as the login field as well. but i can't use it for some reason.
I have 3 fields in a table members_id(autonumber) members_name Members_pin
when i define members__id as primary key , members_name as login field and members_pin as password login works and let me login.
but if i use members__id as primary key , members_id as login field and members_pin as password it never let me login.
Please Help
|
|
|
|
Sachaski
|
| Posted: 06/28/2002, 6:15 AM |
|
do you have an extra underscore '_' in your query?
In your posts, which perhaps you have used a cut and paste from your code (just a guess) you talk about both:
members_id
members__id
Hope it's as simple as that!
|
|
|
|
CodeCharge Support
|
| Posted: 06/29/2002, 2:18 AM |
|
Solution for CodeCharge:
if you want login field to be of numeric type, create Custom Login event, find the line like:
bPassed = CLng(DLookUp("employees", "count(*)", "employee_id =" & ToSQL(sLogin, "Text") & " and pass=" & ToSQL(sPassword, "Text")))
and modify sLogin type:
bPassed = CLng(DLookUp("employees", "count(*)", "employee_id =" & ToSQL(sLogin, "Number") & " and pass=" & ToSQL(sPassword, "Text")))
|
|
|
|
|
