Below is my formula if condition, which is working fine. I just want to add formula like is property__c!= null, Only then below formula will run.  how can i do that?  Ex. If property__c!= null  Only then   IF(   NOT(     OR(     CASE( REOHQ__REOHQ_Basement__c, "N/A",1,  "Crawl",1, "Slab",1, "None",1, 0)=1,     CASE( Top_Property__r.REOHQ__REOHQ_Basement__c, "N/A",1,  "Crawl",1, "Slab",1, "None",1, 0)=1    )),   True,   false )
In my object record type i have created formula field. Now i want my formula field to work as below.  If Basement__c = NA and Property__r.Basement__c = NA OR  Basement__c = Crawl and Property__r.Basement__c = Crawl OR  Basement__c = Slab and Property__r.Basement__c = Slab Then it will return Type__c(formula field) = "MAtch"  And (Another rule) Basement__c DOES NOT contain any of the following "N/A,Crawl,Slab,None and Property__r.Basement__c Does not contain any of this then formula field will return "HAs basement"  How can i achieve this? Please help.
Check for column name in a SqlDataReader object How do I check to see if a column exists in a SqlDataReader object?  In my data access layer, I have create a method that builds the same object for multiple stored procedures calls.  One of the stored procedures has an additional column that is not used by the other stored procedures.  I want to modified the method to accommodate for every scenario.  My application is written in C#. What does = +_ mean in JavaScript Simulation of interacting particles I'd like to do some URL rewriting (Why? See .) so that instead of users seeing addresses like   labouseur.com/course-compilers.html    they can instead see and use simply   labouseur.com/course-compilers   (Even better, maybe I should restructure that so that it's courses/compilers.)  I'm using a Linux-based shared hosting service for my website, so I do not have administrative control of the server, but I do have control over .htaccess. The references I've read online seemed less than clear to me, so I'm looking for a little clarity and advice here. Is there word for this, other than know-it-all? Just wondering, if there's a word for:  One who makes it appear as if they're an expert on a subject while there are also signals (subtly or blatantly noticeable) that this person doesn't know very much on the subject or at least as much as they're acting like they do on the subject; pretending to have much knowledge on a subject matter.  I found pedantic but I don't suppose it's the right word. Understanding complete separation for logistic regression Why does logistic regression not converge for a linearly separable data set?   For linear separable data sets the model parameters go to infinity when mimizing the error function (according to Bishop2006, Pattern recognition and machine learning, section 4.3.2). I don't understand why. It must be connected to setting the score function, i.e. the derivative of the error function, to zero.  The error function is given by $E(\mathbf{w})$ as shown in the figure below. Where $\mathbf{t}$ is the target variable vector of the training set and $\mathbf{w}$ the parameter / coefficient vector. The posterior probabiltiy for class 1 is given by  $$y(n) = p(C_1|\mathbf{x}_n) = \sigma(\mathbf{w}'\mathbf{x}_n).$$ Where sigma is the logistic sigmoid function and $\mathbf{x}_n$ is the feature vector for instance $n$ including the predictors.     My second question to logistic regression is if the to posterior probabilities $p(C_1|\mathbf{x}_n)$ and $p(C_2|\mathbf{x}_n)$ sum to one? I'm having some issues SSH'ing to a server when logged into a particular VM.  From my local PC, I can log in to the server just fine using the command ssh -i .ssh/[my private key] username@domain.  If I then SSH into another unrelated server which also has the same private key and run the above command it will also log in just fine in to the server.  But, when I SSH into a particular OpenStack VM (again has the same private key) on the unrelated server and then SSH in to the server from there I start getting prompted for a passphrase. But a passphrase hasn't been set for the key so inevitably I get a "Permission denied (publickey)." error.  To double check, I removed the private key from the VM and scp'd the private key from my PC into it again and tried the same command I still get prompted for a passphrase.  In other words:   PC - SSH - Server1 = Works fine  PC - SSH - Server2 - SSH - Server1 =     Works fine  PC - SSH - Server2 - SSH - Virtual Machine - SSH - Server 1 =         Asks for a passphrase   What could be the reason behind this? It's definitely the right private key I'm using and it has the appropriate permissions.  Edit - Output of ssh -v -i .ssh/[my private key] username@domain as requested  OpenSSH_7.4p1, OpenSSL 1.0.2k-fips  26 Jan 2017 debug1: Reading configuration data /etc/ssh/ssh_config debug1: /etc/ssh/ssh_config line 58: Applying options for * debug1: Connecting to xxx.xxx.xxx.xxx [xxx.xxx.xxx.xxx] port 22. debug1: Connection established. debug1: key_load_public: No such file or directory debug1: identity file /.ssh/[my private key].ppk type -1 debug1: key_load_public: No such file or directory debug1: identity file /.ssh/[my private key].ppk-cert type -1 debug1: Enabling compatibility mode for protocol 2.0 debug1: Local version string SSH-2.0-OpenSSH_7.4 debug1: Remote protocol version 2.0, remote software version OpenSSH_7.2p2 Ubuntu-4ubuntu2.4 debug1: match: OpenSSH_7.2p2 Ubuntu-4ubuntu2.4 pat OpenSSH* compat 0x04000000 debug1: Authenticating to xxx.xxx.xxx.xxx:22 as '[my username]' debug1: SSH2_MSG_KEXINIT sent debug1: SSH2_MSG_KEXINIT received debug1: kex: algorithm: curve25519-sha256@libssh.org debug1: kex: host key algorithm: ecdsa-sha2-nistp256 debug1: kex: server-&gt;client cipher: chacha20-poly1305@openssh.com MAC: &lt;implicit&gt; compression: none debug1: kex: client-&gt;server cipher: chacha20-poly1305@openssh.com MAC: &lt;implicit&gt; compression: none debug1: kex: curve25519-sha256@libssh.org need=64 dh_need=64 debug1: kex: curve25519-sha256@libssh.org need=64 dh_need=64 debug1: expecting SSH2_MSG_KEX_ECDH_REPLY debug1: Server host key: ecdsa-sha2-nistp256 SHA256:ZiugTjR5fM0E3evOwHoePFKspDQChA0Ab6L0q88KP/g debug1: Host 'xxx.xxx.xxx.xxx' is known and matches the ECDSA host key. debug1: Found key in /home/centos/.ssh/known_hosts:2 debug1: rekey after 134217728 blocks debug1: SSH2_MSG_NEWKEYS sent debug1: expecting SSH2_MSG_NEWKEYS debug1: SSH2_MSG_NEWKEYS received debug1: rekey after 134217728 blocks debug1: SSH2_MSG_EXT_INFO received debug1: kex_input_ext_info: server-sig-algs=&lt;rsa-sha2-256,rsa-sha2-512&gt; debug1: SSH2_MSG_SERVICE_ACCEPT received debug1: Authentications that can continue: publickey debug1: Next authentication method: publickey debug1: Trying private key: /.ssh/[my private key].ppk Enter passphrase for key '/.ssh/[my private key].ppk': Enter passphrase for key '/.ssh/[my private key].ppk': Enter passphrase for key '/.ssh/[my private key].ppk': debug1: No more authentication methods to try. Permission denied (publickey). How to get class object's name as a string in Javascript? Ubuntu 16.04 Jan 3 2018 update causing screen/access issues Yesterday (Jan. 3, 2018), I installed an OS update (Ubuntu 16.04), using the Software Center. My system isn't working correctly now. When my mouse rolls over the Launch bar, it disappears, then any open window disappears, leaving me with only the desktop screensaver showing. I can't even shut the computer off using the settings button on the top.  I went into the Terminal and attempted to fix it using the following commands:  sudo apt-get dist-upgrade sudo apt-get autoremove   But I'm still having the same problem.  I have reinstalled Ubuntu 16.04 and when I accepted the update on install had the same problem.  I have reinstalled it a second time but have not done an OS update and everything seems to be working fine.    Found another user with the same problem:    Is it possible that the Meltdown security update is at fault?  I've read the update has been issued for 64-bit x86 architecture ();  I'm running a 32 bit i386 architecture.  Could that be an issue and is there a way to correct it? Is there a C pre-processor which eliminates #ifdef blocks based on values defined/undefined? What does an icon on the tag mean, for example the "rg" before the sql-server tag as pictured below? Book featuring a child learning from a crowdsourced AI book In bash, how do I escape an exclamation mark? I want to do something like bzr commit -m "It works!". I can sort of escape the exclamation mark by doing bzr commit -m "It works\!". However, then my commit message includes the backslash. How do I escape the exclamation mark, while still ignoring the backslash? I have two checkboxes in a lightning component, when we click on the first checkbox it marks true to the other checkbox, it works well only with the UI tags but doesn't work when I convert it to lightning tag  &lt;ui:inputCheckbox aura:id="box3" change="{!c.selectAll}"/&gt;  &lt;ui:inputCheckbox aura:id="boxPack" value=""                                                          change="{!c.checkboxSelect}"/&gt;   below are the lightning tags  &lt;lightning:input type="checkbox" aura:id="box3" onclick="{!c.selectAll}"/&gt;  &lt;lightning:input type="checkbox" aura:id="boxPack" value=""                                                          onclick="{!c.checkboxSelect}"/&gt;   controller  checkboxSelect: function(component, event, helper) {         // get the selected checkbox value           var selectedRec = event.getSource().get("v.value");         // get the selectedCount attrbute value(default is 0) for add/less numbers.          var getSelectedNumber = component.get("v.selectedCount");         // check, if selected checkbox value is true then increment getSelectedNumber with 1          // else Decrement the getSelectedNumber with 1              if (selectedRec == true) {             getSelectedNumber++;         } else {             getSelectedNumber--;         }         // set the actual value on selectedCount attribute to show on header part.          component.set("v.selectedCount", getSelectedNumber);     },      selectAll: function(component, event, helper) {         //get the header checkbox value           var selectedHeaderCheck = event.getSource().get("v.value");         // get all checkbox on table with "boxPack" aura id (all iterate value have same Id)         // return the List of all checkboxs element          var getAllId = component.find("boxPack");         // If the local ID is unique[in single record case], find() returns the component. not array            if(! Array.isArray(getAllId)){             if(selectedHeaderCheck == true){                  console.log('true');                 component.find("boxPack").set("v.value", true);                 component.set("v.selectedCount", 1);             }else{                 component.find("boxPack").set("v.value", false);                 component.set("v.selectedCount", 0);             }         }else{             // check if select all (header checkbox) is true then true all checkboxes on table in a for loop               // and set the all selected checkbox length in selectedCount attribute.             // if value is false then make all checkboxes false in else part with play for loop              // and select count as 0              if (selectedHeaderCheck == true) {                 for (var i = 0; i &lt; getAllId.length; i++) {                     component.find("boxPack")[i].set("v.value", true);                     component.set("v.selectedCount", getAllId.length);                 }             } else {                 for (var i = 0; i &lt; getAllId.length; i++) {                     component.find("boxPack")[i].set("v.value", false);                     component.set("v.selectedCount", 0);                 }             }          }        }, What is butterfly lighting, and when do I use it? I often hear the term 'Butterfly Lighting' used when discussing high-fashion and glamor photography. How do I set up Butterfly Lighting, and when do I use it? vim-clang-format: clang-format is not found I need to find the closure of these sets on the ordered square: $$A = \{(1/n)\times 0 | n\in \mathbb{Z}_+\}$$ $$B = \{(1-1/n)\times \frac{1}{2}| n\in \mathbb{Z}_+\}$$ $$C = \{x\times 0 | 0&lt;x&lt;1\}$$ $$D = \{x\times \frac{1}{2}| 0&lt;x&lt;1\}$$ $$E = \{\frac{1}{2}\times y | 0&lt;y&lt;1\}$$ I know that the closure is just the set itself united with its limit points. For $A$, the set of limit points, I imagine, are $\{&lt;1,0&gt;\}$, that is, the $x$ coordinate is $1$ and the $y$ is $0$. But  is says the reverse. What am I getting wrong? Following the same reasoning, $B' = \{&lt;1,\frac{1}{2}&gt;\}$ $C' = \{&lt;0,0&gt;,&lt;0,1&gt;\}$ What am I doing wrong? Return a value when using jQuery.each()? I noticed that there is a definition of the pvalue in my textbook is defined says the following:    I have no idea why it is written with a supremum. I've spent hours pondering this, does anyone have enough of a background to help me with this? Thank you! Intuitive explanation for density of transformed variable? Suppose $X$ is a random variable with pdf $f_X(x)$. Then the random variable $Y=X^2$ has the pdf   $$f_Y(y)=\begin{cases}\frac{1}{2\sqrt{y}}\left(f_X(\sqrt{y})+f_X(-\sqrt{y})\right) &amp; y \ge 0 \\ 0 &amp; y \lt 0\end{cases}$$   I understand the calculus behind this. But I'm trying to think of a way to explain it to someone who doesn't know calculus. In particular, I'm trying to explain why the factor $\frac{1}{\sqrt{y}}$ appears out front. I'll take a stab at it:  Suppose $X$ has a Gaussian distribution. Almost all the weight of its pdf is between the values, say, $-3$ and $3.$ But that maps to 0 to 9 for $Y$. So, the heavy weight in the pdf for $X$ has been extended across a wider range of values in the transformation to $Y$. Thus, for $f_Y(y)$ to be a true pdf the extra heavy weight must be downweighted by the multiplicative factor $\frac{1}{\sqrt{y}}$  How does that sound?  If anyone can provide a better explanation of their own or link to one in a document or textbook I'd greatly appreciate it. I find this variable transformation example in several intro mathematical probability/stats books. But I never find an intuitive explanation with it :(