DevForce Community Forum : What is 1=0 there for? http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : What is 1=0 there for? Wed, 10 Jun 2026 07:38:16 -700 Tue, 24 Aug 2010 16:55:04 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2086 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ What is 1=0 there for? : OK, many thanks for that info. ... http://www.ideablade.com/forum/forum_posts.asp?TID=2086&PID=8168#8168 Author: agrogers
Subject: 2086
Posted: 24-Aug-2010 at 4:55pm

OK, many thanks for that info.]]> Tue, 24 Aug 2010 16:55:04 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2086&PID=8168#8168 What is 1=0 there for? : In DevForce Classic the (1=0)... http://www.ideablade.com/forum/forum_posts.asp?TID=2086&PID=8164#8164 Author: kimj
Subject: 2086
Posted: 24-Aug-2010 at 1:30pm

In DevForce Classic the (1=0) queries are issued to gather schema information at runtime. ]]> Tue, 24 Aug 2010 13:30:45 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2086&PID=8164#8164 What is 1=0 there for? : HiWhen we use the profiler to... http://www.ideablade.com/forum/forum_posts.asp?TID=2086&PID=8153#8153 Author: agrogers
Subject: 2086
Posted: 23-Aug-2010 at 6:51pm

Hi

When we use the profiler to view the query being sent to SQL Server there is an entry in the where clause that reads ((1=0)) as shown below.  What might be producing that?

select * from "dbo"."ReportCardSubjectCriteria" where (((Deleted = 0) AND UserAccessId IN (1,2)) and ((1 = 0)))

Thanks
Andrew
]]> Mon, 23 Aug 2010 18:51:38 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2086&PID=8153#8153