Have been thinking vs had been thinking
has been, have been , had been
iPhone: Detecting user inactivity/idle time since last screen touch Name "Chapter" is not showed in the table of the content When closing a question as a duplicate, it is becoming harder and harder to search for a good original as the pool of questions and answers grows and grows.  While the new dupe closing dialog is a huge step forward, it doesn't always work - if you've spent some time on the site, you know there are perfect answers to many new questions but you can't always find them. Or can't be bothered to, as your time is limited.  A way to further improve this could be introducing a vote for canonical answers.  It could, for example, work like this:   Answers get a new icon, the "canonical vote" (signified here by a cannon because I can't think of anything that makes sense right now.)     Only users with a certain minimum rep (maybe 1k+ or 2k+) see this icon. The icon would work like the favourite icon: You can toggle it on or off at any time. The hover message for the icon could read e.g.      This is a "canonical answer": It answers the question asked in the most extensive and general way, and is very likely to benefit other users with the same problem.    Questions that contain an answer with three or more canonical votes get special  treatment:      They show up on the top in search results; maybe even under a special heading ("Questions with canonical answers")  They show up prominently in the "close as dupe" dialog (i.e. the canonical votes influence the metric that is used to determine the questions shown there).  There could be some rewards for users whose answers receive "canonical" votes - maybe a badge if ten of your answers get at least three canonical votes, or a counter of canonical answers in your profile. It would be really interesting as it's a badge that you can't game your way to, but this whole rewarding part is entirely optional.  would be a great safeguard against over-use of this feature.    Dupe (but sans cannon):       Related: I'm looking for a way to insert continuous colour legend for a raster layer.  I managed to create discrete symbols with values along the bar, but I would like to have a continuous bar with some values on the bar, similar to the old plugin "One-Band Raster", that it doesn't work with the QGIS version higher than 1.7  I tried to set in properties->style, where I selected the  Render Type "Singleband pseudocolor" and see the "generate new color ramp" box.  I tried both "Continuous" or "Equal interval". However, in the Composer the legend always is displayed with discrete symbols.  Is there any way that can make QGIS Composer to display a nice continuous band for a raster layer? How to deal with high correlation among predictors in multiple regression? This is a somewhat bizarre question. My objectives are to understand the language design decision and to identify the possibilities of reflection in C++.   Why C++ language committee did not go towards implementing reflection in the language? Is reflection too difficult in a language that does not run on a virtual machine (like java)? If one were to implement reflection for C++, what will be the challenges?   I guess the uses of reflection are well-known: editors can be more easily written, program code will be smaller, mocks can be generated for unit tests and so on. But it would be great if you could comment on uses of reflection too. How did Walter White poison that character? I've seen Breaking Bad complete series 2-3 times, but I never found out how Walter White was able to poison Brock.  I mean did he himself directly feed the Valley of the Lilly berries to Brock or did he let Saul do the work? I can't figure it out. How is $J^{PC}$ value experimentally determined for new types of particles? I have a common scenario in app design, where I need to store an ordered list, and make the ordering easily accessible and adjustable via an application UI.    The ordering operations are simple and operate on only one item at a time - move to top, move to bottom, move up one position, or down one position.  These positioning operations may be interspersed in with typical add / edit / delete list operations.  For discussion, this is a single-user app and db store.  Because the objects can be highly complex, I'd like to avoid caching the entire list client-side, and tracking newly created objects in memory until a big save operation occurs.    I am using MS-SQL almost exclusively on these projects, and I'm wondering if there are db features, SQL features, or design patterns I should be using to better support the management of ordered lists.    My current approach is to use a DECIMAL column to store the list positions, which become fractional during the item move process.  Then I sort the list and re-generate integer positions to normalize list.  Following this operation, it's ready for another item move.   In an example implementation, I create a column named Seq for position tracking.  Once decimal place is enough for the .5 storage.   [Seq] [decimal](10, 1) NOT NULL   When an item is re-positioned in the app UI,    I UPDATE that record with new Seq value I retrieve the full table, sorted ascending by Seq and regenerate all Seq values in the table from a 1-based integer series   The new Seq value is easily calculated-    Move to top = 0 Move to bottom = MAX(Seq) + 1 Move up = subtract 1.5 from the current Seq value Move down = add 1.5 to the current Seq value   As lists get longer, updates get slower, since I'm doing N UPDATE statements, where N is the number of rows in the table, so it seems only suitable for small tables.    Is there some kind of in-built capability for managing an ordered list in SQL or MS-SQL? Is there a means to update multiple rows in one call?    A far more performant approach would be to allow more decimal places, and then position at the median of the two adjacent items, with no re-sequencing on the list.     Move to top = Min(Seq) - 1 Move to bottom = MAX(Seq) + 1 Move up = median of the 2 previous item Seq values Move down = median of the 2 following item Seq values   This approach only requires one SELECT (containing 2 rows max) and one UPDATE.    However with enough re-positions I imagine the field would run out of decimal places. For example, if I start with items at positions 10 and 11, and keep moving items down the list from position 9, they'd be given sequences of 10.5, then 10.25, then 10.125.  After 10 moves, the positions get lengthy... 10.0009765625.    UPDATE #1 - IMPROVED RE-SEQUENCING OF THE LIST  Regarding re-sequencing, I'm more caught up on row_number(), OVER, and WITH capabilities in MS-SQL.  It's nice to find that there's a much smoother way to re-sequence the list in a single UPDATE operation;  with OrderedItems as  (     select         ItemID,         Seq,         row_number() over (order by Seq asc) NewSeq     from          Items ) update OrderedItems set Seq = NewSeq Cancel misclicked flags I'm wondering (since it just happened to me), is it possible to "cancel" ("undo", "delete", "retract", whatever) a flag I just raised if I misclicked it, so the mods won't waste time?  I looked everywhere, but I can't find such a feature. "All the good people" vs. "all of the good people" threeparttablex table notes for tabu tabulars with less than \textwidth Is there going to be a process around hellbanning? Given , I must say I think the idea (making that user's content visible to only them) is a good one.  However, the people in whose hands that power will be placed terrify me.  Jeff is saying that he doesn't like that bans can degenerate into meta-discussions about the fairness of banning, and in that respect I agree with him. But the meta-discussions do accomplish one thing -- they get more than one person to look at the ban and weigh in on what they think.  This isn't that I don't trust moderators (or, indeed, diamond moderators), but I don't trust any one single human being with an irrevocable and complete banhammer, where there's no potential to dispute things. (And if the user doesn't know they're banned, there's no potential for dispute)  Basically, I'd sleep a lot more soundly at night knowing that if one of these "enhanced bans" are put into place, that at least two people have looked at the "problem child", and only after more than one person has signed off on such a ban, does that go into effect. I don't care exactly what that process is, but I don't want to have to worry about pissing off a moderator and getting banned as a result.  We all get pissed off here -- it's part of any community. But "the nuclear option(s)" need(s) to be decided upon by someone with a cool head, not someone who's pissed off. Converting time field omitting time and returning null values? I have a time field in my shapefile that is formatted as HH:mm:ss.s It is a text field, and I want to convert it to a date so I can calculate time elapsed across rows (if there's a better way to do this let me know). Basically, each row is a point on a route, and I want to use the time field to calculate the amount of time elapsed between the first and last points on the route.   I tried using the convert time field tool, setting the input format as HH:mm:ss.s, and the output type as DATE. The output field however only shows values of 01/01/2001 for some rows and  for other rows.   time is the input field and time_c is the output field  I'm not sure what's going wrong here, here is what shows up in the geoprocessing results window:    I tried adding the date data to the field as well to make the format yyyy-MM-dd HH:mm:ss.s, but it still didn't work: I know that \: in LaTeX produces a space when rendered.  Are there any alternatives, because my LaTeX renderer doesn't support \: (it renders it as text), and there is no help / FAQ that I can find. MacOS 10.14 Mojave public beta public Wi-Fi problem I can not connect to a single public Wi-Fi hotspot that does not require a password but instead shows a pop-up window pointed to captive.apple.com  The pop-up opens blank with the error "The web page couldn't be loaded"  Any idea on how to fix this? I used a website called Seeking Arrangements and met a  sugar daddy. He asked for my email login, online banking login, routing, account number, Facebook, as well as my  address which is the only thing I gave him since it’s a PO. I’ve been extremely vague just to see if this is real.   I don’t plan to give him anything because I have only been talking to him for a few months and  I feel conflicted. I doubt that he is trying to scam me but I suspect that he has some kind of master plan. With things such as Venmo, Zelle, and Cashapp, what is the need for “put me on his payroll?”   He claims that he is in another country on a business trip.  He said that  he tried to send me a gift but he lost access to his card. He is now asking to deposit more than 10k into my account and have me wire it. Is this a l classic way of scamming people? If so, is it common that they spend months creating a relationship with you  to catfish you? What is the advantage of using sudo apt-get autoremove over a cleaner app? I know that atan2 gives me the absolute angle of any vector. But it doesn't give a value from 0 to 360 degrees. Instead, it gives a value (if I'm not mistaken), between 0 and 180, or between 0 and -180. For example, instead of giving angle 270, it will say -90.  This is a little confusing for me. Let me try to describe how I think this works, and please tell me if I'm correct. Actually, I'll draw it.    Is this correct? I'm having a little trouble understanding this. Thanks The first time I learnt LaTeX, I thought \newcommand properly fits for inline mode and \newenvironment for displayed mode.  Later I noticed it is not correct. So the question is   What is the rule of thumb when deciding whether we should use one over the other one?