I am trying to Show the Records based on Postcode in the VF Page which has a Distance Filter as 10,15,25,50 and 100 miles. It works perfectly fine till 25 but then fails. If(postObj.Geolocation__c != null){                 for(postcode__c obj :  [SELECT Geolocation__c,Name ,Id , Geolocation__Latitude__s                                          FROM postcode__c WHERE DISTANCE(Geolocation__c, GEOLOCATION(:latitude,:longitude), 'mi') &lt; :distance LIMIT 50000]){                     postalcodeIds.add(obj.Id);                 }                       }  Postcode is a Object which has 2 Million Records in SF. Errro Message - Too many query rows: 50001 Error is in expression '{!searchCall}' in page searchpage: Class.Database.QueryLocatorIterator.hasNext: line 41, column 1
What I am trying to do is to set a date in my date field and also update the object. I am using the class below to do so which works just fine in my sanbox but in production I am getting this error:      System.LimitException: Too many query rows: 50001   public with sharing class updateObject{     public  List&lt;NRProducts__c&gt;  values;     public PageReference updateObject() {         values=[SELECT Refreshed_Date__c FROM NRProducts__c ];         for (NRProducts__c s :values){            s.Refreshed_Date__c =Date.today();          }          update values;         return null;                       }     }   VF Page:  &lt;apex:page showheader="false" controller="updateObject" sidebar="false"&gt; &lt;apex:form&gt;  &lt;apex:commandButton action="{!updateObject}" value="Update"/&gt; &lt;/apex:form&gt; &lt;/apex:page&gt;
I'm trying to set up file transfer via FileZilla and it doesn't seem to matter what details I put in, I always get the following error:     Status: Connection attempt failed with "ECONNREFUSED - Connection   refused by server". Error: Could not connect to server   My Dad has tried on his computer (with FileZilla on Windows) and it connects and everything is fine.. When I try on mine with all the same details that he put in, it comes up with that error.  I read that a firewall might be blocking it so I double checked and my firewall through system preferences and it is off.  Anybody know why this might be???  Additional info:  Macbook Pro running OS X El Capitan version 10.11.6  FileZilla version 3.23.0.2 Prevent iTunes from starting when iPhone/iPod/iPad is plugged in on Windows Is there any way to prevent iTunes from starting under XP when an iPhone is plugged in?  Using iTunes v 9.  Usually I just want to charge my phone and don't want iTunes to start.  Note: Exact  of this question - except this is for v9 on Windows.  The answer in the related question doesn't work for me. Looking for intro to Conformal Bootstrap Displaying multiple fields as labels if one field is null in QGIS? I am having some issues trying to show multiple fields for a single label in QGIS. In QGIS2.6, attempting to display labels for a feature consisting of multiple fields results in an empty label if one of the fields is null. So for example, in the label expression dialog:  concat("Temp Site",'\n',"Notes",'\n',"Function")   will function normally unless one of the fields is null, then it results in no label being shown. Using the '||' operator instead in the expression dialog also results in the same behaviour:  "Temp Site" || '\n'  ||  "Notes" || '\n'  ||  "Function"   Is there a way to display the labels even if one of the fields is null? StackExchange drop down hiding chat, blog and log out, concerns What is the correct way to pluralize an initialism in which the final word is not pluralized by adding the letter "s"? Convert .mov to .mp4 I want to convert .mov to .mp4! I saved the video from iMovie but it is in .mov format! How do I convert it to .mp4?  I'm using a MacBook and I want to share it to my phone, but my phone can't open .mov format video. Someone told me that the English language is special (compared to German, at least) in the way that every noun could be used as a verb. I think this phenomenon is called supine. Is this correct?  Examples:   house → to house well → to well phone → to phone table → to table lamp → to lamp   At first it seemed to me that this would work with all nouns. But then I thought of the following nouns, and I think they can't be used as a verb, am I right?   person →(?) to person human →(?) to human baker →(?) to baker computer →(?) to computer example →(?) to example   It seems that nouns describing people (person, human, baker) are exceptions? But it works for "author" ("to author"). Hmm. "Computer" seems smiliar to a person's job to me (could be a human instead of a machine that computes).  But what about "example"? I think "to example (something/someone)" is not possible, is it? What would a native speaker understand/think if someone says:      He examples.      I want to example it/him.   Which are the nouns that can't be used as a verb? How to build a dmg Mac OS X file (on a non-Mac platform)? Is it possible to build a .dmg file (for distributing apps) from a non-Mac platform? And if yes, how? mv * folder (avoiding 'cannot move' error) My English is pretty basic, please don't mind. Wondering how to make the liquify wave and distort color effect in Photoshop? I'd tried using distort>shear/wave/zigzag, but still can't make it similar like the photo below. How can I get my external IP address in a shell script? cube collider losing shape upon rotation I'm not sure what's going on here. I have a cube which I have turned into a rectangle; it's a child of a plane which is the "ground" so that they share rotation (this is a pinball table).   To create these cubes, I just used the create => 3d shape => cube/plane option. No packages are used.   The issue is when I rotate the rectangle, the collider visibly becomes wrong.  This is before rotation:    This is after rotating on the y axis:    The collider does seem to rotate, but not at the correct amount. Can anyone shed some light as to what's going on here?  Here's the inspector and hierarchy:      I also tried making the plane a cube, it didn't change anything. I am trying to create a schema page in LaTeX. It shall look like this.   How can I create schema code which look like this image? There should be also a click to go function. When the user clicks on the user_schema link he should be redirected to that page.  What classes I can use for this? Any suggestions would be appreciated.    \documentclass{article} \usepackage[utf8]{inputenc}  \begin{document} \maketitle  \section{User schema} \mySchema{Users} {     _id: ObjectId - Id do registro     name: String - Nome do usuário     date: Date - Data de Cadastro     ren_date: Date - Data de renovação do Cadastro     email: String - Lorem ipsum dolorsitamet, consecteturadipisicingelit, sed do eiusmodtemporincididunt ut labore et dolore magna aliqua. Ut enim ad minimveniam, exercitationullamcolaborisnisi ut aliquipexeacommodoconsequat. Duisautereprehenderit in voluptatevelit esse cillumdolore eu fugiatnullapariatur. Occaecatcupidatat non proident, sunt in culpa quiofficiadeseruntmollit.     access_log: Array [          {              date: String - Data da ocorrência.             user: ObjectId - Usuário que executou.             action: String - Ação Executada.         }         {              date: String - Data da ocorrência.             user: ObjectId - Usuário que executou.             action: String - Ação Executada.         }     ]     \link{group}{group_id}: ObjectId - Id do grupo. } \end{document}   Here is the image how should it appear: Is $C[0,1]$ a Banach space for the $L^1$ norm? Is $C[0,1]$ a Banach space with respect to the norm $\|f\| = \int\limits_0^1|f(t)| \, dt$?   People keep telling me it is, but lets consider: $f_n(x) = x^n$. This function defines a Cauchy sequence, yet the limit clearly isn't a continuous function! How to capture Control+D signal? Reason for LCM of all numbers from 1 .. n equals roughly $e^n$ I computed the LCM for all natural numbers from 1 up to a limit $n$ and plotted the result over $n$.  Due to the fast-raising numbers, I plotted the logarithm of the result and was surprised to find a (more or less) identity curve ($x=y$).  In other words, $LCM(1, 2, 3, ..., n)$ appears to be roughly the value $e^n$.  Is a there a simple explanation on why this is so?  $LCM(a, b, c, …)$ shall be defined as the least common multiple of all arguments $a, b, c, …$ I want to build a flow to trigger an email when a date in one of the fields is nearing. I have a field named Payment due date. is it possible to trigger an email 2 days prior to the Payment due date. So that I don't miss the payment due date and payment is not delayed. Any kind of assistance is appreciated. Thank you very much in advance! Which of the following two sentences is correct?  He must decide who to be. He must decide whom to be.  I can think of arguments for both sides, but I'm not sure. To elaborate, is who(m) the object of decide, the subject of be, or the object of be? Does the infinitive form of be have any bearing on the answer? And is there anything else to consider about the position or role of who(m) in this particular sentence that would inform the answer? The answers to the linked question  say to &quot;substitute he and him for who and whom.&quot; However, that doesn't give a clear answer in this context, because neither of those pronouns sounds right: &quot;He must decide to be he&quot;? &quot;He must decide to be him&quot;? Normally we'd use a reflexive pronoun here (&quot;He must decide to be himself&quot;) and it's not clear what case that corresponds to. Evaluate $\lim_{n\rightarrow\infty} \int_0^1 f(x^n) dx$ Let $f$ be a real, continuous function defined for all $0\leq x\leq 1$ such that $f(0)=1$, $f(1/2)=2$, and $f(1)=3$. Show that  $$\lim_{n\rightarrow\infty} \int_0^1 f(x^n) dx$$  exists and compute the limit.  Attempt:   Since $f$ is real-valued continuous on $0\leq x\leq 1$ and the boundaries $f(0)=1$ and $f(1)=3$, $f$ is bounded on the interval  and the integral $\displaystyle\int_0^1 f(x^n)dx$ exists for any positive $n$. Thus, we can interchange the limit and the integral and compose the limit, \begin{align*} \lim_{n\rightarrow\infty} \int_0^1 f(x^n)dx&amp;=\int_0^1\lim_{n\rightarrow\infty}f(x^n)dx\\ &amp;=\int_0^1 f\left(\lim_{n\rightarrow\infty} x^n \right)dx\\ &amp;=\int_0^1 f(0)dx=1. \end{align*}  Questions: So, my first question concerns whether interchanging the limit and the integral is correct. It seems it would be justified by the dominated convergence theorem, where $f(x^n)$ is dominated by a function $g(x)=\displaystyle\sup_{0\leq x\leq 1} f(x^n)$ and $f_n(x^n)$, on $0\leq x\leq 1$, converges pointwise to a function $f$ that takes value 1 for $x\neq 1$ and 3 for $x=1$.  My next question is whether the interchange between the limit and composition of the function is allowed. Since the function is continuous and the limit exists at that point, it seems the interchange would be justified.