# Programs & Examples On #Power series

### How do I calculate the date six months from the current date using the datetime Python module?

This solution works correctly for December, which most of the answers on this page do not. You need to first shift the months from base 1 (ie Jan = 1) to base 0 (ie Jan = 0) before using modulus ( % ) or integer division ( // ), otherwise November (11) plus 1 month gives you 12, which when finding the remainder ( 12 % 12 ) gives 0.

(And dont suggest "(month % 12) + 1" or Oct + 1 = december!)

``````def AddMonths(d,x):
newmonth = ((( d.month - 1) + x ) % 12 ) + 1
newyear  = int(d.year + ((( d.month - 1) + x ) / 12 ))
return datetime.date( newyear, newmonth, d.day)
``````

However ... This doesnt account for problem like Jan 31 + one month. So we go back to the OP - what do you mean by adding a month? One solution is to backtrack until you get to a valid day, given that most people would presume the last day of jan, plus one month, equals the last day of Feb. This will work on negative numbers of months too. Proof:

``````>>> import datetime
datetime.date(2010, 9, 25)
datetime.date(2010, 12, 25)
datetime.date(2011, 1, 25)
datetime.date(2011, 9, 25)
datetime.date(2012, 8, 25)
datetime.date(2010, 7, 25)
datetime.date(2010, 8, 25)
datetime.date(2009, 8, 25)
datetime.date(2009, 12, 25)
datetime.date(2010, 1, 25)>>>
``````

### Using mysql concat() in WHERE clause?

What you have should work but can be reduced to:

``````select * from table where concat_ws(' ',first_name,last_name)
like '%\$search_term%';
``````

Can you provide an example name and search term where this doesn't work?

### What is the default access modifier in Java?

Default access modifier is package-private - visible only from the same package

### How to decrypt Hash Password in Laravel

``````if(password_verify('1234567', \$crypt_password_string)) {
// in case if "\$crypt_password_string" actually hides "1234567"
}
``````

### How to override trait function and call it from the overridden function?

Your last one was almost there:

``````trait A {
function calc(\$v) {
return \$v+1;
}
}

class MyClass {
use A {
calc as protected traitcalc;
}

function calc(\$v) {
\$v++;
return \$this->traitcalc(\$v);
}
}
``````

The trait is not a class. You can't access its members directly. It's basically just automated copy and paste...

### MSOnline can't be imported on PowerShell (Connect-MsolService error)

I'm using a newer version of the SPO Management Shell. For me to get the error to go away, I changed my Import-Module statement to use:

`Import-Module Microsoft.Online.SharePoint.PowerShell -DisableNameChecking;`

I also use the newer command:

`Connect-SPOService`

### Angular @ViewChild() error: Expected 2 arguments, but got 1

Use this

@ViewChild(ChildDirective, {static: false}) Component

### Git - Pushing code to two remotes

In recent versions of Git you can add multiple `pushurl`s for a given remote. Use the following to add two `pushurl`s to your `origin`:

``````git remote set-url --add --push origin git://original/repo.git
git remote set-url --add --push origin git://another/repo.git
``````

So when you push to `origin`, it will push to both repositories.

UPDATE 1: Git 1.8.0.1 and 1.8.1 (and possibly other versions) seem to have a bug that causes `--add` to replace the original URL the first time you use it, so you need to re-add the original URL using the same command. Doing `git remote -v` should reveal the current URLs for each remote.

UPDATE 2: Junio C. Hamano, the Git maintainer, explained it's how it was designed. Doing `git remote set-url --add --push <remote_name> <url>` adds a `pushurl` for a given remote, which overrides the default URL for pushes. However, you may add multiple `pushurl`s for a given remote, which then allows you to push to multiple remotes using a single `git push`. You can verify this behavior below:

``````\$ git clone git://original/repo.git
\$ git remote -v
origin  git://original/repo.git (fetch)
origin  git://original/repo.git (push)
\$ git config -l | grep '^remote\.'
remote.origin.url=git://original/repo.git
``````

Now, if you want to push to two or more repositories using a single command, you may create a new remote named `all` (as suggested by @Adam Nelson in comments), or keep using the `origin`, though the latter name is less descriptive for this purpose. If you still want to use `origin`, skip the following step, and use `origin` instead of `all` in all other steps.

So let's add a new remote called `all` that we'll reference later when pushing to multiple repositories:

``````\$ git remote add all git://original/repo.git
\$ git remote -v
origin  git://original/repo.git (fetch)
origin  git://original/repo.git (push)
\$ git config -l | grep '^remote\.all'
``````

Then let's add a `pushurl` to the `all` remote, pointing to another repository:

``````\$ git remote set-url --add --push all git://another/repo.git
\$ git remote -v
all git://original/repo.git (fetch)
all git://another/repo.git (push)                 <-- CHANGED
origin  git://original/repo.git (fetch)
origin  git://original/repo.git (push)
\$ git config -l | grep '^remote\.all'
remote.all.url=git://original/repo.git
``````

Here `git remote -v` shows the new `pushurl` for push, so if you do `git push all master`, it will push the `master` branch to `git://another/repo.git` only. This shows how `pushurl` overrides the default url (remote.all.url).

Now let's add another `pushurl` pointing to the original repository:

``````\$ git remote set-url --add --push all git://original/repo.git
\$ git remote -v
all git://original/repo.git (fetch)
all git://another/repo.git (push)
origin  git://original/repo.git (fetch)
origin  git://original/repo.git (push)
\$ git config -l | grep '^remote\.all'
remote.all.url=git://original/repo.git
remote.all.pushurl=git://another/repo.git
``````

You see both `pushurl`s we added are kept. Now a single `git push all master` will push the `master` branch to both `git://another/repo.git` and `git://original/repo.git`.

### Replace last occurrence of a string in a string

Below corrected zack's code (https://stackoverflow.com/a/11144999/9996503). Be careful with regular expressions! Consider this:

``````\$string = 'Round brackets (parentheses) "()", square brackets "()"';
\$find = '()';
\$replace = '[]';
// Zack's code:
\$result = preg_replace(strrev("/\$find/"),strrev(\$replace),strrev(\$string),1);
var_dump(\$result); // Output: NULL
// Correct code:
\$result = strrev(preg_replace('/'.preg_quote(strrev(\$find)).'/', strrev(\$replace), strrev(\$string), 1));
echo \$result; //Output: Round brackets (parentheses) "()", square brackets "[]"
``````

### What does this error mean: "error: expected specifier-qualifier-list before 'type_name'"?

You have to name your struct like that:

``````typedef struct car_t {

char

wheel_t

} car_t;
``````

### How to get the date 7 days earlier date from current date in Java

Java now has a pretty good built-in date library, java.time bundled with Java 8.

``````import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;

public class Foo {
public static void main(String[] args) {

DateTimeFormatter format =
DateTimeFormatter.ofPattern("yyyy-MM-dd'T'HH:mm:ss'Z'");

LocalDateTime now = LocalDateTime.now();
LocalDateTime then = now.minusDays(7);

System.out.println(String.format(
"Now:  %s\nThen: %s",
now.format(format),
then.format(format)
));
/*
Example output:
Now:  2014-05-09T14:51:48Z
Then: 2014-05-02T14:51:48Z
*/
}
}
``````

### if variable contains

You can use a regex:

``````if (/ST1/i.test(code))
``````

### Python: Find in list

If you want to find one element or `None` use default in `next`, it won't raise `StopIteration` if the item was not found in the list:

``````first_or_default = next((x for x in lst if ...), None)
``````

### Angular (4, 5, 6, 7) - Simple example of slide in out animation on ngIf

Actually the minimum amount of Angular to be used (as requested in the original question) is just adding a class to the DOM element when `show` variable is true, and perform the animation/transition via CSS.

So your minimum Angular code is this:

``````<div class="box-opener" (click)="show = !show">
Open/close the box
</div>

<div class="box" [class.opened]="show">
<!-- Content -->
</div>
``````

With this solution, you need to create CSS rules for the transition, something like this:

``````.box {
background-color: #FFCC55;
max-height: 0px;
overflow-y: hidden;
transition: ease-in-out 400ms max-height;
}

.box.opened {
max-height: 500px;
transition: ease-in-out 600ms max-height;
}
``````

If you have retro-browser-compatibility issues, just remember to add the vendor prefixes in the `transition`s.

### How do CSS triangles work?

Consider the below triangle

``````.triangle {
border-bottom:15px solid #000;
border-left:10px solid transparent;
border-right:10px solid transparent;
width:0;
height:0;
}
``````

This is what we are given:

Why it came out in this shape? The below diagram explains the dimensions, note that 15px was used for the bottom border and 10px was used for left and right.

It's pretty easy to make a right-angle triangle also by removing the right border.

### How do you add input from user into list in Python

code below allows user to input items until they press enter key to stop:

``````In [1]: items=[]
...: i=0
...: while 1:
...:     i+=1
...:     item=input('Enter item %d: '%i)
...:     if item=='':
...:         break
...:     items.append(item)
...: print(items)
...:

Enter item 1: apple

Enter item 2: pear

Enter item 3: #press enter here
['apple', 'pear']

In [2]:
``````

### How to convert any date format to yyyy-MM-dd

``````string sourceDateText = "31-08-2012";
DateTime sourceDate = DateTime.Parse(sourceDateText, "dd-MM-yyyy")
string formatted = sourceDate.ToString("yyyy-MM-dd");
``````

### How to implement my very own URI scheme on Android

This is very possible; you define the URI scheme in your AndroidManifest.xml, using the `<data>` element. You setup an intent filter with the `<data>` element filled out, and you'll be able to create your own scheme. (More on intent filters and intent resolution here.)

Here's a short example:

``````<activity android:name=".MyUriActivity">
<intent-filter>
<action android:name="android.intent.action.VIEW" />
<category android:name="android.intent.category.DEFAULT" />
<category android:name="android.intent.category.BROWSABLE" />
<data android:scheme="myapp" android:host="path" />
</intent-filter>
</activity>
``````

As per how implicit intents work, you need to define at least one action and one category as well; here I picked VIEW as the action (though it could be anything), and made sure to add the DEFAULT category (as this is required for all implicit intents). Also notice how I added the category BROWSABLE - this is not necessary, but it will allow your URIs to be openable from the browser (a nifty feature).

### Android Button setOnClickListener Design

Implement Activity with `View.OnClickListener` like below.

``````public class MyActivity extends AppCompatActivity implements View.OnClickListener {

@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_scan_options);

Button button = findViewById(R.id.button);
Button button2 = findViewById(R.id.button2);

button.setOnClickListener(this);
button2.setOnClickListener(this);
}

@Override
public void onClick(View view) {

int id = view.getId();

switch (id) {

case R.id.button:

// Write your code here first button

break;

case R.id.button2:

// Write your code here for second button

break;

}

}

}
``````

### What's the difference between session.persist() and session.save() in Hibernate?

This question has some good answers about different persistence methods in Hibernate. To answer your question directly, with save() the insert statement is executed immediately regardless of transaction state. It returns the inserted key so you can do something like this:

``````long newKey = session.save(myObj);
``````

So use save() if you need an identifier assigned to the persistent instance immediately.

With persist(), the insert statement is executed in a transaction, not necessarily immediately. This is preferable in most cases.

Use persist() if you don't need the insert to happen out-of-sequence with the transaction and you don't need the inserted key returned.

### Where is GACUTIL for .net Framework 4.0 in windows 7?

VS 2012/13 Win 7 64 bit gacutil.exe is located in

```C:\Program Files (x86)\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools
```

### How to use graphics.h in codeblocks?

2. Copy `graphics.h` and `winbgim.h` files in include folder of your compiler directory
3. Copy `libbgi.a` to lib folder of your compiler directory
4. In code::blocks open Settings >> Compiler and debugger >>linker settings click Add button in link libraries part and browse and select `libbgi.a` file
5. In right part (i.e. other linker options) paste commands `-lbgi -lgdi32 -lcomdlg32 -luuid -loleaut32 -lole32`
6. Click OK

### \$(this).serialize() -- How to add a value?

this better:

``````data: [\$(this).serialize(),\$.param({NonFormValue: NonFormValue})].join('&')
``````

### org.postgresql.util.PSQLException: FATAL: sorry, too many clients already

You need to close all your connexions for example: If you make an INSERT INTO statement you need to close the statement and your connexion in this way:

``````statement.close();
Connexion.close():
``````

And if you make a SELECT statement you need to close the statement, the connexion and the resultset in this way:

``````resultset.close();
statement.close();
Connexion.close();
``````

I did this and it worked

### How to print a certain line of a file with PowerShell?

This will show the 10th line of myfile.txt:

`get-content myfile.txt | select -first 1 -skip 9`

both `-first` and `-skip` are optional parameters, and `-context`, or `-last` may be useful in similar situations.

### How to convert hex string to Java string?

Just another way to convert hex string to java string:

``````public static String unHex(String arg) {

String str = "";
for(int i=0;i<arg.length();i+=2)
{
String s = arg.substring(i, (i + 2));
int decimal = Integer.parseInt(s, 16);
str = str + (char) decimal;
}
return str;
}
``````

### Importing PNG files into Numpy?

I like the build-in pathlib libary because of quick options like `directory= Path.cwd()` Together with opencv it's quite easy to read pngs to numpy arrays. In this example you can even check the prefix of the image.

``````from pathlib import Path
import cv2
prefix = "p00"
suffix = ".png"
directory= Path.cwd()
file_names= [subp.name for subp in directory.rglob('*') if  (prefix in subp.name) & (suffix == subp.suffix)]
file_names.sort()
print(file_names)

all_frames= []
for file_name in file_names:
file_path = str(directory / file_name)
all_frames.append(frame)
print(type(all_frames[0]))
print(all_frames[0] [1][1])
``````

Output:

``````['p000.png', 'p001.png', 'p002.png', 'p003.png', 'p004.png', 'p005.png', 'p006.png', 'p007.png', 'p008.png', 'p009.png']
<class 'numpy.ndarray'>
[255 255 255]
``````

### How to allow only a number (digits and decimal point) to be typed in an input?

There is an input number directive which I belive can do just what you want.

``````<input type="number"
ng-model="{string}"
[name="{string}"]
[min="{string}"]
[max="{string}"]
[required]
[ng-required="{string}"]
[ng-minlength="{number}"]
[ng-maxlength="{number}"]
[ng-pattern="{string}"]
[ng-change="{string}"]>
``````

the official doc is here: http://docs.angularjs.org/api/ng.directive:input.number

### How to print colored text to the terminal?

Here's a solution that works on Windows 10 natively.

Using a system call, such as `os.system("")`, allows colours to be printed in Command Prompt and Powershell natively:

``````import os

# System call
os.system("")

# Class of different styles
class style():
BLACK = '\033[30m'
RED = '\033[31m'
GREEN = '\033[32m'
YELLOW = '\033[33m'
BLUE = '\033[34m'
MAGENTA = '\033[35m'
CYAN = '\033[36m'
WHITE = '\033[37m'
UNDERLINE = '\033[4m'
RESET = '\033[0m'

print(style.YELLOW + "Hello, World!")
``````

Note: Windows does not fully support ANSI codes, whether through system calls or modules. Not all text decoration is supported, and although the bright colours display, they are identical to the regular colours.

Thanks to @j-l for finding an even shorter method.

tl;dr: Add `os.system("")`

### Disable F5 and browser refresh using JavaScript

``````\$(window).bind('beforeunload', function(e) {
e.preventDefault();
});
``````

### Center image in table td in CSS

As per my analysis and search on the internet also, I could not found a way to centre the image vertically centred using `<div>` it was possible only using `<table>` because table provides the following property:

``````valign="middle"
``````

### How can I get a value from a map?

The main problem is that operator [] is used to insert and read a value into and from the map, so it cannot be const. If the key does not exist, it will create a new entry with a default value in it, incrementing the size of the map, that will contain a new key with an empty string ,in this particular case, as a value if the key does not exist yet. You should avoid operator[] when reading from a map and use, as was mention before, "map.at(key)" to ensure bound checking. This is one of the most common mistakes people often do with maps. You should use "insert" and "at" unless your code is aware of this fact. Check this talk about common bugs Curiously Recurring C++ Bugs at Facebook

### Setting the classpath in java using Eclipse IDE

Try this:

Project -> Properties -> Java Build Path -> Add Class Folder.

If it doesnt work, please be specific in what way your compilation fails, specifically post the error messages Eclipse returns, and i will know what to do about it.

### How to convert SQL Server's timestamp column to datetime format

I had the same problem with timestamp eg:'29-JUL-20 04.46.42.000000000 PM'. I wanted to turn it into 'yyyy-MM-dd' format. The solution that finally works for me is

SELECT TO_CHAR(mytimestamp, 'YYYY-MM-DD') FROM mytable;

### Loop through an array in JavaScript

For example, I used in a Firefox console:

``````[].forEach.call(document.getElementsByTagName('pre'), function(e){
console.log(e);
})
``````

You can use querySelectorAll to get same result

_x000D_
_x000D_
``````document.querySelectorAll('pre').forEach( (e) => {
console.log(e.textContent);
})``````
_x000D_
``````<pre>text 1</pre>
<pre>text 2</pre>
<pre>text 3</pre>``````
_x000D_
_x000D_
_x000D_

### How to get css background color on <tr> tag to span entire row

This worked for me, even within a div:

``````      div.cntrblk tr:hover td {
line-height: 150%;
background-color: rgb(255,0,0);
font-weight: bold;
font-size: 150%;
border: 0;
}
``````

It selected the entire row, but I'd like it to not do the header, haven't looked at that yet. It also partially fixed the fonts that wouldn't scale-up with the hover??? Apparently you to have apply settings to the cell not the row, but select all the component cells with the tr:hover. On to tracking down the in-consistent font scaling problem. Sweet that CSS will do this.

### How to make a .NET Windows Service start right after the installation?

Visual Studio

If you are creating a setup project with VS, you can create a custom action who called a .NET method to start the service. But, it is not really recommended to use managed custom action in a MSI. See this page.

``````ServiceController controller  = new ServiceController();
controller.MachineName = "";//The machine where the service is installed;
controller.Start();
``````

InstallShield or Wise

If you are using InstallShield or Wise, these applications provide the option to start the service. Per example with Wise, you have to add a service control action. In this action, you specify if you want to start or stop the service.

Wix

``````<ServiceInstall
Id="ServiceInstaller"
Type="ownProcess"
Vital="yes"
Name=""
DisplayName=""
Description=""
Start="auto"
Account="LocalSystem"
ErrorControl="ignore"
Interactive="no">
</ServiceInstall>
``````

### Capturing a form submit with jquery and .submit

Wrap the code in document ready and prevent the default submit action:

``````\$(function() { //shorthand document.ready function
\$('#login_form').on('submit', function(e) { //use on if jQuery 1.7+
e.preventDefault();  //prevent form from submitting
console.log(data); //use the console for debugging, F12 in Chrome, not alerts
});
});
``````

### should use size_t or ssize_t

`ssize_t` is used for functions whose return value could either be a valid size, or a negative value to indicate an error. It is guaranteed to be able to store values at least in the range `[-1, SSIZE_MAX]` (`SSIZE_MAX` is system-dependent).

So you should use `size_t` whenever you mean to return a size in bytes, and `ssize_t` whenever you would return either a size in bytes or a (negative) error value.

### How to get the hours difference between two date objects?

Use the timestamp you get by calling `valueOf` on the date object:

``````var diff = date2.valueOf() - date1.valueOf();
var diffInHours = diff/1000/60/60; // Convert milliseconds to hours
``````

### Reactjs setState() with a dynamic key name?

In loop with `.map` work like this:

``````{
dataForm.map(({ id, placeholder, type }) => {
return <Input
value={this.state.type}
onChangeText={(text) => this.setState({ [type]: text })}
placeholder={placeholder}
key={id} />
})
}
``````

Note the `[]` in `type` parameter. Hope this helps :)

### Return HTML from ASP.NET Web API

#### ASP.NET Core. Approach 1

If your Controller extends `ControllerBase` or `Controller` you can use `Content(...)` method:

``````[HttpGet]
public ContentResult Index()
{
return base.Content("<div>Hello</div>", "text/html");
}
``````

#### ASP.NET Core. Approach 2

If you choose not to extend from `Controller` classes, you can create new `ContentResult`:

``````[HttpGet]
public ContentResult Index()
{
return new ContentResult
{
ContentType = "text/html",
Content = "<div>Hello World</div>"
};
}
``````

#### Legacy ASP.NET MVC Web API

Return string content with media type `text/html`:

``````public HttpResponseMessage Get()
{
var response = new HttpResponseMessage();
response.Content = new StringContent("<div>Hello World</div>");
return response;
}
``````

### how do I make a single legend for many subplots with matplotlib?

I have noticed that no answer display an image with a single legend referencing many curves in different subplots, so I have to show you one... to make you curious...

Now, you want to look at the code, don't you?

``````from numpy import linspace
import matplotlib.pyplot as plt

# Calling the axes.prop_cycle returns an itertoools.cycle

color_cycle = plt.rcParams['axes.prop_cycle']()

# I need some curves to plot

x = linspace(0, 1, 51)
f1 = x*(1-x)   ; lab1 = 'x - x x'
f2 = 0.25-f1   ; lab2 = '1/4 - x + x x'
f3 = x*x*(1-x) ; lab3 = 'x x - x x x'
f4 = 0.25-f3   ; lab4 = '1/4 - x x + x x x'

# let's plot our curves (note the use of color cycle, otherwise the curves colors in
# the two subplots will be repeated and a single legend becomes difficult to read)
fig, (a13, a24) = plt.subplots(2)

a13.plot(x, f1, label=lab1, **next(color_cycle))
a13.plot(x, f3, label=lab3, **next(color_cycle))
a24.plot(x, f2, label=lab2, **next(color_cycle))
a24.plot(x, f4, label=lab4, **next(color_cycle))

# so far so good, now the trick

lines_labels = [ax.get_legend_handles_labels() for ax in fig.axes]
lines, labels = [sum(lol, []) for lol in zip(*lines_labels)]

# finally we invoke the legend (that you probably would like to customize...)

fig.legend(lines, labels)
plt.show()
``````

The two lines

``````lines_labels = [ax.get_legend_handles_labels() for ax in fig.axes]
lines, labels = [sum(lol, []) for lol in zip(*lines_labels)]
``````

deserve an explanation — to this aim I have encapsulated the tricky part in a function, just 4 lines of code but heavily commented

``````def fig_legend(fig, **kwdargs):

# generate a sequence of tuples, each contains
#  - a list of handles (lohand) and
#  - a list of labels (lolbl)
tuples_lohand_lolbl = (ax.get_legend_handles_labels() for ax in fig.axes)
# e.g. a figure with two axes, ax0 with two curves, ax1 with one curve
# yields:   ([ax0h0, ax0h1], [ax0l0, ax0l1]) and ([ax1h0], [ax1l0])

# legend needs a list of handles and a list of labels,
# so our first step is to transpose our data,
# generating two tuples of lists of homogeneous stuff(tolohs), i.e
# we yield ([ax0h0, ax0h1], [ax1h0]) and ([ax0l0, ax0l1], [ax1l0])
tolohs = zip(*tuples_lohand_lolbl)

# finally we need to concatenate the individual lists in the two
# lists of lists: [ax0h0, ax0h1, ax1h0] and [ax0l0, ax0l1, ax1l0]
# a possible solution is to sum the sublists - we use unpacking
handles, labels = (sum(list_of_lists, []) for list_of_lists in tolohs)

# call fig.legend with the keyword arguments, return the legend object

return fig.legend(handles, labels, **kwdargs)
``````

PS I recognize that `sum(list_of_lists, [])` is a really inefficient method to flatten a list of lists but ? I love its compactness, ? usually is a few curves in a few subplots and ? Matplotlib and efficiency? ;-)

#### Important Update

If you want to stick with the official Matplotlib API my answer above is perfect, really.

On the other hand, if you don't mind using a private method of the `matplotlib.legend` module ... it's really much much much easier

``````from matplotlib.legend import _get_legend_handles_labels
...

fig.legend(*_get_legend_handles_and_labels(fig.axes), ...)
``````

A complete explanation can be found in the source code of `Axes.get_legend_handles_labels` in `.../matplotlib/axes/_axes.py`

### What is the pythonic way to unpack tuples?

`````` dt = datetime.datetime(*t[:7])
``````

### How to use DISTINCT and ORDER BY in same SELECT statement?

You can use CTE:

``````WITH DistinctMonitoringJob AS (
SELECT DISTINCT Category Distinct_Category FROM MonitoringJob
)

SELECT Distinct_Category
FROM DistinctMonitoringJob
ORDER BY Distinct_Category DESC
``````

### How to find the extension of a file in C#?

This solution also helps in cases of more than one extension like "Avishay.student.DB"

``````                FileInfo FileInf = new FileInfo(filePath);
string strExtention = FileInf.Name.Replace(System.IO.Path.GetFileNameWithoutExtension(FileInf.Name), "");
``````

### How to call a mysql stored procedure, with arguments, from command line?

With quotes around the date:

``````mysql> CALL insertEvent('2012.01.01 12:12:12');
``````

### Python reading from a file and saving to utf-8

Process text to and from Unicode at the I/O boundaries of your program using `open` with the `encoding` parameter. Make sure to use the (hopefully documented) encoding of the file being read. The default encoding varies by OS (specifically, `locale.getpreferredencoding(False)` is the encoding used), so I recommend always explicitly using the `encoding` parameter for portability and clarity (Python 3 syntax below):

``````with open(filename, 'r', encoding='utf8') as f:

# process Unicode text

with open(filename, 'w', encoding='utf8') as f:
f.write(text)
``````

If still using Python 2 or for Python 2/3 compatibility, the `io` module implements `open` with the same semantics as Python 3's `open` and exists in both versions:

``````import io
with io.open(filename, 'r', encoding='utf8') as f:

# process Unicode text

with io.open(filename, 'w', encoding='utf8') as f:
f.write(text)
``````

# Update May 28th, 2017: This method is no longer supported by me and doesn't work anymore as far as I know. Don't try it.

# How To Add Google Apps and ARM Support to Genymotion v2.0+ #

Original Source: [GUIDE] Genymotion | Installing ARM Translation and GApps - XDA-Developers

Note(Feb 2nd): Contrary to previous reports, it's been discovered that Android 4.4 does in fact work with ARM translation, although it is buggy. Follow the steps the same as before, just make sure you download the 4.4 GApps.

UPDATE-v1.1: I've gotten more up-to-date builds of libhoudini and have updated the ZIP file. This fixes a lot of app crashes and hangs. Just flash the new one, and it should work.

This guide is for getting back both ARM translation/support (this is what causes the "INSTALL_FAILED_CPU_ABI_INCOMPATIBLE" errors) and Google Play apps in your Genymotion VM.

• ARM Translation Installer v1.1 (Mirrors)
2. Next open your Genymotion VM and go to the home screen
3. Now drag&drop the Genymotion-ARM-Translation_v1.1.zip onto the Genymotion VM window.
4. It should say "File transfer in progress". Once it asks you to flash it, click 'OK'.
5. Now reboot your VM using ADB (`adb reboot`) or an app like ROM Toolbox. If nescessary you can simply close the VM window, but I don't recommend it.
6. Once you're on the home screen again drag&drop the gapps-*-signed.zip (the name varies) onto your VM, and click 'OK' when asked.
7. Once it finishes, again reboot your VM and open the Google Play Store.
9. Once in the Store go to the 'My Apps' menu and let everything update (it fixes a lot of issues). Also try updating Google Play Services directly.
10. Now try searching for 'Netflix' and 'Google Drive'
11. If both apps show up in the results and you're able to Download/Install them, then congratulations: you now have ARM support and Google Play fully set up!

I've tested this on Genymotion v2.0.1-v2.1 using Android 4.3 and 4.4 images. Feel free to skip the GApps steps if you only want the ARM support. It'll work perfectly fine by itself.

Old Zips: v1.0. Don't download these as they will not solve your issues. It is left for archival and experimental purposes.

### Redirecting unauthorized controller in ASP.NET MVC

``````LoginPath = new PathString("/Account/Login"),
``````

Example:

``````// Enable the application to use a cookie to store information for the signed in user
// and to use a cookie to temporarily store information about a user logging in with a third party login provider
{
{
// Enables the application to validate the security stamp when the user logs in.
OnValidateIdentity = SecurityStampValidator.OnValidateIdentity<ApplicationUserManager, ApplicationUser>(
validateInterval: TimeSpan.FromMinutes(30),
regenerateIdentity: (manager, user) => user.GenerateUserIdentityAsync(manager))
}
});
``````

### Create tap-able "links" in the NSAttributedString of a UILabel?

`UITextView` supports data-detectors in OS3.0, whereas `UILabel` doesn't.

If you enable the data-detectors on the `UITextView` and your text contains URLs, phone numbers, etc. they will appear as links.

### Adjusting and image Size to fit a div (bootstrap)

Simply add the class `img-responsive` to your `img` tag, it is applicable in bootstrap 3 onward!

### Input widths on Bootstrap 3

I do not know why everyone has seem to overlook the site.css file in the Content folder. Look at line 22 in this file and you will see the settings for input to be controlled. It would appear that your site is not referencing this style sheet.

`input, select, textarea { max-width: 280px;}`

to your fiddle and it works just fine.

You should never ever update bootstrap.css or bootstrap.min.css. Doing so will set you up to fail when bootstrap gets updated. That is why the site.css file is included. This is where you can make changes to site that will still give you the responsive design you are looking for.

Here is the fiddle with it working

### Is there a destructor for Java?

If it's just memory you are worried about, don't. Just trust the GC it does a decent job. I actually saw something about it being so efficient that it could be better for performance to create heaps of tiny objects than to utilize large arrays in some instances.

### input() error - NameError: name '...' is not defined

Since you are writing for Python 3.x, you'll want to begin your script with:

``````#!/usr/bin/env python3
``````

If you use:

``````#!/usr/bin/env python
``````

It will default to Python 2.x. These go on the first line of your script, if there is nothing that starts with #! (aka the shebang).

``````#! python
``````

Then you can change it to:

``````#! python3
``````

Although this shorter formatting is only recognized by a few programs, such as the launcher, so it is not the best choice.

The first two examples are much more widely used and will help ensure your code will work on any machine that has Python installed.

### Deleting rows from parent and child tables

Two possible approaches.

1. If you have a foreign key, declare it as on-delete-cascade and delete the parent rows older than 30 days. All the child rows will be deleted automatically.

2. Based on your description, it looks like you know the parent rows that you want to delete and need to delete the corresponding child rows. Have you tried SQL like this?

``````  delete from child_table
where parent_id in (
select parent_id from parent_table
where updd_tms != (sysdate-30)
``````

-- now delete the parent table records

``````delete from parent_table
where updd_tms != (sysdate-30);
``````

---- Based on your requirement, it looks like you might have to use PL/SQL. I'll see if someone can post a pure SQL solution to this (in which case that would definitely be the way to go).

``````declare
v_sqlcode number;
PRAGMA EXCEPTION_INIT(foreign_key_violated, -02291);
begin
for v_rec in (select parent_id, child id from child_table
where updd_tms != (sysdate-30) ) loop

-- delete the children
delete from child_table where child_id = v_rec.child_id;

-- delete the parent. If we get foreign key violation,
-- stop this step and continue the loop
begin
delete from parent_table
where parent_id = v_rec.parent_id;
exception
when foreign_key_violated
then null;
end;
end loop;
end;
/
``````

### How to sort by dates excel?

1. Select the whole column
2. Right click -> Format cells... -> Number -> Category: Date -> OK
3. Data -> Text to Columns -> select Delimited -> Next -> in your case selection of Delimiters doesn't matter -> Next -> select Date: DMY -> Finish

Now you should be able to sort by this column either Oldest to Newest or Newest to Oldest

### EXCEL VBA Check if entry is empty or not 'space'

Most terse version I can think of

``````Len(Trim(TextBox1.Value)) = 0
``````

If you need to do this multiple times, wrap it in a function

``````Public Function HasContent(text_box as Object) as Boolean
HasContent = (Len(Trim(text_box.Value)) > 0)
End Function
``````

Usage

``````If HasContent(TextBox1) Then
' ...
``````

### How do you calculate the variance, median, and standard deviation in C++ or Java?

To calculate the mean, loop through the list/array of numbers, keeping track of the partial sums and the length. Then return the `sum/length`.

``````double sum = 0.0;
int length = 0;

for( double number : numbers ) {
sum += number;
length++;
}

return sum/length;
``````

Variance is calculated similarly. Standard deviation is simply the square root of the variance:

``````double stddev = Math.sqrt( variance );
``````

### Difference between subprocess.Popen and os.system

Subprocess is based on popen2, and as such has a number of advantages - there's a full list in the PEP here, but some are:

• using pipe in the shell
• better newline support
• better handling of exceptions

### How do CORS and Access-Control-Allow-Headers work?

Yes, you need to have the header `Access-Control-Allow-Origin: http://domain.com:3000` or `Access-Control-Allow-Origin: *` on both the OPTIONS response and the POST response. You should include the header `Access-Control-Allow-Credentials: true` on the POST response as well.

Your OPTIONS response should also include the header `Access-Control-Allow-Headers: origin, content-type, accept` to match the requested header.

### Spring - applicationContext.xml cannot be opened because it does not exist

I got the same issue while working on a maven project, so I recreate the configuration file `spring.xml` in `src/main/java` and it worked for me.

### How do I get the path of the Python script I am running in?

7.2 of Dive Into Python: Finding the Path.

``````import sys, os

print('sys.argv[0] =', sys.argv[0])
pathname = os.path.dirname(sys.argv[0])
print('path =', pathname)
print('full path =', os.path.abspath(pathname))
``````

### How to check if an element does NOT have a specific class?

use the .not() method and check for an attribute:

``````\$('p').not('[class]');
``````

Check it here: http://jsfiddle.net/AWb79/

### How to list all databases in the mongo shell?

To list mongodb database on shell

`````` show databases     //Print a list of all available databases.
show dbs   // Print a list of all databases on the server.
``````

Few more basic commands

``````use <db>    // Switch current database to <db>. The mongo shell variable db is set to the current database.
show collections    //Print a list of all collections for current database.
show users  //Print a list of users for current database.
show roles  //Print a list of all roles, both user-defined and built-in, for the current database.
``````

### How do I output the results of a HiveQL query to CSV?

In case you are doing it from Windows you can use Python script hivehoney to extract table data to local CSV file.

It will:

2. pbrun.
3. kinit.
5. Save echo from beeline to a file on Windows.

Execute it like this:

``````set PROXY_HOST=your_bastion_host

set SERVICE_USER=you_func_user

set LINUX_USER=your_SOID

set LINUX_PWD=your_pwd

python hh.py --query_file=query.sql
``````

### Return a value of '1' a referenced cell is empty

``````=if(a1="","1","0")
``````

In this formula if the cell is empty then the result would be `1` else it would be `0`

### Failed to authenticate on SMTP server error using gmail

Did you turn on the "Allow less secure apps" on? go to this link

Take a look at the Sign-in & security -> Apps with account access menu.

You must turn the option "Allow less secure apps" ON.

If is still doesn't work try one of these:

``````MAIL_DRIVER=smtp
MAIL_HOST=smtp.gmail.com
MAIL_PORT=587
[email protected]
MAIL_ENCRYPTION=tls
``````

because the one's you have specified in the mail.php will only be used if the value is not available in the .env file.

### Angular 2 'component' is not a known element

#### Route modules (did not saw this as an answer)

First check: if you have declared- and exported the component inside its module, imported the module where you want to use it and named the component correctly inside the HTML.

Otherwise, you might miss a module inside your routing module:
When you have a routing module with a route that routes to a component from another module, it is important that you import that module within that route module. Otherwise the Angular CLI will show the error: `component is not a known element`.

# For example

1) Having the following project structure:

``````+---core
¦   +---sidebar
¦           sidebar.component.ts
¦           sidebar.module.ts
¦
+---todos
¦   todos-routing.module.ts
¦   todos.module.ts
¦
+---pages
edit-todo.component.ts
edit-todo.module.ts
``````

2) Inside the `todos-routing.module.ts` you have a route to the `edit.todo.component.ts` (without importing its module):

``````  {
path: 'edit-todo/:todoId',
component: EditTodoComponent,
},
``````

The route will just work fine! However when importing the `sidebar.module.ts` inside the `edit-todo.module.ts` you will get an error: `app-sidebar is not a known element`.

Fix: Since you have added a route to the `edit-todo.component.ts` in step 2, you will have to add the `edit-todo.module.ts` as an import, after that the imported sidebar component will work!

### Unique Key constraints for multiple columns in Entity Framework

You need to define a composite key.

With data annotations it looks like this:

``````public class Entity
{
public string EntityId { get; set;}
[Key]
[Column(Order=0)]
public int FirstColumn  { get; set;}
[Key]
[Column(Order=1)]
public int SecondColumn  { get; set;}
}
``````

You can also do this with modelBuilder when overriding OnModelCreating by specifying:

``````modelBuilder.Entity<Entity>().HasKey(x => new { x.FirstColumn, x.SecondColumn });
``````

### How to get a file or blob from an object URL?

Modern solution:

``````let blob = await fetch(url).then(r => r.blob());
``````

The url can be an object url or a normal url.

### Can't ping a local VM from the host

I know this is an old post, but I ran into this same issue with my VMs. Log into the VM and go to Control Panel > System and Security > Windows Firewall > Allowed Apps. Then check all of the boxes next to "File and Printer Sharing" to enable file sharing. This should allow you to ping the VM. The screenshot below is from a 2016 Windows Server but the same method will work on older ones.

### How to suppress "unused parameter" warnings in C?

For the record, I like Job's answer above but I'm curious about a solution just using the variable name by itself in a "do-nothing" statement:

``````void foo(int x) {
x; /* unused */
...
}
``````

Sure, this has drawbacks; for instance, without the "unused" note it looks like a mistake rather than an intentional line of code.

The benefit is that no DEFINE is needed and it gets rid of the warning.

Are there any performance, optimization, or other differences?

Its super easy to use and you can put it on left, right, top or bottom. Very well documented with sample code and Apache 2.0 license.

### DBNull if statement

At first use ExecuteScalar

`````` objConn = new SqlConnection(strConnection);
objConn.Open();
objCmd = new SqlCommand(strSQL, objConn);
object result = cmd.ExecuteScalar();
if(result == null)
strLevel = "";
else
strLevel = result.ToString();
``````

### How to upload image in CodeIgniter?

``````\$image_folder = APPPATH . "../images/owner_profile/" . \$_POST ['mob_no'] [0] . \$na;
if (isset ( \$_FILES ['image'] ) && \$_FILES ['image'] ['error'] == 0) {
list ( \$a, \$b ) = explode ( '.', \$_FILES ['image'] ['name'] );
\$b = end ( explode ( '.', \$_FILES ['image'] ['name'] ) );
\$up = move_uploaded_file ( \$_FILES ['image'] ['tmp_name'], \$image_folder . "." . \$b );
\$path = (\$_POST ['mob_no'] [0] . \$na . "." . \$b);
``````

### How to work with complex numbers in C?

The notion of complex numbers was introduced in mathematics, from the need of calculating negative quadratic roots. Complex number concept was taken by a variety of engineering fields.

Today that complex numbers are widely used in advanced engineering domains such as physics, electronics, mechanics, astronomy, etc...

Real and imaginary part, of a negative square root example:

``````#include <stdio.h>
#include <complex.h>

int main()
{
int negNum;

printf("Calculate negative square roots:\n"
"Enter negative number:");

scanf("%d", &negNum);

double complex negSqrt = csqrt(negNum);

double pReal = creal(negSqrt);
double pImag = cimag(negSqrt);

printf("\nReal part %f, imaginary part %f"
", for negative square root.(%d)",
pReal, pImag, negNum);

return 0;
}
``````

### How to concatenate two numbers in javascript?

This is the easy way to do this

``````var value = 5 + "" + 6;
``````

### How to convert strings into integers in Python?

Instead of putting `int( )`, put `float( )` which will let you use decimals along with integers.

### Save PHP array to MySQL?

There is no good way to store an array into a single field.

You need to examine your relational data and make the appropriate changes to your schema. See example below for a reference to this approach.

If you must save the array into a single field then the `serialize()` and `unserialize()` functions will do the trick. But you cannot perform queries on the actual content.

As an alternative to the serialization function there is also `json_encode()` and `json_decode()`.

Consider the following array

``````\$a = array(
1 => array(
'a' => 1,
'b' => 2,
'c' => 3
),
2 => array(
'a' => 1,
'b' => 2,
'c' => 3
),
);
``````

To save it in the database you need to create a table like this

``````\$c = mysql_connect(\$server, \$username, \$password);
mysql_select_db('test');
\$r = mysql_query(
'DROP TABLE IF EXISTS test');
\$r = mysql_query(
'CREATE TABLE test (
id INTEGER UNSIGNED NOT NULL,
a INTEGER UNSIGNED NOT NULL,
b INTEGER UNSIGNED NOT NULL,
c INTEGER UNSIGNED NOT NULL,
PRIMARY KEY (id)
)');
``````

To work with the records you can perform queries such as these (and yes this is an example, beware!)

``````function getTest() {
\$ret = array();
\$c = connect();
\$query = 'SELECT * FROM test';
\$r = mysql_query(\$query,\$c);
while (\$o = mysql_fetch_array(\$r,MYSQL_ASSOC)) {
\$ret[array_shift(\$o)] = \$o;
}
mysql_close(\$c);
return \$ret;
}
function putTest(\$t) {
\$c = connect();
foreach (\$t as \$k => \$v) {
\$query = "INSERT INTO test (id,".
implode(',',array_keys(\$v)).
") VALUES (\$k,".
implode(',',\$v).
")";
\$r = mysql_query(\$query,\$c);
}
mysql_close(\$c);
}

putTest(\$a);
\$b = getTest();
``````

The `connect()` function returns a mysql connection resource

``````function connect() {
mysql_select_db('test');
return \$c;
}
``````

### Android: checkbox listener

``````h.chk.setOnClickListener(new View.OnClickListener()
{
@Override
public void onClick(View view)
{
CheckBox chk=(CheckBox)view; // important line and code work
if(chk.isChecked())
{
Message.message(a,"Clicked at"+position);
}
else
{
Message.message(a,"UnClick");
}
}
});
``````

### Select multiple records based on list of Id's with linq

You can use `Contains()` for that. It will feel a little backwards when you're really trying to produce an `IN` clause, but this should do it:

``````var userProfiles = _dataContext.UserProfile
.Where(t => idList.Contains(t.Id));
``````

I'm also assuming that each `UserProfile` record is going to have an `int` `Id` field. If that's not the case you'll have to adjust accordingly.

### How to have stored properties in Swift, the same way I had on Objective-C?

So I think I found a method that works cleaner than the ones above because it doesn't require any global variables. I got it from here: http://nshipster.com/swift-objc-runtime/

The gist is that you use a struct like so:

``````extension UIViewController {
private struct AssociatedKeys {
static var DescriptiveName = "nsh_DescriptiveName"
}

var descriptiveName: String? {
get {
return objc_getAssociatedObject(self, &AssociatedKeys.DescriptiveName) as? String
}
set {
if let newValue = newValue {
objc_setAssociatedObject(
self,
&AssociatedKeys.DescriptiveName,
newValue as NSString?,
UInt(OBJC_ASSOCIATION_RETAIN_NONATOMIC)
)
}
}
}
}
``````

UPDATE for Swift 2

``````private struct AssociatedKeys {
static var displayed = "displayed"
}

//this lets us check to see if the item is supposed to be displayed or not
var displayed : Bool {
get {
guard let number = objc_getAssociatedObject(self, &AssociatedKeys.displayed) as? NSNumber else {
return true
}
return number.boolValue
}

set(value) {
objc_setAssociatedObject(self,&AssociatedKeys.displayed,NSNumber(bool: value),objc_AssociationPolicy.OBJC_ASSOCIATION_RETAIN_NONATOMIC)
}
}
``````

### How to update a single pod without touching other dependencies

just saying:

`pod install` - for installing new pods,

`pod update` - for updating existing pods,

`pod update podName` - for updating only specific pod without touching other pods,

`pod update podName versionNum` - for updating / DOWNGRADING specific pod without touching other pods

### document.body.appendChild(i)

In 2019 you can use querySelector for that.

It's supported by most browsers (https://caniuse.com/#search=querySelector)

``````document.querySelector('body').appendChild(i);
``````

### HTML5 Video // Completely Hide Controls

There are two ways to hide video tag controls

1. Remove the `controls` attribute from the video tag.

2. Add the css to the video tag

``````video::-webkit-media-controls-panel {
display: none !important;
opacity: 1 !important;}
``````

### How to pass data in the ajax DELETE request other than headers

Quoting the RFC 2616 Fielding

The `DELETE` method requests that the origin server delete the resource identified by the Request-URI.

So you need to pass the data in the URI

``````\$.ajax({
url: urlCall + '?' + \$.param({"Id": Id, "bolDeleteReq" : bolDeleteReq}),
type: 'DELETE',
success: callback || \$.noop,
error: errorCallback || \$.noop
});
``````

### REST / SOAP endpoints for a WCF service

MSDN seems to have an article for this now:

https://msdn.microsoft.com/en-us/library/bb412196(v=vs.110).aspx

Intro:

By default, Windows Communication Foundation (WCF) makes endpoints available only to SOAP clients. In How to: Create a Basic WCF Web HTTP Service, an endpoint is made available to non-SOAP clients. There may be times when you want to make the same contract available both ways, as a Web endpoint and as a SOAP endpoint. This topic shows an example of how to do this.

### How to extract a value from a string using regex and a shell?

you can use the shell(bash for example)

``````\$ string="12 BBQ ,45 rofl, 89 lol"
\$ echo \${string% rofl*}
12 BBQ ,45
\$ string=\${string% rofl*}
\$ echo \${string##*,}
45
``````

### Git push error pre-receive hook declined

Following resolved problem in my local machine:

A. First, ensure that you are using the correct log on details to connect to Bitbucket Server (ie. a username/password/SSH key that belongs to you)

B. Then, ensure that the name/email address is correctly set in your local Git configuration: Set your local Git configuration for the account that you are trying to push under (the check asserts that you are the person who committed the files) * Note that this is case sensitive, both for name and email address * It is also space sensitive - some company accounts have extra spaces/characters in their name eg. "`Contractor/ space space(LDN)`".  You must include the same number of spaces in your configuration as on Bitbucket Server.  Check this in Notepad if stuck.

C. If you were using the wrong account, simply switch your account credentials (username/password/SSH key) and try pushing again.

D. Else, if your local configuration incorrect you will need to amend it

For MAC

`open -a TextEdit.app ~/.gitconfig`

NOTE: You will have to fix up the old commits that you were trying to push.

``````> git commit --amend --reset-author

<save and quit the commit file text editor that opens, if Vim then
:wq to save and quit>
``````

``````> git push
``````

### Object reference not set to an instance of an object.

The correct way in .NET 4.0 is:

``````if (String.IsNullOrWhiteSpace(strSearch))
``````

The `String.IsNullOrWhiteSpace` method used above is equivalent to:

``````if (strSearch == null || strSearch == String.Empty || strSearch.Trim().Length == 0)
// String.Empty is the same as ""
``````

Reference for IsNullOrWhiteSpace method

http://msdn.microsoft.com/en-us/library/system.string.isnullorwhitespace.aspx

Indicates whether a specified string is Nothing, empty, or consists only of white-space characters.

In earlier versions, you could do something like this:

``````if (String.IsNullOrEmpty(strSearch) || strSearch.Trim().Length == 0)
``````

The `String.IsNullOrEmpty` method used above is equivalent to:

``````if (strSearch == null || strSearch == String.Empty)
``````

Which means you still need to check for your "IsWhiteSpace" case with the `.Trim().Length == 0` as per the example.

Reference for IsNullOrEmpty method

http://msdn.microsoft.com/en-us/library/system.string.isnullorempty.aspx

Indicates whether the specified string is Nothing or an Empty string.

Explanation:

You need to ensure `strSearch` (or any variable for that matter) is not `null` before you dereference it using the dot character (`.`) - i.e. before you do `strSearch.SomeMethod()` or `strSearch.SomeProperty` you need to check that `strSearch != null`.

In your example you want to make sure your string has a value, which means you want to ensure the string:

• Is not null
• Is not the empty string (`String.Empty` / `""`)
• Is not just whitespace

In the cases above, you must put the "Is it null?" case first, so it doesn't go on to check the other cases (and error) when the string is `null`.

### Finding a branch point with Git?

Not quite a solution to the question but I thought it was worth noting the the approach I use when I have a long-living branch:

At the same time I create the branch, I also create a tag with the same name but with an `-init` suffix, for example `feature-branch` and `feature-branch-init`.

(It is kind of bizarre that this is such a hard question to answer!)

### How to force Selenium WebDriver to click on element which is not currently visible?

Or you may use Selenium Action Class to simulate user interaction -- For example

``````    WebDriver = new FirefoxDriver();

WebElement menu = driver.findElement(By.xpath("")); // the triger event element

Actions build = new Actions(driver); // heare you state ActionBuider
build.moveToElement(menu).build().perform(); // Here you perform hover mouse over the needed elemnt to triger the visibility of the hidden
WebElement m2m= driver.findElement(By.xpath(""));//the previous non visible element
m2m.click();
``````

### How to remove indentation from an unordered list item?

``````padding-left: 0;
``````

### Multi value Dictionary

Just create a `Pair<TFirst, TSecond>` type and use that as your value.

I have an example of one in my C# in Depth source code. Reproduced here for simplicity:

``````using System;
using System.Collections.Generic;

public sealed class Pair<TFirst, TSecond>
: IEquatable<Pair<TFirst, TSecond>>
{

public Pair(TFirst first, TSecond second)
{
this.first = first;
this.second = second;
}

public TFirst First
{
get { return first; }
}

public TSecond Second
{
get { return second; }
}

public bool Equals(Pair<TFirst, TSecond> other)
{
if (other == null)
{
return false;
}
return EqualityComparer<TFirst>.Default.Equals(this.First, other.First) &&
EqualityComparer<TSecond>.Default.Equals(this.Second, other.Second);
}

public override bool Equals(object o)
{
return Equals(o as Pair<TFirst, TSecond>);
}

public override int GetHashCode()
{
return EqualityComparer<TFirst>.Default.GetHashCode(first) * 37 +
EqualityComparer<TSecond>.Default.GetHashCode(second);
}
}
``````

### Removing whitespace between HTML elements when using line breaks

The whitespace between the elements is only put there by the HTML editor for visual formatting purposes. You can use jQuery to remove the whitespace:

``````\$("div#MyImages").each(function () {

var div = \$(this);
var children= div.children();
children.detach();
div.empty();
div.append(children);

});
``````

This detaches the child elements, clears any whitespace that remains before adding the child elements back again.

Unlike the other answers to this question, using this method ensures that the inherited css `display` and `font-size` values are maintained. There's also no need to use `float` and the cumbersome `clear` that is then required. Of course, you will need to be using jQuery.

### Creating a new directory in C

I want to write a program that (...) creates the directory and a (...) file inside of it

because this is a very common question, here is the code to create multiple levels of directories and than call fopen. I'm using a gnu extension to print the error message with printf.

``````void rek_mkdir(char *path) {
char *sep = strrchr(path, '/');
if(sep != NULL) {
*sep = 0;
rek_mkdir(path);
*sep = '/';
}
if(mkdir(path, 0777) && errno != EEXIST)
printf("error while trying to create '%s'\n%m\n", path);
}

FILE *fopen_mkdir(char *path, char *mode) {
char *sep = strrchr(path, '/');
if(sep) {
char *path0 = strdup(path);
path0[ sep - path ] = 0;
rek_mkdir(path0);
free(path0);
}
return fopen(path,mode);
}
``````

### How to close TCP and UDP ports via windows command line

wkillcx is a reliable windows command line tool for killing tcp connections from the command line that hasn't been mentioned. It does have issues with servers with large number of connections sometimes though. I sometimes use tcpview for interactive kills but wkillcx can be used in scripts.

### Sass .scss: Nesting and multiple classes?

If that is the case, I think you need to use a better way of creating a class name or a class name convention. For example, like you said you want the `.container` class to have different color according to a specific usage or appearance. You can do this:

SCSS

``````.container {
background: red;

&--desc {
background: blue;
}

// or you can do a more specific name
&--blue {
background: blue;
}

&--red {
background: red;
}
}
``````

CSS

``````.container {
background: red;
}

.container--desc {
background: blue;
}

.container--blue {
background: blue;
}

.container--red {
background: red;
}
``````

The code above is based on BEM Methodology in class naming conventions. You can check this link: BEM — Block Element Modifier Methodology

### Delete all documents from index/type without deleting type

Torsten Engelbrecht's comment in John Petrones answer expanded:

``````curl -XDELETE 'http://localhost:9200/twitter/tweet/_query' -d
'{
"query":
{
"match_all": {}
}
}'
``````

(I did not want to edit John's reply, since it got upvotes and is set as answer, and I might have introduced an error)

### Inconsistent accessibility: property type is less accessible

make your class `public` access modifier,

just add `public` keyword infront of your class name

`````` namespace Test
{
public  class Delivery
{
private string name;
private DateTime arrivalTime;

public string Name
{
get { return name; }
set { name = value; }
}

{
set { address = value; }
}

public DateTime ArrivlaTime
{
get { return arrivalTime; }
set { arrivalTime = value; }
}

public string ToString()
{
{ return name + address + arrivalTime.ToString(); }
}
}
}
``````

### Get img src with PHP

``````\$str = '<img border="0" src=\'/images/image.jpg\' alt="Image" width="100" height="100"/>';

preg_match('/(src=["\'](.*?)["\'])/', \$str, \$match);  //find src="X" or src='X'
\$split = preg_split('/["\']/', \$match[0]); // split by quotes

\$src = \$split[1]; // X between quotes

echo \$src;
``````

Other regexp's can be used to determine if the pulled src tag is a picture like so:

``````if(preg_match('/([jpg]{3}\$)|([gif]{3}\$)|([jpeg]{3}\$)|([bmp]{3}\$)|([png]{3}\$)/', \$src) == 1) {
//its an image
}
``````

### Atom menu is missing. How do I re-enable

Open Atom and press ALT key you are done.

### How to get second-highest salary employees in a table

Try this: This will give dynamic results irrespective of no of rows

``````SELECT * FROM emp WHERE salary = (SELECT max(e1.salary)
FROM emp e1 WHERE e1.salary < (SELECT Max(e2.salary) FROM emp e2))**
``````

### Why I cannot cout a string?

There are several problems with your code:

1. `WordList` is not defined anywhere. You should define it before you use it.
2. You can't just write code outside a function like this. You need to put it in a function.
3. You need to `#include <string>` before you can use the string class and iostream before you use `cout` or `endl`.
4. `string`, `cout` and `endl` live in the `std` namespace, so you can not access them without prefixing them with `std::` unless you use the `using` directive to bring them into scope first.

### Iterating through a range of dates in Python

Why are there two nested iterations? For me it produces the same list of data with only one iteration:

``````for single_date in (start_date + timedelta(n) for n in range(day_count)):
print ...
``````

And no list gets stored, only one generator is iterated over. Also the "if" in the generator seems to be unnecessary.

After all, a linear sequence should only require one iterator, not two.

#### Update after discussion with John Machin:

Maybe the most elegant solution is using a generator function to completely hide/abstract the iteration over the range of dates:

``````from datetime import timedelta, date

def daterange(start_date, end_date):
for n in range(int((end_date - start_date).days)):
yield start_date + timedelta(n)

start_date = date(2013, 1, 1)
end_date = date(2015, 6, 2)
for single_date in daterange(start_date, end_date):
print(single_date.strftime("%Y-%m-%d"))
``````

NB: For consistency with the built-in `range()` function this iteration stops before reaching the `end_date`. So for inclusive iteration use the next day, as you would with `range()`.

### Remove stubborn underline from link

`style="text-decoration:none;"`

Example:

``````<a href="page.html"  style="text-decoration:none;"></a>
``````

Or use the CSS way.

``````.classname a {
color: #FFFFFF;
text-decoration: none;
}
``````

• domContentLoaded: marks the point when both the DOM is ready and there are no stylesheets that are blocking JavaScript execution - meaning we can now (potentially) construct the render tree. Many JavaScript frameworks wait for this event before they start executing their own logic. For this reason the browser captures the EventStart and EventEnd timestamps to allow us to track how long this execution took.

source

### Table Height 100% inside Div element

Had a similar problem. My solution was to give the inner table a fixed height of 1px and set the height of the td in the inner table to 100%. Against all odds, it works fine, tested in IE, Chrome and FF!

### Should I use past or present tense in git commit messages?

The preference for present-tense, imperative-style commit messages comes from Git itself. From Documentation/SubmittingPatches in the Git repo:

Describe your changes in imperative mood, e.g. "make xyzzy do frotz" instead of "[This patch] makes xyzzy do frotz" or "[I] changed xyzzy to do frotz", as if you are giving orders to the codebase to change its behavior.

So you'll see a lot of Git commit messages written in that style. If you're working on a team or on open source software, it is helpful if everyone sticks to that style for consistency. Even if you're working on a private project, and you're the only one who will ever see your git history, it's helpful to use the imperative mood because it establishes good habits that will be appreciated when you're working with others.

### Lombok added but getters and setters not recognized in Intellij IDEA

In my case,

1. Lombok plugin was installed ?
2. Annotation processor was checked ?

but still I was getting the error as lombok is incompatible and getter and setters was not recognized. with further checking I found that recently my intelliJ version got upgraded and the old Lombok plugin is not compatible.

Go to Preference -> Plugins -> Search lombok and update

OR

Go to Preference -> Plugins -> Search lombok-> Uninstall restart IDE and install again from MarketPlace

### What are intent-filters in Android?

If possible try this one instant solution:

``````Intent intent =new Intent(getApplicationBaseContext,second_Act.class);
StartActivity(intent);
``````

In many case It is java facet problem ,jdk or jre or jsp version is difference than maven project face.

### Making a cURL call in C#

Severity Code Description Project File Line Suppression State Error CS0246 The type or namespace name 'HttpClient' could not be found (are you missing a using directive or an assembly reference?) 1_default.aspx D:\Projetos\Testes\FacebookAPI\FB-CustomAudience\default.aspx.cs 56 Active

In this case you shoud:

1. Add System.Net.Http from Nuget: Tools / NuGet Package Manager / Manager NuGet Packages for Solution;
2. Search for System.Net.Http

### Reading binary file and looping over each byte

This post itself is not a direct answer to the question. What it is instead is a data-driven extensible benchmark that can be used to compare many of the answers (and variations of utilizing new features added in later, more modern, versions of Python) that have been posted to this question — and should therefore be helpful in determining which has the best performance.

In a few cases I've modified the code in the referenced answer to make it compatible with the benchmark framework.

First, here are the results for what currently are the latest versions of Python 2 & 3:

``````Fastest to slowest execution speeds with 32-bit Python 2.7.16
numpy version 1.16.5
Test file size: 1,024 KiB
100 executions, best of 3 repetitions

1                  Tcll (array.array) :   3.8943 secs, rel speed   1.00x,   0.00% slower (262.95 KiB/sec)
2  Vinay Sajip (read all into memory) :   4.1164 secs, rel speed   1.06x,   5.71% slower (248.76 KiB/sec)
3            codeape + iter + partial :   4.1616 secs, rel speed   1.07x,   6.87% slower (246.06 KiB/sec)
4                             codeape :   4.1889 secs, rel speed   1.08x,   7.57% slower (244.46 KiB/sec)
5               Vinay Sajip (chunked) :   4.1977 secs, rel speed   1.08x,   7.79% slower (243.94 KiB/sec)
6           Aaron Hall (Py 2 version) :   4.2417 secs, rel speed   1.09x,   8.92% slower (241.41 KiB/sec)
7                     gerrit (struct) :   4.2561 secs, rel speed   1.09x,   9.29% slower (240.59 KiB/sec)
8                     Rick M. (numpy) :   8.1398 secs, rel speed   2.09x, 109.02% slower (125.80 KiB/sec)
9                           Skurmedel :  31.3264 secs, rel speed   8.04x, 704.42% slower ( 32.69 KiB/sec)

Benchmark runtime (min:sec) - 03:26
``````

``````Fastest to slowest execution speeds with 32-bit Python 3.8.0
numpy version 1.17.4
Test file size: 1,024 KiB
100 executions, best of 3 repetitions

1  Vinay Sajip + "yield from" + "walrus operator" :   3.5235 secs, rel speed   1.00x,   0.00% slower (290.62 KiB/sec)
2                       Aaron Hall + "yield from" :   3.5284 secs, rel speed   1.00x,   0.14% slower (290.22 KiB/sec)
3         codeape + iter + partial + "yield from" :   3.5303 secs, rel speed   1.00x,   0.19% slower (290.06 KiB/sec)
4                      Vinay Sajip + "yield from" :   3.5312 secs, rel speed   1.00x,   0.22% slower (289.99 KiB/sec)
5      codeape + "yield from" + "walrus operator" :   3.5370 secs, rel speed   1.00x,   0.38% slower (289.51 KiB/sec)
6                          codeape + "yield from" :   3.5390 secs, rel speed   1.00x,   0.44% slower (289.35 KiB/sec)
7                                      jfs (mmap) :   4.0612 secs, rel speed   1.15x,  15.26% slower (252.14 KiB/sec)
8              Vinay Sajip (read all into memory) :   4.5948 secs, rel speed   1.30x,  30.40% slower (222.86 KiB/sec)
9                        codeape + iter + partial :   4.5994 secs, rel speed   1.31x,  30.54% slower (222.64 KiB/sec)
10                                        codeape :   4.5995 secs, rel speed   1.31x,  30.54% slower (222.63 KiB/sec)
11                          Vinay Sajip (chunked) :   4.6110 secs, rel speed   1.31x,  30.87% slower (222.08 KiB/sec)
12                      Aaron Hall (Py 2 version) :   4.6292 secs, rel speed   1.31x,  31.38% slower (221.20 KiB/sec)
13                             Tcll (array.array) :   4.8627 secs, rel speed   1.38x,  38.01% slower (210.58 KiB/sec)
14                                gerrit (struct) :   5.0816 secs, rel speed   1.44x,  44.22% slower (201.51 KiB/sec)
15                 Rick M. (numpy) + "yield from" :  11.8084 secs, rel speed   3.35x, 235.13% slower ( 86.72 KiB/sec)
16                                      Skurmedel :  11.8806 secs, rel speed   3.37x, 237.18% slower ( 86.19 KiB/sec)
17                                Rick M. (numpy) :  13.3860 secs, rel speed   3.80x, 279.91% slower ( 76.50 KiB/sec)

Benchmark runtime (min:sec) - 04:47
``````

I also ran it with a much larger 10 MiB test file (which took nearly an hour to run) and got performance results which were comparable to those shown above.

Here's the code used to do the benchmarking:

``````from __future__ import print_function
import array
import atexit
from collections import deque, namedtuple
import io
import numpy as np
from operator import attrgetter
import os
import random
import struct
import sys
import tempfile
from textwrap import dedent
import time
import timeit
import traceback

try:
xrange
except NameError:  # Python 3
xrange = range

class KiB(int):
""" KibiBytes - multiples of the byte units for quantities of information. """
def __new__(self, value=0):
return 1024*value

BIG_TEST_FILE = 1  # MiBs or 0 for a small file.
SML_TEST_FILE = KiB(64)
EXECUTIONS = 100  # Number of times each "algorithm" is executed per timing run.
TIMINGS = 3  # Number of timing runs.
CHUNK_SIZE = KiB(8)
if BIG_TEST_FILE:
FILE_SIZE = KiB(1024) * BIG_TEST_FILE
else:
FILE_SIZE = SML_TEST_FILE  # For quicker testing.

# Common setup for all algorithms -- prefixed to each algorithm's setup.
COMMON_SETUP = dedent("""
# Make accessible in algorithms.
from __main__ import array, deque, get_buffer_size, mmap, np, struct
from __main__ import ACCESS_READ, CHUNK_SIZE, FILE_SIZE, TEMP_FILENAME
from functools import partial
try:
xrange
except NameError:  # Python 3
xrange = range
""")

def get_buffer_size(path):
""" Determine optimal buffer size for reading files. """
st = os.stat(path)
try:
bufsize = st.st_blksize # Available on some Unix systems (like Linux)
except AttributeError:
bufsize = io.DEFAULT_BUFFER_SIZE
return bufsize

# Utility primarily for use when embedding additional algorithms into benchmark.
# Verify generator reads correct number of bytes (assumes values are correct).
bytes_read = sum(1 for _ in file_byte_iterator(TEMP_FILENAME))
'Wrong number of bytes generated: got {:,} instead of {:,}'.format(
"""

TIMING = namedtuple('TIMING', 'label, exec_time')

class Algorithm(namedtuple('CodeFragments', 'setup, test')):

# Default timeit "stmt" code fragment.
_TEST = """
#for b in file_byte_iterator(TEMP_FILENAME):  # Loop over every byte.
#    pass  # Do stuff with byte...
deque(file_byte_iterator(TEMP_FILENAME), maxlen=0)  # Data sink.
"""

# Must overload __new__ because (named)tuples are immutable.
def __new__(cls, setup, test=None):
""" Dedent (unindent) code fragment string arguments.
Args:
`setup` -- Code fragment that defines things used by `test` code.
In this case it should define a generator function named
`file_byte_iterator()` that will be passed that name of a test file
of binary data. This code is not timed.
`test` -- Code fragment that uses things defined in `setup` code.
Defaults to _TEST. This is the code that's timed.
"""
test =  cls._TEST if test is None else test  # Use default unless one is provided.

# Uncomment to replace all performance tests with one that verifies the correct
# number of bytes values are being generated by the file_byte_iterator function.

return tuple.__new__(cls, (dedent(setup), dedent(test)))

algorithms = {

'Aaron Hall (Py 2 version)': Algorithm("""
def file_byte_iterator(path):
with open(path, "rb") as file:
sentinel = bytes() # or b''
for chunk in iter(callable, sentinel):
for byte in chunk:
yield byte
"""),

"codeape": Algorithm("""
def file_byte_iterator(filename, chunksize=CHUNK_SIZE):
with open(filename, "rb") as f:
while True:
if chunk:
for b in chunk:
yield b
else:
break
"""),

"codeape + iter + partial": Algorithm("""
def file_byte_iterator(filename, chunksize=CHUNK_SIZE):
with open(filename, "rb") as f:
for chunk in iter(partial(f.read, chunksize), b''):
for b in chunk:
yield b
"""),

"gerrit (struct)": Algorithm("""
def file_byte_iterator(filename):
with open(filename, "rb") as f:
fmt = '{}B'.format(FILE_SIZE)  # Reads entire file at once.
yield b
"""),

'Rick M. (numpy)': Algorithm("""
def file_byte_iterator(filename):
for byte in np.fromfile(filename, 'u1'):
yield byte
"""),

"Skurmedel": Algorithm("""
def file_byte_iterator(filename):
with open(filename, "rb") as f:
while byte:
yield byte
"""),

"Tcll (array.array)": Algorithm("""
def file_byte_iterator(filename):
with open(filename, "rb") as f:
arr = array.array('B')
arr.fromfile(f, FILE_SIZE)  # Reads entire file at once.
for b in arr:
yield b
"""),

"Vinay Sajip (read all into memory)": Algorithm("""
def file_byte_iterator(filename):
with open(filename, "rb") as f:
yield b
"""),

"Vinay Sajip (chunked)": Algorithm("""
def file_byte_iterator(filename, chunksize=CHUNK_SIZE):
with open(filename, "rb") as f:
while chunk:
for b in chunk:
yield b
"""),

}  # End algorithms

#
# Versions of algorithms that will only work in certain releases (or better) of Python.
#
if sys.version_info >= (3, 3):
algorithms.update({

'codeape + iter + partial + "yield from"': Algorithm("""
def file_byte_iterator(filename, chunksize=CHUNK_SIZE):
with open(filename, "rb") as f:
for chunk in iter(partial(f.read, chunksize), b''):
yield from chunk
"""),

'codeape + "yield from"': Algorithm("""
def file_byte_iterator(filename, chunksize=CHUNK_SIZE):
with open(filename, "rb") as f:
while True:
if chunk:
yield from chunk
else:
break
"""),

"jfs (mmap)": Algorithm("""
def file_byte_iterator(filename):
with open(filename, "rb") as f, \
yield from s
"""),

'Rick M. (numpy) + "yield from"': Algorithm("""
def file_byte_iterator(filename):
#    data = np.fromfile(filename, 'u1')
yield from np.fromfile(filename, 'u1')
"""),

'Vinay Sajip + "yield from"': Algorithm("""
def file_byte_iterator(filename, chunksize=CHUNK_SIZE):
with open(filename, "rb") as f:
while chunk:
yield from chunk  # Added in Py 3.3
"""),

})  # End Python 3.3 update.

if sys.version_info >= (3, 5):
algorithms.update({

'Aaron Hall + "yield from"': Algorithm("""
from pathlib import Path

def file_byte_iterator(path):
''' Given a path, return an iterator over the file
'''
path = Path(path)
bufsize = get_buffer_size(path)

with path.open('rb') as file:
yield from chunk
"""),

})  # End Python 3.5 update.

if sys.version_info >= (3, 8, 0):
algorithms.update({

'Vinay Sajip + "yield from" + "walrus operator"': Algorithm("""
def file_byte_iterator(filename, chunksize=CHUNK_SIZE):
with open(filename, "rb") as f:
yield from chunk  # Added in Py 3.3
"""),

'codeape + "yield from" + "walrus operator"': Algorithm("""
def file_byte_iterator(filename, chunksize=CHUNK_SIZE):
with open(filename, "rb") as f:
yield from chunk
"""),

})  # End Python 3.8.0 update.update.

#### Main ####

def main():
global TEMP_FILENAME

def cleanup():
""" Clean up after testing is completed. """
try:
os.remove(TEMP_FILENAME)  # Delete the temporary file.
except Exception:
pass

atexit.register(cleanup)

# Create a named temporary binary file of pseudo-random bytes for testing.
fd, TEMP_FILENAME = tempfile.mkstemp('.bin')
with os.fdopen(fd, 'wb') as file:
os.write(fd, bytearray(random.randrange(256) for _ in range(FILE_SIZE)))

# Execute and time each algorithm, gather results.
start_time = time.time()  # To determine how long testing itself takes.

timings = []
for label in algorithms:
try:
timing = TIMING(label,
min(timeit.repeat(algorithms[label].test,
setup=COMMON_SETUP + algorithms[label].setup,
repeat=TIMINGS, number=EXECUTIONS)))
except Exception as exc:
print('{} occurred timing the algorithm: "{}"\n  {}'.format(
type(exc).__name__, label, exc))
traceback.print_exc(file=sys.stdout)  # Redirect to stdout.
sys.exit(1)
timings.append(timing)

# Report results.
print('Fastest to slowest execution speeds with {}-bit Python {}.{}.{}'.format(
64 if sys.maxsize > 2**32 else 32, *sys.version_info[:3]))
print('  numpy version {}'.format(np.version.full_version))
print('  Test file size: {:,} KiB'.format(FILE_SIZE // KiB(1)))
print('  {:,d} executions, best of {:d} repetitions'.format(EXECUTIONS, TIMINGS))
print()

longest = max(len(timing.label) for timing in timings)  # Len of longest identifier.
ranked = sorted(timings, key=attrgetter('exec_time')) # Sort so fastest is first.
fastest = ranked[0].exec_time
for rank, timing in enumerate(ranked, 1):
print('{:<2d} {:>{width}} : {:8.4f} secs, rel speed {:6.2f}x, {:6.2f}% slower '
'({:6.2f} KiB/sec)'.format(
rank,
timing.label, timing.exec_time, round(timing.exec_time/fastest, 2),
round((timing.exec_time/fastest - 1) * 100, 2),
(FILE_SIZE/timing.exec_time) / KiB(1),  # per sec.
width=longest))
print()
mins, secs = divmod(time.time()-start_time, 60)
print('Benchmark runtime (min:sec) - {:02d}:{:02d}'.format(int(mins),
int(round(secs))))

main()
``````

Read line by line, not the whole file:

``````for line in open(file_name, 'rb'):
# process line here
``````

Even better use `with` for automatically closing the file:

``````with open(file_name, 'rb') as f:
for line in f:
# process line here
``````

The above will read the file object using an iterator, one line at a time.

### Operand type clash: uniqueidentifier is incompatible with int

The reason is that the data doesn't match the datatype. I have come across the same issues that I forgot to make the fields match. Though my case is not same as yours, but it shows the similar error message.

The situation is that I copy a table, but accidently I misspell one field, so I change it using the `ALTER` after creating the database. And the order of fields in both table is not identical. so when I use the `INSERT INTO TableName SELECT * FROM TableName`, the result showed the similar errors: `Operand type clash: datetime is incompatible with uniqueidentifier`

This is a simiple example:

``````use example
go
create table Test1 (
id int primary key,
item uniqueidentifier,
inserted_at datetime
)
go
create table Test2 (
id int primary key,
inserted_at datetime
)
go
alter table Test2 add item uniqueidentifier;
go

--insert into Test1 (id, item, inserted_at) values (1, newid(), getdate()), (2, newid(), getdate());

insert into Test2 select * from Test1;

select * from Test1;
select * from Test2;

``````

The error message is:

``````Msg 206, Level 16, State 2, Line 24
Operand type clash: uniqueidentifier is incompatible with datetime
``````

### Disable all Database related auto configuration in Spring Boot

Another way to control it via Profiles is this:

``````// note: no @SpringApplication annotation here
@Import(DatabaseConfig.class)
public class Application {

public static void main(String[] args) {
SpringApplication.run(Application.class, args);
}
}

@Configuration
@Import({DatabaseConfig.WithDB.class, DatabaseConfig.WithoutDB.class})
public class DatabaseConfig {

@Profile("!db")
@EnableAutoConfiguration(
exclude = {DataSourceAutoConfiguration.class,   DataSourceTransactionManagerAutoConfiguration.class,
HibernateJpaAutoConfiguration.class})
static class WithoutDB {

}

@Profile("db")
@EnableAutoConfiguration
static class WithDB {

}
}
``````

### onSaveInstanceState () and onRestoreInstanceState ()

The main thing is that if you don't store in `onSaveInstanceState()` then `onRestoreInstanceState()` will not be called. This is the main difference between `restoreInstanceState()` and `onCreate()`. Make sure you really store something. Most likely this is your problem.

### python list by value not by reference

As answered in the official Python FAQ:

``````b = a[:]
``````

### How to select a div element in the code-behind page?

You have make div as server control using following code,

``````<div class="tab-pane active" id="portlet_tab1" runat="server">
``````

then this div will be accessible in code behind.

### How to generate a create table script for an existing table in phpmyadmin?

I found another way to export table in sql file.

Suppose my table is `abs_item_variations`

``````abs_item_variations ->structure -> propose table structure -> export -> Go
``````

### ASP.NET MVC controller actions that return JSON or partial html

To answer the other half of the question, you can call:

``````return PartialView("viewname");
``````

when you want to return partial HTML. You'll just have to find some way to decide whether the request wants JSON or HTML, perhaps based on a URL part/parameter.

### How to get the size of a file in MB (Megabytes)?

You can use substring to get portio of String which is equal to 1 mb:

``````public static void main(String[] args) {
// Get length of String in bytes
String string = "long string";
long sizeInBytes = string.getBytes().length;
int oneMb=1024*1024;
if (sizeInBytes>oneMb) {
String string1Mb=string.substring(0, oneMb);
}
}
``````

### How to get the total number of rows of a GROUP BY query?

If you're willing to give up a hint of abstraction, then you could use a custom wrapper class which simply passes everything through to the PDO. Say, something like this: (Warning, code untested)

``````class SQLitePDOWrapper
{
private \$pdo;

public function __construct( \$dns, \$uname = null, \$pwd = null, \$opts = null )
{
\$this->pdo = new PDO( \$dns, \$unam, \$pwd, \$opts );
}
public function __call( \$nm, \$args )
{
\$ret = call_user_func_array( array( \$this->pdo, \$nm ), \$args );
if( \$ret instanceof PDOStatement )
{
return new StatementWrapper( \$this, \$ret, \$args[ 0 ] );
// I'm pretty sure args[ 0 ] will always be your query,
// even when binding
}

return \$ret;
}

}

class StatementWrapper
{
private \$pdo; private \$stat; private \$query;

public function __construct( PDO \$pdo, PDOStatement \$stat, \$query )
{
\$this->pdo  = \$pdo;
\$this->stat = \$stat;
this->query = \$query;
}

public function rowCount()
{
if( strtolower( substr( \$this->query, 0, 6 ) ) == 'select' )
{
// replace the select columns with a simple 'count(*)
\$res = \$this->pdo->query(
'SELECT COUNT(*)' .
substr( \$this->query,
strpos( strtolower( \$this->query ), 'from' ) )
)->fetch( PDO::FETCH_NUM );
return \$res[ 0 ];
}
return \$this->stat->rowCount();
}

public function __call( \$nm, \$args )
{
return call_user_func_array( array( \$this->stat, \$nm ), \$args );
}
}
``````

### How do I deserialize a complex JSON object in C# .NET?

I solved this problem to add a public setter for all properties, which should be deserialized.

### Node.js console.log() not logging anything

Using modern --inspect with node the console.log is captured and relayed to the browser.

node --inspect myApp.js

or to capture early logging --inspect-brk can be used to stop the program on the first line of the first module...

node --inspect-brk myApp.js

### Right Align button in horizontal LinearLayout

I know this is old but here is another one in a Linear Layout would be:

``````<LinearLayout
xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:orientation="horizontal"
android:layout_marginTop="35dp">

<TextView
android:id="@+id/lblExpenseCancel"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="@string/cancel"
android:textColor="#404040"
android:layout_marginLeft="10dp"
android:textSize="20sp"
android:layout_marginTop="9dp" />

<Button
android:layout_width="wrap_content"
android:layout_height="45dp"
android:background="@drawable/stitch_button"
android:layout_marginLeft="10dp"
android:layout_gravity="center_vertical|bottom|right|top"
android:layout_marginRight="15dp" />
``````

Please note the layout_gravity as opposed to just gravity.

### Remove last character from string. Swift language

The easiest way to trim the last character of the string is:

``````title = title[title.startIndex ..< title.endIndex.advancedBy(-1)]
``````

### Find PHP version on windows command line

For Beginners to anything php, it is usually stored in the C:/ path folder of your PC (My Computer).

==On Windows==
2.Type cmd and press enter to select the first program/application that responds to your search result.
A black window terminal will appear, this is known as a Command Line Interpreter
3.In the Terminal Window (Application) Type cd c: and press enter
4.Now type php -v and press enter

and viola there you'll have the current php version that is installed in your machine

### How to select all instances of selected region in Sublime Text

On Windows/Linux press Alt+F3.

This worked for me on Ubuntu. I changed it in my "Key-Bindings:User" to something that I liked better though.

### Excel vba - convert string to number

If, for example, x = 5 and is stored as string, you can also just:

x = x + 0

and the new x would be stored as a numeric value.

### What is the difference between Views and Materialized Views in Oracle?

Materialized views can only be set to refresh automatically through the database detecting changes when the view query is considered simple by the compiler. If it's considered too complex, it won't be able to set up what are essentially internal triggers to track changes in the source tables to only update the changed rows in the mview table.

When you create a materialized view, you'll find that Oracle creates both the mview and as a table with the same name, which can make things confusing.

### connecting to mysql server on another PC in LAN

Connecting to any mysql database should be like this:

`\$mysql -h hostname -Pportnumber -u username -p` (then enter)

Then it will ask for password. Note: Port number should be closer to -P or it will show error. Make sure you know what is your mysql port. Default is 3306 and is optional to specify the port in this case. If its anything else you need to mention port number with -P or else it will show error.

For example: `\$mysql -h 10.20.40.5 -P3306 -u root -p` (then enter)

``````Password:My_Db_Password
``````

``````mysql>_
``````

Note: If you are trying to connect a db at different location make sure you can ping to that server/computer.

``````\$ping 10.20.40.5
``````

It should return TTL with time you got back PONG. If it says destination unreachable then you cannot connect to remote mysql no matter what.

In such case contact your Network Administrator or Check your cable connection to your computer till the end of your target computer. Or check if you got LAN/WAN/MAN or internet/intranet/extranet working.

### Class Diagrams in VS 2017

the following procedure worked for me:

• Close VS.
• Run Visual Studio Installer.
• Click on the 'Modify' button under 'Visual Studio Professional 2017'
• In the new window, scroll down and select 'Visual Studio Extension Development' under 'Other Toolsets'.
• Then on the right, if not selected yet, click on 'Class Designer'
• Click on 'Modify' to confirm

### Angular checkbox and ng-click

The order of execution of `ng-click` and `ng-model` is ambiguous since they do not define clear priorities. Instead you should use `ng-change` or a `\$watch` on the `\$scope` to ensure that you obtain the correct values of the model variable.

In your case, this should work:

``````<input type="checkbox" ng-model="vm.myChkModel" ng-change="vm.myClick(vm.myChkModel)">
``````

### How to set Bullet colors in UL/LI html lists via CSS without using any images or span tags

The easiest thing you can do is wrap the contents of the `<li>` in a `<span>` or equivalent then you can set the color independently.

Alternatively, you could make an image with the bullet color you want and set it with the `list-style-image` property.

### Get difference between two lists

``````In [5]: list(set(temp1) - set(temp2))
Out[5]: ['Four', 'Three']
``````

Beware that

``````In [5]: set([1, 2]) - set([2, 3])
Out[5]: set([1])
``````

where you might expect/want it to equal `set([1, 3])`. If you do want `set([1, 3])` as your answer, you'll need to use `set([1, 2]).symmetric_difference(set([2, 3]))`.

### How does JavaScript .prototype work?

It's just that you already have an object with `Object.new` but you still don't have an object when using the constructor syntax.

### How to copy a folder via cmd?

``````xcopy  "C:\Documents and Settings\user\Desktop\?????????" "D:\Backup" /s /e /y /i
``````

Probably the problem is the space.Try with quotes.

### How to remove the arrow from a select element in Firefox

We've found a simple and decent way to do this. It's cross-browser,degradable, and doesn't break a form post. First set the select box's `opacity` to `0`.

``````.select {
opacity : 0;
width: 200px;
height: 15px;
}

<select class='select'>
<option value='foo'>bar</option>
</select>
``````

this is so you can still click on it

Then make div with the same dimensions as the select box. The div should lay under the select box as the background. Use `{ position: absolute }` and `z-index` to achieve this.

``````.div {
width: 200px;
height: 15px;
position: absolute;
z-index: 0;
}

<div class='.div'>{the text of the the current selection updated by javascript}</div>
<select class='select'>
<option value='foo'>bar</option>
</select>
``````

Update the div's innerHTML with javascript. Easypeasy with jQuery:

``````\$('.select').click(function(event)) {
\$('.div').html(\$('.select option:selected').val());
}
``````

That's it! Just style your div instead of the select box. I haven't tested the above code so you'll probably need tweak it. But hopefully you get the gist.

I think this solution beats `{-webkit-appearance: none;}`. What browsers should do at the very most is dictate interaction with form elements, but definitely not how their initially displayed on the page as that breaks site design.

### How to redirect page after click on Ok button on sweet alert?

I did it by using this code:

``````<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.4.0/jquery.js"></script>
<script>

\$(".confirm").on('click',function(){
window.location.href = "index.php";
});

</script>
``````

Thanks.

### How to use store and use session variables across pages?

#### Sessions Step By Step

1. Defining session before everything, No output should be before that, NO OUTPUT

``````<?php
session_start();
?>
``````
2. Set your session inside a page and then you have access in that page. For example this is page 1.php

``````<?php
//This is page 1 and then we will use session that defined from this page:
session_start();
\$_SESSION['email']='[email protected]';
?>
``````
3. Using and Getting session in 2.php

`````` <?php

session_start();
if(\$_SESSION['email']){
echo 'Your Email Is Here!  :) ';
}
?>
``````

### Twitter bootstrap float div right

``````<p class="pull-left">Text left</p>
<p class="text-right">Text right in same line</p>
``````

This work for me.

edit: An example with your snippet:

_x000D_
_x000D_
``````@import url('https://unpkg.com/[email protected]/dist/css/bootstrap.css');_x000D_
.container {_x000D_
margin-top: 10px;_x000D_
}``````
_x000D_
``````<div class="container">_x000D_
<div class="row-fluid">_x000D_
<div class="span6 pull-left">_x000D_
<p>Text left</p>_x000D_
</div>_x000D_
<div class="span6 text-right">_x000D_
<p>text right</p>_x000D_
</div>_x000D_
</div>_x000D_
</div>``````
_x000D_
_x000D_
_x000D_

### Calculate RSA key fingerprint

The newer SSH commands will list fingerprints as a SHA256 Key.

For example:

``````ssh-keygen -lf ~/.ssh/id_dsa.pub
1024 SHA256:19n6fkdz0qqmowiBy6XEaA87EuG/jgWUr44ZSBhJl6Y (DSA)
``````

If you need to compare it against an old fingerprint you also need to specify to use the MD5 fingerprint hashing function.

``````ssh-keygen -E md5 -lf ~/.ssh/id_dsa.pub
2048 MD5:4d:5b:97:19:8c:fe:06:f0:29:e7:f5:96:77:cb:3c:71 (DSA)
``````

Also available: `-E sha1`

Update... YES...yes... I know... DSA keys for SSH should no longer be used, the older RSA key or newer ecliptic keys should be used instead.

To those 'admins' that keep editing the command I used in the above. STOP CHANGING IT! You make the command and resulting output mis-match!

### How to determine a Python variable's type?

Do you mean in Python or using ctypes?

In the first case, you simply cannot - because Python does not have signed/unsigned, 16/32 bit integers.

In the second case, you can use `type()`:

``````>>> import ctypes
>>> a = ctypes.c_uint() # unsigned int
>>> type(a)
<class 'ctypes.c_ulong'>
``````

For more reference on ctypes, an its type, see the official documentation.

### Creating a .p12 file

I'm debugging an issue I'm having with SSL connecting to a database (MySQL RDS) using an ORM called, Prisma. The database connection string requires a PKCS12 (.p12) file (if interested, described here), which brought me here.

I know the question has been answered, but I found the following steps (in Github Issue#2676) to be helpful for creating a .p12 file and wanted to share. Good luck!

1. Generate 2048-bit RSA private key:

`openssl genrsa -out key.pem 2048`

2. Generate a Certificate Signing Request:

`openssl req -new -sha256 -key key.pem -out csr.csr`

3. Generate a self-signed x509 certificate suitable for use on web servers.

`openssl req -x509 -sha256 -days 365 -key key.pem -in csr.csr -out certificate.pem`

4. Create SSL identity file in PKCS12 as mentioned here

`openssl pkcs12 -export -out client-identity.p12 -inkey key.pem -in certificate.pem`

### C Linking Error: undefined reference to 'main'

You are overwriting your object file `runexp.o` by running this command :

`````` gcc -o runexp.o scd.o data_proc.o -lm -fopenmp
``````

In fact, the `-o` is for the output file. You need to run :

``````gcc -o runexp.out runexp.o scd.o data_proc.o -lm -fopenmp
``````

runexp.out will be you binary file.

### Remove all of x axis labels in ggplot

You have to set to `element_blank()` in `theme()` elements you need to remove

``````ggplot(data = diamonds, mapping = aes(x = clarity)) + geom_bar(aes(fill = cut))+
theme(axis.title.x=element_blank(),
axis.text.x=element_blank(),
axis.ticks.x=element_blank())
``````

### How to pass model attributes from one Spring MVC controller to another controller?

If you want just pass all attributes to redirect...

``````public String yourMethod( ...., HttpServletRequest request, RedirectAttributes redirectAttributes) {
if(shouldIRedirect()) {
return "redirect:/newPage.html";
}
}
``````

### How to add noise (Gaussian/salt and pepper etc) to image in Python with OpenCV

The Function adds gaussian , salt-pepper , poisson and speckle noise in an image

``````Parameters
----------
image : ndarray
Input image data. Will be converted to float.
mode : str
One of the following strings, selecting the type of noise to add:

'poisson'   Poisson-distributed noise generated from the data.
's&p'       Replaces random pixels with 0 or 1.
'speckle'   Multiplicative noise using out = image + n*image,where
n is uniform noise with specified mean & variance.

import numpy as np
import os
import cv2
def noisy(noise_typ,image):
if noise_typ == "gauss":
row,col,ch= image.shape
mean = 0
var = 0.1
sigma = var**0.5
gauss = np.random.normal(mean,sigma,(row,col,ch))
gauss = gauss.reshape(row,col,ch)
noisy = image + gauss
return noisy
elif noise_typ == "s&p":
row,col,ch = image.shape
s_vs_p = 0.5
amount = 0.004
out = np.copy(image)
# Salt mode
num_salt = np.ceil(amount * image.size * s_vs_p)
coords = [np.random.randint(0, i - 1, int(num_salt))
for i in image.shape]
out[coords] = 1

# Pepper mode
num_pepper = np.ceil(amount* image.size * (1. - s_vs_p))
coords = [np.random.randint(0, i - 1, int(num_pepper))
for i in image.shape]
out[coords] = 0
return out
elif noise_typ == "poisson":
vals = len(np.unique(image))
vals = 2 ** np.ceil(np.log2(vals))
noisy = np.random.poisson(image * vals) / float(vals)
return noisy
elif noise_typ =="speckle":
row,col,ch = image.shape
gauss = np.random.randn(row,col,ch)
gauss = gauss.reshape(row,col,ch)
noisy = image + image * gauss
return noisy
``````

### Non-static variable cannot be referenced from a static context

It is ClassLoader responsible to load the class files.Let's see what happens when we write our own classes.

Example 1:

``````class StaticTest {

static int a;
int b;
int c;
}
``````

Now we can see that class "StaticTest" has 3 fields.But actually there is no existence of b,c member variable.But why ???. OK Lest's see. Here b,c are instance variable.Since instance variable gets the memory at the time of object creation. So here b,c are not getting any memory yet. That's why there is no existence of b,c. So There is only existence of a. For ClassLoader it has only one information about a. ClassLoader yet not recognize b,c because it's object not instantiated yet.

Let's see another example: Example 2:

``````class StaticTest {

public void display() {
System.out.println("Static Test");
}

public static void main(String []cmd) {

display();
}

}
``````

Now if we try to compile this code compiler will give CE error. CE: non-static method display() cannot be referenced from a static context.

Now For ClassLoader it looks like:

``````class StaticTest {

public static void main(String []cmd) {

display();
}

}
``````

In Example 2 CE error is because we call non static method from a static context. So it is not possible for ClassLoader to recognize method display() at compile time.So compile time error is occurred.

### SQL query to select dates between two dates

``````select * from test
where CAST(AddTime as datetime) between '2013/4/4' and '2014/4/4'
``````

-- if data type is different

### How can I find whitespace in a String?

This will tell if you there is any whitespaces:

Either by looping:

``````for (char c : s.toCharArray()) {
if (Character.isWhitespace(c)) {
return true;
}
}
``````

or

``````s.matches(".*\\s+.*")
``````

And `StringUtils.isBlank(s)` will tell you if there are only whitepsaces.

### What Ruby IDE do you prefer?

Have you tried Aptana? It's based on Eclipse and they have a sweet Rails plugin.

### How to use multiprocessing pool.map with multiple arguments?

A better solution for python2:

``````from multiprocessing import Pool
def func((i, (a, b))):
print i, a, b
return a + b
pool = Pool(3)
pool.map(func, [(0,(1,2)), (1,(2,3)), (2,(3, 4))])
``````

2 3 4

1 2 3

0 1 2

out[]:

[3, 5, 7]

### Sorting objects by property values

Example.

This runs on cscript.exe, on windows.

``````// define the Car class
(function() {
// makeClass - By John Resig (MIT Licensed)
// Allows either new User() or User() to be employed for construction.
function makeClass(){
return function(args){
if ( this instanceof arguments.callee ) {
if ( typeof this.init == "function" )
this.init.apply( this, (args && args.callee) ? args : arguments );
} else
return new arguments.callee( arguments );
};
}

Car = makeClass();

Car.prototype.init = function(make, model, price, topSpeed, weight) {
this.make = make;
this.model = model;
this.price = price;
this.weight = weight;
this.topSpeed = topSpeed;
};
})();

// create a list of cars
var autos = [
new Car("Chevy", "Corvair", 1800, 88, 2900),
new Car("Buick", "LeSabre", 31000, 138, 3700),
new Car("Toyota", "Prius", 24000, 103, 3200),
new Car("Porsche", "911", 92000, 155, 3100),
new Car("Mercedes", "E500", 67000, 145, 3800),
new Car("VW", "Passat", 31000, 135, 3700)
];

// a list of sorting functions
var sorters = {
byWeight : function(a,b) {
return (a.weight - b.weight);
},
bySpeed : function(a,b) {
return (a.topSpeed - b.topSpeed);
},
byPrice : function(a,b) {
return (a.price - b.price);
},
byModelName : function(a,b) {
return ((a.model < b.model) ? -1 : ((a.model > b.model) ? 1 : 0));
},
byMake : function(a,b) {
return ((a.make < b.make) ? -1 : ((a.make > b.make) ? 1 : 0));
}
};

function say(s) {WScript.Echo(s);}

function show(title)
{
say ("sorted by: "+title);
for (var i=0; i < autos.length; i++) {
say("  " + autos[i].model);
}
say(" ");
}

autos.sort(sorters.byWeight);
show("Weight");

autos.sort(sorters.byModelName);
show("Name");

autos.sort(sorters.byPrice);
show("Price");
``````

You can also make a general sorter.

``````var byProperty = function(prop) {
return function(a,b) {
if (typeof a[prop] == "number") {
return (a[prop] - b[prop]);
} else {
return ((a[prop] < b[prop]) ? -1 : ((a[prop] > b[prop]) ? 1 : 0));
}
};
};

autos.sort(byProperty("topSpeed"));
show("Top Speed");
``````

### How to convert UTF8 string to byte array?

You can save a string raw as is by using FileReader.

Save the string in a blob and call readAsArrayBuffer(). Then the onload-event results an arraybuffer, which can converted in a Uint8Array. Unfortunately this call is asynchronous.

``````function stringToBytes(str)
{
let done = () => {};

{
done(new Uint8Array(event.target.result), str);
};

return { done: callback => { done = callback; } };
}
``````

Call it like this:

``````stringToBytes("\u{1f4a9}").done(bytes =>
{
console.log(bytes);
});
``````

output: `[240, 159, 146, 169]`

explanation:

JavaScript use UTF-16 and surrogate-pairs to store unicode characters in memory. To save unicode character in raw binary byte streams an encoding is necessary. Usually and in the most case, UTF-8 is used for this. If you not use an enconding you can't save unicode character, just ASCII up to 0x7f.

### What does "yield break;" do in C#?

`yield` basically makes an `IEnumerable<T>` method behave similarly to a cooperatively (as opposed to preemptively) scheduled thread.

`yield return` is like a thread calling a "schedule" or "sleep" function to give up control of the CPU. Just like a thread, the `IEnumerable<T>` method regains controls at the point immediately afterward, with all local variables having the same values as they had before control was given up.

`yield break` is like a thread reaching the end of its function and terminating.

People talk about a "state machine", but a state machine is all a "thread" really is. A thread has some state (I.e. values of local variables), and each time it is scheduled it takes some action(s) in order to reach a new state. The key point about `yield` is that, unlike the operating system threads we're used to, the code that uses it is frozen in time until the iteration is manually advanced or terminated.

### Unable to run Java code with Intellij IDEA

Last resort option when nothing else seems to work: close and reopen IntelliJ.

My issue was with reverting a Git commit, which happened to change the Java SDK configured for the Project to a no longer installed version of the JDK. But fixing that back still didn't allow me to run the program. Restarting IntelliJ fixed this

### Why doesn't wireshark detect my interface?

By Restarting NPF, I can see the interfaces with wireshark 1.6.5

Open a Command Prompt with administrative privileges.

1. Execute the command "sc stop npf".
2. Then start npf by command "sc start npf".
3. Open WireShark.

That's it.

### How to get the system uptime in Windows?

I use this little PowerShell snippet:

``````function Get-SystemUptime {
\$operatingSystem = Get-WmiObject Win32_OperatingSystem
"\$((Get-Date) - ([Management.ManagementDateTimeConverter]::ToDateTime(\$operatingSystem.LastBootUpTime)))"
}
``````

which then yields something like the following:

``````PS> Get-SystemUptime
6.20:40:40.2625526
``````

### How to convert from int to string in objective c: example code

If you just need an int to a string as you suggest, I've found the easiest way is to do as below:

``````[NSString stringWithFormat:@"%d",numberYouAreTryingToConvert]
``````

### How do I create a chart with multiple series using different X values for each series?

You need to use the Scatter chart type instead of Line. That will allow you to define separate X values for each series.

### Custom thread pool in Java 8 parallel stream

Alternatively to the trick of triggering the parallel computation inside your own forkJoinPool you can also pass that pool to the CompletableFuture.supplyAsync method like in:

``````ForkJoinPool forkJoinPool = new ForkJoinPool(2);
CompletableFuture<List<Integer>> primes = CompletableFuture.supplyAsync(() ->
range(1, 1_000_000).parallel().filter(PrimesPrint::isPrime).collect(toList()),
forkJoinPool
);
``````

### If hasClass then addClass to parent

The reason that does not work is because `this` has no specific meaning inside of an if statement, you will have to go back to a level of scope where `this` is defined (a function).

For example:

``````\$('#element1').click(function() {
console.log(\$(this).attr('id')); // logs "element1"

if (\$('#element2').hasClass('class')) {
console.log(\$(this).attr('id')); // still logs "element1"
}
});
``````

### Named colors in matplotlib

To get a full list of colors to use in plots:

``````import matplotlib.colors as colors
colors_list = list(colors._colors_full_map.values())
``````

So, you can use in that way quickly:

``````scatter(X,Y, color=colors_list[0])
scatter(X,Y, color=colors_list[1])
scatter(X,Y, color=colors_list[2])
...
scatter(X,Y, color=colors_list[-1])
``````

### Java 8: merge lists with stream API

Alternative: Stream.concat()

``````Stream.concat(map.values().stream(), listContainer.lst.stream())
.collect(Collectors.toList()
``````

### jQuery: selecting each td in a tr

``````\$('#tblNewAttendees tbody tr).each((index, tr)=> {
//console.log(tr);
\$(tr).children('td').each ((index, td) => {
console.log(td);

});

});
``````

You can use this tr and td parameter also.

### Detect merged cells in VBA Excel with MergeArea

While working with selected cells as shown by @tbur can be useful, it's also not the only option available.

You can use Range() like so:

``````If Worksheets("Sheet1").Range("A1").MergeCells Then
Do something
Else
Do something else
End If
``````

Or:

``````If Worksheets("Sheet1").Range("A1:C1").MergeCells Then
Do something
Else
Do something else
End If
``````

Alternately, you can use Cells():

``````If Worksheets("Sheet1").Cells(1, 1).MergeCells Then
Do something
Else
Do something else
End If
``````

### AWS - Disconnected : No supported authentication methods available (server sent :publickey)

While trying to connect to a SiteGround server via Putty I had the same problem. Their instructions are pretty thorough, and must work for some people, but didn't work for me.

They recommend running pageant.exe, which runs in the background. You register your key(s) with Pageant, and it's supposed to let Putty know about the keys when it tries to connect.

In a couple of places I found suggestions to specify the key directly in the Putty session definition: Putty Configuration > Connection > SSH > Auth > "Private key file for authentication", then browse to your key file in .ppk format.

Doing this without running Pageant resolved the problem for me.

### Favicon: .ico or .png / correct tags?

See here: Cross Browser favicon

Thats the way to go:

``````<link rel="icon" type="image/png" href="http://www.example.com/image.png"><!-- Major Browsers -->
<!--[if IE]><link rel="SHORTCUT ICON" href="http://www.example.com/alternateimage.ico"/><![endif]--><!-- Internet Explorer-->
``````

### In WPF, what are the differences between the x:Name and Name attributes?

They are not the same thing.

`x:Name` is a xaml concept, used mainly to reference elements. When you give an element the x:Name xaml attribute, "the specified `x:Name` becomes the name of a field that is created in the underlying code when xaml is processed, and that field holds a reference to the object." (MSDN) So, it's a designer-generated field, which has internal access by default.

`Name` is the existing string property of a `FrameworkElement`, listed as any other wpf element property in the form of a xaml attribute.

As a consequence, this also means `x:Name` can be used on a wider range of objects. This is a technique to enable anything in xaml to be referenced by a given name.

### httpd-xampp.conf: How to allow access to an external IP besides localhost?

In windows all you have to do is to go to windows search Allow an app through Windows Firewall.click on Allow another app select Apache and mark public and private both . Open cmd by pressing windows button+r write cmd than in cmd write ipconfig find out your ip . than open up your browser write down your ip http://172.16..x and you will be on the xampp startup page.if you want to access your local site simply put / infront of your ip e.g http://192.168.1.x/yousite. Now you are able to access your website in private network computers .

i hope this will resolve your problem

### Stored procedure or function expects parameter which is not supplied

I came across this issue yesterday, but none of the solutions here worked exactly, however they did point me in the right direction.

Our application is a workflow tool written in C# and, overly simplified, has several stored procedures on the database, as well as a table of metadata about each parameter used by each stored procedure (name, order, data type, size, etc), allowing us to create as many new stored procedures as we need without having to change the C#.

Analysis of the problem showed that our code was setting all the correct parameters on the `SqlCommand` object, however once it was executed, it threw the same error as the OP got.

Further analysis revealed that some parameters had a value of `null`. I therefore must draw the conclusion that `SqlCommand` objects ignore any `SqlParameter` object in their `.Parameters` collection with a value of `null`.

There are two solutions to this problem that I found.

1. In our stored procedures, give a default value to each parameter, so from `@Parameter int` to `@Parameter int = NULL` (or some other default value as required).

2. In our code that generates the individual `SqlParameter` objects, assigning `DBNull.Value` instead of `null` where the intended value is a SQL `NULL` does the trick.

The original coder has moved on and the code was originally written with Solution 1 in mind, and having weighed up the benefits of both, I think I'll stick with Solution 1. It's much easier to specify a default value for a specific stored procedure when writing it, rather than it always being `NULL` as defined in the code.

Hope that helps someone.

### How to alter SQL in "Edit Top 200 Rows" in SSMS 2008

The default to open/add rows to a table is Edit Top 200 Rows. If you have more than 200 rows, like me now, then you need to change the default setting. Here's what I did to change the edit default to 300:

1. Go to Tools in top nav
2. Select options, then SQL Service Object Explorer (on left)
3. On right side of panel, click into the field that contains 200 and change to 300 (or whatever number you wish)
4. Click OK and voila, you're all set!

### Random integer in VB.NET

``````Function xrand() As Long
Dim r1 As Long = Now.Day & Now.Month & Now.Year & Now.Hour & Now.Minute & Now.Second & Now.Millisecond
Dim RAND As Long = Math.Max(r1, r1 * 2)
Return RAND
End Function
``````

[BBOYSE] This its the best way, from scratch :P

### Skip rows during csv import pandas

Also be sure that your file is actually a CSV file. For example, if you had an .xls file, and simply changed the file extension to .csv, the file won't import and will give the error above. To check to see if this is your problem open the file in excel and it will likely say:

"The file format and extension of 'Filename.csv' don't match. The file could be corrupted or unsafe. Unless you trust its source, don't open it. Do you want to open it anyway?"

To fix the file: open the file in Excel, click "Save As", Choose the file format to save as (use .cvs), then replace the existing file.

This was my problem, and fixed the error for me.

### Normalization in DOM parsing with java - how does it work?

The rest of the sentence is:

where only structure (e.g., elements, comments, processing instructions, CDATA sections, and entity references) separates Text nodes, i.e., there are neither adjacent Text nodes nor empty Text nodes.

This basically means that the following XML element

``````<foo>hello
wor
ld</foo>
``````

could be represented like this in a denormalized node:

``````Element foo
Text node: ""
Text node: "Hello "
Text node: "wor"
Text node: "ld"
``````

When normalized, the node will look like this

``````Element foo
Text node: "Hello world"
``````

And the same goes for attributes: `<foo bar="Hello world"/>`, comments, etc.

### C error: Expected expression before int

`{ }` -->

defines scope, so `if(a==1) { int b = 10; }` says, you are defining int b, for {}- this scope. For

``````if(a==1)
int b =10;
``````

there is no scope. And you will not be able to use `b` anywhere.

### Button that refreshes the page on click

just create the empty reference on link such as following

`````` <a href="" onclick="dummy(0);return false;" >
``````

### How do I execute a string containing Python code in Python?

Check out eval:

``````x = 1
print eval('x+1')
->2
``````

### How to get image width and height in OpenCV?

You can use `rows` and `cols`:

``````cout << "Width : " << src.cols << endl;
cout << "Height: " << src.rows << endl;
``````

or `size()`:

``````cout << "Width : " << src.size().width << endl;
cout << "Height: " << src.size().height << endl;
``````

### Get drop down value

``````var dd = document.getElementById("dropdownID");
var selectedItem = dd.options[dd.selectedIndex].value;
``````

### QtCreator: No valid kits found

Another way to solve this issue (I did it on Ubuntu 16.04 but it might also work for windows and other Ubuntu versions):

While going through the installation steps, when you reach the step where you choose which packages to install via check boxes, instead of just pressing next with the default "Tools" checkbox selected also check the box for the version of QT you would like in addition to the "Tools" box. I usually check the first box which is the latest version of QT.

After doing this you should not see the "no valid kits found" issue described in this thread.

Happy Coding.

### Generic type conversion FROM string

lubos hasko's method fails for nullables. The method below will work for nullables. I didn't come up with it, though. I found it via Google: http://web.archive.org/web/20101214042641/http://dogaoztuzun.com/post/C-Generic-Type-Conversion.aspx Credit to "Tuna Toksoz"

Usage first:

``````TConverter.ChangeType<T>(StringValue);
``````

The class is below.

``````public static class TConverter
{
public static T ChangeType<T>(object value)
{
return (T)ChangeType(typeof(T), value);
}

public static object ChangeType(Type t, object value)
{
TypeConverter tc = TypeDescriptor.GetConverter(t);
return tc.ConvertFrom(value);
}

public static void RegisterTypeConverter<T, TC>() where TC : TypeConverter
{

}
}
``````

### Message 'src refspec master does not match any' when pushing commits in Git

In my case the issue, occuring on Windows, seemed to have something to do with us adding a prefix like `feature\` to branch names. We were trying to create and push a branch with such a prefix (say, `feature\branch`) but there was already a different branch, with a different name prefixed with `Feature\` (say, `Feature\otherbranch`). This means that on Windows the new branch was placed in the same `refs\heads\Feature` folder. Git may be case-sensitive but Windows filesystem isn't. It helped once we checked out the local branch named `Feature\branch`.

### How to remove entry from \$PATH on mac

On MAC OS X Leopard and higher

``````cd /etc/paths.d
``````

There may be a text file in the above directory that contains the path you are trying to remove.

``````vim textfile //check and see what is in it when you are done looking type :q
//:q just quits, no saves
``````

If its the one you want to remove do this

``````rm textfile //remove it, delete it
``````

Here is a link to a site that has more info on it, even though it illustrates 'adding' the path. However, you may gain some insight.

### How to resolve symbolic links in a shell script

Since I've run into this many times over the years, and this time around I needed a pure bash portable version that I could use on OSX and linux, I went ahead and wrote one:

The living version lives here:

https://github.com/keen99/shell-functions/tree/master/resolve_path

but for the sake of SO, here's the current version (I feel it's well tested..but I'm open to feedback!)

Might not be difficult to make it work for plain bourne shell (sh), but I didn't try...I like \$FUNCNAME too much. :)

``````#!/bin/bash

resolve_path() {
# usage:  resolve_path <a file or directory>
# follows symlinks and relative paths, returns a full real path
#
local owd="\$PWD"
#echo "\$FUNCNAME for \$1" >&2
local opath="\$1"
local npath=""
local obase=\$(basename "\$opath")
local odir=\$(dirname "\$opath")
if [[ -L "\$opath" ]]
then
#file or directory, we want to cd into it's dir
cd \$odir
#then extract where the link points.
#have to -L BEFORE we -f, because -f includes -L :(
if [[ -L \$npath ]]
then
resolve_path "\$npath"
#and finish out early, we're done.
return \$?
#done
elif [[ -f \$npath ]]
#the link points to a file.
then
#get the dir for the new file
nbase=\$(basename \$npath)
npath=\$(dirname \$npath)
cd "\$npath"
ndir=\$(pwd -P)
retval=0
#done
elif [[ -d \$npath ]]
then
#the link points to a directory.
cd "\$npath"
ndir=\$(pwd -P)
retval=0
#done
else
echo "\$FUNCNAME: ERROR: unknown condition inside link!!" >&2
echo "opath [[ \$opath ]]" >&2
echo "npath [[ \$npath ]]" >&2
return 1
fi
else
if ! [[ -e "\$opath" ]]
then
echo "\$FUNCNAME: \$opath: No such file or directory" >&2
return 1
#and break early
elif [[ -d "\$opath" ]]
then
cd "\$opath"
ndir=\$(pwd -P)
retval=0
#done
elif [[ -f "\$opath" ]]
then
cd \$odir
ndir=\$(pwd -P)
nbase=\$(basename "\$opath")
retval=0
#done
else
echo "\$FUNCNAME: ERROR: unknown condition outside link!!" >&2
echo "opath [[ \$opath ]]" >&2
return 1
fi
fi
#now assemble our output
echo -n "\$ndir"
if [[ "x\${nbase:=}" != "x" ]]
then
echo "/\$nbase"
else
echo
fi
cd "\$owd"
return \$retval
}
``````

here's a classic example, thanks to brew:

``````%% ls -l `which mvn`
lrwxr-xr-x  1 draistrick  502  29 Dec 17 10:50 /usr/local/bin/mvn@ -> ../Cellar/maven/3.2.3/bin/mvn
``````

use this function and it will return the -real- path:

``````%% cat test.sh
#!/bin/bash
. resolve_path.inc
echo
which mvn
echo
echo "and the real path:"
resolve_path `which mvn`

%% test.sh

/usr/local/bin/mvn

and the real path:
/usr/local/Cellar/maven/3.2.3/libexec/bin/mvn
``````

### Process list on Linux via Python

You could use psutil as a platform independent solution!

``````import psutil
psutil.pids()

[1, 2, 3, 4, 5, 6, 7, 46, 48, 50, 51, 178, 182, 222, 223, 224,
268, 1215, 1216, 1220, 1221, 1243, 1244, 1301, 1601, 2237, 2355,
2637, 2774, 3932, 4176, 4177, 4185, 4187, 4189, 4225, 4243, 4245,
4263, 4282, 4306, 4311, 4312, 4313, 4314, 4337, 4339, 4357, 4358,
4363, 4383, 4395, 4408, 4433, 4443, 4445, 4446, 5167, 5234, 5235,
5252, 5318, 5424, 5644, 6987, 7054, 7055, 7071]
``````

### Hexadecimal to Integer in Java

I finally find answers to my question based on all of your comments. Thanks, I tried this :

``````public Integer calculateHash(String uuid) {

try {
//....
String hex = hexToString(output);
//Integer i = Integer.valueOf(hex, 16).intValue();
//Instead of using Integer, I used BigInteger and I returned the int value.
BigInteger bi = new BigInteger(hex, 16);
return bi.intValue();`
} catch (NoSuchAlgorithmException e) {
System.out.println("SHA1 not implemented in this system");
}
//....
}
``````

This solution is not optimal but I can continue with my project. Thanks again for your help

### Regular expression to find URLs within a string

A probably too simplistic, but working method might be:

``````[localhost|http|https|ftp|file]+://[\w\S(\.|:|/)]+
``````

I tested it on Python and as long as the string parsing contains a space before and after and none in the url (which I have never seen before) it should be fine.

Here is an online ide demonstrating it

However here are some benefits of using it:

• It recognises `file:` and `localhost` as well as ip addresses
• It will never match without them
• It does not mind unusual characters such as `#` or `-` (see url of this post)

### When does a cookie with expiration time 'At end of session' expire?

If you set the expiration time to 0, the cookie won't be created at all. I've tested this on Google Chrome at least, and when set to 0 that was the result. The cookie, I guess, expires immediately after creation.

To set a cookie so it expires at the end of the browsing session, simply OMIT the expiration parameter altogether.

Example:

``````document.cookie = "cookie_name=cookie_value; 0; path=/";
``````

Just write:

``````document.cookie = "cookie_name=cookie_value; path=/";
``````

### Trigger change event of dropdown

alternatively you can put onchange attribute on the dropdownlist itself, that onchange will call certain jquery function like this.

``````<input type="dropdownlist" onchange="jqueryFunc()">

<script type="text/javascript">
\$(function(){
jqueryFunc(){
//something goes here
}
});
</script>
``````

hope this one helps you, and please note that this code is just a rough draft, not tested on any ide. thanks