How to do join on multiple criteria, returning all combinations of both criteria?
I am willing to bet that this is a really simple answer as I am a noob to SQL. Given: - - There can be anywhere from 1 - 5 values of criteria 2 for each criteria 1 on the table. When I use the join s...
- Modified
- 2 Nov at 00:46
How to get current working directory using vba?
I am using MS Excel 2010 and trying to get the current directory using the below code, ``` path = ActiveWorkbook.Path ``` But ActiveWorkbook.Path returns blank.
How to call a method with a separate thread in Java?
let's say I have a method `doWork()`. How do I call it from a separate thread (not the main thread).
- Modified
- 16 Aug at 01:53
How to keep Docker container running after starting services?
I've seen a bunch of tutorials that seem do the same thing I'm trying to do, but for some reason my Docker containers exit. Basically, I'm setting up a web-server and a few daemons inside a Docker con...
- Modified
- 17 Jan at 13:1
docker entrypoint running bash script gets "permission denied"
I'm trying to dockerize my node.js app. When the container is built I want it to run a `git clone` and then start the node server. Therefore I put these operations in a .sh script. And run the script ...
How to recover MySQL database from .myd, .myi, .frm files
How to restore one of my MySQL databases from `.myd`, `.myi`, `.frm` files?
Key hash for Android-Facebook app
I'm working on an Android app, in which I want to integrate a Facebook posting feature. I downloaded the Facebook-Android SDK, and I got the readme.md (text file) in there, in which it is mentioned to...
How to display a Windows Form in full screen on top of the taskbar?
I have a .net windows application that needs to run in full screen. When the application starts however the taskbar is shown on top of the main form and it only disappears when activating the form by ...
- Modified
- 16 Jan at 17:35
"webxml attribute is required" error in Maven
I am getting the following error: > Error assembling WAR: webxml attribute is required (or pre-existing WEB-INF/web.xml if executing in update mode) I have got `web.xml` in right place which is `pr...
Get the first item from an iterable that matches a condition
I would like to get the first item from a list matching a condition. It's important that the resulting method not process the entire list, which could be quite large. For example, the following functi...
CSS: how do I create a gap between rows in a table?
Meaning making the resultant table look less like this: ... and more like this: I tried adding ``` margin-bottom:1em; ``` to both and but got nothing. Any ideas?
How to turn a String into a JavaScript function call?
I got a string like: ``` settings.functionName + '(' + t.parentNode.id + ')'; ``` that I want to translate into a function call like so: ``` clickedOnItem(IdofParent); ``` This of course will ha...
- Modified
- 23 Jul at 15:13
Quickest way to find missing number in an array of numbers
I have an array of numbers from 1 to 100 (both inclusive). The size of the array is 100. The numbers are randomly added to the array, but there is one random empty slot in the array. What is the quic...
Typescript: No index signature with a parameter of type 'string' was found on type '{ "A": string; }
I have some vanilla javascript code that takes a string input, splits the string into characters, and then matches those characters to a key on an object. ``` DNATranscriber = { "G":"C", "C":...
- Modified
- 12 Jun at 19:9
List files recursively in Linux CLI with path relative to the current directory
This is similar to [this question](https://stackoverflow.com/questions/105212/linux-recursively-list-all-files-in-a-directory-including-files-in-symlink-dire), but I want to include the path relative ...
DateTime vs DateTimeOffset
What is the difference between a `DateTime` and a `DateTimeOffset` and when should one be used? --- Currently, we have a standard way of dealing with .NET `DateTime`s in a TimeZone-aware way: Whene...
- Modified
- 21 Feb at 15:28
RegEx to extract all matches from string using RegExp.exec
I'm trying to parse the following kind of string: ``` [key:"val" key2:"val2"] ``` where there are arbitrary key:"val" pairs inside. I want to grab the key name and the value. For those curious I'm...
- Modified
- 20 Sep at 15:2
What's the difference between `raw_input()` and `input()` in Python 3?
What is the difference between `raw_input()` and `input()` in Python 3?
- Modified
- 31 Jan at 22:12
How to hide TabPage from TabControl
How to hide TabPage from TabControl in WinForms 2.0?
- Modified
- 16 Feb at 08:15
NPM global install "cannot find module"
I wrote a module which I published to npm a moment ago (https://npmjs.org/package/wisp) So it installs fine from the command line: `$ npm i -g wisp` However, when I run it from the command line, I ...
How to get all selected values of a multiple select box?
I have a `<select>` element with the `multiple` attribute. How can I get this element's selected values using JavaScript? Here's what I'm trying: ``` function loopSelected() { var txtSelectedV...
- Modified
- 31 Aug at 13:30
How to keep footer at bottom of screen
What is best practice for setting up a web page so that if there is very little content/text to be displayed on that web page the footer is displayed at the bottom of the browser window and not half w...
How to create a release signed apk file using Gradle?
I would like to have my Gradle build to create a release signed apk file using Gradle. I'm not sure if the code is correct or if I'm missing a parameter when doing `gradle build`? This is some of the ...
- Modified
- 28 Dec at 13:22
Change the current directory from a Bash script
Is it possible to change current directory from a script? I want to create a utility for directory navigation in Bash. I have created a test script that looks like the following: ``` #!/bin/bash cd ...
- Modified
- 11 Jan at 19:19
Place cursor at the end of text in EditText
I am changing the value of an `EditText` on `keyListener`. But when I change the text the cursor is moving to the beginning of the `EditText`. I need the cursor to be at the end of the text. How to ...
- Modified
- 26 Jan at 19:52