- Feature Articles
- CodeSOD
- Error'd
-
Forums
-
Other Articles
- Random Article
- Other Series
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
I think he meant "if else". I wonder if he thinks i.e. has that adversative meaning in general contexts, too.
Admin
Admin
Remy missed a trick here: ("that means", or "that is to say", i.e. "in other words")
which would have tickled my funny-bone.
Admin
The useless WHERE clause will evaluate to false if the column is null. So, it's actually "emp.BlaBla IS NOT NULL" written in a funky way.
Admin
The WHERE is stupid but it does do something, at least on SQL server it will filter out NULL values So it's the same as a WHERE emp.LawbaseCode IS NOT NULL
Admin
The WHERE clause might be the legacy of an optional filter parameter that was removed at some point. Perhaps it used to be something like
emp.LawbaseCode = ISNULL(@LawbaseCode, emp.LawbaseCode)
, where@LawbaseCode
was a parameter with NULL as default. This would return the records matching@LawbaseCode
if one was supplied, or all non-null records otherwise. Then somebody decided that filter was too restrictive and decided to just filter on the client side (the SQL client, not necessarily the application client side).Admin
Shouldn't this be in the "Coded Smorgasboard" category, rather than the "CodeSOD" category?
Admin
The site honestly has too many categories and the Smorgasbord isn't distinct enough from a CodeSOD, so I've mostly deprecated it for new articles.
Admin
I was about to suggest
| what "i.e." means (e.g. "that means", or "that is to say", or "in other words")
Admin
I remember working with someone designing an XML interface where he was prepared to give each subelement a unique sequential ID so that people wouldn't have to assume that XML preserves the order of elements... despite it always having preserved element order because that's critical for any sort of document that might be human readable. He'd worked out whole pages of documentation on how to do the issuing of the IDs correctly and to validate that they were sequenced, and we just thought "WTF!" and deleted it all.
Admin
Implementing Adobe Analytics was a nightmare. Never again.
Admin
For Adobe Analytics it seems to be a pattern:
description of what those fields mean. And there's also this gem:
Admin
OP for the confusing comment here.
What the comment meant to say is "if this is true the provided credentials will be encrypted [by the sender]; i.e. the provided credentials will not be encrypted [by us]"
Or maybe it was the other way around... who knows?
Admin
Doesn't its stand for "in effect"?
Admin
Like so many 2-letter acronyms in English, it is derived from latin: "id est". Other examples include e.g. , am, pm, ad, etc, but apparently not bc.