| 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> |
|---|---|---|
| ||
| Previous by Date: | Re: Could not find the ColdFusion Component, GArlington |
|---|---|
| Next by Date: | Re: Where clause in SQL server, Ian Skinner |
| Previous by Thread: | User/table access issues, sk8save |
| Next by Thread: | Re: Where clause in SQL server, Ian Skinner |
| Indexes: | [Date] [Thread] [Top] [All Lists] |