Yes, thats it! And I always mention also "Don't forget to use "Tab" instead of "Space"!" ;-)
Ben Nadel wrote: > Chris, > > I am ALLL about the white space: > > SELECT > t1.id, > t1.name > ( > ISNULL( t1.foo, '' ) > ) AS foo > FROM > table1 t1 > INNER JOIN > table2 t2 > ON > ( > t1.fid = t2.id > AND > t2.date_createdd IS NOT NULL > AND > t2.id IN > ( > SELECT > b.id > FROM > bar b > ) > ) > WHERE > t1.id IN ( 1, 2, 3, 4, 5 ) > AND > ( > 1 = 0 > OR > (t1.id % 2) = 1 > ) > ORDER BY > t1.id ASC, > t2.id ASC > > > > Maybe this is totally crazy, but to me the indentation makes it look > VERY OBVIOUS. Granted I am used to reading it but it is super easy for > me to look at it and see how things are related (grouped together with > parens, AND'ed OR'ed, sub query , etc). > > > ...................... > Ben Nadel > Certified Advanced ColdFusion MX7 Developer > www.bennadel.com > > Need ColdFusion Help? > www.bennadel.com/ask-ben/ > -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ OÄuz Demirkapı TeraTech Inc. | Senior Developer 405 East Gude Dr Suite 207, Rockville, MD 20850, USA Voice: +1 (301) 424-3903 ext 111 | Fax: +1 (301) 762-8185 Web: http://www.teratech.com | E-mail: oguz.demirkapi <AT> teratech.com Winner in CFDJ awards Best Consulting. Member Team Fusebox. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271170 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
