Why 0 results on "where not in" query
NULL values inside NOT IN clause
Can I connect to a specific access point by BSSID? Is there any way to get Mac OS X to connect to a specific access point by BSSID? I have a network with the same SSID for multiple access points, and I would sometimes like to specify which specific access point to connect to. Is this something Mac OS X can do natively, or is there a third party tool that can do this? Why is this trigger finding a null value despite the field being populated? Overriding some DNS entries in BIND for internal networks Can we insert or update FieldSets using apex code? Although we can create or update fieldsets using salesforce UI but Is there any way to insert or update FieldSets using apex code (using metadata or API calls) ? I have a multiboot system set up. The system has three drives. Multiboot is configured with Windows XP, Windows 7, and Ubuntu - all on the first drive. I had a lot of unpartitioned space left on the drive and was reserving it for adding other OSes and for storing files there in the future.  One day I went ahead and downloaded Partition Wizard and created a logical NTFS partition from within Windows 7, still some unpartitioned space left over. Everything worked fine, until I rebooted the computer a few days later.  Now I'm getting:    error: unknown filesystem.   grub rescue&gt;   First of all I was surprised not to find any kind of help command, by trying:    help, ?, man, --help, -h, bash, cmd, etc.  Now I'm stuck with non-bootable system. I have started researching the issue and finding that people usually recommend to boot to a Live CD and fix the issue from there. Is there a way to fix this issue from within grub rescue without the need for Live CD?  UPDATE  By following the steps from , I was able to boot to initramfs prompt. But not anywhere further than that.  So far from reading the manual on , I was able to see my drives and partitions using ls command. For the first hard drive I see the following: (hd0) (hd0,msdos6) (hd0,msdos5) (hd0,msdos2) (hd0,msdos1)  I now know that (hd0,msdos6) contains Linux on it, since ls (hd0,msdos6)/ lists directories. Others will give "error: unknown filesystem."  UPDATE 2  After the following commands I am now getting to the boot menu and can boot into Windows 7 and Ubuntu, but upon reboot I have to repeat these steps.    ls ls (hd0,msdos6)/ set root=(hd0,msdos6) ls / set prefix=(hd0,msdos6)/boot/grub insmod /boot/grub/linux.mod normal   UPDATE 3  Thanks Shashank Singh, with your instructions I have simplified my steps to the following. I have learned from you that I can replace msdos6 with just a 6 and that I can just do insmod normal instead of insmod /boot/grub/linux.mod. Now I just need to figure out how to save this settings from within grub itself, without booting into any OS.  set root=(hd0,6) set prefix=(hd0,6)/boot/grub insmod normal normal   UPDATE 4  Well, it seems like it is a requirement to boot into Linux. After booting into Ubuntu I have performed the following steps described in the :  sudo update-grub sudo grub-install /dev/sda   This did not resolve the issue. I still get the grub rescue prompt. What do I need to do to permanently fix it?  I have also learned that drive numbers as in hd0 need to be translated to drive letters as in /dev/sda for some commands. hd1 would be sdb, hd2 would be sdc, and so on. Partitions listed in grub as (hd0,msdos6) would be translated to /dev/sda6.  UPDATE 5  I could not figure out why the following did not fix grub:  sudo update-grub sudo grub-install /dev/sda   So I downloaded  based on an answer from  post. That seemed to do the trick after I picked the "Recommended Repair (repairs most frequent problems)" option. Question on the correlation between two dependent variables I'm working on this question and it's stumping me.     Let $S_n = X_1 + \ldots + X_n$ (with $n&gt;=1$) be a random walk with $X_1, \ldots, X_n$ be iid RV's.   $$ E(X_k)=\mu,\,{\rm Var}(X_k)=\sigma^2.  $$   Find the covariance of $S_n$ and $S_m$   Can anyone help out? I am trying to use the equation: $${\rm Cov}[S_n, S_m] = E[S_nS_m] - E[S_n]E[S_m]$$  but can't quite figure it out. How to prevent search engines from indexing a single page of my website? When, if ever, should voting override answer acceptance for answer sorting? The accepted answer always appears at the top of the list, regardless of sort order. This can be misleading if the question author accepted an invalid solution and a better solution was proposed later, and eventually got more votes. I have seen somewhat obscure questions where the accepted answer has a negative score and the next answer has 10 or more up-votes. I want to shrink my second (LVM) partition, in order to create a new partition in the newly freed space. I am using the Live CD to do so, because I know I can't resize/move this partition while it is in use. When I opened GParted in the Live CD, I realized that I could not resize the partition, because when I right-click it, the option "resize/move" is disabled.  I tried to unmount it, to "lazy" unmount it (umount -l /dev/sda2) but it didn't work.  A screenshot from GParted: How to Remove URLs from Google Search Engine CNAME for top of domain? Is it possible to set a CNAME record at the top of a domain? (i.e. @ CNAME www, @ CNAME foobar.com., etc.)  My ISP says that it's only possible to use CNAME's for subdomains but I've read somewhere else that is should be possible even if not recommended. Find $f$ if $ f(x)+f\left(\frac{1}{1-x}\right)=x $ Find $f$ if $$ f(x)+f\left(\frac{1}{1-x}\right)=x $$ I think, that I have to find x that $f(x) = f\left(\frac{1}{1-x}\right)$ I've tried to put x which make $x = \frac{1}{1 - x}$, but this equation has no roots in real numbers. What is the name of this theorem, and are there any caveats? For random variable $X$ that follows some distribution, $f(x)$ is the probability density function of that distribution if and only if $$\mathbb{E}[\phi(X)] = \int_{-\infty}^\infty \phi(x) f(x)dx$$ for all functions $\phi$.  Context: My professor used this in lecture to demonstrate a way to find the distribution of $cX$ given random variable $X$ that follows a specific distribution.   What is the name of this theorem? Have I missed any qualifications/caveats? I am in particular curious about whether "for all functions" is correct. My professor mentioned "positive, bounded, deterministic functions," but I am not sure what he meant by that. Where can I find a proof of this theorem? For example an electron radiates when accelerated. So does a positron. But is the radiation emitted by accelerated positronium the sum of the radiation emitted by each separately? If not, why not? If so, does this provide a way of testing whether a given neutral particle is composite? For example, does a neutron bremsstrahlung when decelerated? Sometimes when I am running a development version of Ubuntu, the Software Updater will tell me that a partial upgrade is needed when I check for updates.  What is a partial upgrade, and why are they necessary? Sometimes users run into problems when doing them, so when should I run a partial upgrade, if ever? Double dispatch in C#? I can not update  on a Debian 6.0 (Squeeze) server to get rid of the discovered vulnerability:  bash --version GNU bash, version 4.1.5(1)-release (x86_64-pc-linux-gnu)  apt-get update apt-get install bash Reading package lists... Done Building dependency tree Reading state information... Done bash is already the newest version. 0 upgraded, 0 newly installed, 0 to remove and 7 not upgraded.   Can I use Squeeze-LTS for this server just to update Bash? After one week I will be on another server, so I will not make any other updates.  uname -m x86_64  lsb_release -a No LSB modules are available. Distributor ID: Debian Description:    Debian GNU/Linux 6.0.5 (squeeze) Release:        6.0.5 Codename:       squeeze How do you photograph rain? What are recommended settings for my Nikon Coolpix P1 to best portray rain?  Here's what I got. No retouching was applied.   The picture I took when the rain was heavy with the automatic settings:  The picture I took with the "Sports" program; by then, however, the rain was not as hard. Ugh, ugly gray strip at the bottom, that was the flat surface I put my camera on to get a stable picture.   My main problem is that the actual rain and hailstorm is very hard to see in the picture. The overall effect is, instead, of fog.    Follow-up from the thread, courtesy of more rain, now with less hailstorm and more thunder.  The feedback amounted to flash and faster shutter. I took a few photos and I'm having some trouble to reconstruct what I did to get each result. Two representative results:   Fast shutter, with some guest starring:I'm talking about that horrible building obviously. Faster shutter and flash:Kinda difficult to say those pictures were taken sixty seconds of each other. :)   I'm not sure, however, that either of this is really an improvement of the original results. The Megahertz Myth became a promotional tactic due to differences between the PC's INTEL 8086 processor and Apple's Rockwell 6502 processor.  The 8086 ran at 4.77MHz while the 6502 ran at 1MHz.  However, instructions on the 6502 needed fewer cycles; so many fewer, in fact, that it ran faster than the 8086.  Why do some instructions need fewer cycles?  And why can't the instructions of the 6502, needing fewer cycles, be combined with a fast cycling processor of the 8086?  Wikipedia's article for instructions per cycle (IPC) says     Factors governing IPC   A given level of instructions per second can be achieved with a high IPC and a low clock speed...or from a low IPC and high clock speed.   Why can't you have both high instructions per cycle and high clock speed?  Maybe this has to do with what a clock cycle is?  Wikipedia mentions synchronization of circuits?  Not sure what that means.  Or maybe this has to do with how a pipeline works?  I'm not sure why instructions in a short pipeline are different from instructions in a long pipeline.  Any insight would be great!  Just trying to understand the architecture behind the myth.  Thanks!  References: Is there a way to make Runnable's run() throw an exception?