login form problem [message #457678] |
Tue, 25 May 2010 11:10 |
purelove
Messages: 32 Registered: May 2010 Location: bahrain
|
Member |
|
|
hello every one,,,
well i had create a login form which contains 2 text-boxes and 2 buttons(- login & -exit)
the trigger when button pressed on login button is that:::
declare
cursor logon_cursor is
select usrname from student
where usrname = :USER_ID
and pass = :USER_PASS;
student_row logon_cursor%ROWTYPE;
BEGIN
:System.Message_Level := '25';
OPEN logon_cursor;
FETCH logon_cursor INTO student_row;
IF logon_cursor%FOUND
THEN GO_ITEM('student.usrname');
else
MESSAGE('Invalid username or password');
:USER_ID :='';
:USER_PASS :='';
GO_ITEM('USER_ID');
END IF;
:SYSTEM.MESSAGE_LEVEL := '0';
END;
well.,, i had also create a table "student" with 2 attributes
----usrname
----pass
please tell me whats the problem in that!!!
when i run the form and click on the login button ,it just clear the faild!!!!!!
|
|
|
|
|
|
|
Re: login form problem [message #457734 is a reply to message #457678] |
Tue, 25 May 2010 15:25 |
gregor
Messages: 86 Registered: March 2010 Location: Germany
|
Member |
|
|
1, remove: ":System.Message_Level := '25'; " it isn't nessary at this point. when I look up to your sources.
2. when " cursor logon_cursor " answers "No DATA FOUND"..
..... you said: "it just clear the faild!!!!!! " ... I think the cursor has nothing found,
|
|
|
Re: login form problem [message #457736 is a reply to message #457734] |
Tue, 25 May 2010 15:48 |
purelove
Messages: 32 Registered: May 2010 Location: bahrain
|
Member |
|
|
i had remove ":System.Message_Level := '25'
but nothing change!!
also i run the form in debug mode!!! also the same things>>>>well it's just clear the fields>>when the user name and pass is correct o incorrect it just clear it,without displaying any of the messages what i had write it!!!
so what do u thing..??where is the problem...!!???
|
|
|
|
|
|