But ... but ... you know everything!

So disappointed

Now they have 4 problems ...

meanwhile, searching for "stack overflow ios app" returned thenextweb.com/dd/2017/05/16/…

Next up: an app which redirects you to the mobile site.

@Bart of Yahoo! Answers?

That would be awesome

@Bart that's pretty much what the first version (alpha?) of the SE app was. Worked well.

@rene Thanks; yeah I can't do it in the where clause. I ended up posting a question on so about it.

Is this really a dupe of goto Area 51 and create as new site?

I don't really know what that is. Either he seems to be asking if it's within scope of existing sites, or he's asking for permission to suggest a new site. The response to the latter is "just do it", I guess.

site-recommendation workflow: If there are existing sites, answer with those. Otherwise, propose in Area 51.

OK, fair enough

@rene Oh huh I just realized a great trick for it. I'll give somebody else the chance to discover it first. Turns out count(a + b) nails it, even for mixed types.

@JasonC cool!

Oh but

It'll give int overflow errors if the types are int and the result is too large

but ...

Still I guess if you know that won't be the case it works

is there something that concatenate them instead, to prevent overflow?

I was just thinking that same thought, researching that now

@JasonC a bug? MS implemented JavaScript type coercion in SqlServer?

@rene No, I dunno what the rules are but pretty sure the results of an arithmetic operation are the type of the widest operand or something.

@Gerry Underflow risk.

there's ToString(), but dunno if it's computationally heavy in a query

I could convert the values to a larger int type first but then it's no longer concise, and also not very general but I suppose that's ok.

That's true, if you know everything is positive

Or Concat()

Nah, I tried concat. concat(null, not null) is not null.

Oh I got it

count('' + a + b)

Total hack. But forces conversion to string for any compatible type.

So no overflow.

Wait no nevermind

Used the wrong test case.

Damn, chat.meta.stackexchange.com/rooms/878/… is frozen, lol. Can't move messages. There's no escape.

Lastly, perhaps IsNull() can help...

@JasonC you need to increase your rate for stupid things you say then ....

@JasonC that answer just appeared on your SO question

@Elephant you can't escape the wrath of The @Derpy. Welcome to the club! ;-)

@JasonC try DATALENGTH() to prevent overflow

well, LEN() works too..

sd gone

That was weird

For a second i was getting 404's on meta.stackexchange.com

Has been fine for me

@JasonC stop breaking things!

^

@JasonC That means something.

:(

Uncaught SyntaxError: Unexpected token meta.stackexchange.com for Jason at position 404

@JasonC not frozen, deleted. Pretty sure you can move messages from a frozen room to other rooms, just not the other way around.

← 1 message moved from Cloud Cuckoo Land

@UniversalElectricity hello!

@Uni I see you are active on GH! github.com/eyeballcode/eyeballcode.github.io/commits/master come back!

great, just scare off all teh ppl

Maybe he got sucked into the Game of Life...

I wish Game of Thrones had started...

Soon. Soon.

But it will be short. :(

But then there will be spinoffs

3 of them, no 4 of, 5! 6? 7!? Like, a bunch of spinoffs.

I'm afraid to expect for too much, so that I won't get disappointed...

One thing is for sure, there will be another scene where Daenerys will burn again... there must be...

@M.A.R. I'm waiting

heh, so @Brian find time to fix bugs in the old app...

Too bad we'll never see such thing with the old android app. (or new, most likely.)

It tends to go in the way of posting questions apparently.

Except for Jon Skeet, who posts all answers from voice to text on his wrist watch.

@TravisJ that's so 2016. He's transmitting the answers directly from his brain.

Oh really? Well then when is Stephen Hawking going to start answering, huh?

@Gerry there is copy and paste on phones too

@Gerry - In my opinion only bad questions come from phones. But that was a losing opinion.

@TravisJ as soon as he learn to program... ;)

hah!

A lot of "mobile" derived traffic also comes from tablets which have legitimate UI tools.

Anyway, this is real:

Heh, does it has spelchick?

@TravisJ just auto complete, based on your memories. (e.g. "I want to meet [name is auto filled]")

I wonder, is Smart TV considered "mobile" too?

Are you watching SO on your tv?

lol

;)

Watching is lame, I mean using a browser from inside the TV ;)

The PS4 browser sucks, that's for sure. Didn't try something else yet.

xb1 uses ms edge for its browser, so I dare not browse at all on it for fear of finding the next wanna cry virus.

Is this a virus?

"ransomware". heh

Well, it alters your registry, hides an executable in a system folder, and runs a background process in order to assume some point of control over the target system. So, yeah, I would call it a virus. The end result, the type of attack, would still be ransomware. Plus, people like catch phrases so they need a good word to go with things nowadays :)

@Gerry - That reminds me of programming apps on a nokia phone

@Gerry happy C-day!

Here is you cake, @Gerry

@TravisJ can probably bring the booze

@Gerry heh, Oded is older chat user, though he's not in that list for some reason... guess he's not visiting here enough.

@ShadowWizard 25 year bowmore perhaps? :)

[ SmokeDetector | MS ] Bad keyword with a link in answer: If someone becomes a split-brain patient, which side will "maintain" the continuity in their consciousness? by Muneer Ahmed on cogsci.SE

Well, if it were from a pure funding approach, then those exhibits would basically refute the idea that no one wanted another yahoo answers.

Also to note, Quora is invasive as a site. SO is much less so.

I only say that because if you navigate through more than one link deep in their site they require you to register or prevent you from continuing. Or at least, what "Joe calls preventing" (family guy reference).

SE could compete in the yahoo answers arena if it made entertainment.stackexchange.com where literally any question went and the only close reason was "the post represents a real danger, either physically or as a result of following linked content".

I feel chasing Yahoo is a losing proposition.

However, that would totally be pandora's box.

@JonEricson - Anything Yahoo seems to be losing :) However, Quora seems to have found an odd niche in there somewhere. I personally like the professionalism, or at least mostly, that is present in the content at Stack Exchange.

:D

[ SmokeDetector | MS ] Pattern-matching website in answer: On new iPhone, when I call people no one can hear me but I can hear them by Jonathan Hawkins on apple.SE

@Gerry If we put our mind to it, I bet we could corner the market in mathematician job listings.

That might not exactly be the best phrase to use :P

(usually cornering the market involves price manipulation of some sort)

@TravisJ Exactly. I was thinking of Trading Places. (But I guess this will be Exhibit A in the eventual legal battle. ;-)

lol

@Gerry Same profile for developers. (Well, if you define "use" as participate.)

Makes sense. Math is a lot more mature than programming.

What I would really use as a developer is somewhere that could take exhibit A (some random data set) and exhibit B (some random display layout) and then merge them into B with A's data.

Very tired of doing that myself.

Didn't want to go? Or perhaps didn't know to go?

Who is using google as an app?

Okay, that's fair.

I guess the reason is that, in a very basic sense, writing a comment on facebook is "contributing". However, not everyone can actually contribute to SO - that is essentially by design. So for the large amount of people who cannot actively contribute, why would they choose to go and "visit" (i.e. casually browse) Stack Overflow?

I mean, let's be honest, of the group of casual browsers (which is probably not many) a lot of them come here with popcorn for teh meta.

Perhaps that was the goal of SO Docs? To get more casual browsing, and allow a broader swath of contribution - I vaguely remember people saying something to this extent.

Anyway, the point remains though, casual browsing requires an easier level of entry for contribution. There was a decent suggestion to that regard once, which was to allow users of a certain reputation the ability to have their own place to blog at Stack Overflow.

@TravisJ It was certainly a goal. I do see some people who have contributed to Docs who didn't ask or answer first.

It is also kinda hard to contribute such a polished work as a SO Docs topic + example set from a phone or mobile app.

Yeah. I'm skeptical. But then again, my son wrote a draft of an English paper on his phone.

I think my eyes would give out doing that, unless he used voice to text.

wow

That must be someone familiar with the site.

Based on the way they used -5 to start their comment with.

@TravisJ google is sneaky though, their stock launcher on android is their app in essence. And they're the default for most anyway

and don't most people just find SO through google?

(Even on desktop)