Login error with CFIF statement

[n | d | a]

Hi all: I'm having trouble with a login CFIF routine. The following code
works fine when the login is TRUE, but when I try to login with invalid info
the CFELSE statement doesn't kick in and I end up with a blank action page
screen, rather than being redirected back to the login screen. I can't figure
out why the CFELSE is not kicking in...

....<CFELSEIF action EQ "login">

<CFQUERY NAME="qry_Login" DATASOURCE="#Database.DSN#">
SELECT Username, Password
FROM tblUsers
WHERE Username = '#Form.Username#' AND Password = '#Form.Password#'
</CFQUERY>

<CFOUTPUT QUERY="qry_Login">
<CFIF qry_Login.Recordcount EQ 1>

<CFSET Client.LoggedIn = "True">
<CFSET Client.UserName = '#Username#'>

<CFLOCATION URL="index.cfm?action=viewposts" ADDTOKEN="No">

<CFELSE>
<CFLOCATION URL="index.cfm?action=login" ADDTOKEN="No">
</CFIF>

</CFOUTPUT>

<CFELSEIF>....

[The Dagger]

Is this your login check form?

[The Dagger]

Maybe try:
<cfelse>
<cfinclude template="nameofloginform.cfm">
</cfif>

[Kronin555]

You're doing this:

<CFOUTPUT QUERY="qry_Login">
<CFIF qry_Login.Recordcount EQ 1>

<CFSET Client.LoggedIn = "True">
<CFSET Client.UserName = '#Username#'>

<CFLOCATION URL="index.cfm?action=viewposts" ADDTOKEN="No">

<CFELSE>
<CFLOCATION URL="index.cfm?action=login" ADDTOKEN="No">
</CFIF>

</CFOUTPUT>

Note that you have a cfoutput of the query in question over the whole cfif
test. If there aren't any records returned in that query, the cfoutput won't be
processed (because the query doesn't have any records).

Change it to:

<CFIF qry_Login.Recordcount EQ 1>

<CFSET Client.LoggedIn = "True">
<CFSET Client.UserName = '#qry_Login.Username#'>

<CFLOCATION URL="index.cfm?action=viewposts" ADDTOKEN="No">

<CFELSE>
<CFLOCATION URL="index.cfm?action=login" ADDTOKEN="No">
</CFIF>

Note that the <cfoutput query="qry_Login">, </cfoutput> is completely gone.