Forgot your password?
User Journal

Journal: Fun with SQL Server 2012 6

Journal by Marxist Hacker 42

I have a Table Valued Function that returns a simple parameterized view. I want to turn that view into a string.

Can anybody tell me why the first query works and the second one doesn't?


SET @JobID=2861

SELECT @strOut =Coalesce(@strOut +',','')+ ISNULL('[' +
MP.ModelPointName + '] int', 'ErrorInFactoryModel int')
FROM (SELECT TOP 800 ModelPointName, Sequence
      FROM dbo.GetReferencedModelPointsByJobID(@JobID)
      ORDER BY Sequence) MP
WHERE NOT (MP.ModelPointName LIKE '%Ship%'
        OR MP.ModelPointName LIKE '%Scrap%')

PRINT @strOut

SET @strOut=NULL

SELECT @strOut =Coalesce(@strOut +',','')+ ISNULL('[' +
MP.ModelPointName + '] int', 'ErrorInFactoryModel int')
FROM dbo.GetReferencedModelPointsByJobID(@JobID) MP
WHERE NOT (MP.ModelPointName LIKE '%Ship%'
        OR MP.ModelPointName LIKE '%Scrap%')
      ORDER BY Sequence

PRINT @strOut

The 2nd one returns a single field name, the first, returns all the field names.

User Journal

Journal: Trying to remember a conspiracy theory 6

Journal by Marxist Hacker 42

Back in the early 1990s, when CD Roms were first invented, on major use of them was for the conspiracy dial up bulletin board system. With a CD Rom online on your bulletin board, you could "host" a CD full of downloadable text files on everything from government cover-ups to UFOs.

I was into such things at the time, and read many of these files.

Fast forward to today- and Pope Francis gives us a conspiracy theory: that rich first world nations are promoting war in the third world as a prop to economics. All over the first world Catholic blogosphere, there is outrage- how dare the Pope tell us capitalism is supported by warfare?

Of course, Dwight Eisenhower, upon leaving the U.S. Presidency said the same thing,- warned us about the military industrial complex.

But I seem to remember a "secret" document passed around those old BBSs from the Vietnam Era that basically said the same thing, only actually recommending it as a policy. Does anybody else remember this document? Can you remember something I can google on? I'm coming up empty.

User Journal

Journal: Which is more dangerous, theology or ideology? 15

Journal by Marxist Hacker 42

This article insists that for human beings, belief is not optional. There are two basic types of beliefs- religious theology and political ideology- but all human beings, even atheists, have some form of belief.
  A study of war would seem to indicate that the 20th century clearly showed that ideology is more dangerous than theology, but since fighting for religion has never really gone out of fashion, what do you think?

User Journal

Journal: A geeky theory 8

Journal by Marxist Hacker 42

The multiverse theory is as falsifiable as God himself. Therefore, I have a theory of sociology- that anybody believing in the multiverse has simply fallen for a new religion created by comic books and bad science fiction.

User Journal

Journal: REPOST: Brandon Eich 20

Journal by squiggleslash

(One last edit. After constructive criticism of my style from JC I'm going to lead this with a quote from a part of a post I made previously that sums up why Eich was unsuitable to be CEO without all the "It's not about X", "Hate campaign", and other stuff that is totally right but makes it all TL;DR. Original post after the -----, you don't have to read it any more)

It's not about what you think, it's about how you treat other people and how you deal with being, quite legitimately, associated with a set of actions (whatever the motive) that many find offensive. We would not be here today had Eich not, two years ago, thought this was a good thing to write:

Second, the donation does not in itself constitute evidence of animosity. Those asserting this are not providing a reasoned argument, rather they are labeling dissenters to cast them out of polite society. To such assertions, I can only respond: no.

about people who might possibly think he has animosity about gays because he donated, twice, totalling $1,000, after it became obvious what the nature of the campaign was, to an organization that repeatedly ran TV ads claiming married homosexuals were a danger to children.

That was a particularly dumb thing to write. It's something most of us feel sometimes when we're under attack, but that's kinda why the job of CEO doesn't go to just about anyone. There are so many useful positions Eich could have gone to, why-oh-why did they make him CEO?


(Just three additional notes: First, I've reposted this because the original was open to everyone, and it turned out the same illiterate idiots who've insisted that questioning Eich's handling of revelations of his donations to an active hate campaign is the same thing as wanting him fired for his opinion are now trolling my journal. So, regretfully, I'm deleting the old JE. Second: this was originally written before Eich resigned. Some minor updates since this was originally published: additional line about "what Slashdotters believe", and removal of comment about other Mozilla board members resigning as this appears to have been misrepresented by media. Finally: actually the situation is worse than described below. In the below I presumed Eich hadn't known exactly what he donated to, thinking it was a generic pro-Prop 8 campaign. It turns out Eich knew it was a hate campaign before he made his donations. This significantly changes the relevence of "Strike 2" below.)

Let's get a few things out of the way first.

There is no issue with Eich's private views, and to a certain extent even his opposition to "gay marriage", however backward and unreasonable such a position might be. It is not about whether he supported Prop 8, whether his name appeared on any petitions in favor of it, or whether he voted for it - again, however unreasonable and backward and pathetic such a position might be.

The problem is this.

I remember the pro-Prop 8 campaigns. Those campaigning for Prop 8 did not focus exclusively on a small set of arguments focussed entirely on some kind of practical, or even religious, argument in favor of Prop 8.

The campaigns themselves were, objectively, homophobic and bigoted. They smeared. They lied. Dog whistles about "protecting our children" (couched with plausable deniability type justifications along the lines of "If it doesn't pass, children will think gay marriages are normal" - uh, right..) were common, as one obvious example.

And Eich donated money to that.

And having basically co-funded a campaign whipping up hate against 5-10% of Mozilla's workforce, he's now in charge of them.

That's strike one.

Strike two is that he's never acknowledged that this was ever a problem. My reading, both of his 2012 "explanation" (which lacks any justifications, it's more a "Don't call me a bigot, you're a bigot" type piece of crap we usually hear from right wing nuts caught with their heads in white hoods) and his current "Let bygones by bygones, of course I'll be nice to the gheys that's Mozilla policy!" comments) is that he's pointedly refused to distance himself from the campaigning he co-funded. No "I never had any problems with gay people and I was disappointed to see how the funds I donated were used", let alone support for groups combatting homophobia.

So... what happens next?

Firefox is Firefox. It's the world's best browser, albeit one that has suffered many knocks over the last few years both with its well documented issues with memory and reliability, and the user interface changes that continue to blur the line between it and its competitors. People aren't switching from Firefox to Chrome because they want Chrome for the most part, they're just switching because Firefox is becoming Chrome anyway, leaving no compelling reason to stick with it during the periods Firefox is especially unstable.

A political boycott of the browser is unfortunate and I'm not entirely sure it would be effective. At the same time, there's a feeling of powerlessness one has a result of this.

Moreover, there is an education problem within the community that's obvious from reading and engaging in the discussions on the subject. The same points come up over and over again:

- The equation of Eich's personal views with his public actions, as if all public actions have a shield if they're rooted somewhere in a personal view somewhere, no matter how slimy or despicable.
- The assumption that criticism of generic support for Prop. 8 is the same as criticism of specific campaigns for Prop. 8 that were objectively hate campaigns, with many refusing to believe any of the campaigns that were pro-Prop 8 contained hate propaganda.
- The failure to recognize that necessary and required qualifications for leadership include a requirement that mutual respect should exist between leader and lead.
- A failure to recognize the special role of a CEO within an organization
- An obsession with supporting those accused of homophobic actions because of some perceived disagreement with "Political Correctness", regardless of context.

I have a gut feeling that if Eich had donated $1,000 to a campaign calling for the re-enslavement of blacks, a campaign which used dog-whistles like "Welfare" et al, we'd still be having this conversation. Really. I do.

Eich is, objectively, not qualified for the Mozilla CEO job. I know some people say "Well, look at all his other qualities", and I'm sure they're right and great and all, but a blind man can know the rules of the road and the layout of New York City like the back of his hand but I still wouldn't want him driving a bus there. It is difficult to get good people some times, but you have to be patient. Good CEOs need to be good figureheads, they need to be respected inside and outside the organization. Eich isn't. Maybe one day he will be.

User Journal

Journal: Brandon Eich knew he was funding a hate campaign. He did it anyway. 1

Journal by squiggleslash

I had sympathy for Eich, despite wanting him to exit the Mozilla CEO position. We're a community of people with no social graces and the idea that someone might end up having their career choices limited beause their lack of human interaction skills - or so I thought - seemed depressing and obvious. To recap, Eich's stone-age views on equality weren't what bothered me so much as his failure to adequately handle the consequences of $1,000 in donations to an actual hate campaign.

That evaporated today. Eich knew exactly what he had donated to before he made the donation. Here's the link. And here's the money quote:

This is the campaign to which Eich contributed. It's proper to note that his two donations of $500 each came on Oct. 25 and 28, days before the Nov. 4 vote and well after the style of the TV campaign was established.

Quoting Eich, defending himself in his "I'm not a bigot, you're a bigot, so there, I win" post of 2012: (My bolding)

Second, the donation does not in itself constitute evidence of animosity. Those asserting this are not providing a reasoned argument, rather they are labeling dissenters to cast them out of polite society. To such assertions, I can only respond: âoenoâ.

If deliberately, intentionally, funding a campaign that calls gays and gay marriage a danger to children isn't evidence of animosity against gays, what the hell is?

It had been my previous position that Eich had simply mishandled the situation. He'd obviously made some donations, but I'd assumed he was telling the truth in claiming there was no animosity or homophobia on his part. I reconciled the two by assuming he didn't know that the funds he donated would be used in the way they were. I criticized him for not distancing himself from the campaign he donated to after it became apparent it was a hate campaign, not simply a pro-Prop 8 campaign. I said this was evidence of poor judgement.

This appears to have been a mistake on my part. The truth appears to be uglier.

User Journal

Journal: Depressing 4

Journal by squiggleslash

So you argue X. You make it clear your view is X, and not Y. You explicitly and repeatedly distance yourself from position Y as it's not what you believe. You explain X in clear detail and how X works.

ALL the responses to you start with the position that you're arguing Y. I'm modded through the floor long before I can get responses out pointing out that they're arguing against strawmen.

I'm losing faith but I don't know what in. Is it me, is it them? Part of me thinks "Well, I must be not explaining this well enough", but...

Genuinely asked for help here. Got kinda an answer, but it only semiexplains the whole thing. Getting the impression people read one phrase in my comments and once they've read it they completely switch off and ignore everything before and after it, including the explanation of why I'm using that phrase.

This may or may not be true, but if you can't call a spade a spade because people think you're talking about coffee grounds (OK, it's early in the morning and I'm tired), then how the hell do you proceed and explain that the problem starts with an actual fucking spade, not vaguely related pile of coffee grounds?

User Journal

Journal: Usability issues with Android, also trying to work around them 3

Journal by squiggleslash

While for the most part, I'm liking Android as a tablet system, I'm increasingly frustrated with it as a phone. By that, I mean I want to be able to use my phone as, well, a phone. Hindering this are several issues:

- My Galaxy Nexus really doesn't understand the necessity of prioritizing voice quality over data availability when I'm on a call. As a basic example, it recently switched, mid-call, from a 2GSM tower with five bar coverage to a UMTS tower with no bars (yes, no bars, which is one above no signal), with the result that my wife couldn't hear a thing I said, and I could only hear "Hello? Hello? Are you still there?" That's an example, the reality is it pulls this shit all the time, and the only way to actually make it reliable is to, well, switch it to 2G-only mode...
- Voice dialing has gone from merely "attrocious" to "what the f--- are they thinking?" over the last few years. Here's a brief history:

1. Google's first attempts actually involved listening to you say who you wanted to call, and then presenting a list of possible interpretations on the screen, requiring you to select, by viewing the screen and using your finger, which one you wanted. Pointless.
2. They semi fixed it, though it was far from reliable, and went in the wrong direction, going ahead with a call without any chance to confirm or easily cancel the operation.
3. At various times they tweaked it, usually breaking something in the process. At various times we've had confirmations. At other, none.
4. They then added Google's patented "You don't want few relevent results, you want as many irrelevent results as possible" feature that has made their search engine such a joy to use in recent years - not. Result, if I call my wife by her nickname, which is how she's listed in my phonebook, it'll translate the nickname into a full name (ie "Trish => Patricia", "Art => Arthur", etc) and then list everyone with that first name asking me who I wanted to call. And then, to add insult to injury, it doesn't recognize my answer ever and ends the session, requiring I go through the entire process again, and again, until I give up. To date, I have not successfully placed a call using the voice calling feature since it was implemented.

Stage 4 is so bad that I actually did something dramatic, I disabled the Google Search app (which is the only way to disable voice dialing) on my phone. Why? Because I didn't want the risk I'd be tempted to use it when driving. Being frustrated by something that isn't road related when you're driving is dangerous.

So... thinking of switching to a tablet/feature phone combination. To do this, the tablet needs T-Mobile data capabilities or else the phone needs some kind of Wifi or similar tethering. I suspect the latter is going to be tremendously inconvenient though, and I'm not sure there are any phones out there with that support.

The tablet needs to be pocketable, making 7" the very largest I can go for. Ideally it needs a front camera and microphone, as I assume the feature phone will have a decent camera for day to day use. GPS is also a must. Operating system? I'm not sure. I like Android but I'm not wedded to it. That said, if it were Windows 8 (are there any 7" W8 tablets?) or something like Ubuntu, I'd want things like an ix86 compatible CPU, expandable storage, and HDMI-out/USB-in ports, and I'm about 99% sure there are no tablets out there that meet that specification - not 7" anyway. To make it clear what I'm after it can be either of:

1. Android tablet, 7", decent modern ARM CPU, 16Gb storage+, front camera, microphone, GPS, T-Mobile compatible 3G or 4G


2. Win 8/Ubuntu tablet, 7", Intel Atom or equivalent, expandable storage, HDMI, USB-in, front camera, microphone, GPS, T-Mobile compatible 3G or 4G

So that's where my brain is at. A decent but portable tablet with a dedicated feature phone, rather than a jack of all trades that manages to suck as an actual phone.

Any thoughts?

User Journal

Journal: What's your favorite JQuery suite? 5

Journal by Marxist Hacker 42

Ok, I'm stretching a bit as a programmer in my current contract, because they're thrilled with the timeframe I've given. This contract is finally allowing me to learn MVC, which means *next* contract I'll be able to command a much higher rate.
However, using MVC on Microsoft tools means abandoning Ajax. I really need a good "Date/Time" control and a good cascading combobox. Anybody have any suggestions for an open source JQuery suite I should examine?

The confusion of a staff member is measured by the length of his memos. -- New York Times, Jan. 20, 1981