How can I dynamically populate a query with a List / Array of items in SQL WHERE IN I have a List&lt;Long&gt; matchingLongs = new Arraylist(); that I would like to pass to an SQL statement :    WHERE Id IN (matchingLongs);     How can I dynamically populate the Longs into the query?    If I would print to console it should look like :    WHERE Id IN (1223, 9834, 3, 924, 88778, 65652165223, 34, 8723738793287);     Thank you all.
PreparedStatement IN clause alternatives? What are the best workarounds for using a SQL IN clause with instances of java.sql.PreparedStatement, which is not supported for multiple values due to SQL injection attack security issues: One ? placeholder represents one value, rather than a list of values.  Consider the following SQL statement:  SELECT my_column FROM my_table where search_column IN (?)   Using preparedStatement.setString( 1, "'A', 'B', 'C'" ); is essentially a non-working attempt at a workaround of the reasons for using ? in the first place.    What workarounds are available?
Find objects between two dates MongoDB How can i get currency symbols from currency code in iphone? Can fresh pasta sheets be used to assemble a lasagne, then left in the fridge overnight before baking? Or will this make them mushy or otherwise degrade them?  I have recently gotten into making fresh pasta, and I want to prep a lasagne the night before. I have done this before with store-bough dried noodles, but I'm not sure if doing this will have a negative effect on fresh, more delicate pasta. See code:   var file1 = "50.xsl"; var file2 = "30.doc"; getFileExtension(file1); //returns xsl getFileExtension(file2); //returns doc  function getFileExtension(filename) {     /*TODO*/ } Crossfading Video AND Audio with ffmpeg This Super User answer  has got me so far, but now that I have tried many solutions and seen every SO link out there, it's time to ask you all for help.  I am trying to crossfade 2 videos that are 10 seconds each in ts format with audio and video at the same time.   The steps are:   Add complex filter black screen Fade out video 1 after 9 seconds, with 1 second fade duration Fade in video 2 at 9 seconds, with 1 second fade duration Trim black filter output to 19 seconds   This works fine for just video alone, but when I attempt to add audio, I can't get past this error message:     Output pad "default" with type audio of the filter instance "Parsed_asetpts_4" of asetpts not connected to any destination   It appears I'm not connecting the audio output properly. I think I need to alter the [over] lines to include audio. But how do I do this?  `ffmpeg -i vid1.ts -i vid2.ts -f lavfi -i color=black -filter_complex \ "[0:v]format=pix_fmts=yuva420p,\ fade=t=out:st=9:d=1:alpha=1,setpts=PTS-STARTPTS[v0];\ [0:a]\ afade=t=out:st=9:d=1,asetpts=PTS-STARTPTS[a0];\ [1:v]format=pix_fmts=yuva420p,\ fade=t=in:st=0:d=1:alpha=1,setpts=PTS-STARTPTS+9/TB[v1];\ [1:a]\ afade=t=in:st=0:d=1,asetpts=PTS-STARTPTS+9/TB[a1];\ [a0][a1]amix=inputs=2;\  [2:v]scale=720x406,trim=duration=19[over];\ [over][v0]overlay[over1];\ [over1][v1]overlay=format=yuv420[outv]" -vcodec libx264 -y -map [outv] final.ts` After installing NVIDIA driver, X isn't showing I recently installed the NVIDIA 319 driver from the Jockey window, and now X won't load! I'm stuck with a blinking cursor. I used to have the 304 drivers installed.  How do I fix this? Process Unicode files with BOM correctly with POSIX tools Trying to use grep today, I ran into the  of the  in a Unicode file (UTF-8, in this case). Specifically, I was trying to find a file beginning with XYZ with the pattern grep '^XYZ', but of course grep treated the BOM as three separate characters and did not match the first line of the file if the first line started with XYZ. I even tried to update the regular expression to ignore spaces ('^[[:space:]]*XYZ'), but to no avail.  Other questions have dealt with  or , but I want to know if POSIX tools have a general option to handle Unicode files correctly. If grep handled the Unicode file correctly, it would consider the file contents to start after the BOM and match XYZ on the first line just like any other line. Let $f:X\to Y$ be a function and $E\subseteq X$ and $F\subseteq X$.   Show that in general $f(E − F)\nsubseteq f(E) − f(F)$.   I have no idea about how to prove this; and could anyone please explain the basic theory of functions(by relating to this question. Thank you. In $\mathbb{R}$ with standard topology the closure of the above set $M$ is $M \cup 0$. I fail showing this by purely topological means. I.e. not using the fact that this holds in the reals as a metric space and deduce it for the induced topology.  I assumed that there exist a closed subset $A$ containing $M$ but not 0. Hence, the complement of $A$ is an open subset containing 0. Does this already yield a contradiction or do I need a different approach?  Could you help me on this? Bounding lines around tax nodes I am trying to draw lines around a number of nodes. I very much like the definition of \convexpath definition given , but it is not working well on my setup (MacTex 2014 with all available updates).   I tried to compile , but what I get is the following, which is clearly not what I should be getting. Any ideas would be much appreciated. When I run this command :  apt install libkf5*   I get the following error :  Unable to locate package libkf5*    I'm sure that the packages whose names start with libkf5 exist (tab-completion says so) . So the problem is not about the absence of those packages.(Note the asterisk at the end of that error message , the wildcard's not working at all) I use apt v.1.9. Thanks in advance. Removing an Ubuntu installation I first had windwos 7, then I installed Ubuntu alongside and when my laptop starts I can choose between ubuntu and windows (the ubuntu boot screen) .  Now I have installed another ubuntu inside the windows 7 using virtual box. I want to remove that first ubuntu installation and free up its partiotion. Can I do it without making any problems for the windows and boot screen? Can I replace my road bike's front wheel quick release with any quick release? I lost my road bike's quick release. Pictured are what I lost. Do I need to find a specific quick release that fits, or does one size fit all/most? Is it possible to prevent LUDecomposition from pivoting? The vast majority of intelligent species in the Star Trek universe are bipedal, humanoid creatures.  From the lot I've seen of TOS, TNG, DS9, Voyager, Enterprise, and the movies, it seems that this coincidence goes largely unquestioned.  Metaknowledge grants that it is much easier to have human actors portray human-like beings, and so this was probably done due to budgetary/technological limitations.  However, I'm wondering if an in-universe reason for this was ever given or explored? Why is it called John Dies at the End? The 2012 adaptation of David Wong's "John Dies at the End" ends without John dying at the end at all. While the core of the film espouses the belief that time is not linear, the word "end" suggests there is a beginning and an end to things.  Why is the movie called John Dies at the End? This is a  about Active Directory domain naming.   After experimenting with Windows domains and domain controllers in a virtual environment, I've realized that having an active directory domain named identically to a DNS domain is bad idea (Meaning that having example.com as an Active Directory name is no good when we have the example.com domain name registered for use as our website).   , but I'm still not sure about what other rules there are around naming Active Directory domains.  Are there any best practices on what an Active Directory name should or shouldn't be? I am debating whether or not to get the Potato Sack (yes, I realize I've been debating for several weeks now) bundle through steam.  I already own: Defense Grid: The Awakening, Super Meat Boy, and Audiosurf, all of which are part of the sack pack. What happens if I buy the Potato Sack?  Do I get 2nd copies of the three above mentioned games to gift elsewhere?  Is the price of the bundle reduced by the games I already have?  Do I get nothing special for already owning those 3 games? Smallest Width for Galaxy S and Galaxy S2 Is "architect" a verb and a noun? I hear the word architect used as a verb in the technical field and now more often in other industries and groups, for example:     We need to architect a better solution to the problem.   I am interested if this is considered acceptable usage, as I see this word being used more in published technical documents (not necessarily books, but corporate publications).  I can see how a conductor can conduct, a typist can type, but can a scientist "science"?  A scientist might research, analyze, and so forth, as an architect might design, create, build, etc.  Merriam-Webster , however, I have been told that other dictionaries exist that define architect as both a noun and a verb&nbsp;— is there a credible reference or source that authoritatively answers this question?