I'm new to Blender and I want to project an image on a plane from a spotlight but I'm having difficulty.  This  says to find Texture panel for the lamp which I can't find. There is a Texture panel in 2.80 but it doesn't seem connected to the spotlight. I presume these instructions are for 2.79 or earlier.  Can someone direct me to a useful link or at least give a general overview of how to do this in Blender 2.80?
What is the correct vector input for a texture connected to a Cycles lamp so that I can make a projector-like textured light?  I am trying to make an projector-like effect with a textured light in Cycles, currently trying it out with a Spot type of lamp, but I am open to any solution involving other lamp types if they work correctly.  The problem is that whatever vector input I use, the texture is always projected downwards, towards the global $-Z$ axis in scene world space, no matter where I point my spot light. I would like to have the texture always project "forward" towards the the direction the spot light is pointing, in the local $-Z$ axis.    The plan would then be to use this spot at several places in my scene, pointing at different directions, and as it currently stands I would have to have a different node setup for each spot instance, manually compensating for each unique rotation in the scene, which would quickly become unpractical.  I have searched around the internet and I am currently using a solution similar to the one on this .  Is there any better method, perhaps involving some funky Vector Math, or is this not currently supported?
LINQ to SQL Where Clause Optional Criteria I am working with a LINQ to SQL query and have run into an issue where I have 4 optional fields to filter the data result on.  By optional, I mean has the choice to enter a value or not.  Specifically, a few text boxes that could have a value or have an empty string and a few drop down lists that could have had a value selected or maybe not...  For example:      using (TagsModelDataContext db = new TagsModelDataContext())      {         var query = from tags in db.TagsHeaders                     where tags.CST.Equals(this.SelectedCust.CustCode.ToUpper())                      &amp;&amp; Utility.GetDate(DateTime.Parse(this.txtOrderDateFrom.Text)) &lt;= tags.ORDDTE                     &amp;&amp; Utility.GetDate(DateTime.Parse(this.txtOrderDateTo.Text)) &gt;= tags.ORDDTE                     select tags;         this.Results = query.ToADOTable(rec =&gt; new object[] { query });     }   Now I need to add the following fields/filters, but only if they are supplied by the user.   Product Number - Comes from another table that can be joined to TagsHeaders. PO Number - a field within the TagsHeaders table. Order Number - Similar to PO #, just different column. Product Status - If the user selected this from a drop down, need to apply selected value here.   The query I already have is working great, but to complete the function, need to be able to add these 4 other items in the where clause, just don't know how! Please help me prove this. I'm not sure how to apply the parallelogram law to the norm. Why is spawning threads in Java EE container discouraged? One of the first things I've learned about Java EE development is that I shouldn't spawn my own threads inside a Java EE container. But when I come to think about it, I don't know the reason.  Can you clearly explain why it is discouraged?   I am sure most enterprise applications need some kind of asynchronous jobs like mail daemons, idle sessions, cleanup jobs etc.  So, if indeed one shouldn't spawn threads, what is the correct way to do it when needed? Proof of dividing fractional expressions For dividing two fractional expressions, how does the division sign turns into multiplication? Is there a step by step proof which proves  $$\frac{a}{b} \div \frac{c}{d} = \frac{a}{b} \cdot \frac{d}{c}=\frac{ad}{bc}?$$ Stack Overflow interesting questions implementation According to the tooltip of the 'interesting' tab, interesting questions are     "questions that may be of interest to you based on your history and tag preferences"   Does Stack Overflow use a recommendation engine or just some sql sort/filter? Do I need a visa for Paris, if my connecting flight stops for 24 hours in Paris? Do I need visa for Paris, if my connecting flight stops at Paris for 24hrs and I want to visit Paris during that 24hrs? I have US B1 visa. I'll be travelling from San Francisco to Bangalore (India) via Paris. I hold Indian passport. If yes, what is the procedure for that visa? In the United States, we say that someone lives on a street, whereas I've noticed that British people say in. For instance:     Bubba lives on Washington Street.   Colin lives in Cavendish Avenue.   I believe we both would use at when a number is given. For instance:     Bubba lives at 16 Washington Street.   Colin lives at 7 Cavendish Avenue.   I don't think it matters if it's a road, avenue, street, circle, or lane — as far as I know, in America, we always live on a street. Does it vary in British English, or is it always in? If it varies, what are the rules? I have the loop tools addon enabled and when I click the circle button with these verts selected, it just disappears. Why is that?  You can see the selected options in the bottom screenshot. It is worth noting that all the verts are flat on the x plane. Locking in X or not does not change the effect.   When I use the to sphere operator it squishes the verts on Z and stretches super wide on Y, not making a cirlce.    EDIT:  here is the blend How to disable all caches in safari 11? I just got a question in the review queue that, though poor, I thought was potentially salvageable via editing.  However when I clicked the Edit button I got the deleted post error.  Since the post was gone, I clicked I'm Done (what is there do do with a deleted post?) only to get the review audit failed message instead.  The current behavior is also problematic in that, now that I know about it, it's a risk-free way to check if a question is an audit and not an actual review. That allows me or anyone else who knows about it to detect audits without having to recognize that the question is bad. What is the mysterious stranger doing in my vault? com.google.android.trichromelibrary causes many Android apps to crash Recently, apps that are fine an hour ago now crash when I open them. The crash report message seems to be caused by a null pointer exception (NPE) in com.google.android.trichromelibrary. Apps affected for me:  Gmail Dashlane  Is it just me, or is there actually something wrong with the library? How can I fix these affected apps? Crash report: *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** Build fingerprint: 'Xiaomi/polaris/polaris:10/QKQ1.190828.002/20.9.4:user/release-keys' Revision: '0' ABI: 'arm64' Timestamp: ... pid: ..., tid: ..., name: com.dashlane &gt;&gt;&gt; com.dashlane &lt;&lt;&lt; uid: ... signal 11 (SIGSEGV), code 1 (SEGV_MAPERR), fault addr 0x0 Cause: null pointer dereference          ...  backtrace:     #00 pc 00000000038621f0 /data/app/ com.google.android.trichromelibrary 438909034-YaxP9ttrIDcQBfleP5vm7Q==/base.apk! libmonochrome_64.so (offset 0x646000) (BuildId: ... )  (click  for the screenshot of the bug report) I constantly have problems working with dates in Excel, I must be doing something wrong but I don't understand what.  I have a spreadsheet, exported from our exchange server, that contains a column with dates on. They have come out in US format even though I'm in the UK.   The column in question looks like this  04/08/2012 04/09/2009 04/01/2010 04/21/2011 04/05/2012 08/30/2009 08/29/2010 08/28/2011   In Excel, I have highlighted the column and selected Format Cells.... In this dialog box, I have selected the Date, selected English (United States) as the locale and chosen the matching date format from the list. I hit OK and try to sort the data by this column.   In the sort dialogue I choose this column, select sort on Values but the order only gives me options for A to Z, not oldest to newest as I would expect.  This in turn sorts the date data by the first two digits.  I am aware I could re-format this data to ISO and then the A to Z sort would work but I shouldn't have too, I'm obviously missing something. What is it?  EDIT: I messed up the bounty but this should have gone to @r0berts answer, his first suggestion of Text to Columns with no delimiter and choosing 'MDY' as the type of data works. Additionally, if you have a time (i.e. 04/21/2015 18:34:22), you need to first get rid of the time data. However after that the method suggested by @r0berts works fine. How add 14 days on end date I have End Date column and I want to add 14 Days on it auto when created, can I do it by workflow? Can I do it via jQuery. If yes how? if no how I can do it? Is it possible to find the origin of a virus? Is there any method with which you can determine the origin for a given piece of malware in Windows?  One of my PCs was recently infected with the  password stealing trojan. Is there any way to tell from what source this virus was downloaded from? How can I report bugs with or request features for the Stack Exchange mobile apps? I'm using the official Stack Exchange mobile app for iOS or Android, and  My app crashed! It doesn't look good on my new smartphone. It won't run after I updated my device. I noticed another bug. I have an idea for a new feature which is currently not in the app.  How do I report bugs with or request features for the iOS and Android apps? Also:  I've used the built-in functionality of the app to report a bug or submit a feature request. Did I do the right thing? The app prompted me to post on Meta after an error occurred. Should I post about it here? I'm wondering why the latest version is from 2017. I've heard rumors that the apps are no longer supported; is that true? I can't find the app on my device's app store anymore! Where did it go?     We get a lot of bug reports from users about the mobile apps, which are unsupported, and at the moment, there is no centralized Q&amp;A pair for those to be closed as duplicates of (the relevant answers are spread across multiple unrelated questions). This question is an FAQ proposal, to serve as a directly-related duplicate target for those questions. How to change folders color? How do i change the folders colors? i am using this icon theme   and there are several folders. like black, gray, purple, orange(which is the default), yellow, green, red, blue, brown and lightblue  How can i use any of them? for example have a blue folder called "family" in images and another right beside that have a purple folder called "others".  Basically why have he created all those folders with different colors? How to set systemwide "XP style DPI scaling" in Windows 8.1? I run my ThinkPad with a system DPI setting of 140%. In Windows 7 and 8, I enabled the "Use Windows XP style DPI scaling" checkbox in the Custom DPI Setting dialog. When this setting is off, non-DPI-aware applications get DPI virtualization via bitmap stretching, which results in large but fuzzy text. Turning on the checkbox disables this bitmap stretching, so non-DPI-aware apps get smaller text but without the fuzzy stretching. I find most apps to be more readable with the smaller crisper text, so I enable XP style scaling (i.e. disable DPI virtualization).  Windows 8.1 RTM has removed this option completely. After upgrading, all of my non-DPI-aware apps are running with ugly bitmap stretching. I'm able to fix this by going into the Properties for each app and setting the "Disable diplay scaling on high DPI settings" box in the Compatibility tab, but that is a bit of a pain.  Is there any way to restore the systemwide XP-style DPI scaling in Windows 8.1? Intuitive explanation for dividing by $n-1$ when calculating standard deviation? I was asked today in class why you divide the sum of square error by $n-1$ instead of with $n$, when calculating the standard deviation.  I said I am not going to answer it in class (since I didn't wanna go into unbiased estimators), but later I wondered - is there an intuitive explanation for this?! Can massive damage knock out rather than causing instant death? Suppose, as happened last night, a character intends to subdue rather than kill an opponent. She made a melee attack, hit, declared her intent to knock out. The damage roll was enough to reduce the opponent to zero and the remaining damage exceeded the opponent's maximum HP. Now we would seem to have two rules invoked:  Instant Death. Massive damage can kill you instantly. When damage reduces you to 0 hit points and there is damage remaining, you die if the remaining damage equals or exceeds your hit point maximum. (PHB p.197) Knocking a Creature Out. When an attacker reduces a creature to 0 hit points with a melee attack, the attacker can knock the creature out. The attacker can make this choice the instant the damage is dealt. The creature falls unconscious and is stable. (PHB p.198)  So which rule takes precedence? Or is it neither?