Selecting with LEFT OUTER JOIN and return as comma-separated list
Simulating group_concat MySQL function in Microsoft SQL Server 2005?
Help Text not showing on I have a table inside of a pageblocksection and then inside of that I have an  that I am trying to utilize the default help text for but it's not showing up.  &lt;apex:pageBlockSection columns="1"&gt;   &lt;apex:outputPanel&gt;     &lt;table&gt; width="100%"&gt;       &lt;tr&gt;         &lt;td&gt;           &lt;apex:pageBlockSectionItem helpText="test text"&gt;             &lt;apex:inputCheckbox value="{!searchBySKU}" /&gt;             &lt;apex:outputLabel value="Search for this SKU or text in the SKU name" /&gt;           &lt;/apex:pageBlockSectionItem&gt;         &lt;/td&gt;       &lt;/tr&gt;     &lt;/table&gt;   &lt;/apex:outputPanel&gt; &lt;/apex:pageBlockSection&gt;   Any ideas why this doesn't work as I expect?  EDIT:  So, I just did some more testing and it creates the text if it's a direct child of the pageBlockSection. Is there any way to get around this restriction without going the fully custom route to do so? "How big of a problem" vs. "how big a problem" Quite a few phrases in English are constructed like so:     How [adjective] a [noun]...?   This is the question form of the construction, which is often answered with the negative:     Not that [adjective] a [noun].   or the positive:     Quite [adjective] a [noun].   However, from time to time I'll hear the word 'of' inserted before the 'a', e.g.:     Not that [adjective] of a [noun].   This usually sounds wrong to me, with the exception of the case where the adjective 'much' is used.  So, this sounds fine to my ear:     Not that much of a problem.   whereas this doesn't:     Not that loud of a noise.   Why is it that 'much' should be used with 'of', and other adjectives not?  Is it because 'much' is seen as measuring a quantity (of something), whereas other adjectives that may be used in this construction are seen as measuring the quality of a whole thing? Understanding divison by monic polynomial in $R[x]$ where $R$ is an arbitrary ring I read "Algebra: Chapter 0" by P.Aluffi. I encountered a topic where it says you can divide any polynomial in $R[x]$($R$ is any ring) by a monic polynomial(that is, a polynomial of the form $x^d + \sum\limits_{i=0}^{d-1} a_i x^{i}$).   It says if $g(x)$ is any polynomial and $f(x)$ is a monic polynomial. Then $\exists \ \ \ q(x), r(x) \in R[x],\: \deg r(x) &lt; \deg f(x): g(x) = f(x)q(x) + r(x).$  I have two questions regarding this:  1) Why $f(x)$ needs to be monic?   2) How can we prove it? The book talk about induction and that if $\deg  g(x) = n &gt; d = deg \ f(x)$, then $\forall a \in R$ we have $ax^n = ax^{n-d}f(x) + h(x)$ for some $h(x): \deg \ h(x) &lt; n$. It's true, but how do I take it from here? How do I install drivers for Realtek RTL8812BU? So I've been experimenting with Ubuntu on and off for a while, but I honestly have no idea what the hell I'm doing. So I have a realtek RTL8812bu WiFi dongle that I'm hoping to get working. I did some research, and came across  that a couple people across two threads said worked for them:  At the bottom it said there is a new version . So somewhere it said it was confirmed to work on kernels up to 4.16, so I checked and I'm on 4.15.0. But the problem I'm having, is what am I supposed to do? There is some installation guide at the bottom that is about as clear as mud to me since I don't know much. What programming languages can I use in Blender? What version of Python does Blender use and are other languages available? Also, does Python work the same in Blender as when you write console applications or when working with Pygame or are there any differences? If so, what are the main differences? We are sponsoring a family to visit us in UK as friends from Madagascar for two weeks. They have a 6 year old and a 16 month old.   Do the kids need their own visas, and are they the standard visitor visa or a special child visa?   Also, when I try and apply on the website I can only apply for one person so how do I apply for all the individuals in the family?   I have looked on the Immigration website and can't find the answers I need. In sysctl, the /proc/sys/net/ipv[46]/conf/ keys have the following subkeys: all, default, and a key for each network interface. For example, on a machine with a single network interface eth0, it will look like this:  iserv ~ # ll /proc/sys/net/ipv[46]/conf/ /proc/sys/net/ipv4/conf/: insgesamt 0 dr-xr-xr-x 0 root root 0 12. Sep 23:30 all/ dr-xr-xr-x 0 root root 0 12. Sep 23:30 default/ dr-xr-xr-x 0 root root 0 12. Sep 23:30 eth0/ dr-xr-xr-x 0 root root 0 12. Sep 23:30 lo/  /proc/sys/net/ipv6/conf/: insgesamt 0 dr-xr-xr-x 0 root root 0 12. Sep 23:30 all/ dr-xr-xr-x 0 root root 0 12. Sep 23:30 default/ dr-xr-xr-x 0 root root 0 12. Sep 23:30 eth0/ dr-xr-xr-x 0 root root 0 12. Sep 23:30 lo/   All the respective settings exist in each key separately. For example, if I want to disable IPv6 Router Advertisements with the accept_ra value, this value exists four times:  iserv ~ # sysctl -a 2&gt;/dev/null | grep "accept_ra " net.ipv6.conf.all.accept_ra = 1 net.ipv6.conf.default.accept_ra = 1 net.ipv6.conf.lo.accept_ra = 1 net.ipv6.conf.eth0.accept_ra = 1   My question now is: which of these values do I need to change? I figured all (to change all existing interfaces) and default (to change all new interfaces that may appear later), but changing these still leaves the value at 1 for lo and eth0:  iserv ~ # sysctl -w net.ipv6.conf.all.accept_ra=0 net.ipv6.conf.all.accept_ra = 0 iserv ~ # sysctl -w net.ipv6.conf.default.accept_ra=0 net.ipv6.conf.default.accept_ra = 0 iserv ~ # sysctl -a 2&gt;/dev/null | grep "accept_ra "   net.ipv6.conf.all.accept_ra = 0 net.ipv6.conf.default.accept_ra = 0 net.ipv6.conf.lo.accept_ra = 1 net.ipv6.conf.eth0.accept_ra = 1   Will the machine now accept Router Advertisements on eth0, or will it not? Hi im new to Blender and i want to know when im in edit mode if i can copy or cut a selections of polygons faces and paste to another mesh.  Thanks in advance for any help How to get new answers to old/popular questions read/voted on? If a question has more than one page of answers then a new answer is not likely to get much attention.  I think the stackoverflow engine should give some more weight to newer answers to old questions but I'm not sure how.  Maybe a tweaked UI to get access to newer answers.  NB. In the related questions this  popped up, I hadnt realised either that these tools existed. Please explain the meaning of "otherwise than" in this sentence Please explain the meaning of the second part and explain "otherwise than" in part b     a person’s UK property business consists of:      (a) every business which the person carries on for generating income from land in the United Kingdom; and      (b) every transaction which the person enters into for that purpose otherwise than in the course of such a business. I was working with a new C++ developer a while back when he asked the question: "Why can't variable names start with numbers?"  I couldn't come up with an answer except that some numbers can have text in them (123456L, 123456U) and that wouldn't be possible if the compilers were thinking everything with some amount of alpha characters was a variable name.  Was that the right answer?  Are there any more reasons?  string 2BeOrNot2Be = "that is the question"; // Why won't this compile? general solution sum of two uniform random variables aY+bX=Z? is there a general solution to that? I have seen simple examples for Y+X=Z but I was wondering how this would be with rescaling? The following question is from Artin's Algebra.      If $A$ and $B$ are two square matrices with real entries, show that $AB-BA=I$ has no solutions.    I have no idea on how to tackle this question. I tried block multiplication, but it didn't appear to work. How to mount an image file without root permission? Problem applying L'Hopitals rule. Is it possible to construct a multi-colored double-bladed lightsaber? I was just watching  video of some SW dueling at the 2015 World Fencing Championship, and wondered if it's actually possible in the SW universe to construct a multi-colored double-bladed lightsaber?   Are there any accounts of such a thing? If not, would it at least be theoretically possible to make one, or, are there obvious limitations? Managing Metered Connections on OSX I'm having a difficulty in finding one way car rentals from Alaska, which I can return in Seattle.  Do all the main rental agencies restrict such one-way rentals, as they involve crossing through Canada, before entering the lower 48 states? What does functools.wraps do? In a comment on this , someone said that they weren't sure what functools.wraps was doing. So, I'm asking this question so that there will be a record of it on StackOverflow for future reference: what does functools.wraps do, exactly? When water climbs up a piece of paper, where is the energy coming from? Take a glass of water and piece of toilet paper. If you keep the paper vertical, and touch the surface of the water with the tip of the paper, you can see the water being absorbed and climbing up the paper. This climbing up is intriguing me. Where is the energy coming from?  Supposedly, a lot of water molecules are moving up and gaining potential energy. This has to be balanced by something. I can think of a few possibilities, but I can't tell which one it is.   When the water molecules dilute into the paper, they are at a state of lower potential binding energy. Some molecular interaction (van der Waals?) is at lower energy when you have a water+paper solution, compared to a water-only solution. This compensates the gain in gravitational energy. The surface between the paper and the water is at lower pressure than the atmosphere. This causes the water to be pushed into the paper by the atmospheric pressure, up until the point that the column of water above the surface is heavy enough to counterbalance. The potential energy would be a result of work done by the atmosphere. Some water molecules climb up randomly and loose kinetic energy going up, and somehow get "stuck" up there. Something else?