|Subject||RE: [firebird-support] Help with query, bit confused|
> Yeah, I need to also include anoter identifier there likeBeing a primary key in completely irrelevant. You've got three values in an
> login_name='joe' had played with that as well, same results.
> Here is a corrected version.
> SELECT COUNT(STATUS) FROM CONTACT_LOGIN_LOG
> WHERE LOGIN_NAME='joe' AND STATUS='Failed' AND LOGGED IN (
> SELECT FIRST 3 LOGGED FROM CONTACT_LOGIN_LOG
> WHERE LOGIN_NAME='joe' ORDER BY LOGGED DESC);
> Being that LOGGED is a primary key, I thought having the
> login_name was
> redundant or unneccessary?
'IN' condition. Nothing more than that.
>Fwar. There's a lot of tests for that! There might be a simpler way...
> > Can you re-describe what you actually want it to give you,
> and we'll see if
> > we can recommend a query.
> > If you want the last three failed logins:
> I want to know the number of failed logins based on the last
> 3 attempts.
> So if 2 failed login attempts, I want 2. 3, 3, 1,1.
Are you using this for a system that does the following:
"Welcome back, mr. <surname>. There have been three(3) unsuccessful login
attempts since you last logged in."