Simple Query 1

[JayKusch]

Afternoon,

this is more of an FYI on my part. have several stored procedures as well as queries that have been written not in stored procedures. i find ni most of the code the statment:

1=1

as in:

Select * from WhatEver
Where date_entered = '10/31/01' and
name = 'Johns' and
1=1


there are no fields, in any tables, that are named "1", so i am rather confussed. they do use a primary key on all tables that is numeric and seeded from 1 by 1. does this play into the 1=1 syntax?

thanks

 

[grahamm]

It's a trick used when SQL is embedded in asp/jsp/coldfusion pages. It allows the programmer to optionally add extra clauses preceeded with an operator without having to test if a clause is the 1st clause.

Searching

http://www.google.com

for 'sql tricks 1=1' came up with:

http://lists.evolt.org/archive/Week-of-Mon-20010219/150931.html

or

http://www.katungroup.com/coldfusionsqltips.htm

By itself (i.e. without optional clauses) it's not necessary. also, in the example you gave where there are preceeding required clauses (i.e. name='John') it's also not necessary.