[thelist] OT -- toronto holiday get-together

[rudy]

toronto evolt holiday get-together wednesday night 8 p.m. -- 
for details, see below


<tip type="conditional sql">
when generating exclusive WHERE conditions, avoid needless if/else testing 
by starting the WHERE clause with something guaranteed to be true --

     select foo from yourTable
        where 1=1

if no additional conditions are needed, i.e. selected by the user (imagine 
this query being dynamically tailored by user choices on a search form), 
then the above query returns the entire table

but when additional exclusive conditions are selected, you don't have to 
bother testing each one (to see if it's the first one which would've 
otherwise had to start with the WHERE keyword)

just generate each one with an AND keyword, tacking it on to the query so 
far --

     select foo from yourTable
        where 1=1
   <cfif userField1Checked>
           and dbColumn1 = '<cfoutput>#userField1Value#</cfoutput>'
    </cfif>
   <cfif userField2Checked>
           and dbColumn2 = '<cfoutput>#userField2Value#</cfoutput>'
    </cfif>

of course, if you are doing inclusive selection, you'll be generating OR 
conditions, in which case you want the WHERE clause to start with 
something NOT true

     select foo from yourTable
        where 1=0
   <cfif userFieldChecked>
           or dbColumn = '<cfoutput>#userFieldValue#</cfoutput>'
    </cfif>

</tip>



==================================
EVOLT TORONTO HOLIDAY GET-TOGETHER
==================================

WEDNESDAY DECEMBER 13   8:00 PM

C'EST WHAT, 67 FRONT ST E. (CORNER OF CHURCH)

http://toronto.com/E/V/TORON/0011/99/14/1.html

there are no reservations, so in order to find us, start at the bar (you 
won't have to go far) and look for the grey-haired guy in these photos --

   http://rudy.ca/codefest2.html