# Programs & Examples On #Skew

### tqdm in Jupyter Notebook prints new progress bars repeatedly

Try using `tqdm.notebook.tqdm` instead of `tqdm`, as outlined here.

This could be as simple as changing your import to:

`from tqdm.notebook import tqdm`

Good luck!

EDIT: After testing, it seems that `tqdm` actually works fine in 'text mode' in Jupyter notebook. It's hard to tell because you haven't provided a minimal example, but it looks like your problem is caused by a print statement in each iteration. The print statement is outputting a number (~0.89) in between each status bar update, which is messing up the output. Try removing the print statement.

### Calculating percentile of dataset column

Using {dplyr}:

``````library(dplyr)

# percentiles
infert %>%
mutate(PCT = ntile(age, 100))

# quartiles
infert %>%
mutate(PCT = ntile(age, 4))

# deciles
infert %>%
mutate(PCT = ntile(age, 10))
``````

### Understanding `scale` in R

This is a late addition but I was looking for information on the scale function myself and though it might help somebody else as well.

To modify the response from Ricardo Saporta a little bit.
Scaling is not done using standard deviation, at least not in version 3.6.1 of R, I base this on "Becker, R. (2018). The new S language. CRC Press." and my own experimentation.

``````X.man.scaled <- X/sqrt(sum(X^2)/(length(X)-1))
X.aut.scaled <- scale(X, center = F)
``````

The result of these rows are exactly the same, I show it without centering because of simplicity.

I would respond in a comment but did not have enough reputation.

### Aesthetics must either be length one, or the same length as the dataProblems

It is better to not subset the variables inside `aes()`, and instead transform your data:

``````df1 <- unstack(df,form = price~product)
df1\$skew <- rep(letters[2:1],each = 4)

p1 <- ggplot(df1, aes(x=p1, y=p3, colour=factor(skew))) +
geom_point(size=2, shape=19)
p1
``````

### CSS3 Transform Skew One Side

I know this is old, but I would like to suggest using a linear-gradient to achieve the same effect instead of margin offset. This is will maintain any content at its original place.

http://jsfiddle.net/zwXaf/2/

HTML

``````<ul>
<li><a href="#">One</a></li>
<li><a href="#">Two</a></li>
<li><a href="#">Three</a></li>
</ul>
``````

CSS

``````/* reset */
ul, li, a {
}
/* nav stuff */
ul, li, a {
display: inline-block;
text-align: center;
}
/* appearance styling */
ul {
/* hacks to make one side slant only */
overflow: hidden;
background: linear-gradient(to right, red, white, white, red);
}
li {
background-color: red;
transform:skewX(-20deg);
-ms-transform:skewX(-20deg);
-webkit-transform:skewX(-20deg);
}
li a {
color: #ffffff;
text-decoration: none;
width: 80px;
transform:skewX(20deg);
-ms-transform:skewX(20deg);
-webkit-transform:skewX(20deg);
}
``````

### Responsive Image full screen and centered - maintain aspect ratio, not exceed window

I have come to point out the answer nobody seems to see here. You can fullfill all requests you have made with pure CSS and it's very simple. Just use Media Queries. Media queries can check the orientation of the user's screen, or viewport. Then you can style your images depending on the orientation.

``````img {
width:auto;
height:auto;
max-width:100%;
max-height:100%;
}
``````

Then use some media queries to check your orientation and that's it!

``````@media (orientation: landscape) { img { height:100%; } }
@media (orientation: portrait) { img { width:100%; } }
``````

You will always get an image that scales to fit the screen, never loses aspect ratio, never scales larger than the screen, never clips or overflows.

#### Centering

To center your image horizontally and vertically, just use the flex box model. Use a parent `div` set to 100% width and height, like so:

``````div.parent {
display:flex;
position:fixed;
left:0px;
top:0px;
width:100%;
height:100%;
justify-content:center;
align-items:center;
}
``````

With the parent div's `display` set to `flex`, the element is now ready to use the flex box model. The `justify-content` property sets the horizontal alignment of the flex items. The `align-items` property sets the vertical alignment of the flex items.

#### Conclusion

I too had wanted these exact requirements and had scoured the web for a pure CSS solution. Since none of the answers here fulfilled all of your requirements, either with workarounds or settling upon sacrificing a requirement or two, this solution really is the most straightforward for your goals; as it fulfills all of your requirements with pure CSS.

EDIT: The accepted answer will only appear to work if your images are large. Try using small images and you will see that they can never be larger than their original size.

### How to solve error: "Clock skew detected"?

One of the reason may be improper date/time of your PC.

In Ubuntu PC to check the date and time using:

``````date
``````

Example, One of the ways to update date and time is:

``````date -s "23 MAR 2017 17:06:00"
``````

### AngularJS: how to enable \$locationProvider.html5Mode with deeplinking

My problem solved with these :

``````<base href="/" />
``````

2- Use this in `app.config`

``````\$locationProvider.html5Mode(true);
``````

### How to change heatmap.2 color range in R?

You could try to create your own color palette using the `RColorBrewer` package

``````my_palette <- colorRampPalette(c("green", "black", "red"))(n = 1000)
``````

and see how this looks like. But I assume in your case only scaling would help if you really want to keep the black in "the middle". You can simply use `my_palette` instead of the `redgreen()`

I recommend that you check out the RColorBrewer package, they have pretty nice in-built palettes, and see interactive website for colorbrewer.

### How to add a vertical Separator?

This is a very simple way of doing it with no functionality and all visual effect,

Use a grid and just simply customise it.

``````<Grid Background="DodgerBlue" Height="250" Width="1" VerticalAlignment="Center" Margin="5,0,5,0"/>
``````

Just another way to do it.

### Python equivalent of D3.js

I've got a good example of automatically generating D3.js network diagrams using Python here: http://brandonrose.org/ner2sna

The cool thing is that you end up with auto-generated HTML and JS and can embed the interactive D3 chart in a notebook with an IFrame

### Using css transform property in jQuery

If you want to use a specific transform function, then all you need to do is include that function in the value. For example:

``````\$('.user-text').css('transform', 'scale(' + ui.value + ')');
``````

Secondly, browser support is getting better, but you'll probably still need to use vendor prefixes like so:

``````\$('.user-text').css({
'-webkit-transform' : 'scale(' + ui.value + ')',
'-moz-transform'    : 'scale(' + ui.value + ')',
'-ms-transform'     : 'scale(' + ui.value + ')',
'-o-transform'      : 'scale(' + ui.value + ')',
'transform'         : 'scale(' + ui.value + ')'
});
``````

jsFiddle with example: http://jsfiddle.net/jehka/230/

### OpenCV C++/Obj-C: Detecting a sheet of paper / Square Detection

This is a recurring subject in Stackoverflow and since I was unable to find a relevant implementation I decided to accept the challenge.

I made some modifications to the squares demo present in OpenCV and the resulting C++ code below is able to detect a sheet of paper in the image:

``````void find_squares(Mat& image, vector<vector<Point> >& squares)
{
// blur will enhance edge detection
Mat blurred(image);
medianBlur(image, blurred, 9);

Mat gray0(blurred.size(), CV_8U), gray;
vector<vector<Point> > contours;

// find squares in every color plane of the image
for (int c = 0; c < 3; c++)
{
int ch[] = {c, 0};
mixChannels(&blurred, 1, &gray0, 1, ch, 1);

// try several threshold levels
const int threshold_level = 2;
for (int l = 0; l < threshold_level; l++)
{
// Use Canny instead of zero threshold level!
if (l == 0)
{
Canny(gray0, gray, 10, 20, 3); //

// Dilate helps to remove potential holes between edge segments
dilate(gray, gray, Mat(), Point(-1,-1));
}
else
{
gray = gray0 >= (l+1) * 255 / threshold_level;
}

// Find contours and store them in a list
findContours(gray, contours, CV_RETR_LIST, CV_CHAIN_APPROX_SIMPLE);

// Test contours
vector<Point> approx;
for (size_t i = 0; i < contours.size(); i++)
{
// approximate contour with accuracy proportional
// to the contour perimeter
approxPolyDP(Mat(contours[i]), approx, arcLength(Mat(contours[i]), true)*0.02, true);

// Note: absolute value of an area is used because
// area may be positive or negative - in accordance with the
// contour orientation
if (approx.size() == 4 &&
fabs(contourArea(Mat(approx))) > 1000 &&
isContourConvex(Mat(approx)))
{
double maxCosine = 0;

for (int j = 2; j < 5; j++)
{
double cosine = fabs(angle(approx[j%4], approx[j-2], approx[j-1]));
maxCosine = MAX(maxCosine, cosine);
}

if (maxCosine < 0.3)
squares.push_back(approx);
}
}
}
}
}
``````

After this procedure is executed, the sheet of paper will be the largest square in `vector<vector<Point> >`:

I'm letting you write the function to find the largest square. ;)

### 'foo' was not declared in this scope c++

In C++, your source files are usually parsed from top to bottom in a single pass, so any variable or function must be declared before they can be used. There are some exceptions to this, like when defining functions inline in a class definition, but that's not the case for your code.

Either move the definition of `integrate` above the one for `getSkewNormal`, or add a forward declaration above `getSkewNormal`:

``````double integrate (double start, double stop, int numSteps, Evaluatable evalObj);
``````

The same applies for `sum`.

### CSS Animation onClick

Try this:

``````<div>
<p onclick="startAnimation()">Start</p><!--O botão para iniciar (start)-->
<div id="animation">Hello!</div> <!--O elemento que você quer animar-->
</div>

<style>
@keyframes animationName {
from {margin-left:-30%;}
}
</style>

<script>
function startAnimation() {
document.getElementById("animation").style.animation = "animationName 2s linear 1";
}
</script>
``````

### Compiling C++ on remote Linux machine - "clock skew detected" warning

Replace the watch battery in your computer. I have seen this error message when the coin looking battery on the motherboard was in need of replacement.

### Create an array or List of all dates between two dates

LINQ:

``````Enumerable.Range(0, 1 + end.Subtract(start).Days)
.ToArray();
``````

For loop:

``````var dates = new List<DateTime>();

for (var dt = start; dt <= end; dt = dt.AddDays(1))
{
}
``````

EDIT: As for padding values with defaults in a time-series, you could enumerate all the dates in the full date-range, and pick the value for a date directly from the series if it exists, or the default otherwise. For example:

``````var paddedSeries = fullDates.ToDictionary(date => date, date => timeSeries.ContainsDate(date)
? timeSeries[date] : defaultValue);
``````

### Specifying width and height as percentages without skewing photo proportions in HTML

Note: it is invalid to provide percentages directly as `<img>` `width` or `height` attribute unless you're using HTML 4.01 (see current spec, obsolete spec and this answer for more details). That being said, browsers will often tolerate such behaviour to support backwards-compatibility.

Those percentage widths in your 2nd example are actually applying to the container your `<img>` is in, and not the image's actual size. Say you have the following markup:

``````<div style="width: 1000px; height: 600px;">
<img src="#" width="50%" height="50%">
</div>
``````

Your resulting image will be 500px wide and 300px tall.

jQuery Resize

If you're trying to reduce an image to 50% of its width, you can do it with a snippet of jQuery:

``````\$( "img" ).each( function() {
var \$img = \$( this );
\$img.width( \$img.width() * .5 );
});
``````

Just make sure you take off any height/width = 50% attributes first.

### UIImage resize (Scale proportion)

This change worked for me:

``````// The size returned by CGImageGetWidth(imgRef) & CGImageGetHeight(imgRef) is incorrect as it doesn't respect the image orientation!
// CGImageRef imgRef = [image CGImage];
// CGFloat width = CGImageGetWidth(imgRef);
// CGFloat height = CGImageGetHeight(imgRef);
//
// This returns the actual width and height of the photo (and hence solves the problem
CGFloat width = image.size.width;
CGFloat height = image.size.height;
CGRect bounds = CGRectMake(0, 0, width, height);
``````

### How do you stretch an image to fill a <div> while keeping the image's aspect-ratio?

If you want to set a max width or height (so that it will not be very large) while keeping the images aspect-ratio, you can do this:

``````img{
object-fit: contain;
max-height: 70px;
}
``````

### Fitting a density curve to a histogram in R

I had the same problem but Dirk's solution didn't seem to work. I was getting this warning messege every time

``````"prob" is not a graphical parameter
``````

I read through `?hist` and found about `freq: a logical vector set TRUE by default.`

the code that worked for me is

``````hist(x,freq=FALSE)
lines(density(x),na.rm=TRUE)
``````

### jQuery - Get Width of Element when Not Visible (Display: None)

Thank you for posting the realWidth function above, it really helped me. Based on "realWidth" function above, I wrote, a CSS reset, (reason described below).

``````function getUnvisibleDimensions(obj) {
if (\$(obj).length == 0) {
return false;
}

var clone = obj.clone();
clone.css({
visibility:'hidden',
width : '',
height: '',
maxWidth : '',
maxHeight: ''
});
\$('body').append(clone);
var width = clone.outerWidth(),
height = clone.outerHeight();
clone.remove();
return {w:width, h:height};
}
``````

"realWidth" gets the width of an existing tag. I tested this with some image tags. The problem was, when the image has given CSS dimension per width (or max-width), you will never get the real dimension of that image. Perhaps, the img has "max-width: 100%", the "realWidth" function clone it and append it to the body. If the original size of the image is bigger than the body, then you get the size of the body and not the real size of that image.

### How to set full calendar to a specific start date when it's initialized for the 1st time?

As per machineAddict's comment, as of version 2 and later, `year, month and day` have been replaced by `defaultDate`, which is a Moment, supporting constructors such as an `ISO 8601` date string or a Unix Epoch.

So e.g. to initialize the calendar with a given date:

``````\$('#calendar').fullCalendar({
defaultDate: moment('2014-09-01'),
...
});
``````

### How to update RecyclerView Adapter Data?

If nothing mentioned in the above comments is working for you. It might mean the problem lies somewhere else.

One place I found the solution was in the way I was setting the list to the adapter. In my activity the list was a instance variable and I was changing it directly when any data changed. Due to it being a reference variable there was something weird going on. So I changed the reference variable to a local one and used another variable to update data and then pass to `addAll()` function mentioned in above answers.

### How to fix a header on scroll

I know Coop has already answered this question, but here is a version which also tracks where in the document the div is, rather than relying on a static value:

http://jsfiddle.net/gxRC9/16/

Javascript

``````var offset = \$( ".sticky-header" ).offset();

\$(window).scroll(function() {

if ( \$('body').scrollTop() > offset.top){
} else {
}

});
``````

CSS

``````.fixed{
position: fixed;
top: 0px;
}
``````

### Java, looping through result set

The problem with your code is :

``````     String  show[]= {rs4.getString(1)};
String actuate[]={rs4.getString(2)};
``````

This will create a new array every time your loop (an not append as you might be assuming) and hence in the end you will have only one element per array.

Here is one more way to solve this :

``````    StringBuilder sids = new StringBuilder ();
StringBuilder lids = new StringBuilder ();

while (rs4.next()) {
sids.append(rs4.getString(1)).append(" ");
lids.append(rs4.getString(2)).append(" ");
}

String show[] = sids.toString().split(" ");
String actuate[] = lids.toString().split(" ");
``````

These arrays will have all the required element.

### How can I check if my Element ID has focus?

If you want to use jquery `\$("..").is(":focus")`.

You can take a look at this stack

### How to convert php array to utf8?

A more general function to encode an array is:

``````/**
* also for multidemensional arrays
*
* @param array \$array
* @param string \$sourceEncoding
* @param string \$destinationEncoding
*
* @return array
*/
function encodeArray(array \$array, string \$sourceEncoding, string \$destinationEncoding = 'UTF-8'): array
{
if(\$sourceEncoding === \$destinationEncoding){
return \$array;
}

array_walk_recursive(\$array,
function(&\$array) use (\$sourceEncoding, \$destinationEncoding) {
\$array = mb_convert_encoding(\$array, \$destinationEncoding, \$sourceEncoding);
}
);

return \$array;
}
``````

### How to get week number in Python?

`datetime.date` has a `isocalendar()` method, which returns a tuple containing the calendar week:

``````>>> import datetime
>>> datetime.date(2010, 6, 16).isocalendar()[1]
24
``````

datetime.date.isocalendar() is an instance-method returning a tuple containing year, weeknumber and weekday in respective order for the given date instance.

### Query to list all stored procedures

Unfortunately `INFORMATION_SCHEMA` doesn't contain info about the system procs.

``````SELECT *
FROM sys.objects
WHERE objectproperty(object_id, N'IsMSShipped') = 0
AND objectproperty(object_id, N'IsProcedure') = 1
``````

### What does -save-dev mean in npm install grunt --save-dev

To add on to Andreas' answer, you can install only the dependencies by using:

``````npm install --production
``````

### JUnit tests pass in Eclipse but fail in Maven Surefire

Usually when tests pass in eclipse and fail with maven it is a classpath issue because it is the main difference between the two.

So you can check the classpath with maven -X test and check the classpath of eclipse via the menus or in the .classpath file in the root of your project.

Are you sure for example that personservice-test.xml is in the classpath ?

### How do I see which version of Swift I'm using?

Bonus contribution: I'm using a custom node.js script to extract a clean string for use with Jazzy documentation. You might get some use of this if you can find a place to work it into your dev process:

Invoked from a Bash script:

``````#!/bin/bash
swiftversion=\$(node SwiftVerSlicer.js "\${xcrun swift -version}");
echo \$swiftversion
``````

SwiftVerSlicer.js:

``````// begin script
const inputString = `\${process.argv[2]}`
let searchTerm = (inputString.indexOf('(') - 1)//-1 cause whitespace
let version = inputString.slice(0,searchTerm)
console.log(version)
// end script
``````

You can also use regex of course, but do whatever you like :]

### Combine two tables for one output

You'll need to use `UNION` to combine the results of two queries. In your case:

``````SELECT ChargeNum, CategoryID, SUM(Hours)
FROM KnownHours
GROUP BY ChargeNum, CategoryID
UNION ALL
SELECT ChargeNum, 'Unknown' AS CategoryID, SUM(Hours)
FROM UnknownHours
GROUP BY ChargeNum
``````

Note - If you use `UNION ALL` as in above, it's no slower than running the two queries separately as it does no duplicate-checking.

### how to remove untracked files in Git?

The command for your rescue is `git clean`.

### TypeError: 'list' object cannot be interpreted as an integer

remove the `range`.

``````for i in myList
``````

range takes in an integer. you want for each element in the list.

### What does the @ symbol before a variable name mean in C#?

An important point that the other answers forgot, is that "@keyword" is compiled into "keyword" in the CIL.

So if you have a framework that was made in, say, F#, which requires you to define a class with a property named "class", you can actually do it.

It is not that useful in practice, but not having it would prevent C# from some forms of language interop.

I usually see it used not for interop, but to avoid the keyword restrictions (usually on local variable names, where this is the only effect) ie.

``````private void Foo(){
int @this = 2;
}
``````

but I would strongly discourage that! Just find another name, even if the 'best' name for the variable is one of the reserved names.

### How to check type of object in Python?

use `isinstance(v, type_name)` or `type(v) is type_name` or `type(v) == type_name`,

where type_name can be one of the following:

• None
• bool
• int
• float
• complex
• str
• list
• tuple
• set
• dict

and, of course,

• custom types (classes)

### jQuery: get parent tr for selected radio button

Try this.

You don't need to prefix attribute name by `@` in jQuery selector. Use `closest()` method to get the closest parent element matching the selector.

``````\$("#MwDataList input[name=selectRadioGroup]:checked").closest('tr');
``````

You can simplify your method like this

``````function getSelectedRowGuid() {
return GetRowGuid(
}
``````

`closest()` - Gets the first element that matches the selector, beginning at the current element and progressing up through the DOM tree.

As a side note, the ids of the elements should be unique on the page so try to avoid having same ids for radio buttons which I can see in your markup. If you are not going to use the ids then just remove it from the markup.

### Using NULL in C++?

From crtdbg.h (and many other headers):

``````#ifndef NULL
#ifdef __cplusplus
#define NULL    0
#else
#define NULL    ((void *)0)
#endif
#endif
``````

Therefore `NULL` is `0`, at least on the Windows platform. So no, not that I know of.

### Xcode 6: Keyboard does not show up in simulator

This seems to be a bug in iOS 8. There are two fixes to this problem :

1. Toggle between simulator keyboard and MacBook keyboard using the Command+K shortcut.

2. Reattach keyboard to simulator :

a. Open Simulator

b. Select Hardware -> Keyboard

c. Uncheck and then check 'Connect Hardware Keyboard'

OR simply press the Shift + Command + K shortcut

### Java Array, Finding Duplicates

To check for duplicates you need to compare distinct pairs.

### Forbidden You don't have permission to access /wp-login.php on this server

The solution is to add this to the beginning of your .htaccess

``````<Files wp-login.php>
Order Deny,Allow
Deny from all
Allow from all
</Files>
``````

It's because many hosts were under attack, using the wordpress from their clients.

### How to add a new row to datagridview programmatically

I have found this useful more than once when the DataGrid is bound to a table.

``````        DataTable dt = (DataTable)dgvData.DataSource;
DataRow row = dt.NewRow();
foreach (var something in something)
{
row["ColumnName"] = something ;
}
dgvData.DataSource = dt;
``````

### Login to remote site with PHP cURL

Panama Jack Example not work for me - Give Fatal error: Call to undefined function build_unique_path(). I used this code - (more simple - my opinion) :

``// options\$login_email = '[email protected]';\$login_pass = 'alabala4807';\$cookie_file_path = "/tmp/cookies.txt";\$LOGINURL = "http://alabala.com/index.php?route=account/login"; \$agent = "Nokia-Communicator-WWW-Browser/2.0 (Geos 3.0 Nokia-9000i)";// begin script\$ch = curl_init();// extra headers\$headers[] = "Accept: */*";\$headers[] = "Connection: Keep-Alive";// basic curl options for all requestscurl_setopt(\$ch, CURLOPT_HTTPHEADER,  \$headers);curl_setopt(\$ch, CURLOPT_HEADER,  0);curl_setopt(\$ch, CURLOPT_SSL_VERIFYHOST, 0);curl_setopt(\$ch, CURLOPT_SSL_VERIFYPEER, false);         curl_setopt(\$ch, CURLOPT_USERAGENT, \$agent); curl_setopt(\$ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt(\$ch, CURLOPT_FOLLOWLOCATION, 1); curl_setopt(\$ch, CURLOPT_COOKIEFILE, \$cookie_file_path); curl_setopt(\$ch, CURLOPT_COOKIEJAR, \$cookie_file_path); // set first URLcurl_setopt(\$ch, CURLOPT_URL, \$LOGINURL);// execute session to get cookies and required form inputs\$content = curl_exec(\$ch); // grab the hidden inputs from the form required to login\$fields = getFormFields(\$content);\$fields['email'] = \$login_email;\$fields['password'] = \$login_pass;// set postfields using what we extracted from the form\$POSTFIELDS = http_build_query(\$fields); // change URL to login URLcurl_setopt(\$ch, CURLOPT_URL, \$LOGINURL); // set post optionscurl_setopt(\$ch, CURLOPT_POST, 1); curl_setopt(\$ch, CURLOPT_POSTFIELDS, \$POSTFIELDS); // perform login\$result = curl_exec(\$ch);  print \$result; function getFormFields(\$data){    if (preg_match('/()/is', \$data, \$matches)) {      \$inputs = getInputs(\$matches[1]);      return \$inputs;    } else {      die('didnt find login form');     }}function getInputs(\$form){    \$inputs = array();    \$elements = preg_match_all("/(]+>)/is", \$form, \$matches);    if (\$elements > 0) {        for(\$i = 0;\$i            \$el = preg_replace('/\s{2,}/', ' ', \$matches[1][\$i]);            if (preg_match('/name=(?:["\'])?([^"\'\s]*)/i', \$el, \$name)) {                \$name  = \$name[1];                \$value = '';                if (preg_match('/value=(?:["\'])?([^"\'\s]*)/i', \$el, \$value)) {                    \$value = \$value[1];                }                \$inputs[\$name] = \$value;            }        }    }    return \$inputs;}\$grab_url='http://grab.url/alabala';//page with the content I want to grabcurl_setopt(\$ch, CURLOPT_URL, \$grab_url);//do stuff with the info with DomDocument() etc\$html = curl_exec(\$ch);curl_close(\$ch);var_dump(\$html); die;``

### Replace X-axis with own values

Yo could also set `labels = FALSE` inside `axis(...)` and print the labels in a separate command with Text. With this option you can rotate the text the text in case you need it

``````lablist<-as.vector(c(1:10))
axis(1, at=seq(1, 10, by=1), labels = FALSE)
text(seq(1, 10, by=1), par("usr")[3] - 0.2, labels = lablist, srt = 45, pos = 1, xpd = TRUE)
``````

Detailed explanation here

### How to convert ‘false’ to 0 and ‘true’ to 1 in Python

Any of the following will work:

``````s = "true"

(s == 'true').real
1

(s == 'false').real
0

(s == 'true').conjugate()
1

(s == '').conjugate()
0

(s == 'true').__int__()
1

(s == 'opal').__int__()
0

def as_int(s):
return (s == 'true').__int__()

>>>> as_int('false')
0
>>>> as_int('true')
1
``````

### How to decode a Base64 string?

I had issues with spaces showing in between my output and there was no answer online at all to fix this issue. I literally spend many hours trying to find a solution and found one from playing around with the code to the point that I almost did not even know what I typed in at the time that I got it to work. Here is my fix for the issue: `[System.Text.Encoding]::UTF8.GetString(([System.Convert]::FromBase64String(\$base64string)|?{\$_}))`

### convert an enum to another type of enum

I wrote this answer because I believe there are fundamental issues with the majority of answers already provided, and the ones that are acceptable are incomplete.

Mapping by enum integer value

This approach is bad simply because it assumes that the integer values of both `MyGender` and `TheirGender` will always remain comparable. In practice, it is very rare that you can guarantee this even within a single project, let alone a separate service.

The approach we take should be something that can be used for other enum-mapping cases. We should never assume that one enum identically relates to another - especially when we may not have control over one or another.

Mapping by enum string value

This is a little better, as `MyGender.Male` will still convert to `TheirGender.Male` even if the integer representation is changed, but still not ideal.

I would discourage this approach as it assumes the name values will not change, and will always remain identical. Considering future enhancements, you cannot guarantee that this will be the case; consider if `MyGender.NotKnown` was added. It is likely that you would want this to map to `TheirGender.Unknown`, but this would not be supported.

Also, it is generally bad to assume that one enum equates to another by name, as this might not be the case in some contexts. As mentioned earlier, an ideal approach would work for other enum-mapping requirements.

Explicitly mapping enums

This approach explictly maps `MyGender` to `TheirGender` using a switch statement.

This is better as:

• Covers the case where the underlying integer value changes.
• Covers the case where the enum names changes (i.e. no assumptions - the developer will need to update the code to handle the scenario - good).
• Handles cases where enum values cannot be mapped.
• Handles cases where new enum values are added and cannot be mapped by default (again, no assumptions made - good).
• Can easily be updated to support new enum values for either `MyGender` or `TheirGender`.
• The same approach can be taken for all enum mapping requirements.

Assuming we have the following enums:

``````public enum MyGender
{
Male = 0,
Female = 1,
}

public enum TheirGender
{
Male = 0,
Female = 1,
Unknown = 2,
}
``````

We can create the following function to "convert from their enum to mine":

``````public MyGender GetMyGender(TheirGender theirGender)
{
switch (theirGender)
{
case TheirGender.Male:
return MyGender.Male;

case TheirGender.Female:
return MyGender.Female;

default:
throw new InvalidEnumArgumentException(nameof(theirGender), (int)theirGender, typeof(TheirGender));
}
}
``````

A previous answer suggested returning a nullable enum (`TheirGender?`) and returning null for any unmatched input. This is bad; null is not the same as an unknown mapping. If the input cannot be mapped, an exception should be thrown, else the method should be named more explictly to the behaviour:

``````public TheirGender? GetTheirGenderOrDefault(MyGender myGender)
{
switch (myGender)
{
case MyGender.Male:
return TheirGender.Male;

case MyGender.Female:
return TheirGender.Female;

default:
return default(TheirGender?);
}
}
``````

If it is likely that this method will be required more than once in various parts of the solution, you could consider creating an extension method for this:

``````public static class TheirGenderExtensions
{
public static MyGender GetMyGender(this TheirGender theirGender)
{
switch (theirGender)
{
case TheirGender.Male:
return MyGender.Male;

case TheirGender.Female:
return MyGender.Female;

default:
throw new InvalidEnumArgumentException(nameof(theirGender), (int)theirGender, typeof(TheirGender));
}
}
}
``````

If you are using C#8, you can use the syntax for switch expressions and expression bodies to neaten up the code:

``````public static class TheirGenderExtensions
{
public static MyGender GetMyGender(this TheirGender theirGender)
=> theirGender switch
{
TheirGender.Male => MyGender.Male,
TheirGender.Female => MyGender.Female,
_ => throw new InvalidEnumArgumentException(nameof(theirGender), (int)theirGender, typeof(TheirGender))
};
}
``````

If you will only ever be mapping the enums within a single class, then an extension method may be overkill. In this case, the method can be declared within the class itself.

Furthermore, if the mapping will only ever take place within a single method, then you can declare this as a local function:

``````public static void Main()
{
Console.WriteLine(GetMyGender(TheirGender.Male));
Console.WriteLine(GetMyGender(TheirGender.Female));
Console.WriteLine(GetMyGender(TheirGender.Unknown));

static MyGender GetMyGender(TheirGender theirGender)
=> theirGender switch
{
TheirGender.Male => MyGender.Male,
TheirGender.Female => MyGender.Female,
_ => throw new InvalidEnumArgumentException(nameof(theirGender), (int)theirGender, typeof(TheirGender))
};
}
``````

tl;dr:

Do not:

• Map enums by integer value
• Map enums by name

Do:

• Map enums explicitly using a switch statement
• Throw an exception when a value cannot be mapped rather than returning null
• Consider using extension methods

### How to enable DataGridView sorting when user clicks on the column header?

KISS : Keep it simple, stupid

Way A: Implement an own SortableBindingList class when like to use DataBinding and sorting.

Way B: Use a List<string> sorting works also but does not work with DataBinding.

### Pylint "unresolved import" error in Visual Studio Code

I solved the problem with command-line python. I installed modules with vs code terminal in project path, but when import the module on windows command line python, that throws an error as this module not defined so I install these modules from the command line and my problem solved.

### Get text of label with jquery

Try this

``````var g = \$('#<%=Label1.ClientID%>').text();
``````

### How can I install the VS2017 version of msbuild on a build server without installing the IDE?

The Visual Studio Build tools are a different download than the IDE. They appear to be a pretty small subset, and they're called Build Tools for Visual Studio 2019 (download).

You can use the GUI to do the installation, or you can script the installation of msbuild:

``````vs_buildtools.exe --add Microsoft.VisualStudio.Workload.MSBuildTools --quiet
``````

Microsoft.VisualStudio.Workload.MSBuildTools is a "wrapper" ID for the three subcomponents you need:

• Microsoft.Component.MSBuild
• Microsoft.VisualStudio.Component.CoreBuildTools
• Microsoft.VisualStudio.Component.Roslyn.Compiler

You can find documentation about the other available CLI switches here.

The build tools installation is much quicker than the full IDE. In my test, it took 5-10 seconds. With `--quiet` there is no progress indicator other than a brief cursor change. If the installation was successful, you should be able to see the build tools in `%programfiles(x86)%\Microsoft Visual Studio\2019\BuildTools\MSBuild\Current\Bin`.

If you don't see them there, try running without `--quiet` to see any error messages that may occur during installation.

### CSS text-align not working

I try to avoid floating elements unless the design really needs it. Because you have floated the `<li>` they are out of normal flow.

If you add `.navigation { text-align:center; }` and change `.navigation li { float: left; }` to `.navigation li { display: inline-block; }` then entire navigation will be centred.

One caveat to this approach is that `display: inline-block;` is not supported in IE6 and needs a workaround to make it work in IE7.

### PostgreSQL - SQL state: 42601 syntax error

Your function would work like this:

``````CREATE OR REPLACE FUNCTION prc_tst_bulk(sql text)
RETURNS TABLE (name text, rowcount integer) AS
\$\$
BEGIN

RETURN QUERY EXECUTE '
WITH v_tb_person AS (' || sql || \$x\$)
SELECT name, count(*)::int FROM v_tb_person WHERE nome LIKE '%a%' GROUP BY name
UNION
SELECT name, count(*)::int FROM v_tb_person WHERE gender = 1 GROUP BY name\$x\$;

END
\$\$ LANGUAGE plpgsql;
``````

Call:

``````SELECT * FROM prc_tst_bulk(\$\$SELECT a AS name, b AS nome, c AS gender FROM tbl\$\$)
``````
• You cannot mix plain and dynamic SQL the way you tried to do it. The whole statement is either all dynamic or all plain SQL. So I am building one dynamic statement to make this work. You may be interested in the chapter about executing dynamic commands in the manual.

• The aggregate function `count()` returns `bigint`, but you had `rowcount` defined as `integer`, so you need an explicit cast `::int` to make this work

• I use dollar quoting to avoid quoting hell.

However, is this supposed to be a honeypot for SQL injection attacks or are you seriously going to use it? For your very private and secure use, it might be ok-ish - though I wouldn't even trust myself with a function like that. If there is any possible access for untrusted users, such a function is a loaded footgun. It's impossible to make this secure.

Craig (a sworn enemy of SQL injection!) might get a light stroke, when he sees what you forged from his piece of code in the answer to your preceding question. :)

The query itself seems rather odd, btw. But that's beside the point here.

### Reverting single file in SVN to a particular revision

If you want to roll back an individual file from a specific revision and be able to commit, then do:

svn merge -c -[OldRev#] [Filename]

ie. `svn merge -c -150 myfile.py`

Note the negative on the revision number

### Count the number of occurrences of a character in a string in Javascript

Easiest way i found out...

Example-

``````str = 'mississippi';

function find_occurences(str, char_to_count){
return str.split(char_to_count).length - 1;
}

find_occurences(str, 'i') //outputs 4
``````

### Group a list of objects by an attribute

you can use `guava`'s `Multimaps`

``````@Canonical
class Persion {
String name
Integer age
}
List<Persion> list = [
new Persion("qianzi", 100),
new Persion("qianzi", 99),
new Persion("zhijia", 99)
]
println Multimaps.index(list, { Persion p -> return p.name })
``````

it print:

[qianzi:[com.ctcf.message.Persion(qianzi, 100),com.ctcf.message.Persion(qianzi, 88)],zhijia:[com.ctcf.message.Persion(zhijia, 99)]]

### How can I set / change DNS using the command-prompt at windows 8

First, the network name is likely "Ethernet", not "Local Area Connection". To find out the name you can do this:

``````netsh interface show interface
``````

Which will show the name under the "Interface Name" column (shown here in bold):

```Admin State    State          Type             Interface Name
-------------------------------------------------------------------------
Enabled        Connected      Dedicated        Ethernet
```

Now you can change the primary dns (index=1), assuming that your interface is static (not using dhcp):

``````netsh interface ipv4 add dnsserver "Ethernet" address=192.168.x.x index=1
``````

2018 Update - The command will work with either `dnsserver` (singular) or `dnsservers` (plural). The following example uses the latter and is valid as well:

```netsh interface ipv4 add dnsservers "Ethernet" address=192.168.x.x index=1
```

### Print Combining Strings and Numbers

Using print function without parentheses works with older versions of Python but is no longer supported on Python3, so you have to put the arguments inside parentheses. However, there are workarounds, as mentioned in the answers to this question. Since the support for Python2 has ended in Jan 1st 2020, the answer has been modified to be compatible with Python3.

You could do any of these (and there may be other ways):

``````(1)  print("First number is {} and second number is {}".format(first, second))
(1b) print("First number is {first} and number is {second}".format(first=first, second=second))
``````

or

``````(2) print('First number is', first, 'second number is', second)
``````

(Note: A space will be automatically added afterwards when separated from a comma)

or

``````(3) print('First number %d and second number is %d' % (first, second))
``````

or

``````(4) print('First number is ' + str(first) + ' second number is' + str(second))

``````

Using format() (1/1b) is preferred where available.

### How to make a simple image upload using Javascript/HTML

``````\$('#multi_file_upload').change(function(e) {
var file_id = e.target.id;

var file_name_arr = new Array();
var process_path = site_url + 'public/uploads/';

for (i = 0; i < \$("#" + file_id).prop("files").length; i++) {

var form_data = new FormData();
var file_data = \$("#" + file_id).prop("files")[i];
form_data.append("file_name", file_data);

if (check_multifile_logo(\$("#" + file_id).prop("files")[i]['name'])) {
\$.ajax({
cache: false,
contentType: false,
processData: false,
async: false,
data: form_data,
type: 'post',
success: function(data) {
// display image
}
});
} else {
\$("#" + html_div).html('');
alert('We only accept JPG, JPEG, PNG, GIF and BMP files');
}

}
});

function check_multifile_logo(file) {
var extension = file.substr((file.lastIndexOf('.') + 1))
if (extension === 'jpg' || extension === 'jpeg' || extension === 'gif' || extension === 'png' || extension === 'bmp') {
return true;
} else {
return false;
}
}
``````

### Decompile .smali files on an APK

dex2jar helps to decompile your apk but not 100%. You will have some problems with .smali files. Dex2jar cannot convert it to java. I know one application that can decompile your apk source files and no problems with .smali files. Here is a link http://www.hensence.com/en/smali2java/

### MySQL WHERE IN ()

You have wrong database design and you should take a time to read something about database normalization (wikipedia / stackoverflow).

I assume your table looks somewhat like this

``````TABLE
================================
| group_id | user_ids | name   |
--------------------------------
| 1        | 1,4,6    | group1 |
--------------------------------
| 2        | 4,5,1    | group2 |
``````

so in your table of user groups, each row represents one group and in `user_ids` column you have set of user ids assigned to that group.

Normalized version of this table would look like this

``````GROUP
=====================
| id       | name   |
---------------------
| 1        | group1 |
---------------------
| 2        | group2 |

GROUP_USER_ASSIGNMENT
======================
| group_id | user_id |
----------------------
| 1        | 1       |
----------------------
| 1        | 4       |
----------------------
| 1        | 6       |
----------------------
| 2        | 4       |
----------------------
| ...
``````

Then you can easily select all users with assigned group, or all users in group, or all groups of user, or whatever you can think of. Also, your sql query will work:

``````/* Your query to select assignments */
SELECT * FROM `group_user_assignment` WHERE user_id IN (1,2,3,4);

/* Select only some users */
SELECT * FROM `group_user_assignment` t1
JOIN `group` t2 ON t2.id = t1.group_id
WHERE user_id IN (1,4);

/* Select all groups of user */
SELECT * FROM `group_user_assignment` t1
JOIN `group` t2 ON t2.id = t1.group_id
WHERE t1.`user_id` = 1;

/* Select all users of group */
SELECT * FROM `group_user_assignment` t1
JOIN `group` t2 ON t2.id = t1.group_id
WHERE t1.`group_id` = 1;

/* Count number of groups user is in */
SELECT COUNT(*) AS `groups_count` FROM `group_user_assignment` WHERE `user_id` = 1;

/* Count number of users in group */
SELECT COUNT(*) AS `users_count` FROM `group_user_assignment` WHERE `group_id` = 1;
``````

This way it will be also easier to update database, when you would like to add new assignment, you just simply insert new row in `group_user_assignment`, when you want to remove assignment you just delete row in `group_user_assignment`.

In your database design, to update assignments, you would have to get your assignment set from database, process it and update and then write back to database.

Here is sqlFiddle to play with.

### What primitive data type is time_t?

It's platform-specific. But you can cast it to a known type.

``````printf("%lld\n", (long long) time(NULL));
``````

### How do I write a bash script to restart a process if it dies?

#### In-line:

``````while true; do <your-bash-snippet> && break; done

``````

#### e.g.

``````while true; do openconnect x.x.x.x:xxxx && break; done

``````

### How to disable EditText in Android

Set `inputType` attribute to none in your layout.xml file under EditText

### Python matplotlib multiple bars

I know that this is about `matplotlib`, but using `pandas` and `seaborn` can save you a lot of time:

``````df = pd.DataFrame(zip(x*3, ["y"]*3+["z"]*3+["k"]*3, y+z+k), columns=["time", "kind", "data"])
plt.figure(figsize=(10, 6))
sns.barplot(x="time", hue="kind", y="data", data=df)
plt.show()
``````

### JavaScript - Get Browser Height

You can use the `window.innerHeight`

### Get Time from Getdate()

If it's SQL Server 2005 there is no `TIME` datatype. The easiest way to get only the time component is to set the date to 1/1/1900.

``````DECLARE @time DATETIME

SET @Time = GETDATE()

``````

### Get DateTime.Now with milliseconds precision

This should work:

``````DateTime.Now.ToString("hh.mm.ss.ffffff");
``````

If you don't need it to be displayed and just need to know the time difference, well don't convert it to a String. Just leave it as, `DateTime.Now();`

And use `TimeSpan` to know the difference between time intervals:

Example

``````DateTime start;
TimeSpan time;

start = DateTime.Now;

//Do something here

time = DateTime.Now - start;
label1.Text = String.Format("{0}.{1}", time.Seconds, time.Milliseconds.ToString().PadLeft(3, '0'));
``````

### JavaScript code for getting the selected value from a combo box

There is an unnecessary hashtag; change the code to this:

``````var e = document.getElementById("ticket_category_clone").value;
``````

### Hibernate SessionFactory vs. JPA EntityManagerFactory

EntityManager interface is similar to sessionFactory in hibernate. EntityManager under javax.persistance package but session and sessionFactory under org.hibernate.Session/sessionFactory package.

Entity manager is JPA specific and session/sessionFactory are hibernate specific.

### Use of Greater Than Symbol in XML

You need the Character Entity References

`< = &lt;`

`> = &gt;`

Add all event listeners when a window loads.Works like a charm no matter where you put script tags.

``````window.addEventListener("load", startup);

function startup() {

}

myFunc(){}
``````

### Concatenating two one-dimensional NumPy arrays

The first parameter to `concatenate` should itself be a sequence of arrays to concatenate:

``````numpy.concatenate((a,b)) # Note the extra parentheses.
``````

### Best database field type for a URL

`VARCHAR(512)` (or similar) should be sufficient. However, since you don't really know the maximum length of the URLs in question, I might just go direct to `TEXT`. The danger with this is of course loss of efficiency due to `CLOB`s being far slower than a simple string datatype like `VARCHAR`.

### What is the convention for word separator in Java package names?

Anyone can use underscore _ (its Okay)

No one should use hypen - (its Bad practice)

No one should use capital letters inside package names (Bad practice)

NOTE: Here "Bad Practice" is meant for technically you are allowed to use that, but conventionally its not in good manners to write.

### Storing a Key Value Array into a compact JSON string

So why don't you simply use a key-value literal?

``````var params = {
'slide0002.html': 'Forecase',
...
};

return params['slide0001.html']; // returns: Looking Ahead
``````

### Could not load file or assembly 'CrystalDecisions.ReportAppServer.CommLayer, Version=13.0.2000.0

``````For visual studio 2019
change the code in aspx.cs page

<%@ Register Assembly="CrystalDecisions.Web, Version=13.0.4000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"
Namespace="CrystalDecisions.Web" TagPrefix="CR" %>

in web config:

<configSections>
<sectionGroup name="crystalReports">
<section name="rptBuildProvider" type="CrystalDecisions.Shared.RptBuildProviderHandler, CrystalDecisions.Shared, Version=13.0.4000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, Custom=null"/>
</sectionGroup>
</sectionGroup>
</configSections>

<assemblies>
</assemblies>

<buildProviders>
<add extension=".rpt" type="CrystalDecisions.Web.Compilation.RptBuildProvider, CrystalDecisions.Web, Version=13.0.4000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
<add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.WebForms, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
</buildProviders>
``````

### Using Oracle to_date function for date string with milliseconds

TO_DATE supports conversion to DATE datatype, which doesn't support milliseconds. If you want millisecond support in Oracle, you should look at TIMESTAMP datatype and TO_TIMESTAMP function.

Hope that helps.

### Change line width of lines in matplotlib pyplot legend

@ImportanceOfBeingErnest 's answer is good if you only want to change the linewidth inside the legend box. But I think it is a bit more complex since you have to copy the handles before changing legend linewidth. Besides, it can not change the legend label fontsize. The following two methods can not only change the linewidth but also the legend label text font size in a more concise way.

#### Method 1

``````import numpy as np
import matplotlib.pyplot as plt

# make some data
x = np.linspace(0, 2*np.pi)

y1 = np.sin(x)
y2 = np.cos(x)

# plot sin(x) and cos(x)
fig = plt.figure()
ax.plot(x, y1, c='b', label='y1')
ax.plot(x, y2, c='r', label='y2')

leg = plt.legend()
# get the individual lines inside legend and set line width
for line in leg.get_lines():
line.set_linewidth(4)
# get label texts inside legend and set font size
for text in leg.get_texts():
text.set_fontsize('x-large')

plt.savefig('leg_example')
plt.show()
``````

#### Method 2

``````import numpy as np
import matplotlib.pyplot as plt

# make some data
x = np.linspace(0, 2*np.pi)

y1 = np.sin(x)
y2 = np.cos(x)

# plot sin(x) and cos(x)
fig = plt.figure()
ax.plot(x, y1, c='b', label='y1')
ax.plot(x, y2, c='r', label='y2')

leg = plt.legend()
# get the lines and texts inside legend box
leg_lines = leg.get_lines()
leg_texts = leg.get_texts()
# bulk-set the properties of all lines and texts
plt.setp(leg_lines, linewidth=4)
plt.setp(leg_texts, fontsize='x-large')
plt.savefig('leg_example')
plt.show()
``````

The above two methods produce the same output image:

### How to create .ipa file using Xcode?

Archive process (using Xcode 8.3.2)

Note : If you are using creating IPA using drag-and-drop process using iTunes Mac app then this is no longer applicable for iTunes 12.7 since there is no built-in App store in iTunes 12.7.

1. Select `‘Generic iOS Device`’ on device list in Xcode

1. Clean the project (`cmd + shift + k` as shortcut)

1. Go to `Product` -> `Archive` your project

1. Once archive is succeeded this will open a window with archived project

2. You can validate your archive by pressing `Validate` (optional step but recommended)

3. Now press on `Export` button

1. This will open list of method for export. Select the export method as per your requirement and click on `Next` button.

1. This will show `list of team for provisioning`. Select accordingly and press on ‘`Choose`’ button.

1. Now you’ve to select Device support -> `Export one app for all compatible devices` (recommended). If you want IPA for specific device then select the device variant from list and press on ‘`Next`’ button.

1. Now you’ll be able to see the ‘`Summary`’ and then press on ‘`Next`’ button

1. Thereafter IPA file generation beings and later you’ll be able to `export the IPA as [App Name - Date Time]` and then press on ‘`Done`’.

### Eclipse Error: "Failed to connect to remote VM"

Create setenv.bat file in nib folder of Tomcat. Add SET JPDA_ADDRESS = 8787 ; Override the jpda port Open cmd, go to bin folder of Tomcat and Start tomcat using catalina jpda start Set up a debug point on eclipse Next compile your project. Check localhost:8080/ Deploy the war or jar under webapps folder and this must deploy war on Tomcat. Then send the request. the debug point will get hit NOTE : Don't edit catalina.bat file. make changes in setenv.bat file

### How do I get the time of day in javascript/Node.js?

This function will return you the date and time in the following format: `YYYY:MM:DD:HH:MM:SS`. It also works in Node.js.

``````function getDateTime() {

var date = new Date();

var hour = date.getHours();
hour = (hour < 10 ? "0" : "") + hour;

var min  = date.getMinutes();
min = (min < 10 ? "0" : "") + min;

var sec  = date.getSeconds();
sec = (sec < 10 ? "0" : "") + sec;

var year = date.getFullYear();

var month = date.getMonth() + 1;
month = (month < 10 ? "0" : "") + month;

var day  = date.getDate();
day = (day < 10 ? "0" : "") + day;

return year + ":" + month + ":" + day + ":" + hour + ":" + min + ":" + sec;

}
``````

### Getter and Setter?

If you preffer to use the __call function, you can use this method. It works with

• GET => `\$this->property()`
• SET => `\$this->property(\$value)`
• GET => `\$this->getProperty()`
• SET => `\$this->setProperty(\$value)`

kalsdas

``````public function __call(\$name, \$arguments) {

//Getting and setting with \$this->property(\$optional);

if (property_exists(get_class(\$this), \$name)) {

//Always set the value if a parameter is passed
if (count(\$arguments) == 1) {
/* set */
\$this->\$name = \$arguments[0];
} else if (count(\$arguments) > 1) {
throw new \Exception("Setter for \$name only accepts one parameter.");
}

//Always return the value (Even on the set)
return \$this->\$name;
}

//If it doesn't chech if its a normal old type setter ot getter
//Getting and setting with \$this->getProperty(\$optional);
//Getting and setting with \$this->setProperty(\$optional);
\$prefix = substr(\$name, 0, 3);
\$property = strtolower(\$name[3]) . substr(\$name, 4);
switch (\$prefix) {
case 'get':
return \$this->\$property;
break;
case 'set':
//Always set the value if a parameter is passed
if (count(\$arguments) != 1) {
throw new \Exception("Setter for \$name requires exactly one parameter.");
}
\$this->\$property = \$arguments[0];
//Always return the value (Even on the set)
return \$this->\$name;
default:
throw new \Exception("Property \$name doesn't exist.");
break;
}
}
``````

### Cannot deserialize instance of object out of START_ARRAY token in Spring Webservice

Your json contains an array, but you're trying to parse it as an object. This error occurs because objects must start with `{`.

You have 2 options:

1. You can get rid of the `ShopContainer` class and use `Shop[]` instead

``````ShopContainer response  = restTemplate.getForObject(
url, ShopContainer.class);
``````

replace with

``````Shop[] response  = restTemplate.getForObject(url, Shop[].class);
``````

and then make your desired object from it.

2. You can change your server to return an object instead of a list

``````return mapper.writerWithDefaultPrettyPrinter().writeValueAsString(list);
``````

replace with

``````return mapper.writerWithDefaultPrettyPrinter().writeValueAsString(
new ShopContainer(list));
``````

### Check if string doesn't contain another string

``````WHERE NOT (someColumn LIKE '%Apples%')
``````

### how to install tensorflow on anaconda python 3.6

UPDATE: TensorFlow supports Python 3.6 on Windows since version 1.2.0 (see the release notes)

TensorFlow only supports Python 3.5 64-bit as of now. Support for Python 3.6 is a work in progress and you can track it here as well as chime in the discussion.

The only alternative to use Python 3.6 with TensorFlow on Windows currently is building TF from source.

If you don't want to uninstall your Anaconda distribution for Python 3.6 and install a previous release you can create a conda environment for Python=3.5 as in: ``` conda create --name tensorflow python=3.5 activate tensorflow pip install tensorflow-gpu ```

### PHP to write Tab Characters inside a file?

Use `\t` and enclose the string with double-quotes:

``````\$chunk = "abc\tdef\tghi";
``````

### How to compile without warnings being treated as errors?

Solution:

``````CFLAGS=-Wno-error ./configure
``````

### Sorting by date & time in descending order?

This is one of the simplest ways to sort record by Date:

``````SELECT  `Article_Id` ,  `Title` ,  `Source_Link` ,  `Content` ,  `Source` , `Reg_Date`, UNIX_TIMESTAMP(  `Reg_Date` ) AS DATE
FROM article
ORDER BY DATE DESC
``````

### How to run function in AngularJS controller on document ready?

``````\$scope.\$on('\$ViewData', function(event) {
});
``````

### How to set the min and max height or width of a Frame?

There is no single magic function to force a frame to a minimum or fixed size. However, you can certainly force the size of a frame by giving the frame a width and height. You then have to do potentially two more things: when you put this window in a container you need to make sure the geometry manager doesn't shrink or expand the window. Two, if the frame is a container for other widget, turn grid or pack propagation off so that the frame doesn't shrink or expand to fit its own contents.

Note, however, that this won't prevent you from resizing a window to be smaller than an internal frame. In that case the frame will just be clipped.

``````import Tkinter as tk

root = tk.Tk()
frame1 = tk.Frame(root, width=100, height=100, background="bisque")
frame2 = tk.Frame(root, width=50, height = 50, background="#b22222")

frame1.pack(fill=None, expand=False)
frame2.place(relx=.5, rely=.5, anchor="c")

root.mainloop()
``````

### How to obtain the start time and end time of a day?

``````private Date getStartOfDay(Date date) {
Calendar calendar = Calendar.getInstance();
int year = calendar.get(Calendar.YEAR);
int month = calendar.get(Calendar.MONTH);
int day = calendar.get(Calendar.DATE);
calendar.setTimeInMillis(0);
calendar.set(year, month, day, 0, 0, 0);
return calendar.getTime();
}

private Date getEndOfDay(Date date) {
Calendar calendar = Calendar.getInstance();
int year = calendar.get(Calendar.YEAR);
int month = calendar.get(Calendar.MONTH);
int day = calendar.get(Calendar.DATE);
calendar.setTimeInMillis(0);
calendar.set(year, month, day, 23, 59, 59);
return calendar.getTime();
}
``````

calendar.setTimeInMillis(0); gives you accuracy upto milliseconds

### Composer killed while updating

php -d memory_limit=5G composer.phar update

### anchor jumping by using javascript

Because when you do

``````window.location.href = "#"+anchor;
``````

You load a new page, you can do:

``````<a href="#" onclick="jumpTo('one');">One</a>
<a href="#" id="one"></a>

<script>

function getPosition(element){
var e = document.getElementById(element);
var left = 0;
var top = 0;

do{
left += e.offsetLeft;
top += e.offsetTop;
}while(e = e.offsetParent);

return [left, top];
}

function jumpTo(id){
window.scrollTo(getPosition(id));
}

</script>
``````

### Using sendmail from bash script for multiple recipients

Use option -t for sendmail.

in your case - `echo -e \$mail | /usr/sbin/sendmail -t` and add yout Recepient list to message itself like `To: [email protected] [email protected]` right after the line `From:.....`

`-t` option means - Read message for recipients. To:, Cc:, and Bcc: lines will be scanned for recipient addresses. The Bcc: line will be deleted before transmission.

### Setting Custom ActionBar Title from Fragment

===Update October, 30, 2019===

Since we have new components such as ViewModel and LiveData, we can have a different/easier way to update Activity Title from Fragment by using ViewModel and Live Data

Activity

``````class MainActivity : AppCompatActivity() {
private lateinit var viewModel: MainViewModel
override fun onCreate(savedInstanceState: Bundle?) {
super.onCreate(savedInstanceState)
setContentView(R.layout.main_activity)
if (savedInstanceState == null) {
supportFragmentManager.beginTransaction()
.replace(R.id.container, MainFragment.newInstance())
.commitNow()
}
viewModel = ViewModelProviders.of(this).get(MainViewModel::class.java)
viewModel.title.observe(this, Observer {
supportActionBar?.title = it
})
} }
``````

MainFragment

``````class MainFragment : Fragment() {
companion object {
fun newInstance() = MainFragment()
}
private lateinit var viewModel: MainViewModel
override fun onCreateView(inflater: LayoutInflater, container: ViewGroup?,
savedInstanceState: Bundle?): View {
return inflater.inflate(R.layout.main_fragment, container, false)
}
override fun onActivityCreated(savedInstanceState: Bundle?) {
super.onActivityCreated(savedInstanceState)
activity?.run {
viewModel = ViewModelProviders.of(this).get(MainViewModel::class.java)
} ?: throw Throwable("invalid activity")
viewModel.updateActionBarTitle("Custom Title From Fragment")
} }
``````

And MainModelView:

``````class MainViewModel : ViewModel() {
private val _title = MutableLiveData<String>()
val title: LiveData<String>
get() = _title
fun updateActionBarTitle(title: String) = _title.postValue(title) }
``````

And then you can update the Activity title from Fragment using `viewModel.updateActionBarTitle("Custom Title From Fragment")`

===Update April, 10, 2015===

You should use listener to update your action bar title

Fragment:

``````public class UpdateActionBarTitleFragment extends Fragment {
private OnFragmentInteractionListener mListener;

public UpdateActionBarTitleFragment() {
}

@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
if (getArguments() != null) {
}
}

@Override
public View onCreateView(LayoutInflater inflater, ViewGroup container,
Bundle savedInstanceState) {
if (mListener != null) {
mListener.onFragmentInteraction("Custom Title");
}
return inflater.inflate(R.layout.fragment_update_action_bar_title2, container, false);
}

@Override
public void onAttach(Activity activity) {
super.onAttach(activity);
try {
mListener = (OnFragmentInteractionListener) activity;
} catch (ClassCastException e) {
throw new ClassCastException(activity.toString()
+ " must implement OnFragmentInteractionListener");
}
}

@Override
public void onDetach() {
super.onDetach();
mListener = null;
}

public interface OnFragmentInteractionListener {
public void onFragmentInteraction(String title);
}
}
``````

And Activity:

``````public class UpdateActionBarTitleActivity extends ActionBarActivity implements UpdateActionBarTitleFragment.OnFragmentInteractionListener {

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

@Override
public void onFragmentInteraction(String title) {
getSupportActionBar().setTitle(title);
}
}
``````

### Disable Auto Zoom in Input "Text" tag - Safari on iPhone

Pseudo elements like `:focus` don't work as they used to. From iOS 11, a simple reset declaration can be added before your main styles (providing you don't override them with a smaller font size).

``````/* Prevent zoom */
select, input, textarea {
font-size: 16px;
}
``````

It's worth mentioning that for CSS libraries such as Tachyons.css then it's easy to accidentally override your font size.

For example class: `f5` is equivalent to: `fontSize: 1rem`, which is fine if you have kept the body font scale at the default.

However: if you choose font size class: `f6` this will be equivalent to `fontSize: .875rem` on a small display upwards. In that instance you'll need to be more specific about your reset declarations:

``````
/* Prevent zoom */
select, input, textarea {
font-size: 16px!important;
}

@media screen and (min-width: 30em) {

/* not small */

}

``````

### Angular: Cannot Get /

For me it also was problem with path, but I had percentage sign in the root folder.

After I replaced %20 with space, it started to work :)

### mkdir's "-p" option

mkdir [-switch] foldername

`-p` is a switch which is optional, it will create subfolder and parent folder as well even parent folder doesn't exist.

From the man page:

``````-p, --parents no error if existing, make parent directories as needed
``````

Example:

``````mkdir -p storage/framework/{sessions,views,cache}
``````

This will create subfolder sessions,views,cache inside framework folder irrespective of 'framework' was available earlier or not.

### Python unexpected EOF while parsing

Check if all the parameters of functions are defined before they are called. I faced this problem while practicing Kaggle.

### How does one output bold text in Bash?

In order to apply a style on your string, you can use a command like:

``````echo -e '\033[1mYOUR_STRING\033[0m'
``````

Explanation:

• echo -e - The `-e` option means that escaped (backslashed) strings will be interpreted
• \033 - escaped sequence represents beginning/ending of the style
• lowercase m - indicates the end of the sequence
• 1 - Bold attribute (see below for more)
• [0m - resets all attributes, colors, formatting, etc.

The possible integers are:

• 0 - Normal Style
• 1 - Bold
• 2 - Dim
• 3 - Italic
• 4 - Underlined
• 7 - Reverse
• 8 - Invisible

### Convert 4 bytes to int

You can also use BigInteger for variable length bytes. You can convert it to Long, Integer or Short, whichever suits your needs.

``````new BigInteger(bytes).intValue();
``````

or to denote polarity:

``````new BigInteger(1, bytes).intValue();
``````

### How to access the GET parameters after "?" in Express?

@Zugwait's answer is correct. `req.param()` is deprecated. You should use `req.params`, `req.query` or `req.body`.

But just to make it clearer:

`req.params` will be populated with only the route values. That is, if you have a route like `/users/:id`, you can access the `id` either in `req.params.id` or `req.params['id']`.

`req.query` and `req.body` will be populated with all params, regardless of whether or not they are in the route. Of course, parameters in the query string will be available in `req.query` and parameters in a post body will be available in `req.body`.

So, answering your questions, as `color` is not in the route, you should be able to get it using `req.query.color` or `req.query['color']`.

### How to Set RadioButtonFor() in ASp.net MVC 2 as Checked by default

Came across this and thought I would point out that for MVC 5 all you need to do is set the value on the model. For Example:

Model:

``````   public class ExampleModel
{
public PackingListInputModel()
{

}
public string RadioButtonField { get; set; }
}
``````

View :

``````@model ExampleModel

@using (Html.BeginForm)
{
}
``````

The state of the first radio button ("One") will be set as active because the value matches what was set in the model.

### Remove a CLASS for all child elements

This should work:

``````\$("#table-filters>ul>li.active").removeClass("active");
//Find all `li`s with class `active`, children of `ul`s, children of `table-filters`
``````

### Sqlite convert string to date

If Source Date format isn't consistent there is some problem with `substr` function, e.g.:

1/1/2017 or 1/11/2017 or 11/11/2017 or 1/1/17 etc.

So I followed a different apporach using a temporary table. This snippet outputs 'YYYY-MM-DD' + time if exists.

Note that this version accepts Day/Month/Year format. If you want Month/Day/Year swap the first two variables `DayPart` and `MonthPart`. Also, two year dates '44-'99 assumes 1944-1999 whereas '00-'43 assumes 2000-2043.

`````` BEGIN;

CREATE TEMP TABLE [DateconvertionTable] (Id TEXT PRIMARY KEY, OriginalDate  TEXT  , SepA  INTEGER,  DayPart TEXT,Rest1 TEXT, SepB  INTEGER,  MonthPart TEXT, Rest2 TEXT, SepC  INTEGER,  YearPart TEXT, Rest3 TEXT, NewDate TEXT);
INSERT INTO [DateconvertionTable] (Id,OriginalDate)  SELECT SourceIdColumn, SourceDateColumn From  [SourceTable];

--day Part (If day is first)

UPDATE [DateconvertionTable] SET SepA=instr(OriginalDate ,'/');
UPDATE [DateconvertionTable] SET DayPart=substr(OriginalDate,1,SepA-1) ;
UPDATE [DateconvertionTable] SET Rest1=substr(OriginalDate,SepA+1);

--Month Part (If Month is second)

UPDATE [DateconvertionTable] SET SepB=instr(Rest1,'/');
UPDATE [DateconvertionTable]  SET MonthPart=substr(Rest1, 1,SepB-1);
UPDATE [DateconvertionTable] SET Rest2=substr(Rest1,SepB+1);

--Year Part (3d)

UPDATE [DateconvertionTable] SET SepC=instr(Rest2,' ');

--Use Cases In case of time string included
UPDATE [DateconvertionTable]  SET YearPart= CASE WHEN SepC=0 THEN Rest2 ELSE substr(Rest2,1,SepC-1)  END;

--The Rest considered time
UPDATE [DateconvertionTable]  SET Rest3= CASE WHEN SepC=0 THEN  '' ELSE substr(Rest2,SepC+1) END;

-- Convert 1 digit day and month to 2 digit
UPDATE [DateconvertionTable] SET DayPart=0||DayPart WHERE CAST(DayPart AS INTEGER)<10;
UPDATE [DateconvertionTable] SET MonthPart=0||MonthPart WHERE CAST(MonthPart AS INTEGER)<10;

--If there is a need to convert 2 digit year to 4 digit year, make some assumptions...
UPDATE [DateconvertionTable] SET YearPart=19||YearPart WHERE CAST(YearPart AS INTEGER)>=44 AND CAST(YearPart AS INTEGER)<100;
UPDATE [DateconvertionTable] SET YearPart=20||YearPart WHERE CAST(YearPart AS INTEGER)<44 AND CAST(YearPart AS INTEGER)<100;

UPDATE [DateconvertionTable] SET NewDate = YearPart  || '-' || MonthPart || '-' || DayPart || ' ' || Rest3;

UPDATE [SourceTable] SET SourceDateColumn=(Select NewDate FROM DateconvertionTable WHERE [DateconvertionTable].id=SourceIdColumn);
END;
``````

### What is the use of "object sender" and "EventArgs e" parameters?

Those two parameters (or variants of) are sent, by convention, with all events.

• `sender`: The object which has raised the event
• `e` an instance of `EventArgs` including, in many cases, an object which inherits from `EventArgs`. Contains additional information about the event, and sometimes provides ability for code handling the event to alter the event somehow.

In the case of the events you mentioned, neither parameter is particularly useful. The is only ever one page raising the events, and the `EventArgs` are `Empty` as there is no further information about the event.

Looking at the 2 parameters separately, here are some examples where they are useful.

#### `sender`

Say you have multiple buttons on a form. These buttons could contain a `Tag` describing what clicking them should do. You could handle all the `Click` events with the same handler, and depending on the `sender` do something different

``````private void HandleButtonClick(object sender, EventArgs e)
{
Button btn = (Button)sender;
if(btn.Tag == "Hello")
MessageBox.Show("Hello")
else if(btn.Tag == "Goodbye")
Application.Exit();
// etc.
}
``````

Disclaimer : That's a contrived example; don't do that!

#### `e`

Some events are cancelable. They send `CancelEventArgs` instead of `EventArgs`. This object adds a simple boolean property `Cancel` on the event args. Code handling this event can cancel the event:

``````private void HandleCancellableEvent(object sender, CancelEventArgs e)
{
if(/* some condition*/)
{
// Cancel this event
e.Cancel = true;
}
}
``````

### How to call a stored procedure from Java and JPA

The following works for me:

``````Query query = em.createNativeQuery("BEGIN VALIDACIONES_QPAI.RECALC_COMP_ASSEMBLY('X','X','X',0); END;");
query.executeUpdate();
``````

### How to stop/terminate a python script from running?

If your program is running at an interactive console, pressing CTRL + C will raise a `KeyboardInterrupt` exception on the main thread.

If your Python program doesn't catch it, the `KeyboardInterrupt` will cause Python to exit. However, an `except KeyboardInterrupt:` block, or something like a bare `except:`, will prevent this mechanism from actually stopping the script from running.

Sometimes if `KeyboardInterrupt` is not working you can send a `SIGBREAK` signal instead; on Windows, CTRL + Pause/Break may be handled by the interpreter without generating a catchable `KeyboardInterrupt` exception.

However, these mechanisms mainly only work if the Python interpreter is running and responding to operating system events. If the Python interpreter is not responding for some reason, the most effective way is to terminate the entire operating system process that is running the interpreter. The mechanism for this varies by operating system.

In a Unix-style shell environment, you can press CTRL + Z to suspend whatever process is currently controlling the console. Once you get the shell prompt back, you can use `jobs` to list suspended jobs, and you can kill the first suspended job with `kill %1`. (If you want to start it running again, you can continue the job in the foreground by using `fg %1`; read your shell's manual on job control for more information.)

Alternatively, in a Unix or Unix-like environment, you can find the Python process's PID (process identifier) and kill it by PID. Use something like `ps aux | grep python` to find which Python processes are running, and then use `kill <pid>` to send a `SIGTERM` signal.

The `kill` command on Unix sends `SIGTERM` by default, and a Python program can install a signal handler for `SIGTERM` using the `signal` module. In theory, any signal handler for `SIGTERM` should shut down the process gracefully. But sometimes if the process is stuck (for example, blocked in an uninterruptable IO sleep state), a `SIGTERM` signal has no effect because the process can't even wake up to handle it.

To forcibly kill a process that isn't responding to signals, you need to send the `SIGKILL` signal, sometimes referred to as `kill -9` because `9` is the numeric value of the `SIGKILL` constant. From the command line, you can use `kill -KILL <pid>` (or `kill -9 <pid>` for short) to send a `SIGKILL` and stop the process running immediately.

On Windows, you don't have the Unix system of process signals, but you can forcibly terminate a running process by using the `TerminateProcess` function. Interactively, the easiest way to do this is to open Task Manager, find the `python.exe` process that corresponds to your program, and click the "End Process" button. You can also use the `taskkill` command for similar purposes.

### Kotlin Ternary Conditional Operator

as Drew Noakes quoted, kotlin use if statement as expression, so Ternary Conditional Operator is not necessary anymore,

but with the extension function and infix overloading, you could implement that yourself, here is an example

``````infix fun <T> Boolean.then(value: T?) = TernaryExpression(this, value)

class TernaryExpression<out T>(val flag: Boolean, val truly: T?) {
infix fun <T> or(falsy: T?) = if (flag) truly else falsy
}
``````

then use it like this

``````val grade = 90
val clazz = (grade > 80) then "A" or "B"
``````

### C# cannot convert method to non delegate type

`getTitle` is a function, so you need to put `()` after it.

``````string t = obj.getTitle();
``````

### TypeError: Cannot read property "0" from undefined

For me, the problem was I was using a package that isn't included in `package.json` nor installed.

``````import { ToastrService } from 'ngx-toastr';
``````

So when the compiler tried to compile this, it threw an error.

(I installed it locally, and when running a build on an external server the error was thrown)

### HTML/Javascript change div content

change onClick to `onClick="changeDivContent(this)"` and try

``````function changeDivContent(btn) {
content.innerHTML = btn.value
}
``````

_x000D_
_x000D_
``````function changeDivContent(btn) {_x000D_
content.innerHTML = btn.value_x000D_
}``````
_x000D_
``````<input type="radio" name="radiobutton" value="A" onClick="changeDivContent(this)">_x000D_
_x000D_
<div id="content"></div>``````
_x000D_
_x000D_
_x000D_

### How to duplicate sys.stdout to a log file?

(Ah, just re-read your question and see that this doesn't quite apply.)

Here is a sample program that makes uses the python logging module. This logging module has been in all versions since 2.3. In this sample the logging is configurable by command line options.

In quite mode it will only log to a file, in normal mode it will log to both a file and the console.

``````import os
import sys
import logging
from optparse import OptionParser

def initialize_logging(options):

logger = logging.getLogger('project')
formatter = logging.Formatter('%(asctime)s %(levelname)s\t%(message)s')
level = logging.__dict__.get(options.loglevel.upper(),logging.DEBUG)
logger.setLevel(level)

# Output logging information to screen
if not options.quiet:
hdlr = logging.StreamHandler(sys.stderr)
hdlr.setFormatter(formatter)

# Output logging information to file
logfile = os.path.join(options.logdir, "project.log")
if options.clean and os.path.isfile(logfile):
os.remove(logfile)
hdlr2 = logging.FileHandler(logfile)
hdlr2.setFormatter(formatter)

return logger

def main(argv=None):
if argv is None:
argv = sys.argv[1:]

# Setup command line options
parser = OptionParser("usage: %prog [options]")
parser.add_option("-l", "--logdir", dest="logdir", default=".", help="log DIRECTORY (default ./)")
parser.add_option("-v", "--loglevel", dest="loglevel", default="debug", help="logging level (debug, info, error)")
parser.add_option("-q", "--quiet", action="store_true", dest="quiet", help="do not log to console")
parser.add_option("-c", "--clean", dest="clean", action="store_true", default=False, help="remove old log file")

# Process command line options
(options, args) = parser.parse_args(argv)

# Setup logger format and output locations
logger = initialize_logging(options)

# Examples
logger.error("This is an error message.")
logger.info("This is an info message.")
logger.debug("This is a debug message.")

if __name__ == "__main__":
sys.exit(main())
``````

### How do I append a node to an existing XML file in java

To append a new data element,just do this...

``````Document doc = docBuilder.parse(is);
Node root=doc.getFirstChild();
Element newserver=doc.createElement("new_server");
root.appendChild(newserver);
``````

easy.... 'is' is an InputStream object. rest is similar to your code....tried it just now...

### Vuejs: v-model array in multiple input

Here's a demo of the above:https://jsfiddle.net/sajadweb/mjnyLm0q/11

_x000D_
_x000D_
``````new Vue({_x000D_
el: '#app',_x000D_
data: {_x000D_
users: [{ name: 'sajadweb',email:'[email protected]' }] _x000D_
},_x000D_
methods: {_x000D_
this.users.push({ name: '',email:'' });_x000D_
},_x000D_
deleteUser: function (index) {_x000D_
console.log(index);_x000D_
console.log(this.finds);_x000D_
this.users.splice(index, 1);_x000D_
if(index===0)_x000D_
}_x000D_
}_x000D_
});``````
_x000D_
``````<script src="https://unpkg.com/vue/dist/vue.js"></script>_x000D_
<div id="app">_x000D_
<div v-for="(user, index) in users">_x000D_
<input v-model="user.name">_x000D_
<input v-model="user.email">_x000D_
<button @click="deleteUser(index)">_x000D_
delete_x000D_
</button>_x000D_
</div>_x000D_
_x000D_
New User_x000D_
</button>_x000D_
_x000D_
<pre>{{ \$data }}</pre>_x000D_
</div>``````
_x000D_
_x000D_
_x000D_

### View stored procedure/function definition in MySQL

You can use this:

``````SELECT ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_SCHEMA = 'yourdb' AND ROUTINE_TYPE = 'PROCEDURE' AND ROUTINE_NAME = "procedurename";
``````

### Setting max width for body using Bootstrap

I don't know if this was pointed out here. The settings for `.container` width have to be set on the Bootstrap website. I personally did not have to edit or touch anything within CSS files to tune my `.container` size which is 1600px. Under Customize tab, there are three sections responsible for media and the responsiveness of the web:

• Media queries breakpoints
• Grid system
• Container sizes

Besides Media queries breakpoints, which I believe most people refer to, I've also changed `@container-desktop` to `(1130px + @grid-gutter-width)` and `@container-large-desktop` to `(1530px + @grid-gutter-width)`. Now, the `.container` changes its width if my browser is scaled up to ~1600px and ~1200px. Hope it can help.

### SQL Server remove milliseconds from datetime

``````select substring('12:20:19.8470000',1,(CHARINDEX('.','12:20:19.8470000',1)-1))

(No column name)
12:20:19
``````

### Best practices for circular shift (rotate) operations in C++

C++20 `std::rotl` and `std::rotr`

It has arrived! http://www.open-std.org/jtc1/sc22/wg21/docs/papers/2019/p0553r4.html and should add it to the `<bit>` header.

cppreference says that the usage will be like:

``````#include <bit>
#include <bitset>
#include <cstdint>
#include <iostream>

int main()
{
std::uint8_t i = 0b00011101;
std::cout << "i          = " << std::bitset<8>(i) << '\n';
std::cout << "rotl(i,0)  = " << std::bitset<8>(std::rotl(i,0)) << '\n';
std::cout << "rotl(i,1)  = " << std::bitset<8>(std::rotl(i,1)) << '\n';
std::cout << "rotl(i,4)  = " << std::bitset<8>(std::rotl(i,4)) << '\n';
std::cout << "rotl(i,9)  = " << std::bitset<8>(std::rotl(i,9)) << '\n';
std::cout << "rotl(i,-1) = " << std::bitset<8>(std::rotl(i,-1)) << '\n';
}
``````

giving output:

``````i          = 00011101
rotl(i,0)  = 00011101
rotl(i,1)  = 00111010
rotl(i,4)  = 11010001
rotl(i,9)  = 00111010
rotl(i,-1) = 10001110
``````

I'll give it a try when support arrives to GCC, GCC 9.1.0 with `g++-9 -std=c++2a` still doesn't support it.

The proposal says:

``````namespace std {
// 25.5.5, rotating
template<class T>
[[nodiscard]] constexpr T rotl(T x, int s) noexcept;
template<class T>
[[nodiscard]] constexpr T rotr(T x, int s) noexcept;
``````

and:

25.5.5 Rotating [bitops.rot]

In the following descriptions, let N denote `std::numeric_limits<T>::digits`.

``````template<class T>
[[nodiscard]] constexpr T rotl(T x, int s) noexcept;
``````

Constraints: T is an unsigned integer type (3.9.1 [basic.fundamental]).

Let r be s % N.

Returns: If r is 0, x; if r is positive, `(x << r) | (x >> (N - r))`; if r is negative, `rotr(x, -r)`.

``````template<class T>
[[nodiscard]] constexpr T rotr(T x, int s) noexcept;
``````

Constraints: T is an unsigned integer type (3.9.1 [basic.fundamental]). Let r be s % N.

Returns: If r is 0, x; if r is positive, `(x >> r) | (x << (N - r))`; if r is negative, `rotl(x, -r)`.

A `std::popcount` was also added to count the number of 1 bits: How to count the number of set bits in a 32-bit integer?

### Center Contents of Bootstrap row container

For Bootstrap 4, use the below code:

``````<div class="mx-auto" style="width: 200px;">
Centered element
</div>
``````

### Fastest way to convert string to integer in PHP

integer excract from any string

\$in = 'tel.123-12-33';

``````preg_match_all('!\d+!', \$in, \$matches);
\$out =  (int)implode('', \$matches[0]);
``````

//\$out ='1231233';

### Setting button text via javascript

Create a text node and append it to the button element:

``````var t = document.createTextNode("test content");
b.appendChild(t);
``````

### Can I change the color of Font Awesome's icon color?

You can specify the color in the style attribute:

``````<a href="/users/edit"><i class="icon-cog" style="color:black"></i> Edit profile</a>
``````

### Docker container not starting (docker start)

You are trying to run `bash`, an interactive shell that requires a tty in order to operate. It doesn't really make sense to run this in "detached" mode with `-d`, but you can do this by adding `-it` to the command line, which ensures that the container has a valid tty associated with it and that `stdin` remains connected:

``````docker run -it -d -p 52022:22 basickarl/docker-git-test
``````

You would more commonly run some sort of long-lived non-interactive process (like `sshd`, or a web server, or a database server, or a process manager like `systemd` or `supervisor`) when starting detached containers.

If you are trying to run a service like `sshd`, you cannot simply run `service ssh start`. This will -- depending on the distribution you're running inside your container -- do one of two things:

• It will try to contact a process manager like `systemd` or `upstart` to start the service. Because there is no service manager running, this will fail.

• It will actually start `sshd`, but it will be started in the background. This means that (a) the `service sshd start` command exits, which means that (b) Docker considers your container to have failed, so it cleans everything up.

If you want to run just ssh in a container, consider an example like this.

If you want to run `sshd` and other processes inside the container, you will need to investigate some sort of process supervisor.

### How to create batch file in Windows using "start" with a path and command with spaces

``````start "" "c:\path with spaces\app.exe" "C:\path parameter\param.exe"
``````

When I used above suggestion, I've got:

'c:\path' is not recognized a an internal or external command, operable program or batch file.

I think second qoutation mark prevent command to run. After some search below solution save my day:

``````start "" CALL "c:\path with spaces\app.exe" "C:\path parameter\param.exe"
``````

### Get Folder Size from Windows Command Line

If you have git installed in your computer (getting more and more common) just open MINGW32 and type: `du folder`

### What is the --save option for npm install?

`npm install package_x --save`

The given package (package_x) will be saved in package.json inside dependencies. if you add

`npm install <<package_x>> --save-dev`

then it will be saved inside devDependencies.

### How to get just numeric part of CSS property with jQuery?

Id go for:

``````Math.abs(parseFloat(\$(this).css("property")));
``````

### How can I control the speed that bootstrap carousel slides in items?

If you don't want to change the js files of bootstrap, you can also directly inject the wanted value into the jquery plugin (bootsrap 3.3.6).

This requires of course, that the carousel is activated manually via js, not directly via the data-ride attribute.

For example:

``````var interval = 3500;
\$.fn.carousel.Constructor.TRANSITION_DURATION = interval - 500;
elem.carousel({
interval : interval
});
``````

### How to avoid Number Format Exception in java?

Exceptions in recent versions of Java aren't expensive enough to make their avoidance important. Use the try/catch block people have suggested; if you catch the exception early in the process (i.e., right after the user has entered it) then you're not going to have the problem later in the process (because it'll be the right type anyway).

Exceptions used to be a lot more expensive than they are now; don't optimize for performance until you know the exceptions are actually causing a problem (and they won't, here.)

### Git: How do I list only local branches?

To complement @gertvdijk's answer - I'm adding few screenshots in case it helps someone quick.

On my git bash shell

git branch

command without any parameters shows all my local branches. The current branch which is currently checked out is shown in different color (green) along with an asterisk (*) prefix which is really intuitive.

When you try to see all branches including the remote branches using

git branch -a

command then remote branches which aren't checked out yet are shown in red color:

It is possible but, before git 2.9.3 (august 2016), a `git push` would print the full url used when pushing back to the cloned repo.

But no more: See commit 68f3c07 (20 Jul 2016), and commit 882d49c (14 Jul 2016) by Jeff King (`peff`).
(Merged by Junio C Hamano -- `gitster` -- in commit 71076e1, 08 Aug 2016)

#### `push`: anonymize URL in status output

Commit 47abd85 (fetch: Strip usernames from url's before storing them, 2009-04-17, Git 1.6.4) taught fetch to anonymize URLs.
The primary purpose there was to avoid sticking passwords in merge-commit messages, but as a side effect, we also avoid printing them to stderr.

The push side does not have the merge-commit problem, but it probably should avoid printing them to stderr. We can reuse the same anonymizing function.

Note that for this to come up, the credentials would have to appear either on the command line or in a git config file, neither of which is particularly secure.
So people should be switching to using credential helpers instead, which makes this problem go away.

But that's no excuse not to improve the situation for people who for whatever reason end up using credentials embedded in the URL.

### JavaScript: Create and destroy class instance through class method

You can only manually delete properties of objects. Thus:

``````var container = {};

container.instance = new class();

delete container.instance;
``````

However, this won't work on any other pointers. Therefore:

``````var container = {};

container.instance = new class();

var pointer = container.instance;

delete pointer; // false ( ie attempt to delete failed )
``````

Furthermore:

``````delete container.instance; // true ( ie attempt to delete succeeded, but... )

pointer; // class { destroy: function(){} }
``````

So in practice, deletion is only useful for removing object properties themselves, and is not a reliable method for removing the code they point to from memory.

A manually specified `destroy` method could unbind any event listeners. Something like:

``````function class(){
this.properties = { /**/ }

function handler(){ /**/ }

this.destroy = function(){
something.removeEventListener( 'event', handler );
}
}
``````

### @Cacheable key on multiple method arguments

Update: Current Spring cache implementation uses all method parameters as the cache key if not specified otherwise. If you want to use selected keys, refer to Arjan's answer which uses SpEL list `{#isbn, #includeUsed} ` which is the simplest way to create unique keys.

The default key generation strategy changed with the release of Spring 4.0. Earlier versions of Spring used a key generation strategy that, for multiple key parameters, only considered the hashCode() of parameters and not equals(); this could cause unexpected key collisions (see SPR-10237 for background). The new 'SimpleKeyGenerator' uses a compound key for such scenarios.

Before Spring 4.0

I suggest you to concat the values of the parameters in Spel expression with something like `key="#checkWarehouse.toString() + #isbn.toString()")`, I believe this should work as org.springframework.cache.interceptor.ExpressionEvaluator returns Object, which is later used as the key so you don't have to provide an `int` in your SPEL expression.

As for the hash code with a high collision probability - you can't use it as the key.

Someone in this thread has suggested to use `T(java.util.Objects).hash(#p0,#p1, #p2)` but it WILL NOT WORK and this approach is easy to break, for example I've used the data from SPR-9377 :

``````    System.out.println( Objects.hash("someisbn", new Integer(109), new Integer(434)));
System.out.println( Objects.hash("someisbn", new Integer(110), new Integer(403)));
``````

Both lines print -636517714 on my environment.

P.S. Actually in the reference documentation we have

``````@Cacheable(value="books", key="T(someType).hash(#isbn)")
public Book findBook(ISBN isbn, boolean checkWarehouse, boolean includeUsed)
``````

I think that this example is WRONG and misleading and should be removed from the documentation, as the keys should be unique.

P.P.S. also see https://jira.springsource.org/browse/SPR-9036 for some interesting ideas regarding the default key generation.

I'd like to add for the sake of correctness and as an entertaining mathematical/computer science fact that unlike built-in hash, using a secure cryptographic hash function like MD5 or SHA256, due to the properties of such function IS absolutely possible for this task, but to compute it every time may be too expensive, checkout for example Dan Boneh cryptography course to learn more.

### Getting the first and last day of a month, using a given DateTime object

The accepted answer here does not take into account the Kind of the DateTime instance. For example if your original DateTime instance was a UTC Kind then by making a new DateTime instance you will be making an Unknown Kind instance which will then be treated as local time based on server settings. Therefore the more proper way to get the first and last date of the month would be this:

``````var now = DateTime.UtcNow;
var first = now.Date.AddDays(-(now.Date.Day - 1));
``````

This way the original Kind of the DateTime instance is preserved.

### How to set value to form control in Reactive Forms in Angular

Setting or Updating of Reactive Forms Form Control values can be done using both patchValue and setValue. However, it might be better to use patchValue in some instances.

`patchValue` does not require all controls to be specified within the parameters in order to update/set the value of your Form Controls. On the other hand, `setValue` requires all Form Control values to be filled in, and it will return an error if any of your controls are not specified within the parameter.

In this scenario, we will want to use patchValue, since we are only updating `user` and `questioning`:

``````this.qService.editQue([params["id"]]).subscribe(res => {
this.question = res;
this.editqueForm.patchValue({
user: this.question.user,
questioning: this.question.questioning
});
});
``````

EDIT: If you feel like doing some of ES6's Object Destructuring, you may be interested to do this instead

``````const { user, questioning } = this.question;

this.editqueForm.patchValue({
user,
questioning
});
``````

Ta-dah!

### What does 'useLegacyV2RuntimeActivationPolicy' do in the .NET 4 config?

After a bit of time (and more searching), I found this blog entry by Jomo Fisher.

One of the recent problems we’ve seen is that, because of the support for side-by-side runtimes, .NET 4.0 has changed the way that it binds to older mixed-mode assemblies. These assemblies are, for example, those that are compiled from C++\CLI. Currently available DirectX assemblies are mixed mode. If you see a message like this then you know you have run into the issue:

Mixed mode assembly is built against version 'v1.1.4322' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information.

[Snip]

The good news for applications is that you have the option of falling back to .NET 2.0 era binding for these assemblies by setting an app.config flag like so:

``````<startup useLegacyV2RuntimeActivationPolicy="true">
<supportedRuntime version="v4.0"/>
</startup>
``````

So it looks like the way the runtime loads mixed-mode assemblies has changed. I can't find any details about this change, or why it was done. But the `useLegacyV2RuntimeActivationPolicy` attribute reverts back to CLR 2.0 loading.

### How to filter data in dataview

``````DataView view = new DataView();
view.Table = DataSet1.Tables["Suppliers"];
view.RowFilter = "City = 'Berlin'";
view.RowStateFilter = DataViewRowState.ModifiedCurrent;
view.Sort = "CompanyName DESC";

// Simple-bind to a TextBox control
``````

http://msdn.microsoft.com/en-us/library/system.data.dataview.rowfilter.aspx

### How do I fix the indentation of an entire file in Vi?

You can use tidy application/utility to indent HTML & XML files and it works pretty well in indenting those files.

Prettify an XML file

``````:!tidy -mi -xml %
``````

Prettify an HTML file

``````:!tidy -mi -html %
``````

### Adding input elements dynamically to form

Try this JQuery code to dynamically include form, field, and delete/remove behavior:

_x000D_
_x000D_
``````\$(document).ready(function() {_x000D_
var max_fields = 10;_x000D_
var wrapper = \$(".container1");_x000D_
_x000D_
var x = 1;_x000D_
e.preventDefault();_x000D_
if (x < max_fields) {_x000D_
x++;_x000D_
\$(wrapper).append('<div><input type="text" name="mytext[]"/><a href="#" class="delete">Delete</a></div>'); //add input box_x000D_
} else {_x000D_
}_x000D_
});_x000D_
_x000D_
\$(wrapper).on("click", ".delete", function(e) {_x000D_
e.preventDefault();_x000D_
\$(this).parent('div').remove();_x000D_
x--;_x000D_
})_x000D_
});``````
_x000D_
``````<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>_x000D_
<div class="container1">_x000D_
<span style="font-size:16px; font-weight:bold;">+ </span>_x000D_
</button>_x000D_
<div><input type="text" name="mytext[]"></div>_x000D_
</div>``````
_x000D_
_x000D_
_x000D_

Refer Demo Here

### How to replace multiple white spaces with one white space

There is no way built in to do this. You can try this:

``````private static readonly char[] whitespace = new char[] { ' ', '\n', '\t', '\r', '\f', '\v' };
public static string Normalize(string source)
{
return String.Join(" ", source.Split(whitespace, StringSplitOptions.RemoveEmptyEntries));
}
``````

This will remove leading and trailing whitespce as well as collapse any internal whitespace to a single whitespace character. If you really only want to collapse spaces, then the solutions using a regular expression are better; otherwise this solution is better. (See the analysis done by Jon Skeet.)

### XPath - Selecting elements that equal a value

The XPath spec. defines the string value of an element as the concatenation (in document order) of all of its text-node descendents.

This explains the "strange results".

"Better" results can be obtained using the expressions below:

``````//*[text() = 'qwerty']
``````

The above selects every element in the document that has at least one text-node child with value 'qwerty'.

``````//*[text() = 'qwerty' and not(text()[2])]
``````

The above selects every element in the document that has only one text-node child and its value is: 'qwerty'.

### PHP/Apache: PHP Fatal error: Call to undefined function mysql_connect()

The `mysql` deamon should be running.

If not try this:

``````#/etc/init.d/mysql start
``````

Or this:

``````#service mysqld start
``````

And if you want to add mysql on boot:

``````# chkconfig --add mysqld
# chkconfig -- level 235 mysqld on
``````

If yes, and it is still not working try this:

Uncomment the following lines in /etc/php/php.ini

``````extension=mysqli.so
extension=mysql.so
``````

And please check your post above '/usr/lib64/php/modules/msql.so'. It should be mysql.so (if it's mistyped ignore it...)

### Android Studio installation on Windows 7 fails, no JDK found

If setting the `JAVA_HOME` variable doesn't work for you, set:

``````STUDIO_JDK=C:\Progra~1\Java\jdk1.8.0_172
``````

Where the path points to your JDK installation This is the only thing which works for me in Windows 32bit with Android 10 and up.

### How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?

You should be able to declare a cursor to be a bind variable (called parameters in other DBMS')

like Vincent wrote, you can do something like this:

``````begin
open :yourCursor
for 'SELECT "'|| :someField ||'" from yourTable where x = :y'
using :someFilterValue;
end;
``````

You'd have to bind 3 vars to that script. An input string for "someField", a value for "someFilterValue" and an cursor for "yourCursor" which has to be declared as output var.

Unfortunately, I have no idea how you'd do that from C++. (One could say fortunately for me, though. ;-) )

Depending on which access library you use, it might be a royal pain or straight forward.

### Tomcat Servlet: Error 404 - The requested resource is not available

try this (if the Java EE V6)

``````package crunch;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
@WebServlet(name="hello",urlPatterns={"/hello"})
public class HelloWorld extends HttpServlet {
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
PrintWriter out = response.getWriter();
out.println("Hello World");
}
}
``````

now reach the servlet by `http://127.0.0.1:8080/yourapp/hello`

where 8080 is default tomcat port, and yourapp is the context name of your applciation

### How to thoroughly purge and reinstall postgresql on ubuntu?

I just ran into the same issue for Ubuntu 13.04. These commands removed Postgres 9.1:

``````sudo apt-get purge postgresql
sudo apt-get autoremove postgresql
``````

It occurs to me that perhaps only the second command is necessary, but from there I was able to install Postgres 9.2 (sudo apt-get install postgresql-9.2).

### How to set default font family for entire Android app

Another way to do this for the whole app is using reflection based on this answer

``````public class TypefaceUtil {
/**
* Using reflection to override default typefaces
* NOTICE: DO NOT FORGET TO SET TYPEFACE FOR APP THEME AS DEFAULT TYPEFACE WHICH WILL BE
* OVERRIDDEN
*
* @param typefaces map of fonts to replace
*/
public static void overrideFonts(Map<String, Typeface> typefaces) {
try {
final Field field = Typeface.class.getDeclaredField("sSystemFontMap");
field.setAccessible(true);
Map<String, Typeface> oldFonts = (Map<String, Typeface>) field.get(null);
if (oldFonts != null) {
oldFonts.putAll(typefaces);
} else {
oldFonts = typefaces;
}
field.set(null, oldFonts);
field.setAccessible(false);
} catch (Exception e) {
Log.e("TypefaceUtil", "Can not set custom fonts");
}
}

public static Typeface getTypeface(int fontType, Context context) {
// here you can load the Typeface from asset or use default ones
switch (fontType) {
case BOLD:
return Typeface.create(SANS_SERIF, Typeface.BOLD);
case ITALIC:
return Typeface.create(SANS_SERIF, Typeface.ITALIC);
case BOLD_ITALIC:
return Typeface.create(SANS_SERIF, Typeface.BOLD_ITALIC);
case LIGHT:
return Typeface.create(SANS_SERIF_LIGHT, Typeface.NORMAL);
case CONDENSED:
return Typeface.create(SANS_SERIF_CONDENSED, Typeface.NORMAL);
case THIN:
return Typeface.create(SANS_SERIF_MEDIUM, Typeface.NORMAL);
case MEDIUM:
return Typeface.create(SANS_SERIF_THIN, Typeface.NORMAL);
case REGULAR:
default:
return Typeface.create(SANS_SERIF, Typeface.NORMAL);
}
}
}
``````

then whenever you want to override the fonts you can just call the method and give it a map of typefaces as follows:

``````Typeface regular = TypefaceUtil.getTypeface(REGULAR, context);
Typeface light = TypefaceUtil.getTypeface(REGULAR, context);
Typeface condensed = TypefaceUtil.getTypeface(CONDENSED, context);
Typeface thin = TypefaceUtil.getTypeface(THIN, context);
Typeface medium = TypefaceUtil.getTypeface(MEDIUM, context);
Map<String, Typeface> fonts = new HashMap<>();
fonts.put("sans-serif", regular);
fonts.put("sans-serif-light", light);
fonts.put("sans-serif-condensed", condensed);
fonts.put("sans-serif-thin", thin);
fonts.put("sans-serif-medium", medium);
TypefaceUtil.overrideFonts(fonts);
``````

for full example check

This only works for Android SDK 21 and above for earlier versions check the full example

### Saving image from PHP URL

``````\$data = file_get_contents('http://example.com/image.php');
\$img = imagecreatefromstring(\$data);
imagepng(\$img, 'test.png');
``````

### How to check if dropdown is disabled?

The legacy solution, before 1.6, was to use `.attr` and handle the returned value as a `bool`. The main problem is that the returned type of `.attr` has changed to `string`, and therefore the comparison with `== true` is broken (see http://jsfiddle.net/2vene/1/ (and switch the jquery-version)).

With 1.6 `.prop` was introduced, which returns a `bool`.

Nevertheless, I suggest to use `.is()`, as the returned type is intrinsically `bool`, like:

``````\$('#dropUnit').is(':disabled');
\$('#dropUnit').is(':enabled');
``````

Furthermore `.is()` is much more natural (in terms of "natural language") and adds more conditions than a simple attribute-comparison (eg: `.is(':last')`, `.is(':visible')`, ... please see documentation on selectors).

### Using sessions & session variables in a PHP Login Script

``````\$session_start();

extract(\$_POST);
//extract data from submit post

if(isset(\$submit))
{

if(\$user=="user" && \$pass=="pass")

{

\$_SESSION['user']= \$user;

//if correct password and name store in session

}
else {

}

if(isset(\$_SESSION['user']))

{

exit;
}
``````

### What are all the possible values for HTTP "Content-Type" header?

I would aim at covering a subset of possible "Content-type" values, you question seems to focus on identifying known content types.

@Jeroen RFC 1341 reference is great, but for an fairly exhaustive list IANA keeps a web page of officially registered media types here.

### iOS - Dismiss keyboard when touching outside of UITextField

I see that some people are having issues using the `UITapGestureRecognizer` method. The easiest way that I've accomplished this functionality while still leaving my existing button's tap behavior intact is adding only one line to @Jensen2k 's answer:

``````[tap setCancelsTouchesInView:NO];
``````

This allowed my existing buttons to still work without using @Dmitry Sitnikov 's method.

Read about that `property` here (search for `CancelsTouchesInView`): UIGestureRecognizer Class Reference

I'm not sure how it would work with scrollbars, as I see some had issues with, but hopefully someone else might run into the same scenario I had.

### Why is IoC / DI not common in Python?

IoC and DI are super common in mature Python code. You just don't need a framework to implement DI thanks to duck typing.

The best example is how you set up a Django application using `settings.py`:

``````# settings.py
CACHES = {
'default': {
'BACKEND': 'django_redis.cache.RedisCache',
'LOCATION': REDIS_URL + '/1',
},
'local': {
'BACKEND': 'django.core.cache.backends.locmem.LocMemCache',
'LOCATION': 'snowflake',
}
}
``````

Django Rest Framework utilizes DI heavily:

``````class FooView(APIView):
# The "injected" dependencies:
permission_classes = (IsAuthenticated, )
throttle_classes = (ScopedRateThrottle, )
parser_classes = (parsers.FormParser, parsers.JSONParser, parsers.MultiPartParser)
renderer_classes = (renderers.JSONRenderer,)

def get(self, request, *args, **kwargs):
pass

def post(self, request, *args, **kwargs):
pass
``````

Let me remind (source):

"Dependency Injection" is a 25-dollar term for a 5-cent concept. [...] Dependency injection means giving an object its instance variables. [...].

### Is there a good jQuery Drag-and-drop file upload plugin?

Shameless Plug:

Filepicker.io handles uploading for you and returns a url. It supports drag/drop, cross browser. Also, people can upload from Dropbox/Facebook/Gmail which is super handy on a mobile device.

### Add timestamp column with default NOW() for new rows only

Try something like:-

``````ALTER TABLE table_name ADD  CONSTRAINT [DF_table_name_Created]
DEFAULT (getdate()) FOR [created_at];
``````

replacing `table_name` with the name of your table.

### Using "word-wrap: break-word" within a table

You can try this:

`td p {word-break:break-all;}`

This, however, makes it appear like this when there's enough space, unless you add a `<br>` tag:

``````aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
``````

So, I would then suggest adding `<br>` tags where there are newlines, if possible.

``````aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
``````

http://jsfiddle.net/LLyH3/3/

Also, if this doesn't solve your problem, there's a similar thread here.

### Change tab bar tint color on iOS 7

In app delegate didFinishLaunchingWithOptions:

``````window.tintColor = [UIColor purpleColor];
``````

sets the tint color globally for the app.

### How to convert .pfx file to keystore with private key?

jarsigner can use your pfx file as the keystore for signing your jar. Be sure that your pfx file has the private key and the cert chain when you export it. There is no need to convert to other formats. The trick is to obtain the Alias of your pfx file:

`````` keytool -list -storetype pkcs12 -keystore your_pfx_file -v | grep Alias
``````

Once you have your alias, signing is easy

``````jarsigner.exe -storetype pkcs12 -keystore pfx_file jar_file "your alias"
``````

The above two commands will prompt you for the password you specified at pfx export. If you want to have your password hang out in clear text use the -storepass switch before the -keystore switch

``````jarsigner.exe -verify -verbose -certs  yourjarfile
``````

``````function check() {
document.getElementById('message').innerHTML = "match";
} else {
document.getElementById('message').innerHTML = "no match";
}
}
``````
``````<label>password :
</label>
<span id='message'></span>
``````

### Different class for the last element in ng-repeat

``````<div ng-repeat="file in files" ng-class="!\$last ? 'class-for-last' : 'other'">
{{file.name}}
</div>
``````

That works for me! Good luck!

### Android Studio - Emulator - eglSurfaceAttrib not implemented

I've found the same thing, but only on emulators that have the Use Host GPU setting ticked. Try turning that off, you'll no longer see those warnings (and the emulator will run horribly, horribly slowly..)

In my experience those warnings are harmless. Notice that the "error" is EGL_SUCCESS, which would seem to indicate no error at all!

### Cannot GET / Nodejs Error

I think you're missing your routes, you need to define at least one route for example '/' to index.

e.g.

``````app.get('/', function (req, res) {
res.render('index', {});
});
``````

### How do you get the index of the current iteration of a foreach loop?

``````int i = 0;
foreach (var item in Collection)
{
item.index = i;
++i;
}
``````

### Using \$state methods with \$stateChangeStart toState and fromState in Angular ui-router

#### Suggestion 1

When you add an object to `\$stateProvider.state` that object is then passed with the state. So you can add additional properties which you can read later on when needed.

Example route configuration

``````\$stateProvider
.state('public', {
abstract: true,
module: 'public'
})
module: 'public'
})
.state('tool', {
abstract: true,
module: 'private'
})
.state('tool.suggestions', {
url: '/suggestions',
module: 'private'
});
``````

The `\$stateChangeStart` event gives you acces to the `toState` and `fromState` objects. These state objects will contain the configuration properties.

Example check for the custom module property

``````\$rootScope.\$on('\$stateChangeStart', function(e, toState, toParams, fromState, fromParams) {
if (toState.module === 'private' && !\$cookies.Session) {
// If logged out and transitioning to a logged in page:
e.preventDefault();
} else if (toState.module === 'public' && \$cookies.Session) {
// If logged in and transitioning to a logged out page:
e.preventDefault();
\$state.go('tool.suggestions');
};
});
``````

I didn't change the logic of the cookies because I think that is out of scope for your question.

#### Suggestion 2

You can create a Helper to get you this to work more modular.

Value `publicStates`

``````myApp.value('publicStates', function(){
return {
module: 'public',
routes: [{
config: {
}
}]
};
});
``````

Value `privateStates`

``````myApp.value('privateStates', function(){
return {
module: 'private',
routes: [{
name: 'suggestions',
config: {
url: '/suggestions'
}
}]
};
});
``````

The Helper

``````myApp.provider('stateshelperConfig', function () {
this.config = {
// These are the properties we need to set
// \$stateProvider: undefined
process: function (stateConfigs){
var module = stateConfigs.module;
\$stateProvider = this.\$stateProvider;
\$stateProvider.state(module, {
abstract: true,
module: module
});
angular.forEach(stateConfigs, function (route){
route.config.module = module;
\$stateProvider.state(module + route.name, route.config);
});
}
};

this.\$get = function () {
return {
config: this.config
};
};
});
``````

Now you can use the helper to add the state configuration to your state configuration.

``````myApp.config(['\$stateProvider', '\$urlRouterProvider',
'stateshelperConfigProvider', 'publicStates', 'privateStates',
function (\$stateProvider, \$urlRouterProvider, helper, publicStates, privateStates) {
helper.config.\$stateProvider = \$stateProvider;
helper.process(publicStates);
helper.process(privateStates);
}]);
``````

This way you can abstract the repeated code, and come up with a more modular solution.

Note: the code above isn't tested

### Best way to format multiple 'or' conditions in an if statement (Java)

Use a collection of some sort - this will make the code more readable and hide away all those constants. A simple way would be with a list:

``````// Declared with constants
private static List<Integer> myConstants = new ArrayList<Integer>(){{
}};

// Wherever you are checking for presence of the constant
if(myConstants.contains(x)){
// ETC
}
``````

As Bohemian points out the list of constants can be static so it's accessible in more than one place.

For anyone interested, the list in my example is using double brace initialization. Since I ran into it recently I've found it nice for writing quick & dirty list initializations.

### Jquery Chosen plugin - dynamically populate list by Ajax

This might be helpful. You have to just trigger an event.

``````\$("#DropDownID").trigger("liszt:updated");
``````

Where "DropDownID" is ID of `<select>`.

### How do I check if a string is unicode or ascii?

#### How to tell if an object is a unicode string or a byte string

You can use `type` or `isinstance`.

In Python 2:

``````>>> type(u'abc')  # Python 2 unicode string literal
<type 'unicode'>
>>> type('abc')   # Python 2 byte string literal
<type 'str'>
``````

In Python 2, `str` is just a sequence of bytes. Python doesn't know what its encoding is. The `unicode` type is the safer way to store text. If you want to understand this more, I recommend http://farmdev.com/talks/unicode/.

In Python 3:

``````>>> type('abc')   # Python 3 unicode string literal
<class 'str'>
>>> type(b'abc')  # Python 3 byte string literal
<class 'bytes'>
``````

In Python 3, `str` is like Python 2's `unicode`, and is used to store text. What was called `str` in Python 2 is called `bytes` in Python 3.

#### How to tell if a byte string is valid utf-8 or ascii

You can call `decode`. If it raises a UnicodeDecodeError exception, it wasn't valid.

``````>>> u_umlaut = b'\xc3\x9c'   # UTF-8 representation of the letter 'Ü'
>>> u_umlaut.decode('utf-8')
u'\xdc'
>>> u_umlaut.decode('ascii')
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 0: ordinal not in range(128)
``````

### Run javascript script (.js file) in mongodb including another file inside js

To call external file you can use :

Exemple: if your file.js file is on your "Documents" file (on windows OS), you can type:

### How can I make a .NET Windows Forms application that only runs in the System Tray?

``````this.WindowState = FormWindowState.Minimized;
``````

to your form object. You will see only an icon at system tray.

### Changing default shell in Linux

You should have a 'skeleton' somewhere in `/etc`, probably `/etc/skeleton`, or check the default settings, probably `/etc/default` or something. Those are scripts that define standard environment variables getting set during a login.

If it is just for your own account: check the (hidden) file `~/.profile` and `~/.login`. Or generate them, if they don't exist. These are also evaluated by the login process.

### Operation is not valid due to the current state of the object, when I select a dropdown list

Issue happens because Microsoft Security Update MS11-100 limits number of keys in Forms collection during HTTP POST request. To alleviate this problem you need to increase that number.

This can be done in your application Web.Config in the `<appSettings>` section (create the section directly under `<configuration>` if it doesn’t exist). Add 2 lines similar to the lines below to the section:

``````<add key="aspnet:MaxHttpCollectionKeys" value="2000" />
``````

The above example set the limit to 2000 keys. This will lift the limitation and the error should go away.

### Where to find free public Web Services?

Here you can find some public REST services for encryption and security related things: http://security.jelastic.servint.net

Keep in mind that database tables are designed to grow vertically (more rows), not horizontally (more columns)

### How to solve maven 2.6 resource plugin dependency?

Step 1 : Check the proxy configured in eclipse is correct or not ? (Window->Preferences->General->Network Connections).

Step 2 : Right Click on Project-> Go to Maven -> Update the project

Step 3: Run as Maven Install.

==== By Following these steps, i am able to solve this error.

### How can I generate a list of consecutive numbers?

Just to give you another example, although range(value) is by far the best way to do this, this might help you later on something else.

``````list = []
calc = 0

while int(calc) < 9:
list.append(calc)
calc = int(calc) + 1

print list
[0, 1, 2, 3, 4, 5, 6, 7, 8]
``````

### Warning "Do not Access Superglobal \$_POST Array Directly" on Netbeans 7.4 for PHP

Although a bit late, I've come across this question while searching the solution for the same problem, so I hope it can be of any help...

Found myself in the same darkness than you. Just found this article, which explains some new hints introduced in NetBeans 7.4, including this one:

https://blogs.oracle.com/netbeansphp/entry/improve_your_code_with_new

The reason why it has been added is because superglobals usually are filled with user input, which shouldn't ever be blindly trusted. Instead, some kind of filtering should be done, and that's what the hint suggests. Filter the superglobal value in case it has some poisoned content.

``````\$_SERVER['SERVER_NAME']
``````

``````filter_input(INPUT_SERVER, 'SERVER_NAME', FILTER_SANITIZE_STRING)
``````

You have the filter_input and filters doc here:

http://www.php.net/manual/en/function.filter-input.php

http://www.php.net/manual/en/filter.filters.php

### C/C++ check if one bit is set in, i.e. int variable

The precedent answers show you how to handle bit checks, but more often then not, it is all about flags encoded in an integer, which is not well defined in any of the precedent cases.

In a typical scenario, flags are defined as integers themselves, with a bit to 1 for the specific bit it refers to. In the example hereafter, you can check if the integer has ANY flag from a list of flags (multiple error flags concatenated) or if EVERY flag is in the integer (multiple success flags concatenated).

Following an example of how to handle flags in an integer.

Live example available here: https://rextester.com/XIKE82408

``````//g++  7.4.0

#include <iostream>
#include <stdint.h>

inline bool any_flag_present(unsigned int value, unsigned int flags) {
return bool(value & flags);
}

inline bool all_flags_present(unsigned int value, unsigned int flags) {
return (value & flags) == flags;
}

enum: unsigned int {
ERROR_1 = 1U,
ERROR_2 = 2U, // or 0b10
ERROR_3 = 4U, // or 0b100
SUCCESS_1 = 8U,
SUCCESS_2 = 16U,
OTHER_FLAG = 32U,
};

int main(void)
{
unsigned int value = 0b101011; // ERROR_1, ERROR_2, SUCCESS_1, OTHER_FLAG
unsigned int all_error_flags = ERROR_1 | ERROR_2 | ERROR_3;
unsigned int all_success_flags = SUCCESS_1 | SUCCESS_2;

std::cout << "Was there at least one error: " << any_flag_present(value, all_error_flags) << std::endl;
std::cout << "Are all success flags enabled: " << all_flags_present(value, all_success_flags) << std::endl;
std::cout << "Is the other flag enabled with eror 1: " << all_flags_present(value, ERROR_1 | OTHER_FLAG) << std::endl;
return 0;
}
``````

### How to enable back/left swipe gesture in UINavigationController after setting leftBarButtonItem?

This answer, but with storyboard support.

``````class SwipeNavigationController: UINavigationController {

// MARK: - Lifecycle

override init(rootViewController: UIViewController) {
super.init(rootViewController: rootViewController)
}

override init(nibName nibNameOrNil: String?, bundle nibBundleOrNil: Bundle?) {
super.init(nibName: nibNameOrNil, bundle: nibBundleOrNil)

self.setup()
}

self.setup()
}

private func setup() {
delegate = self
}

// This needs to be in here, not in init
interactivePopGestureRecognizer?.delegate = self
}

deinit {
delegate = nil
interactivePopGestureRecognizer?.delegate = nil
}

// MARK: - Overrides

override func pushViewController(_ viewController: UIViewController, animated: Bool) {
duringPushAnimation = true

super.pushViewController(viewController, animated: animated)
}

// MARK: - Private Properties

fileprivate var duringPushAnimation = false
}
``````

### converting Java bitmap to byte array

Try this to convert String-Bitmap or Bitmap-String

``````/**
* @param bitmap
* @return converting bitmap and return a string
*/
public static String BitMapToString(Bitmap bitmap){
ByteArrayOutputStream baos=new ByteArrayOutputStream();
bitmap.compress(Bitmap.CompressFormat.PNG,100, baos);
byte [] b=baos.toByteArray();
String temp=Base64.encodeToString(b, Base64.DEFAULT);
return temp;
}

/**
* @param encodedString
* @return bitmap (from given string)
*/
public static Bitmap StringToBitMap(String encodedString){
try{
byte [] encodeByte=Base64.decode(encodedString,Base64.DEFAULT);
Bitmap bitmap= BitmapFactory.decodeByteArray(encodeByte, 0, encodeByte.length);
return bitmap;
}catch(Exception e){
e.getMessage();
return null;
}
}
``````

### Why does DEBUG=False setting make my django Static Files Access fail?

You actually can serve static files in a production Django app, securely and without `DEBUG=True`.

Rather than using Django itself, use dj_static in your WSGI file (github):

``````# requirements.txt:

...
dj-static==0.0.6

# YOURAPP/settings.py:

...
STATIC_ROOT = 'staticdir'
STATIC_URL = '/staticpath/'

# YOURAPP/wsgi.py:

...
from django.core.wsgi import get_wsgi_application
from dj_static import Cling

application = Cling(get_wsgi_application())
``````

### jQuery disable/enable submit button

We can simply have if & else .if suppose your input is empty we can have

``````if(\$(#name).val() != '') {
\$('input[type="submit"]').attr('disabled' , false);
}
``````

else we can change false into true

### Random string generation with upper case letters and digits

``````>>> import string
>>> import random
``````

the following logic still generates 6 character random sample

``````>>> print ''.join(random.sample((string.ascii_uppercase+string.digits),6))
JT7K3Q
``````

No need to multiply by 6

``````>>> print ''.join(random.sample((string.ascii_uppercase+string.digits)*6,6))

TK82HK
``````

### Creating composite primary key in SQL Server

it simple, select columns want to insert primary key and click on Key icon on header and save table

happy coding..,

### jQuery getJSON save result into variable

\$.getJSon expects a callback functions either you pass it to the callback function or in callback function assign it to global variale.

``````var globalJsonVar;

\$.getJSON("http://127.0.0.1:8080/horizon-update", function(json){
//do some thing with json  or assign global variable to incoming json.
globalJsonVar=json;
});
``````

IMO best is to call the callback function. which is nicer to eyes, readability aspects.

``````\$.getJSON("http://127.0.0.1:8080/horizon-update", callbackFuncWithData);

function callbackFuncWithData(data)
{
// do some thing with data
}
``````

### Compare dates with javascript

you can done this way also.

``````if (dateFormat(first, "yyyy-mm-dd") > dateFormat(second, "yyyy-mm-dd")) {
console.log("done");
}
``````

OR

``````if (dateFormat(first, "mm-dd-yyyy") >  dateFormat(second, "mm-dd-yyyy")) {
console.log("done");
}
``````

i use following plugin for dateFormat()

``````        var dateFormat = function () {
var token = /d{1,4}|m{1,4}|yy(?:yy)?|([HhMsTt])\1?|[LloSZ]|"[^"]*"|'[^']*'/g,
timezone = /\b(?:[PMCEA][SDP]T|(?:Pacific|Mountain|Central|Eastern|Atlantic) (?:Standard|Daylight|Prevailing) Time|(?:GMT|UTC)(?:[-+]\d{4})?)\b/g,
timezoneClip = /[^-+\dA-Z]/g,
pad = function (val, len) {
val = String(val);
len = len || 2;
while (val.length < len) val = "0" + val;
return val;
};

// Regexes and supporting functions are cached through closure
return function (date, mask, utc) {
var dF = dateFormat;

// You can't provide utc if you skip other args (use the "UTC:" mask prefix)
if (arguments.length == 1 && Object.prototype.toString.call(date) == "[object String]" && !/\d/.test(date)) {
date = undefined;
}

// Passing date through Date applies Date.parse, if necessary
date = date ? new Date(date) : new Date;
if (isNaN(date)) throw SyntaxError("invalid date");

// Allow setting the utc argument via the mask
if (mask.slice(0, 4) == "UTC:") {
utc = true;
}

var _ = utc ? "getUTC" : "get",
d = date[_ + "Date"](),
D = date[_ + "Day"](),
m = date[_ + "Month"](),
y = date[_ + "FullYear"](),
H = date[_ + "Hours"](),
M = date[_ + "Minutes"](),
s = date[_ + "Seconds"](),
L = date[_ + "Milliseconds"](),
o = utc ? 0 : date.getTimezoneOffset(),
flags = {
d:    d,
ddd:  dF.i18n.dayNames[D],
dddd: dF.i18n.dayNames[D + 7],
m:    m + 1,
mmm:  dF.i18n.monthNames[m],
mmmm: dF.i18n.monthNames[m + 12],
yy:   String(y).slice(2),
yyyy: y,
h:    H % 12 || 12,
hh:   pad(H % 12 || 12),
H:    H,
M:    M,
s:    s,
L:    pad(L > 99 ? Math.round(L / 10) : L),
t:    H < 12 ? "a"  : "p",
tt:   H < 12 ? "am" : "pm",
T:    H < 12 ? "A"  : "P",
TT:   H < 12 ? "AM" : "PM",
Z:    utc ? "UTC" : (String(date).match(timezone) || [""]).pop().replace(timezoneClip, ""),
o:    (o > 0 ? "-" : "+") + pad(Math.floor(Math.abs(o) / 60) * 100 + Math.abs(o) % 60, 4),
S:    ["th", "st", "nd", "rd"][d % 10 > 3 ? 0 : (d % 100 - d % 10 != 10) * d % 10]
};

return \$0 in flags ? flags[\$0] : \$0.slice(1, \$0.length - 1);
});
};
}();

// Some common format strings
"default":      "ddd mmm dd yyyy HH:MM:ss",
shortDate:      "m/d/yy",
mediumDate:     "mmm d, yyyy",
longDate:       "mmmm d, yyyy",
fullDate:       "dddd, mmmm d, yyyy",
shortTime:      "h:MM TT",
mediumTime:     "h:MM:ss TT",
longTime:       "h:MM:ss TT Z",
isoDate:        "yyyy-mm-dd",
isoTime:        "HH:MM:ss",
isoDateTime:    "yyyy-mm-dd'T'HH:MM:ss",
isoUtcDateTime: "UTC:yyyy-mm-dd'T'HH:MM:ss'Z'"
};

// Internationalization strings
dateFormat.i18n = {
dayNames: [
"Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat",
"Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"
],
monthNames: [
"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec",
"January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"
]
};

// For convenience...
Date.prototype.format = function (mask, utc) {
};
``````

### GET parameters in the URL with CodeIgniter

MY_Input.php :

``````<?php
// this class extension allows for \$_GET access
class MY_Input extends CI_input {

function _sanitize_globals()
{
// setting allow_get_array to true is the only real modification
\$this->allow_get_array = TRUE;

parent::_sanitize_globals();
}

}
/* End of file MY_Input.php */
/* Location: .application/libraries/MY_Input.php */
``````

MY_URI.php :

``````<?php
/*
| this class extension allows for \$_GET access by retaining the
| standard functionality of allowing query strings to build the
| URI String, but checks if enable_query_strings is TRUE
*/
class MY_URI extends CI_URI{

function _fetch_uri_string()
{
if (strtoupper(\$this->config->item('uri_protocol')) == 'AUTO')
{
// If the URL has a question mark then it's simplest to just
// build the URI string from the zero index of the \$_GET array.
// This avoids having to deal with \$_SERVER variables, which
// can be unreliable in some environments
//
//  *** THE ONLY MODIFICATION (EXTENSION) TO THIS METHOD IS TO CHECK
//      IF enable_query_strings IS TRUE IN THE LINE BELOW ***
if (\$this->config->item('enable_query_strings') === TRUE && is_array(\$_GET) && count(\$_GET) == 1 && trim(key(\$_GET), '/') != '')
{
\$this->uri_string = key(\$_GET);
return;
}

// Is there a PATH_INFO variable?
// Note: some servers seem to have trouble with getenv() so we'll test it two ways
\$path = (isset(\$_SERVER['PATH_INFO'])) ? \$_SERVER['PATH_INFO'] : @getenv('PATH_INFO');
if (trim(\$path, '/') != '' && \$path != "/".SELF)
{
\$this->uri_string = \$path;
return;
}

// No PATH_INFO?... What about QUERY_STRING?
\$path =  (isset(\$_SERVER['QUERY_STRING'])) ? \$_SERVER['QUERY_STRING'] : @getenv('QUERY_STRING');
if (trim(\$path, '/') != '')
{
\$this->uri_string = \$path;
return;
}

// No QUERY_STRING?... Maybe the ORIG_PATH_INFO variable exists?
\$path = str_replace(\$_SERVER['SCRIPT_NAME'], '', (isset(\$_SERVER['ORIG_PATH_INFO'])) ? \$_SERVER['ORIG_PATH_INFO'] : @getenv('ORIG_PATH_INFO'));
if (trim(\$path, '/') != '' && \$path != "/".SELF)
{
// remove path and script information so we have good URI data
\$this->uri_string = \$path;
return;
}

// We've exhausted all our options...
\$this->uri_string = '';
}
else
{
\$uri = strtoupper(\$this->config->item('uri_protocol'));

if (\$uri == 'REQUEST_URI')
{
\$this->uri_string = \$this->_parse_request_uri();
return;
}

\$this->uri_string = (isset(\$_SERVER[\$uri])) ? \$_SERVER[\$uri] : @getenv(\$uri);
}

// If the URI contains only a slash we'll kill it
if (\$this->uri_string == '/')
{
\$this->uri_string = '';
}
}

}
/* End of file MY_URI.php */
/* Location: .application/libraries/MY_URI.php */
``````

### What does \$ mean before a string?

Note that you can also combine the two, which is pretty cool (although it looks a bit odd):

``````// simple interpolated verbatim string
``````

### PyLint "Unable to import" error - how to set PYTHONPATH?

If you are using Cython in Linux, I resolved removing `module.cpython-XXm-X-linux-gnu.so` files in my project target directory.

### How do you convert a JavaScript date to UTC?

My solution keeps the date the same no matter what timezone is set on the client-side. Maybe someone will find it useful.

My use case:

I'm creating a todo app, where you set date of your task. This date should remain constant no matter what timezone you're in.

Example. You want to call your friend at 8 am on June 25th.

You create this task 5 days before (June 20th) while you're in China.

Then, on the same day, you fly to New York for a few days.

Then on June 25th, while you're still in New York, you wake up at 7:30 am (which means you should receive task notification in 30 mins (even tho it's 1:30 pm already in China where you were when creating the task)

So the task is ignoring the timezone. It means 'I want to do it at 8 am in whatever timezone I'll be in'.

What I do is let's say 'I assume you're always in London Timezone - UTC'.

What it means is - when the user picks some date in her/his Timezone - I convert this date to the same date in UTC. ie. You pick 8 am in China, but I convert it to 8 am in UTC.

Then - next time you open the app - I read the date saved in UTC and convert it to the same date in your current timezone - eg. I convert 8 am in UTC to 8 am in the New York timezone.

This solution means that the date can mean something else depending on where you are when setting it and where you're reading it, but it remains constant in a way that it 'feels' like you're always in the same timezone.

Let's write some code:

First - we have 2 main functions for converting from/to UTC ignoring timezone:

``````export function convertLocalDateToUTCIgnoringTimezone(date: Date) {
const timestamp = Date.UTC(
date.getFullYear(),
date.getMonth(),
date.getDate(),
date.getHours(),
date.getMinutes(),
date.getSeconds(),
date.getMilliseconds(),
);

return new Date(timestamp);
}

export function convertUTCToLocalDateIgnoringTimezone(utcDate: Date) {
return new Date(
utcDate.getUTCFullYear(),
utcDate.getUTCMonth(),
utcDate.getUTCDate(),
utcDate.getUTCHours(),
utcDate.getUTCMinutes(),
utcDate.getUTCSeconds(),
utcDate.getUTCMilliseconds(),
);
}
``````

Then, I save/read this date like:

``````function saveTaskDate(localDate: Date) {
// I convert your local calendar date so it looks like you've picked it being in UTC somewhere around London
const utcDate = convertLocalDateToUTCIgnoringTimezone(localDate);
}

// I convert this UTC date to 'look in your local timezone' as if you were now in UTC somewhere around london

// this date will have the same calendar day as the one you've picked previously
// no matter where you were saving it and where you are now
}
``````

### Cannot invoke an expression whose type lacks a call signature

As mentioned in the github issue originally linked by @peter in the comments:

``````const freshFruits = (fruits as (Apple | Pear)[]).filter((fruit: (Apple | Pear)) => !fruit.isDecayed);
``````

### How can I refresh c# dataGridView after update ?

I use the DataGridView's `Invalidate()` function. However, that will refresh the entire DataGridView. If you want to refresh a particular row, you use `dgv.InvalidateRow(rowIndex)`. If you want to refresh a particular cell, you can use `dgv.InvalidateCell(columnIndex, rowIndex)`. This is of course assuming you're using a binding source or data source.

### How do I (or can I) SELECT DISTINCT on multiple columns?

``````SELECT DISTINCT a,b,c FROM t
``````

is roughly equivalent to:

``````SELECT a,b,c FROM t GROUP BY a,b,c
``````

It's a good idea to get used to the GROUP BY syntax, as it's more powerful.

For your query, I'd do it like this:

``````UPDATE sales
SET status='ACTIVE'
WHERE id IN
(
SELECT id
FROM sales S
INNER JOIN
(
SELECT saleprice, saledate
FROM sales
GROUP BY saleprice, saledate
HAVING COUNT(*) = 1
) T
ON S.saleprice=T.saleprice AND s.saledate=T.saledate
)
``````

### Suppress warning messages using mysql from within Terminal, but password written in bash script

You can also run the mysql_config_editor in your script to pass in the password when specifying the login path

``````expect -c "
"
``````

This starts an expect session which can be used in scripts to interact with prompts

See this post

### How to style a div to be a responsive square?

Works on almost all browsers.

You can try giving `padding-bottom` as a percentage.

``````<div style="height:0;width:20%;padding-bottom:20%;background-color:red">
<div>
Content goes here
</div>
</div>
``````

The outer div is making a square and inner div contains the content. This solution worked for me many times.

Here's a jsfiddle

### How to open a different activity on recyclerView item onclick

iconView = (ImageView) itemLayoutView .findViewById(R.id.iconId);

``````        itemLayoutView.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {

Intent intent = new Intent(v.getContext(), SecondPage.class);
v.getContext().startActivity(intent);
Toast.makeText(v.getContext(), "os version is: " + feed.getTitle(), Toast.LENGTH_SHORT).show();
}
});
``````

### Java Desktop application: SWT vs. Swing

An important thing to consider is that some users and some resellers (Dell) install a 64 bit VM on their 64 bit Windows, and you can't use the same SWT library on 32 bit and 64 bit VMs.

This means you will need to distribute and test different packages depending on whether users have 32-bit or a 64-bit Java VM. See this problem with Azureus, for instance, but you also have it with Eclipse, where as of today the builds on the front download page do not run on a 64 bit VM.

### How to convert Seconds to HH:MM:SS using T-SQL

This is what I use (typically for html table email reports)

``````declare @time int, @hms varchar(20)
set @time = 12345
set @hms = cast(cast((@Time)/3600 as int) as varchar(3))
+':'+ right('0'+ cast(cast(((@Time)%3600)/60 as int) as varchar(2)),2)
+':'+ right('0'+ cast(((@Time)%3600)%60 as varchar(2)),2) +' (hh:mm:ss)'
select @hms
``````

### jackson deserialization json to java-objects

It looks like you are trying to read an object from JSON that actually describes an array. Java objects are mapped to JSON objects with curly braces `{}` but your JSON actually starts with square brackets `[]` designating an array.

What you actually have is a `List<product>` To describe generic types, due to Java's type erasure, you must use a `TypeReference`. Your deserialization could read: `myProduct = objectMapper.readValue(productJson, new TypeReference<List<product>>() {});`

A couple of other notes: your classes should always be PascalCased. Your main method can just be `public static void main(String[] args) throws Exception` which saves you all the useless `catch` blocks.

### Best way to restrict a text field to numbers only?

I know that there are already many answers but for the sake of simplicity i would like to add another answer which is simple and self explanatory in which we do not have to remember keycodes and it also works across all browsers.

_x000D_
_x000D_
``````document.getElementById('myinput').onkeydown = function(e)_x000D_
{_x000D_
console.log(e.key);_x000D_
//console.log(e.target.value);_x000D_
switch (e.key)_x000D_
{_x000D_
case "1":_x000D_
case "2":_x000D_
case "3":_x000D_
case "4":_x000D_
case "5":_x000D_
case "6":_x000D_
case "7":_x000D_
case "8":_x000D_
case "9":_x000D_
case "0":_x000D_
case "Backspace":_x000D_
return true;_x000D_
break;_x000D_
_x000D_
case ".":_x000D_
if (e.target.value.indexOf(".") == -1)_x000D_
{_x000D_
return true;_x000D_
}_x000D_
else_x000D_
{_x000D_
return false;_x000D_
}_x000D_
break;_x000D_
_x000D_
default:_x000D_
return false;_x000D_
}_x000D_
_x000D_
}``````
_x000D_
``<input type="text" placeholder="Enter Value" id="myinput" />``
_x000D_
_x000D_
_x000D_

### response.sendRedirect() from Servlet to JSP does not seem to work

Since you already have sent some data,

``````System.out.println("going to demo.jsp");
``````

you won't be able to send a redirect.

### How to convert String to Date value in SAS?

Formats like

``````date9.
``````

or

``````mmddyy10.
``````

are not valid for input command while converting text to a sas date. You can use

``````Date = input( cdate , ANYDTDTE11.);
``````

or

``````Date = input( cdate , ANYDTDTE10.);
``````

for conversion.

### Reading numbers from a text file into an array in C

`5623125698541159` is treated as a single number (out of range of `int` on most architecture). You need to write numbers in your file as

``````5 6 2 3 1 2 5  6 9 8 5 4 1 1 5 9
``````

for 16 numbers.

``````5,6,2,3,1,2,5,6,9,8,5,4,1,1,5,9
``````

then change `%d` specifier in your `fscanf` to `%d,`.

``````  fscanf(myFile, "%d,", &numberArray[i] );
``````

Here is your full code after few modifications:

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

int main(){

FILE *myFile;

int numberArray[16];
int i;

if (myFile == NULL){
exit (0);
}

for (i = 0; i < 16; i++){
fscanf(myFile, "%d,", &numberArray[i] );
}

for (i = 0; i < 16; i++){
printf("Number is: %d\n\n", numberArray[i]);
}

fclose(myFile);

return 0;
}
``````

### Neither BindingResult nor plain target object for bean name available as request attribute

You would have got this Exception while doing a `GET` on `http://localhost:8080/projectname/login`

As Vinay has correctly stated you can definitely use

``````@RequestMapping(value = "/login", method = RequestMethod.GET)
}
``````

But I am going to provide some alternative syntax which I think you were trying with Spring 3.0.

You can also achieve the above functionality with

``````@RequestMapping(value = "/login", method = RequestMethod.GET)
}
``````

and it `login.jsp` (assuming you are using `InternalResourceViewResolver`) you can have

``````<form:form method="POST" action="login.htm" modelAttribute="login">
``````

Notice : modelAttribute is `login` and not `loginModel`. It is as per the class name you provide in argument. But if you want to use `loginModel` as modelAttribute is jsp you can do the following

``````@RequestMapping(value = "/login", method = RequestMethod.GET)
}
``````

and jsp would have

``````<form:form method="POST" action="login.htm" modelAttribute="loginModel">
``````

I know there are just different ways for doing the same thing. But the most important point to note here -

Imp Note: When you add your model class in your methods argument (like `public String displayLogin(Login loginModel)`) it is automatically created and added to your Model object (which is why you can directly access it in JSP without manually putting it in model). Then it will search your request if request has attributes that it can map with the new ModelObject create. If yes Spring will inject values from request parameters to your custom model object class (Login in this case).

You can test this by doing

``````@RequestMapping(value = "/login", method = RequestMethod.GET)
}
``````

Note : Above creating of new custom model object may not hold true if you have given `@SessionAttributes({"login"})`. In this case it will get from session and populate values.

### Update value of a nested dictionary of varying depth

Another way of using recursion:

``````def updateDict(dict1,dict2):
keys1 = list(dict1.keys())
keys2= list(dict2.keys())
keys2 = [x for x in keys2 if x in keys1]
for x in keys2:
if (x in keys1) & (type(dict1[x]) is dict) & (type(dict2[x]) is dict):
updateDict(dict1[x],dict2[x])
else:
dict1.update({x:dict2[x]})
return(dict1)
``````

### CSS table-cell equal width

This can be done by setting table-cell style to `width: auto`, and content empty. The columns are now equal-wide, but holding no content.

To insert content to the cell, add an `div` with css:

``````position: absolute;
left: 0;
top: 0;
right: 0;
bottom: 0;
``````

You also need to add `position: relative` to the cells.

Now you can put the actual content into the div talked above.

https://jsfiddle.net/vensdvvb/

### How to remove outliers from a dataset

Try this. Feed your variable in the function and save the o/p in the variable which would contain removed outliers

``````outliers<-function(variable){
iqr<-IQR(variable)
q1<-as.numeric(quantile(variable,0.25))
q3<-as.numeric(quantile(variable,0.75))
mild_low<-q1-(1.5*iqr)
mild_high<-q3+(1.5*iqr)
new_variable<-variable[variable>mild_low & variable<mild_high]
return(new_variable)
}
``````

Note: You need to explicitly set width and height Make sure the phone dialer, and web browser capabilities are enabled

Followup note: Make sure that after you've removed the SDK DLL, that the xmlns references are not still pointing to it. The best route to take here is

1. Remove the XAML for the ad
2. Remove the xmlns declaration (usually at the top of the page, but sometimes will be declared in the ad itself)
3. Remove the bad DLL (the one ending in .SDK )
4. Do a Clean and then Build (clean out anything remaining from the DLL)
5. Add the xmlns reference (actual reference is below)

Here is the xmlns reference:

``xmlns:AdNamepace="clr-namespace:Microsoft.Advertising.Mobile.UI;assembly=Microsoft.Advertising.Mobile.UI" ``

``<AdNamespace:AdControl x:Name="myAd" Height="80" Width="480"                    AdUnitId="yourAdUnitIdHere" ApplicationId="yourIdHere"/> ``

### Compare cell contents against string in Excel

You can use the `EXACT` Function for exact string comparisons.

``````=IF(EXACT(A1, "ENG"), 1, 0)
``````

### onclick on a image to navigate to another page using Javascript

You can define a a click function and then set the `onclick` attribute for the element.

``````function imageClick(url) {
window.location = url;
}

<img src="../images/bottle.jpg" alt="bottle" class="thumbnails" onclick="imageClick('../images/bottle.html')" />
``````

This approach lets you get rid of the surrounding `<a>` element. If you want to keep it, then define the `onclick` attribute on `<a>` instead of on `<img>`.

### How to use double or single brackets, parentheses, curly braces

#### Parentheses in function definition

Parentheses `()` are being used in function definition:

``````function_name () { command1 ; command2 ; }
``````

That is the reason you have to escape parentheses even in command parameters:

``````\$ echo (
bash: syntax error near unexpected token `newline'

\$ echo \(
(

\$ echo () { command echo The command echo was redefined. ; }
\$ echo anything
The command echo was redefined.
``````

### What is a 'workspace' in Visual Studio Code?

1. Open file menu and select `Save Workspace As`, that will save current explorer status.
2. After that you can chose file->`Open Workspace` to open before saved workspace.

### Change a Git remote HEAD to point to something besides master

There was almost the same question on GitHub a year ago.

The idea was to rename the master branch:

``````git branch -m master development
git branch -m published master
git push -f origin master
``````

Making master have what you want people to use, and do all other work in branches.

(a "`git-symbolic-ref HEAD refs/head/published`" would not be propagated to the remote repo)

This is similar to "How do I delete origin/master in Git".

As said in this thread: (emphasis mine)

"`git clone`" creates only a single local branch.
To do that, it looks at the `HEAD ref` of the remote repo, and creates a local branch with the same name as the remote branch referenced by it.

So to wrap that up, you have repo `A` and clone it:

• `HEAD` references `refs/heads/master` and that exists
-> you get a local branch called `master`, starting from `origin/master`

• HEAD references `refs/heads/anotherBranch` and that exists
-> you get a local branch called `anotherBranch`, starting from `origin/anotherBranch`

• HEAD references `refs/heads/master` and that doesn't exist
-> "`git clone`" complains

Not sure if there's any way to directly modify the `HEAD` ref in a repo.

(which is the all point of your question, I know ;) )

Maybe the only way would be a "publication for the poor", where you:

`````` \$ git-symbolic-ref HEAD refs/head/published
\$ git-update-server-info
\$ rsync -az .git/* server:/local_path_to/git/myRepo.git/
``````

But that would involve write access to the server, which is not always possible.

As I explain in "Git: Correct way to change Active Branch in a bare repository?", `git remote set-head` wouldn't change anything on the remote repo.

It would only change the remote tracking branch stored locally in your local repo, in `remotes/<name>/HEAD`.

With Git 2.29 (Q4 2020), "`git remote set-head`(man)" that failed still said something that hints the operation went through, which was misleading.

See commit 5a07c6c (17 Sep 2020) by Christian Schlack (`cschlack`).
(Merged by Junio C Hamano -- `gitster` -- in commit 39149df, 22 Sep 2020)

#### `remote`: don't show success message when `set-head` fails

Signed-off-by: Christian Schlack

Suppress the message 'origin/HEAD set to master' in case of an error.

``````\$ git remote set-head origin -a
error: Not a valid ref: refs/remotes/origin/master
``````

### How do I programmatically "restart" an Android app?

With the Process Phoenix library. The Activity you want to relaunch is named "A".

Java flavor

``````// Java
public void restart(){
ProcessPhoenix.triggerRebirth(context);
}
``````

Kotlin flavor

``````// kotlin
fun restart() {
ProcessPhoenix.triggerRebirth(context)
}
``````

### Nth word in a string variable

An alternative

``````N=3
STRING="one two three four"

arr=(\$STRING)
echo \${arr[N-1]}
``````

### Capturing Groups From a Grep RegEx

I prefer the one line `python` or `perl` command, both often included in major linux disdribution

``````echo \$'
<a href="http://stackoverflow.com">
</a>
</a>
' |  python -c \$'
import re
import sys
for i in sys.stdin:
g=re.match(r\'.*href="(.*)"\',i);
if g is not None:
print g.group(1)
'
``````

and to handle files:

``````ls *.txt | python -c \$'
import sys
import re
for i in sys.stdin:
i=i.strip()
f=open(i,"r")
for j in f:
g=re.match(r\'.*href="(.*)"\',j);
if g is not None:
print g.group(1)
f.close()
'
``````

### Why is quicksort better than mergesort?

As many people have noted, the average case performance for quicksort is faster than mergesort. But this is only true if you are assuming constant time to access any piece of memory on demand.

In RAM this assumption is generally not too bad (it is not always true because of caches, but it is not too bad). However if your data structure is big enough to live on disk, then quicksort gets killed by the fact that your average disk does something like 200 random seeks per second. But that same disk has no trouble reading or writing megabytes per second of data sequentially. Which is exactly what mergesort does.

Therefore if data has to be sorted on disk, you really, really want to use some variation on mergesort. (Generally you quicksort sublists, then start merging them together above some size threshold.)

Furthermore if you have to do anything with datasets of that size, think hard about how to avoid seeks to disk. For instance this is why it is standard advice that you drop indexes before doing large data loads in databases, and then rebuild the index later. Maintaining the index during the load means constantly seeking to disk. By contrast if you drop the indexes, then the database can rebuild the index by first sorting the information to be dealt with (using a mergesort of course!) and then loading it into a BTREE datastructure for the index. (BTREEs are naturally kept in order, so you can load one from a sorted dataset with few seeks to disk.)

There have been a number of occasions where understanding how to avoid disk seeks has let me make data processing jobs take hours rather than days or weeks.