I use a SQL format such as this:
SELECT
t1.id
,t1.firstname
,t1.lastname
FROM
table t1
LEFT OUTER JOIN table t2
ON t1.id = t2.id
AND t2.id IS NOT NULL
WHERE
t1.x = 1
AND
t1.deleted = 0
ORDER BY
t1.lastname
,t1.firstname
M!ke
-----Original Message-----
From: ColdFusion [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 06, 2007 8:54 AM
To: CF-Talk
Subject: CF Code readability (Where Clause)
How many use the query coding (where clause) as:
where
x = 1 and
Deleted = 0
OR
where
x = 1
and Deleted = 0
I prefer the second one as if I need to remove or simply comment the
line out for testing, I only do the one line rather than having the
comment tags skew over multiple lines?
Thanks for your input.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290453
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
