Questions

Undo git pull, how to bring repos to old state

Is there any way to revert or undo git pull so that my source/repos will come to old state that was before doing git pull ? I want to do this because it merged some files which I didn't want to do so,...

5 Dec at 17:42

What should be in my .gitignore for an Android Studio project?

What files should be in my `.gitignore` for an Android Studio project? I've seen several examples that all include `.iml` but IntelliJ docs say that `.iml` must be included in your source control.

19 May at 14:42

What is the difference between the remap, noremap, nnoremap and vnoremap mapping commands in Vim?

What is the difference between the `remap`, `noremap`, `nnoremap` and `vnoremap` mapping commands in Vim?

16 Apr at 08:4

How can I pass arguments to a batch file?

I need to pass an ID and a password to a batch file at the time of running rather than hardcoding them into the file. Here's what the command line looks like: ``` test.cmd admin P@55w0rd > test-log....

30 Jan at 10:3

How and when to use ‘async’ and ‘await’

From my understanding one of the main things that [async and await](https://learn.microsoft.com/en-us/dotnet/csharp/async) do is to make code easy to write and read - but is using them equal to spawni...

28 Sep at 20:12

How can I declare and use Boolean variables in a shell script?

I tried to declare a Boolean variable in a shell script using the following syntax: ``` variable=$false variable=$true ``` Is this correct? Also, if I wanted to update that variable would I use th...

23 Oct at 12:16

How can I create a two dimensional array in JavaScript?

I have been reading online and some places say it isn't possible, some say it is and then give an example and others refute the example, etc. 1. How do I declare a 2 dimensional array in JavaScript...

How can I remove duplicate rows?

I need to remove duplicate rows from a fairly large SQL Server table (i.e. 300,000+ rows). The rows, of course, will not be perfect duplicates because of the existence of the `RowID` identity field. ...

16 Aug at 15:54

How to copy a dictionary and only edit the copy

I set `dict2 = dict1`. When I edit `dict2`, the original `dict1` also changes. Why? ``` >>> dict1 = {"key1": "value1", "key2": "value2"} >>> dict2 = dict1 >>> dict2["key2"] = "WHY?!" >>> dict1 {'key2'...

10 Apr at 10:46

Asynchronous vs synchronous execution. What is the difference?

What is the difference between asynchronous and synchronous execution?

25 Sep at 04:49

Multiline string literal in C#

Is there an easy way to create a multiline string literal in C#? Here's what I have now: ``` string query = "SELECT foo, bar" + " FROM table" + " WHERE id = 42"; ``` I know PHP has ``` <<<BLOCK ...

20 Nov at 12:6

Which MySQL data type to use for storing boolean values

Since MySQL doesn't seem to have any 'boolean' data type, which data type do you 'abuse' for storing true/false information in MySQL? Especially in the context of writing and reading from/to a PHP sc...

4 May at 19:39

How to drop rows of Pandas DataFrame whose value in a certain column is NaN

I have this `DataFrame` and want only the records whose `EPS` column is not `NaN`: ``` >>> df STK_ID EPS cash STK_ID RPT_Date 601166 20111231 601166 NaN NaN ...

13 Jul at 01:4

Trim string in JavaScript

How do I remove all whitespace from the start and end of the string?

13 Jun at 01:47

Convert JS object to JSON string

If I defined an object in JS with: ``` var j={"name":"binchen"}; ``` How can I convert the object to JSON? The output string should be: ``` '{"name":"binchen"}' ```

16 Oct at 15:42

What does "static" mean in C?

I've seen the word `static` used in different places in C code; is this like a static function/class in C# (where the implementation is shared across objects)?

29 Oct at 15:42

How do I determine the size of my array in C?

How do I determine the size of my array in C? That is, the number of elements the array can hold?

20 Jan at 16:31

pg_config executable not found

I am having trouble installing psycopg2. I get the following error when I try to `pip install psycopg2`: ``` Error: pg_config executable not found. Please add the directory containing pg_config to t...

11 Dec at 15:27

Altering a column: null to not null

I have a table that has several nullable integer columns. This is undesirable for several reasons, so I am looking to update all nulls to 0 and then set these columns to `NOT NULL`. Aside from changi...

"Notice: Undefined variable", "Notice: Undefined index", "Warning: Undefined array key", and "Notice: Undefined offset" using PHP

I'm running a PHP script and continue to receive errors like: > Notice: Undefined variable: my_variable_name in C:\wamp\www\mypath\index.php on line 10Notice: Undefined index: my_index C:\wamp\www\myp...

jQuery document.createElement equivalent?

I'm refactoring some old JavaScript code and there's a lot of DOM manipulation going on. ``` var d = document; var odv = d.createElement("div"); odv.style.display = "none"; this.OuterDiv = odv; var ...

22 Jan at 20:18

Git merge hotfix branch into feature branch

Let’s say we have the following situation in Git: 1. A created repository: mkdir GitTest2 cd GitTest2 git init 2. Some modifications in the master take place and get committed: echo "On Master" > fi...

Difference between JOIN and INNER JOIN

Both these joins will give me the same results: ``` SELECT * FROM table JOIN otherTable ON table.ID = otherTable.FK ``` vs ``` SELECT * FROM table INNER JOIN otherTable ON table.ID = otherTable.FK...

19 Apr at 13:43

Getting key with maximum value in dictionary?

I have a dictionary where keys are strings, and values are integers. ``` stats = {'a': 1, 'b': 3000, 'c': 0} ``` How do I get the key with the maximum value? In this case, it is `'b'`. --- Is ther...

9 Apr at 09:53

How can I list the tables in a SQLite database file that was opened with ATTACH?

What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I have attached it with the `ATTACH` command on the SQLite 3 command line tool?

6 Aug at 15:57