macromedia.coldfusion.database_access
[Top] [All Lists]

Where clause in SQL server

Subject: Where clause in SQL server
From: "emmim44" <webforumsuser@xxxxxxxxxxxxxx>
Date: Fri, 25 Jul 2008 14:13:26 +0000 (UTC)
Newsgroups: macromedia.coldfusion.database_access

Hi all, 
 Can someone explain this to me in plain english? The line ' WHERE 1 = 2 '
 I am new to these concepts...

 <cfquery name="getTeam" datasource="#application.DSN#">
                SELECT  *
                FROM    CCFTeam
                <cfif this.team_id eq "">
                        WHERE   1 = 2
                <cfelse>
                        WHERE   CCFTeamID IN (<cfqueryparam 
cfsqltype="CF_SQL_VARCHAR" 
value="#this.Team_ID#" list="yes">)
                </cfif>
        </cfquery>


<Prev in Thread] Current Thread [Next in Thread>