Programs & Examples On #Matrix multiplication

Questions related to matrix multiplication, especially implementation. Mathematical questions should consider the linear algebra tag.

Matrix multiplication using arrays

Try this,

``````public static Double[][] multiplicar(Double A[][],Double B[][]){
Double[][] C= new Double[2][2];
int i,j,k;
for (i = 0; i < 2; i++) {
for (j = 0; j < 2; j++) {
C[i][j] = 0.00000;
}
}
for(i=0;i<2;i++){
for(j=0;j<2;j++){
for (k=0;k<2;k++){
C[i][j]+=(A[i][k]*B[k][j]);

}

}
}
return C;
}
``````

matrix multiplication algorithm time complexity

The naive algorithm, which is what you've got once you correct it as noted in comments, is O(n^3).

There do exist algorithms that reduce this somewhat, but you're not likely to find an O(n^2) implementation. I believe the question of the most efficient implementation is still open.

See this wikipedia article on Matrix Multiplication for more information.

Matrix Multiplication in pure Python?

``````m=input("row")
n=input("col")
X=[]
for i in range (m):
m1=[]
for j in range (n):
m1.append(input("num"))
X.append(m1)
Y=[]
for i in range (m):
n1=[]
for j in range (n):
n1.append(input("num"))
Y.append(n1)

# result is 3x3
result = [[0,0,0],
[0,0,0],
[0,0,0]]

# iterate through rows of X
for i in range(len(X)):
# iterate through columns of Y
for j in range(len(Y[0])):
# iterate through rows of Y
for k in range(len(Y)):
result[i][j] += X[i][k] * Y[k][j]

for r in result:
print(r)
``````

How to get element-wise matrix multiplication (Hadamard product) in numpy?

``````import numpy as np
x = np.array([[1,2,3], [4,5,6]])
y = np.array([[-1, 2, 0], [-2, 5, 1]])

x*y
Out:
array([[-1,  4,  0],
[-8, 25,  6]])

%timeit x*y
1000000 loops, best of 3: 421 ns per loop

np.multiply(x,y)
Out:
array([[-1,  4,  0],
[-8, 25,  6]])

%timeit np.multiply(x, y)
1000000 loops, best of 3: 457 ns per loop
``````

Both `np.multiply` and `*` would yield element wise multiplication known as the Hadamard Product

`%timeit` is ipython magic

how does multiplication differ for NumPy Matrix vs Array classes?

There is a situation where the dot operator will give different answers when dealing with arrays as with dealing with matrices. For example, suppose the following:

``````>>> a=numpy.array([1, 2, 3])
>>> b=numpy.array([1, 2, 3])
``````

Lets convert them into matrices:

``````>>> am=numpy.mat(a)
>>> bm=numpy.mat(b)
``````

Now, we can see a different output for the two cases:

``````>>> print numpy.dot(a.T, b)
14
>>> print am.T*bm
[[1.  2.  3.]
[2.  4.  6.]
[3.  6.  9.]]
``````

Difference between numpy dot() and Python 3.5+ matrix multiplication @

In mathematics, I think the dot in numpy makes more sense

dot(a,b)_{i,j,k,a,b,c} =

since it gives the dot product when a and b are vectors, or the matrix multiplication when a and b are matrices

As for matmul operation in numpy, it consists of parts of dot result, and it can be defined as

>matmul(a,b)_{i,j,k,c} =

So, you can see that matmul(a,b) returns an array with a small shape, which has smaller memory consumption and make more sense in applications. In particular, combining with broadcasting, you can get

matmul(a,b)_{i,j,k,l} =

for example.

From the above two definitions, you can see the requirements to use those two operations. Assume a.shape=(s1,s2,s3,s4) and b.shape=(t1,t2,t3,t4)

• To use dot(a,b) you need

1. t3=s4;
• To use matmul(a,b) you need

1. t3=s4
2. t2=s2, or one of t2 and s2 is 1
3. t1=s1, or one of t1 and s1 is 1

Use the following piece of code to convince yourself.

Code sample

``````import numpy as np
for it in xrange(10000):
a = np.random.rand(5,6,2,4)
b = np.random.rand(6,4,3)
c = np.matmul(a,b)
d = np.dot(a,b)
#print 'c shape: ', c.shape,'d shape:', d.shape

for i in range(5):
for j in range(6):
for k in range(2):
for l in range(3):
if not c[i,j,k,l] == d[i,j,k,j,l]:
print it,i,j,k,l,c[i,j,k,l]==d[i,j,k,j,l] #you will not see them
``````

Catching multiple exception types in one catch block

Hmm, there are many solution written for php version lower than 7.1.

Here is an other simple one for those who doesn't want catch all exception and can't make common interfaces:

``````<?php
\$ex = NULL
try {
/* ... */
} catch (FirstException \$ex) {
// just do nothing here
} catch (SecondException \$ex) {
// just do nothing here
}
if (\$ex !== NULL) {
// handle those exceptions here!
}
?>
``````

What's the environment variable for the path to the desktop?

I use this code to get the User desktop and Public desktop paths from the registry, tested on Windows XP SP2 pt-PT and Windows 10 b14393 en-US, so it probably works in Vista/7/8 and other languages.

``````:: get user desktop and public desktop paths
for /f "tokens=* delims= " %%a in ('reg query "HKCU\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders" /v Desktop ^|find /i "REG_"') do set "batch_userdesktop=%%a"
for /f "tokens=* delims= " %%a in ('reg query "HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders" /v "Common Desktop" ^|find /i "REG_"') do set "batch_publicdesktop=%%a"

:: remove everything up to and including "_SZ"
set "batch_userdesktop=%batch_userdesktop:*_sz=%"
set "batch_publicdesktop=%batch_publicdesktop:*_sz=%%

:: remove leading spaces and TABs
:loop
if "%batch_userdesktop:~0,1%"==" " set "batch_userdesktop=%batch_userdesktop:~1%" & goto loop
if "%batch_publicdesktop:~0,1%"==" " set "batch_publicdesktop=%batch_publicdesktop:~1%" & goto loop
if "%batch_userdesktop:~0,1%"=="    " set "batch_userdesktop=%batch_userdesktop:~1%" & goto loop
if "%batch_publicdesktop:~0,1%"=="  " set "batch_publicdesktop=%batch_publicdesktop:~1%" & goto loop
``````

The last two lines include a TAB inside the " ", some text editors add spaces when you press TAB, so make sure you have an actual TAB instead of spaces.

I'm not sure the code requires setlocal enabledelayedexpansion, it's part of my SETVARS.CMD which I call from other batches to set common variables like cpu architecture, account language, windows version and service pack, path to user/public desktop, etc.

How to store .pdf files into MySQL as BLOBs using PHP?

In regards to Gordon M's answer above, the 1st and 2nd parameter in `mysqli_real_escape_string ()` call should be swapped for the newer php versions, according to: http://php.net/manual/en/mysqli.real-escape-string.php

Fling gesture detection on grid layout

The swipe gesture detector code above is very useful! You may however wish to make this solution density agnostic by using the following relative values `(REL_SWIPE)` rather than the absolute values `(SWIPE_)`

``````DisplayMetrics dm = getResources().getDisplayMetrics();

int REL_SWIPE_MIN_DISTANCE = (int)(SWIPE_MIN_DISTANCE * dm.densityDpi / 160.0f);
int REL_SWIPE_MAX_OFF_PATH = (int)(SWIPE_MAX_OFF_PATH * dm.densityDpi / 160.0f);
int REL_SWIPE_THRESHOLD_VELOCITY = (int)(SWIPE_THRESHOLD_VELOCITY * dm.densityDpi / 160.0f);
``````

dbms_lob.getlength() vs. length() to find blob size in oracle

`length` and `dbms_lob.getlength` return the number of characters when applied to a CLOB (Character LOB). When applied to a BLOB (Binary LOB), `dbms_lob.getlength` will return the number of bytes, which may differ from the number of characters in a multi-byte character set.

As the documentation doesn't specify what happens when you apply `length` on a BLOB, I would advise against using it in that case. If you want the number of bytes in a BLOB, use `dbms_lob.getlength`.

How do I clear the previous text field value after submitting the form with out refreshing the entire page?

I believe it's better to use

``````\$('#form-id').find('input').val('');
``````

``````\$('#form-id').children('input').val('');
``````

incase you have checkboxes in your form use this to rest it:

``````\$('#form-id').find('input:checkbox').removeAttr('checked');
``````

ValueError: invalid literal for int () with base 10

I found a work around. Python will convert the number to a float. Simply calling float first then converting that to an int will work: `output = int(float(input))`

Create a jTDS connection string

A shot in the dark, but From the looks of your error message, it seems that either the sqlserver instance is not running on port 1433 or something is blocking the requests to that port

What are the rules about using an underscore in a C++ identifier?

The rules (which did not change in C++11):

• Reserved in any scope, including for use as implementation macros:
• identifiers beginning with an underscore followed immediately by an uppercase letter
• identifiers containing adjacent underscores (or "double underscore")
• Reserved in the global namespace:
• identifiers beginning with an underscore
• Also, everything in the `std` namespace is reserved. (You are allowed to add template specializations, though.)

From the 2003 C++ Standard:

17.4.3.1.2 Global names [lib.global.names]

Certain sets of names and function signatures are always reserved to the implementation:

• Each name that contains a double underscore (`__`) or begins with an underscore followed by an uppercase letter (2.11) is reserved to the implementation for any use.
• Each name that begins with an underscore is reserved to the implementation for use as a name in the global namespace.165

165) Such names are also reserved in namespace `::std` (17.4.3.1).

Because C++ is based on the C standard (1.1/2, C++03) and C99 is a normative reference (1.2/1, C++03) these also apply, from the 1999 C Standard:

7.1.3 Reserved identifiers

Each header declares or defines all identifiers listed in its associated subclause, and optionally declares or defines identifiers listed in its associated future library directions subclause and identifiers which are always reserved either for any use or for use as file scope identifiers.

• All identifiers that begin with an underscore and either an uppercase letter or another underscore are always reserved for any use.
• All identifiers that begin with an underscore are always reserved for use as identifiers with file scope in both the ordinary and tag name spaces.
• Each macro name in any of the following subclauses (including the future library directions) is reserved for use as specified if any of its associated headers is included; unless explicitly stated otherwise (see 7.1.4).
• All identifiers with external linkage in any of the following subclauses (including the future library directions) are always reserved for use as identifiers with external linkage.154
• Each identifier with file scope listed in any of the following subclauses (including the future library directions) is reserved for use as a macro name and as an identifier with file scope in the same name space if any of its associated headers is included.

No other identifiers are reserved. If the program declares or defines an identifier in a context in which it is reserved (other than as allowed by 7.1.4), or defines a reserved identifier as a macro name, the behavior is undefined.

If the program removes (with `#undef`) any macro definition of an identifier in the first group listed above, the behavior is undefined.

154) The list of reserved identifiers with external linkage includes `errno`, `math_errhandling`, `setjmp`, and `va_end`.

Other restrictions might apply. For example, the POSIX standard reserves a lot of identifiers that are likely to show up in normal code:

• Names beginning with a capital `E` followed a digit or uppercase letter:
• may be used for additional error code names.
• Names that begin with either `is` or `to` followed by a lowercase letter
• may be used for additional character testing and conversion functions.
• Names that begin with `LC_` followed by an uppercase letter
• may be used for additional macros specifying locale attributes.
• Names of all existing mathematics functions suffixed with `f` or `l` are reserved
• for corresponding functions that operate on float and long double arguments, respectively.
• Names that begin with `SIG` followed by an uppercase letter are reserved
• for additional signal names.
• Names that begin with `SIG_` followed by an uppercase letter are reserved
• for additional signal actions.
• Names beginning with `str`, `mem`, or `wcs` followed by a lowercase letter are reserved
• for additional string and array functions.
• Names beginning with `PRI` or `SCN` followed by any lowercase letter or `X` are reserved
• for additional format specifier macros
• Names that end with `_t` are reserved
• for additional type names.

While using these names for your own purposes right now might not cause a problem, they do raise the possibility of conflict with future versions of that standard.

Personally I just don't start identifiers with underscores. New addition to my rule: Don't use double underscores anywhere, which is easy as I rarely use underscore.

After doing research on this article I no longer end my identifiers with `_t` as this is reserved by the POSIX standard.

The rule about any identifier ending with `_t` surprised me a lot. I think that is a POSIX standard (not sure yet) looking for clarification and official chapter and verse. This is from the GNU libtool manual, listing reserved names.

CesarB provided the following link to the POSIX 2004 reserved symbols and notes 'that many other reserved prefixes and suffixes ... can be found there'. The POSIX 2008 reserved symbols are defined here. The restrictions are somewhat more nuanced than those above.

How to download fetch response in react as file

Browser technology currently doesn't support downloading a file directly from an Ajax request. The work around is to add a hidden form and submit it behind the scenes to get the browser to trigger the Save dialog.

I'm running a standard Flux implementation so I'm not sure what the exact Redux (Reducer) code should be, but the workflow I just created for a file download goes like this...

1. I have a React component called `FileDownload`. All this component does is render a hidden form and then, inside `componentDidMount`, immediately submit the form and call it's `onDownloadComplete` prop.
2. I have another React component, we'll call it `Widget`, with a download button/icon (many actually... one for each item in a table). `Widget` has corresponding action and store files. `Widget` imports `FileDownload`.
3. `Widget` has two methods related to the download: `handleDownload` and `handleDownloadComplete`.
4. `Widget` store has a property called `downloadPath`. It's set to `null` by default. When it's value is set to `null`, there is no file download in progress and the `Widget` component does not render the `FileDownload` component.
5. Clicking the button/icon in `Widget` calls the `handleDownload` method which triggers a `downloadFile` action. The `downloadFile` action does NOT make an Ajax request. It dispatches a `DOWNLOAD_FILE` event to the store sending along with it the `downloadPath` for the file to download. The store saves the `downloadPath` and emits a change event.
6. Since there is now a `downloadPath`, `Widget` will render `FileDownload` passing in the necessary props including `downloadPath` as well as the `handleDownloadComplete` method as the value for `onDownloadComplete`.
7. When `FileDownload` is rendered and the form is submitted with `method="GET"` (POST should work too) and `action={downloadPath}`, the server response will now trigger the browser's Save dialog for the target download file (tested in IE 9/10, latest Firefox and Chrome).
8. Immediately following the form submit, `onDownloadComplete`/`handleDownloadComplete` is called. This triggers another action that dispatches a `DOWNLOAD_FILE` event. However, this time `downloadPath` is set to `null`. The store saves the `downloadPath` as `null` and emits a change event.
9. Since there is no longer a `downloadPath` the `FileDownload` component is not rendered in `Widget` and the world is a happy place.

Widget.js - partial code only

``````import FileDownload from './FileDownload';

export default class Widget extends Component {
constructor(props) {
super(props);
this.state = widgetStore.getState().toJS();
}

}

}

render() {

return (

// button/icon with click bound to this.handleDownload goes here

/>
}
);
}
``````

widgetActions.js - partial code only

``````export function downloadFile(data) {

if (data) {
}

appDispatcher.dispatch({
});
}
``````

widgetStore.js - partial code only

``````let store = Map({
// other store properties
});

class WidgetStore extends Store {
constructor() {
super();
this.dispatchToken = appDispatcher.register(action => {
switch (action.actionType) {
store = store.merge({
});
this.emitChange();
break;
``````

- complete, fully functional code ready for copy and paste
- React 0.14.7 with Babel 6.x ["es2015", "react", "stage-0"]
- form needs to be `display: none` which is what the "hidden" `className` is for

``````import React, {Component, PropTypes} from 'react';
import ReactDOM from 'react-dom';

function getFormInputs() {
const {queryParams} = this.props;

if (queryParams === undefined) {
return null;
}

return Object.keys(queryParams).map((name, index) => {
return (
<input
key={index}
name={name}
type="hidden"
value={queryParams[name]}
/>
);
});
}

export default class FileDownload extends Component {

static propTypes = {
actionPath: PropTypes.string.isRequired,
method: PropTypes.string,
queryParams: PropTypes.object
};

static defaultProps = {
method: 'GET'
};

componentDidMount() {
ReactDOM.findDOMNode(this).submit();
}

render() {
const {actionPath, method} = this.props;

return (
<form
action={actionPath}
className="hidden"
method={method}
>
{getFormInputs.call(this)}
</form>
);
}
}
``````

How can I get the current user's username in Bash?

A hack the I've used on Solaris 9 and Linux and which works fine for both of them:

``````ps -o user= -p \$\$ | awk '{print \$1}'
``````

This snippet prints the name of the user with the current EUID.

NOTE: you need Bash as the interpreter here.

On Solaris you have problems with methods, described above:

• `id` does not accept the `-u` and `-n` parameters (so you will have to parse the output)
• `whoami` does not exist (by default)
• `who am I` prints owner of current terminal (ignores EUID)
• `\$USER` variable is set correctly only after reading profile files (for example, `/etc/profile`)

Get PostGIS version

Other way to get the minor version is:

``````SELECT extversion
FROM pg_catalog.pg_extension
WHERE extname='postgis'
``````

How to read an http input stream

It looks like the documentation is just using `readStream()` to mean:

Ok, we've shown you how to get the InputStream, now your code goes in `readStream()`

So you should either write your own `readStream()` method which does whatever you wanted to do with the data in the first place.

How do I use \$rootScope in Angular to store variables?

first store the values in \$rootScope as

``````.run(function(\$rootScope){
\$rootScope.myData = {name : "nikhil"}
})

.controller('myCtrl', function(\$scope) {
var a ="Nikhilesh";
\$scope.myData.name = a;
});

.controller('myCtrl2', function(\$scope) {
var b = \$scope.myData.name;
)}
``````

\$rootScope is the parent of all \$scope, each \$scope receives a copy of \$rootScope data which you can access using \$scope itself.

How to calculate combination and permutation in R?

The function combn is in the standard utils package (i.e. already installed)

choose is also already available in the Special {base}

How to get ERD diagram for an existing database?

We used DBVisualizer for that.

Description: The references graph is a great feature as it automatically renders all primary/foreign key mappings (also called referential integrity constraints) in a graph style. The table nodes and relations are layed out automatically, with a number of layout modes available. The resulting graph is unique as it displays all information in an optimal and readable layout. from its site

Does the Java &= operator apply & or &&?

It's the last one:

``````a = a & b;
``````

Description Box using "onmouseover"

Although not necessarily a JavaScript solution, there is also a "title" global tag attribute that may be helpful.

``````<a href="https://stackoverflow.com/questions/3559467/description-box-on-mouseover" title="This is a title.">Mouseover me</a>
``````

Mouseover me

Iterating over JSON object in C#

You can use the `JsonTextReader` to read the JSON and iterate over the tokens:

``````using (var reader = new JsonTextReader(new StringReader(jsonText)))
{
{
Console.WriteLine("{0} - {1} - {2}",
}
}
``````

ubuntu "No space left on device" but there is tons of space

It's possible that you've run out of memory or some space elsewhere and it prompted the system to mount an overflow filesystem, and for whatever reason, it's not going away.

Try unmounting the overflow partition:

``````umount /tmp
``````

or

``````umount overflow
``````

How to remove unused imports in Intellij IDEA on commit?

If you are using IntelliJ IDEA or Android Studio:

Go to Settings > Editor > General >Auto Import and check the Optimize imports on the fly checkbox.

Convert char to int in C#

``````char c = '1';
int i = (int)(c-'0');
``````

and you can create a static method out of it:

``````static int ToInt(this char c)
{
return (int)(c - '0');
}
``````

View the change history of a file using Git versioning

SourceTree users

If you use SourceTree to visualize your repository (it's free and quite good) you can right click a file and select Log Selected

The display (below) is much friendlier than gitk and most the other options listed. Unfortunately (at this time) there is no easy way to launch this view from the command line — SourceTree's CLI currently just opens repos.

Print to standard printer from Python?

This has only been tested on Windows:

You can do the following:

``````import os

os.startfile("C:/Users/TestFile.txt", "print")
``````

This will start the file, in its default opener, with the verb 'print', which will print to your default printer.Only requires the `os` module which comes with the standard library

Multiple "style" attributes in a "span" tag: what's supposed to happen?

In HTML, SGML and XML, (1) attributes cannot be repeated, and should only be defined in an element once.

``````<span style="color:blue" style="font-style:italic">Test</span>
``````

is non-conformant to the HTML standard, and will result in undefined behaviour, which explains why different browsers are rendering it differently.

Since there is no defined way to interpret this, browsers can interpret it however they want and merge them, or ignore them as they wish.

(1): Every article I can find states that attributes are "key/value" pairs or "attribute-value" pairs, heavily implying the keys must be unique. The best source I can find states:

Attribute names (id and status in this example) are subject to the same restrictions as other names in XML; they need not be unique across the whole DTD, however, but only within the list of attributes for a given element. (Emphasis mine.)

jQuery & CSS - Remove/Add display:none

To hide the `div`

``````\$('.news').hide();
``````

or

``````\$('.news').css('display','none');
``````

and to show the `div`:

``````\$('.news').show();
``````

or

``````\$('.news').css('display','block');
``````

How to find locked rows in Oracle

The below PL/SQL block finds all locked rows in a table. The other answers only find the blocking session, finding the actual locked rows requires reading and testing each row.

(However, you probably do not need to run this code. If you're having a locking problem, it's usually easier to find the culprit using `GV\$SESSION.BLOCKING_SESSION` and other related data dictionary views. Please try another approach before you run this abysmally slow code.)

First, let's create a sample table and some data. Run this in session #1.

``````--Sample schema.
create table test_locking(a number);
insert into test_locking values(1);
insert into test_locking values(2);
commit;
update test_locking set a = a+1 where a = 1;
``````

In session #2, create a table to hold the locked ROWIDs.

``````--Create table to hold locked ROWIDs.
create table locked_rowids(the_rowid rowid);
--Remove old rows if table is already created:
--delete from locked_rowids;
--commit;
``````

In session #2, run this PL/SQL block to read the entire table, probe each row, and store the locked ROWIDs. Be warned, this may be ridiculously slow. In your real version of this query, change both references to TEST_LOCKING to your own table.

``````--Save all locked ROWIDs from a table.
--WARNING: This PL/SQL block will be slow and will temporarily lock rows.
--You probably don't need this information - it's usually good enough to know
--what other sessions are locking a statement, which you can find in
--GV\$SESSION.BLOCKING_SESSION.
declare
v_resource_busy exception;
pragma exception_init(v_resource_busy, -00054);
v_throwaway number;
type rowid_nt is table of rowid;
v_rowids rowid_nt := rowid_nt();
begin
--Loop through all the rows in the table.
for all_rows in
(
select rowid
from test_locking
) loop
--Try to look each row.
begin
select 1
into v_throwaway
from test_locking
where rowid = all_rows.rowid
for update nowait;
--If it doesn't lock, then record the ROWID.
exception when v_resource_busy then
v_rowids.extend;
v_rowids(v_rowids.count) := all_rows.rowid;
end;

rollback;
end loop;

--Display count:
dbms_output.put_line('Rows locked: '||v_rowids.count);

--Save all the ROWIDs.
--(Row-by-row because ROWID type is weird and doesn't work in types.)
for i in 1 .. v_rowids.count loop
insert into locked_rowids values(v_rowids(i));
end loop;
commit;
end;
/
``````

Finally, we can view the locked rows by joining to the LOCKED_ROWIDS table.

``````--Display locked rows.
select *
from test_locking
where rowid in (select the_rowid from locked_rowids);

A
-
1
``````

How to generate sample XML documents from their DTD or XSD?

XML-XIG: XML Instance Generator

http://xml-xig.sourceforge.net/

This opensource would be helpful.

How to add a response header on nginx when using proxy_pass?

Hide response header and then add a new custom header value

Adding a header with `add_header` works fine with proxy pass, but if there is an existing header value in the response it will stack the values.

If you want to set or replace a header value (for example replace the `Access-Control-Allow-Origin` header to match your client for allowing cross origin resource sharing) then you can do as follows:

``````# 1. hide the Access-Control-Allow-Origin from the server response
# 2. add a new custom header that allows all * origins instead
``````

So `proxy_hide_header` combined with `add_header` gives you the power to set/replace response header values.

Similar answer can be found here on ServerFault

UPDATE:

Note: `proxy_set_header` is for setting request headers before the request is sent further, not for setting response headers (these configuration attributes for headers can be a bit confusing).

Android Relative Layout Align Center

You can use gravity with aligning top and bottom.

`````` android:gravity="center_vertical"
android:layout_alignTop="@id/place_category_icon"
android:layout_alignBottom="@id/place_category_icon"
``````

jQuery, checkboxes and .is(":checked")

``````\$("#personal").click(function() {
if (\$(this).is(":checked")) {
/* var validator = \$("#register_france").validate();
validator.resetForm(); */
}
}
);
``````

JSFIDDLE

How do I access ViewBag from JS

You can achieve the solution, by doing this:

JavaScript:

``````var myValue = document.getElementById("@(ViewBag.CC)").value;
``````

or if you want to use `jQuery`, then:

jQuery

``````var myValue = \$('#' + '@(ViewBag.CC)').val();
``````

Do I need to pass the full path of a file in another directory to open()?

Yes, you need the full path.

``````log = open(os.path.join(root, f), 'r')
``````

Is the quick fix. As the comment pointed out, `os.walk` decends into subdirs so you do need to use the current directory root rather than `indir` as the base for the path join.

How to measure time taken by a function to execute

Don't use Date(). Read below.

``````<script>
var a = performance.now();
var b = performance.now();
alert('It took ' + (b - a) + ' ms.');
</script>
``````

It works on:

• IE 10 ++

• FireFox 15 ++

• Chrome 24 ++

• Safari 8 ++

• Opera 15 ++

• Android 4.4 ++

• etc, etc

`console.time` may be viable for you, but it's non-standard §:

This feature is non-standard and is not on a standards track. Do not use it on production sites facing the Web: it will not work for every user. There may also be large incompatibilities between implementations and the behavior may change in the future.

Besides browser support, `performance.now` seems to have the potential to provide more accurate timings as it appears to be the bare-bones version of `console.time`.

<rant> Also, DON'T EVER use `Date` for anything because it's affected by changes in "system time". Which means we will get invalid results —like "negative timing"— when the user doesn't have an accurate system time:

On Oct 2014, my system clock went haywire and guess what.... I opened Gmail and saw all of my day's emails "sent 0 minutes ago". And I'd thought Gmail is supposed to be built by world-class engineers from Google.......

(Set your system clock to one year ago and go to Gmail so we can all have a good laugh. Perhaps someday we will have a Hall of Shame for JS `Date`.)

Google Spreadsheet's `now()` function also suffers from this problem.

The only time you'll be using `Date` is when you want to show the user his system clock time. Not when you want to get the time or to measure anything.

How do I find duplicate values in a table in Oracle?

I usually use Oracle Analytic function ROW_NUMBER().

Say you want to check the duplicates you have regarding a unique index or primary key built on columns (`c1`, `c2`, `c3`). Then you will go this way, bringing up `ROWID` s of rows where the number of lines brought by `ROW_NUMBER()` is `>1`:

``````Select * From Table_With_Duplicates
Where Rowid In
(Select Rowid
From (Select Rowid,
ROW_NUMBER() Over (
Partition By c1 || c2 || c3
Order By c1 || c2 || c3
) nbLines
From Table_With_Duplicates) t2
Where nbLines > 1)
``````

How to combine paths in Java?

Rather than keeping everything string-based, you should use a class which is designed to represent a file system path.

If you're using Java 7 or Java 8, you should strongly consider using `java.nio.file.Path`; `Path.resolve` can be used to combine one path with another, or with a string. The `Paths` helper class is useful too. For example:

``````Path path = Paths.get("foo", "bar", "baz.txt");
``````

If you need to cater for pre-Java-7 environments, you can use `java.io.File`, like this:

``````File baseDirectory = new File("foo");
File subDirectory = new File(baseDirectory, "bar");
File fileInDirectory = new File(subDirectory, "baz.txt");
``````

If you want it back as a string later, you can call `getPath()`. Indeed, if you really wanted to mimic `Path.Combine`, you could just write something like:

``````public static String combine(String path1, String path2)
{
File file1 = new File(path1);
File file2 = new File(file1, path2);
return file2.getPath();
}
``````

It is because the Creation was delayed. If you want the picture to be loaded immediately, you can simply add this code into the init phase.

like this:

``````src.BeginInit();
src.UriSource = new Uri("picture.jpg", UriKind.Relative);
src.EndInit();
``````

Correct way to read a text file into a buffer in C?

Yes - you would probably be arrested for your terriable abuse of strcat !

Take a look at getline() it reads the data a line at a time but importantly it can limit the number of characters you read, so you don't overflow the buffer.

Strcat is relatively slow because it has to search the entire string for the end on every character insertion. You would normally keep a pointer to the current end of the string storage and pass that to getline as the position to read the next line into.

Add a new item to a dictionary in Python

It can be as simple as:

``````default_data['item3'] = 3
``````

As Chris' answer says, you can use update to add more than one item. An example:

``````default_data.update({'item4': 4, 'item5': 5})
``````

Please see the documentation about dictionaries as data structures and dictionaries as built-in types.

Plotting multiple lines, in different colors, with pandas dataframe

You could use `groupby` to split the DataFrame into subgroups according to the color:

``````for key, grp in df.groupby(['color']):
``````

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

df = pd.read_table('data', sep='\s+')
fig, ax = plt.subplots()

for key, grp in df.groupby(['color']):
ax = grp.plot(ax=ax, kind='line', x='x', y='y', c=key, label=key)

plt.legend(loc='best')
plt.show()
``````

yields

Passing a method as a parameter in Ruby

you also can use "eval", and pass the method as a string argument, and then simply eval it in the other method.

How do I bind a List<CustomObject> to a WPF DataGrid?

Actually, to properly support sorting, filtering, etc. a CollectionViewSource should be used as a link between the DataGrid and the list, like this:

``````<Window.Resources>
<CollectionViewSource x:Key="ItemCollectionViewSource" CollectionViewType="ListCollectionView"/>
</Window.Resources>
``````

The DataGrid line looks like this:

``````<DataGrid
DataContext="{StaticResource ItemCollectionViewSource}"
ItemsSource="{Binding}"
AutoGenerateColumns="False">
``````

In the code behind, you link CollectionViewSource with your link.

``````CollectionViewSource itemCollectionViewSource;
itemCollectionViewSource = (CollectionViewSource)(FindResource("ItemCollectionViewSource"));
itemCollectionViewSource.Source = itemList;
``````

For detailed example see my article on CoedProject: http://www.codeproject.com/Articles/683429/Guide-to-WPF-DataGrid-formatting-using-bindings

How to load all modules in a folder?

Anurag Uniyal answer with suggested improvements!

``````#!/usr/bin/python
# -*- encoding: utf-8 -*-

import os
import glob

all_list = list()
for f in glob.glob(os.path.dirname(__file__)+"/*.py"):
if os.path.isfile(f) and not os.path.basename(f).startswith('_'):
all_list.append(os.path.basename(f)[:-3])

__all__ = all_list
``````

How can you print a variable name in python?

If you are trying to do this, it means you are doing something wrong. Consider using a `dict` instead.

``````def show_val(vals, name):
print "Name:", name, "val:", vals[name]

vals = {'a': 1, 'b': 2}
show_val(vals, 'b')
``````

Output:

``````Name: b val: 2
``````

How to handle a lost KeyStore password in Android?

Today 2/2/2021, I can find my pw in the file name "executionHistory.bin". Let you open it by notepad++ and search for key keyPassword. See the attached picture below.

https://i.stack.imgur.com/NNHFA.png

Looping from 1 to infinity in Python

``````def infinity():
i=0
while True:
i+=1
yield i

for i in infinity():
if there_is_a_reason_to_break(i):
break
``````

To enable extensions, verify that they are enabled in those .ini files - Vagrant/Ubuntu/Magento 2.0.2

ubuntu users try this

``````apt-get install php7.2 libapache2-mod-php7.2 php7.2-common php7.2-gd php7.2-mysql php7.2-curl php7.2-intl php7.2-xsl php7.2-mbstring php7.2-zip php7.2-bcmath php7.2-soap php-xdebug php-imagick
``````

this is work for php 7.2 but you can change this 7.2 to 5.2 and run this command it is work.

PostgreSQL CASE ... END with multiple conditions

This kind of code perhaps should work for You

``````SELECT
*,
CASE
WHEN (pvc IS NULL OR pvc = '') AND (datepose < 1980) THEN '01'
WHEN (pvc IS NULL OR pvc = '') AND (datepose >= 1980) THEN '02'
WHEN (pvc IS NULL OR pvc = '') AND (datepose IS NULL OR datepose = 0) THEN '03'
ELSE '00'
END AS modifiedpvc
FROM my_table;

gid | datepose | pvc | modifiedpvc
-----+----------+-----+-------------
1 |     1961 | 01  | 00
2 |     1949 |     | 01
3 |     1990 | 02  | 00
1 |     1981 |     | 02
1 |          | 03  | 00
1 |          |     | 03
(6 rows)
``````

Setting focus to a textbox control

To set focus,

``````Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
TextBox1.Focus()
End Sub
``````

Set the TabIndex by

``````Me.TextBox1.TabIndex = 0
``````

How can I check if an ip is in a network in Python?

``````>>> import ipaddress
True
``````

If you want to evaluate a lot of IP addresses this way, you'll probably want to calculate the netmask upfront, like

``````n = ipaddress.ip_network('192.0.0.0/16')
``````

Then, for each address, calculate the binary representation with one of

``````a = int(ipaddress.ip_address('192.0.43.10'))
a = struct.unpack('!I', socket.inet_pton(socket.AF_INET, '192.0.43.10'))[0]
a = struct.unpack('!I', socket.inet_aton('192.0.43.10'))[0]  # IPv4 only
``````

Finally, you can simply check:

``````in_network = (a & mask) == netw
``````

Accessing an SQLite Database in Swift

Configure your Swift project to handle SQLite C calls:

Create bridging header file to the project. See the Importing Objective-C into Swift section of the Using Swift with Cocoa and Objective-C. This bridging header should import sqlite3.h:

Add the libsqlite3.0.dylib to your project. See Apple's documentation regarding adding library/framework to one's project.

and used following code

``````    func executeQuery(query: NSString ) -> Int
{
if  sqlite3_open(databasePath! as String, &database) != SQLITE_OK
{
println("Databse is not open")
return 0
}
else
{
query.stringByReplacingOccurrencesOfString("null", withString: "")
var cStatement:COpaquePointer = nil
var executeSql = query as NSString
var lastId : Int?
var sqlStatement = executeSql.cStringUsingEncoding(NSUTF8StringEncoding)
sqlite3_prepare_v2(database, sqlStatement, -1, &cStatement, nil)
var execute = sqlite3_step(cStatement)
println("\(execute)")
if execute == SQLITE_DONE
{
lastId = Int(sqlite3_last_insert_rowid(database))
}
else
{
println("Error in Run Statement :- \(sqlite3_errmsg16(database))")
}
sqlite3_finalize(cStatement)
return lastId!
}
}
func ViewAllData(query: NSString, error: NSError) -> NSArray
{
var cStatement = COpaquePointer()
var result : AnyObject = NSNull()
var thisArray : NSMutableArray = NSMutableArray(capacity: 4)
cStatement = prepare(query)
if cStatement != nil
{
while sqlite3_step(cStatement) == SQLITE_ROW
{
result = NSNull()
var thisDict : NSMutableDictionary = NSMutableDictionary(capacity: 4)
for var i = 0 ; i < Int(sqlite3_column_count(cStatement)) ; i++
{
if sqlite3_column_type(cStatement, Int32(i)) == 0
{
continue
}
if sqlite3_column_decltype(cStatement, Int32(i)) != nil && strcasecmp(sqlite3_column_decltype(cStatement, Int32(i)), "Boolean") == 0
{
var temp = sqlite3_column_int(cStatement, Int32(i))
if temp == 0
{
result = NSNumber(bool : false)
}
else
{
result = NSNumber(bool : true)
}
}
else if sqlite3_column_type(cStatement,Int32(i)) == SQLITE_INTEGER
{
var temp = sqlite3_column_int(cStatement,Int32(i))
result = NSNumber(int : temp)
}
else if sqlite3_column_type(cStatement,Int32(i)) == SQLITE_FLOAT
{
var temp = sqlite3_column_double(cStatement,Int32(i))
result = NSNumber(double: temp)
}
else
{
if sqlite3_column_text(cStatement, Int32(i)) != nil
{
var temp = sqlite3_column_text(cStatement,Int32(i))
result = String.fromCString(UnsafePointer<CChar>(temp))!

var keyString = sqlite3_column_name(cStatement,Int32(i))
thisDict.setObject(result, forKey: String.fromCString(UnsafePointer<CChar>(keyString))!)
}
result = NSNull()

}
if result as! NSObject != NSNull()
{
var keyString = sqlite3_column_name(cStatement,Int32(i))
thisDict.setObject(result, forKey: String.fromCString(UnsafePointer<CChar>(keyString))!)
}
}
}
sqlite3_finalize(cStatement)
}
return thisArray
}
func prepare(sql : NSString) -> COpaquePointer
{
var cStatement:COpaquePointer = nil
sqlite3_open(databasePath! as String, &database)
var utfSql = sql.UTF8String
if sqlite3_prepare(database, utfSql, -1, &cStatement, nil) == 0
{
sqlite3_close(database)
return cStatement
}
else
{
sqlite3_close(database)
return nil
}
}
}
``````

Append column to pandas dataframe

You can also use:

``````dat1 = pd.concat([dat1, dat2], axis=1)
``````

How do you create an asynchronous HTTP request in JAVA?

It has to be made clear the HTTP protocol is synchronous and this has nothing to do with the programming language. Client sends a request and gets a synchronous response.

If you want to an asynchronous behavior over HTTP, this has to be built over HTTP (I don't know anything about ActionScript but I suppose that this is what the ActionScript does too). There are many libraries that could give you such functionality (e.g. Jersey SSE). Note that they do somehow define dependencies between the client and the server as they do have to agree on the exact non standard communication method above HTTP.

If you cannot control both the client and the server or if you don't want to have dependencies between them, the most common approach of implementing asynchronous (e.g. event based) communication over HTTP is using the webhooks approach (you can check this for an example implementation in java).

Hope I helped!

How to download the latest artifact from Artifactory repository?

The role of Artifactory is to provide files for Maven (as well as other build tools such as Ivy, Gradle or sbt). You can just use Maven together with the maven-dependency-plugin to copy the artifacts out. Here's a pom outline to start you off...

``````<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>A group id</groupId>
<artifactId>An artifact id</artifactId>
<version>1.0.0-SNAPSHOT</version>
<packaging>pom</packaging>

<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-dependency-plugin</artifactId>
<version>2.3</version>
<executions>
<execution>
<id>copy</id>
<phase>package</phase>
<goals>
<goal>copy</goal>
</goals>
<configuration>
<artifactItems>
<artifactItem>
<groupId>The group id of your artifact</groupId>
<artifactId>The artifact id</artifactId>
<version>The snapshot version</version>
<type>Whatever the type is, for example, JAR</type>
<outputDirectory>Where you want the file to go</outputDirectory>
</artifactItem>
</artifactItems>
</configuration>
</execution>
</executions>
</plugin>
</plugins>
</build>
</project>
``````

Just run `mvn install` to do the copy.

Setting a timeout for socket operations

You can't control the timeout due to `UnknownHostException`. These are DNS timings. You can only control the connect timeout given a valid host. None of the preceding answers addresses this point correctly.

But I find it hard to believe that you are really getting an `UnknownHostException` when you specify an IP address rather than a hostname.

EDIT To control Java's DNS timeouts see this answer.

Resource interpreted as Document but transferred with MIME type application/json warning in Chrome Developer Tools

I took a different approach. I switched to use \$.post and the error has gone since then.

Change icons of checked and unchecked for Checkbox for Android

One alternative would be to use a drawable/textview instead of a checkbox and manipulate it accordingly. I have used this method to have my own checked and unchecked images for a task application.

Best way to strip punctuation from a string

Not necessarily simpler, but a different way, if you are more familiar with the re family.

``````import re, string
s = "string. With. Punctuation?" # Sample string
out = re.sub('[%s]' % re.escape(string.punctuation), '', s)
``````

Android: show/hide a view using an animation

ViewAnimator:

In XML:

``````  <ViewAnimator
android:id="@+id/animator_message"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:inAnimation="@anim/slide_down_text"
android:outAnimation="@anim/slide_up_text">

<TextView
android:id="@+id/text_message_authentication"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:gravity="center_horizontal"
android:text="message_error_authentication" />

<TextView
android:id="@+id/text_message_authentication_connection"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:gravity="center_horizontal"
android:text="message_error_authentication_connection" />

<TextView
android:id="@+id/text_message_authentication_empty"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:gravity="center_horizontal"
android:text="message_error_authentication_field_empty" />

</ViewAnimator>
``````

Functions:

``````public void show(int viewId) {
ViewAnimator animator = (ViewAnimator) findView(animatorId);
View view = findViewById(viewId);

if (animator.getDisplayedChild() != animator.indexOfChild(view)) {
animator.setDisplayedChild(animator.indexOfChild(view));
}
}

private void showAuthenticationConnectionFailureMessage() {
show(R.id.text_message_authentication_connection);
}
``````

Read text from response

If you http request is Post and `request.Accept = "application/x-www-form-urlencoded";` then i think you can to get text of respone by code bellow:

``````var contentEncoding = response.Headers["content-encoding"];
if (contentEncoding != null && contentEncoding.Contains("gzip")) // cause httphandler only request gzip
{
// using gzip stream reader
using (var responseStreamReader = new StreamReader(new GZipStream(response.GetResponseStream(), CompressionMode.Decompress)))
{
}
}
else
{
// using ordinary stream reader
{
}
}
``````

What are the differences between .gitignore and .gitkeep?

`.gitkeep` isn’t documented, because it’s not a feature of Git.

Git cannot add a completely empty directory. People who want to track empty directories in Git have created the convention of putting files called `.gitkeep` in these directories. The file could be called anything; Git assigns no special significance to this name.

There is a competing convention of adding a `.gitignore` file to the empty directories to get them tracked, but some people see this as confusing since the goal is to keep the empty directories, not ignore them; `.gitignore` is also used to list files that should be ignored by Git when looking for untracked files.

VBA: Counting rows in a table (list object)

You need to go one level deeper in what you are retrieving.

``````Dim tbl As ListObject
Set tbl = ActiveSheet.ListObjects("MyTable")
MsgBox tbl.Range.Rows.Count
MsgBox tbl.DataBodyRange.Rows.Count
Set tbl = Nothing
``````

How can I pass an argument to a PowerShell script?

Call the script from a batch file (*.bat) or CMD

PowerShell Core

``````pwsh.exe -NoLogo -ExecutionPolicy Bypass -Command "./Script.ps1 -Param1 Hello -Param2 World"

pwsh.exe -NoLogo -ExecutionPolicy Bypass -Command "path-to-script/Script.ps1 -Param1 Hello -Param2 World"

pwsh.exe -NoLogo -ExecutionPolicy Bypass -Command "./Script.ps1 Hello -Param2 World"

pwsh.exe -NoLogo -ExecutionPolicy Bypass -Command "./Script.ps1 Hello World"

pwsh.exe -NoLogo -ExecutionPolicy Bypass -Command "./Script.ps1 -Param2 World Hello"
``````

PowerShell

``````powershell.exe -NoLogo -ExecutionPolicy Bypass -Command "./Script.ps1 -Param1 Hello -Param2 World"

powershell.exe -NoLogo -ExecutionPolicy Bypass -Command "path-to-script/Script.ps1 -Param1 Hello -Param2 World"

powershell.exe -NoLogo -ExecutionPolicy Bypass -Command "./Script.ps1 Hello -Param2 World"

powershell.exe -NoLogo -ExecutionPolicy Bypass -Command "./Script.ps1 Hello World"

powershell.exe -NoLogo -ExecutionPolicy Bypass -Command "./Script.ps1 -Param2 World Hello"
``````

Call from PowerShell

PowerShell Core or Windows PowerShell

``````& path-to-script/Script.ps1 -Param1 Hello -Param2 World
& ./Script.ps1 -Param1 Hello -Param2 World
``````

Script.ps1 - Script Code

``````param(
[Parameter(Mandatory=\$True, Position=0, ValueFromPipeline=\$false)]
[System.String]
\$Param1,

[Parameter(Mandatory=\$True, Position=1, ValueFromPipeline=\$false)]
[System.String]
\$Param2
)

Write-Host \$Param1
Write-Host \$Param2
``````

How to add icon inside EditText view in Android ?

Use a relative layout and set the button the be align left of the edit text view, and set the left padding of your text view to the size of your button. I can't think of a good way to do it without hard coding the padding :/

You can also use apk tool to sorta unzip the facebook apk and take a look at its layout files.

How can I read pdf in python?

You can USE PyPDF2 package

``````#install pyDF2
pip install PyPDF2

# importing all the required modules
import PyPDF2

# creating an object
file = open('example.pdf', 'rb')

# creating a pdf reader object

# print the number of pages in pdf file
``````

Follow this Documentation http://pythonhosted.org/PyPDF2/

Xcode : Adding a project as a build dependency

To add it as a dependency do the following:

• Highlight the added project in your file explorer within xcode. In the directory browser window to the right it should show a file with a .a extension. There is a checkbox under the target column (target icon), check it.
• Right-Click on your Target (under the targets item in the file explorer) and choose Get Info
• On the general tab is a Direct Dependencies section. Hit the plus button
• Choose the project and click Add Target

Sending multipart/formdata with jQuery.ajax

Nowadays you don't even need jQuery:) fetch API support table

``````let result = fetch('url', {method: 'POST', body: new FormData(document.querySelector("#form"))})
``````

Add text to textarea - Jquery

That should work. Better if you pass a function to `val`:

``````\$('#replyBox').val(function(i, text) {
return text + quote;
});
``````

This way you avoid searching the element and calling `val` twice.

Android Studio Could not initialize class org.codehaus.groovy.runtime.InvokerHelper

I fixed it just by editing the `gradle-wrapper.properties` file.

You must go to the project folder, then `/android/grandle/wrapper/gradle-wrapper.properties`. In DistributionUrl, change to `https \: //services.gradle.org/distributions/gradle-6.4.1-all.zip`.

error C4996: 'scanf': This function or variable may be unsafe in c programming

You can add "_CRT_SECURE_NO_WARNINGS" in Preprocessor Definitions.

Right-click your project->Properties->Configuration Properties->C/C++ ->Preprocessor->Preprocessor Definitions.

How do I (or can I) SELECT DISTINCT on multiple columns?

If your DBMS doesn't support distinct with multiple columns like this:

``````select distinct(col1, col2) from table
``````

Multi select in general can be executed safely as follows:

``````select distinct * from (select col1, col2 from table ) as x
``````

As this can work on most of the DBMS and this is expected to be faster than group by solution as you are avoiding the grouping functionality.

".addEventListener is not a function" why does this error occur?

_x000D_
_x000D_
``````var comment = document.getElementsByClassName("button");_x000D_
_x000D_
function showComment() {_x000D_
var place = document.getElementById('textfield');_x000D_
var commentBox = document.createElement('textarea');_x000D_
place.appendChild(commentBox);_x000D_
}_x000D_
_x000D_
for (var i in comment) {_x000D_
comment[i].onclick = function() {_x000D_
showComment();_x000D_
};_x000D_
}``````
_x000D_
``````<input type="button" class="button" value="1">_x000D_
<input type="button" class="button" value="2">_x000D_
<div id="textfield"></div>``````
_x000D_
_x000D_
_x000D_

'if' statement in jinja2 template

We need to remember that the `{% endif %}` comes after the `{% else %}`.

So this is an example:

``````{% if someTest %}
<p> Something is True </p>
{% else %}
<p> Something is False </p>
{% endif %}
``````

No Persistence provider for EntityManager named

You have to use the absolute path of the file otherwise this will not work. Then with that path we build the file and pass it to the configuration.

``````@Throws(HibernateException::class)
fun getSessionFactory() : SessionFactory {
return Configuration()
.configure(getFile())
.buildSessionFactory()
}

private fun getFile(canonicalName: String): File {
val absolutePathCurrentModule = System.getProperty("user.dir")
val pathFromProjectRoot = absolutePathCurrentModule.dropLastWhile { it != '/' }
val absolutePathFromProjectRoot = "\${pathFromProjectRoot}module-name/src/main/resources/\$canonicalName"
println("Absolute Path of secret-hibernate.cfg.xml: \$absolutePathFromProjectRoot")
return File(absolutePathFromProjectRoot)
}
``````

GL

Source

How to detect orientation change in layout in Android?

Use the onConfigurationChanged method of Activity. See the following code:

``````@Override
public void onConfigurationChanged(@NotNull Configuration newConfig) {
super.onConfigurationChanged(newConfig);

// Checks the orientation of the screen
if (newConfig.orientation == Configuration.ORIENTATION_LANDSCAPE) {
Toast.makeText(this, "landscape", Toast.LENGTH_SHORT).show();
} else if (newConfig.orientation == Configuration.ORIENTATION_PORTRAIT){
Toast.makeText(this, "portrait", Toast.LENGTH_SHORT).show();
}
}
``````

You also have to edit the appropriate element in your manifest file to include the android:configChanges Just see the code below:

``````<activity android:name=".MyActivity"
android:configChanges="orientation|keyboardHidden"
android:label="@string/app_name">
``````

NOTE: with Android 3.2 (API level 13) or higher, the "screen size" also changes when the device switches between portrait and landscape orientation. Thus, if you want to prevent runtime restarts due to orientation change when developing for API level 13 or higher, you must declare android:configChanges="orientation|screenSize" for API level 13 or higher.

2D array values C++

The proper way to initialize a multidimensional array in C or C++ is

``````int arr[2][5] = {{1,8,12,20,25}, {5,9,13,24,26}};
``````

You can use this same trick to initialize even higher-dimensional arrays if you want.

Also, be careful in your initial code - you were trying to use 1-indexed offsets into the array to initialize it. This didn't compile, but if it did it would cause problems because C arrays are 0-indexed!

How to stop/cancel 'git log' command in terminal?

You can hit the key q (for quit) and it should take you to the prompt.

A simple command line to download a remote maven2 artifact to the local repository?

As of version 2.4 of the Maven Dependency Plugin, you can also define a target destination for the artifact by using the -Ddest flag. It should point to a filename (not a directory) for the destination artifact. See the parameter page for additional parameters that can be used

``````mvn org.apache.maven.plugins:maven-dependency-plugin:2.4:get \
-Dartifact=robo-guice:robo-guice:0.4-SNAPSHOT \
-Ddest=c:\temp\robo-guice.jar
``````

How to print to stderr in Python?

If you want to exit a program because of a fatal error, use:

``````sys.exit("Your program caused a fatal error. ... description ...")
``````

and `import sys` in the header.

Can you recommend a free light-weight MySQL GUI for Linux?

RazorSQL vote here too. It is not free, but it's not expensive (\$70 for a perpetual license and 1 year of free upgrades).

If you use it for work, it will pay for itself quickly. I was jumping between MySQL GUI tools, SQL Server and Informix DBAccess, some of them through VMs because I use a Mac for development. Having a single tool to connect to any database out there is pretty nice. It is also highly customizable, and very reliable.

What's the best way to parse a JSON response from the requests library?

Since you're using `requests`, you should use the response's `json` method.

``````import requests

response = requests.get(...)
data = response.json()
``````

Android: how to convert whole ImageView to Bitmap?

It works in Kotlin after `buildDrawingCache()` being deprecated

`````` // convert imageView to bitmap
val bitmap = (imageViewId.getDrawable() as BitmapDrawable).getBitmap()
``````

SQL DROP TABLE foreign key constraint

In SQL Server Management Studio 2008 (R2) and newer, you can Right Click on the

DB -> Tasks -> Generate Scripts

• Select the tables you want to DROP.

• Select "Save to new query window".

• Click on the Advanced button.

• Set Script DROP and CREATE to Script DROP.

• Set Script Foreign Keys to True.

• Click OK.

• Click Next -> Next -> Finish.

• View the script and then Execute.

Filter an array using a formula (without VBA)

This will do it if you only want the first "B" value, you can sub a cell address for "B" if you want to make it more generic.

``````=INDEX(A2:A6,SUMPRODUCT(MATCH(TRUE,(B2:B6)="B",0)),1)
``````

To use this based on two columns, just concatenate inside the match:

``````=INDEX(A2:A6,SUMPRODUCT(MATCH(TRUE,(A2:A6&B2:B6)=("3"&"B"),0)),1)
``````

Sorting arraylist in alphabetical order (case insensitive)

``````def  lst = ["A2", "A1", "k22", "A6", "a3", "a5", "A4", "A7"];

println lst.sort { a, b -> a.compareToIgnoreCase b }
``````

This should be able to sort with case insensitive but I am not sure how to tackle the alphanumeric strings lists

How to convert a HTMLElement to a string

I was using Angular, and needed the same thing, and landed at this post.

``````@ViewChild('myHTML', {static: false}) _html: ElementRef;
this._html.nativeElement;
``````

How to modify WooCommerce cart, checkout pages (main theme portion)

Another way to totally override the cart.php is to copy:

``````woocommerce/templates/cart/cart.php to
yourtheme/woocommerce/cart/cart.php
``````

Then do whatever you need at the yourtheme/woocommerce/cart/cart.php

Casting LinkedHashMap to Complex Object

I had similar Issue where we have GenericResponse object containing list of values

`````` ResponseEntity<ResponseDTO> responseEntity = restTemplate.exchange(
redisMatchedDriverUrl,
HttpMethod.POST,
requestEntity,
ResponseDTO.class
);
``````

Usage of objectMapper helped in converting LinkedHashMap into respective DTO objects

`````` ObjectMapper mapper = new ObjectMapper();

List<DriverLocationDTO> driverlocationsList = mapper.convertValue(responseDTO.getData(), new TypeReference<List<DriverLocationDTO>>() { });
``````

how to get the first and last days of a given month

``````## Get Current Month's First Date And Last Date

echo "Today Date: ". \$query_date = date('d-m-Y');
echo "<br> First day of the month: ". date('01-m-Y', strtotime(\$query_date));
echo "<br> Last day of the month: ". date('t-m-Y', strtotime(\$query_date));
``````

How to get whole and decimal part of a number?

Just to be different :)

``````list(\$whole, \$decimal) = sscanf(1.5, '%d.%d');
``````

As an added benefit, it will only split where both sides consist of digits.

How to switch to other branch in Source Tree to commit the code?

1. Go to the log view (to be able to go here go to View -> log view).
2. Double click on the line with the branch label stating that branch. Automatically, it will switch branch. (A prompt will dropdown and say switching branch.)
3. If you have two or more branches on the same line, it will ask you via prompt which branch you want to switch. Choose the specific branch from the dropdown and click ok.

To determine which branch you are now on, look at the side bar, under BRANCHES, you are in the branch that is in BOLD LETTERS.

ORA-28000: the account is locked error getting frequently

Check the `PASSWORD_LOCK_TIME` parameter. If it is set to 1 then you won't be able to unlock the password for 1 day even after you issue the `alter user unlock` command.

LIKE operator in LINQ

Regex? no. But for that query you can just use:

`````` string filter = "BALTIMORE";
(blah) .Where(row => row.PortName.Contains(filter)) (blah)
``````

If you really want SQL `LIKE`, you can use `System.Data.Linq.SqlClient.SqlMethods.Like(...)`, which LINQ-to-SQL maps to `LIKE` in SQL Server.

How do I retrieve an HTML element's actual width and height?

element.offsetWidth and element.offsetHeight should do, as suggested in previous post.

However, if you just want to center the content, there is a better way of doing so. Assuming you use xhtml strict DOCTYPE. set the margin:0,auto property and required width in px to the body tag. The content gets center aligned to the page.

gnuplot - adjust size of key/legend

To adjust the length of the samples:

``````set key samplen X
``````

(default is 4)

To adjust the vertical spacing of the samples:

``````set key spacing X
``````

(default is 1.25)

and (for completeness), to adjust the fontsize:

``````set key font "<face>,<size>"
``````

(default depends on the terminal)

And of course, all these can be combined into one line:

``````set key samplen 2 spacing .5 font ",8"
``````

Note that you can also change the position of the key using `set key at <position>` or any one of the pre-defined positions (which I'll just defer to `help key` at this point)

How to solve "The specified service has been marked for deletion" error

I was having this issue when I was using Application Verifier to verify my win service. Even after I closed App Ver my service was blocked from deletion. Only removing the service from App Ver resolved the issue and service was deleted right away. Looks like some process still using your service after you tried to delete one.

VS Code - Search for text in all files in a directory

Select your folder, Press ? + ? + F Don't know about windows but this works for mac :)

Programmatically shut down Spring Boot application

Closing a `SpringApplication` basically means closing the underlying `ApplicationContext`. The `SpringApplication#run(String...)` method gives you that `ApplicationContext` as a `ConfigurableApplicationContext`. You can then `close()` it yourself.

For example,

``````@SpringBootApplication
public class Example {
public static void main(String[] args) {
ConfigurableApplicationContext ctx = SpringApplication.run(Example.class, args);
// ...determine it's time to shut down...
ctx.close();
}
}
``````

Alternatively, you can use the `static` `SpringApplication.exit(ApplicationContext, ExitCodeGenerator...)` helper method to do it for you. For example,

``````@SpringBootApplication
public class Example {
public static void main(String[] args) {
ConfigurableApplicationContext ctx = SpringApplication.run(Example.class, args);
// ...determine it's time to stop...
int exitCode = SpringApplication.exit(ctx, new ExitCodeGenerator() {
@Override
public int getExitCode() {
// no errors
return 0;
}
});

// or shortened to
// int exitCode = SpringApplication.exit(ctx, () -> 0);

System.exit(exitCode);
}
}
``````

What is Func, how and when is it used

Maybe it is not too late to add some info.

Sum:

The Func is a custom delegate defined in System namespace that allows you to point to a method with the same signature (as delegates do), using 0 to 16 input parameters and that must return something.

Nomenclature & how2use:

``````Func<input_1, input_2, ..., input1_6, output> funcDelegate = someMethod;
``````

Definition:

``````public delegate TResult Func<in T, out TResult>(T arg);
``````

Where it is used:

It is used in lambda expressions and anonymous methods.

Table Height 100% inside Div element

This is how you can do it-

HTML-

``````<div style="overflow:hidden; height:100%">
<div style="float:left">a<br>b</div>
<table cellpadding="0" cellspacing="0" style="height:100%;">
<tr><td>This is the content of a table that takes 100% height</td></tr>
</table>
</div>
``````

CSS-

``````html,body
{
height:100%;
background-color:grey;
}
table
{
background-color:yellow;
}
``````

See the DEMO

Update: Well, if you are not looking for applying 100% height to your parent containers, then here is a jQuery solution that should help you-

Demo-using jQuery

Script-

`````` \$(document).ready(function(){
var b= \$(window).height(); //gets the window's height, change the selector if you are looking for height relative to some other element
\$("#tab").css("height",b);
});
``````

Decreasing height of bootstrap 3.0 navbar

This is my experience

`````` .navbar { min-height:38px;   }
.navbar .navbar-brand{ padding: 0 12px;font-size: 16px;line-height: 38px;height: 38px; }
.navbar .navbar-nav > li > a {  padding-top: 0px; padding-bottom: 0px; line-height: 38px; }
.navbar .navbar-toggle {  margin-top: 3px; margin-bottom: 0px; padding: 8px 9px; }
.navbar .navbar-form { margin-top: 2px; margin-bottom: 0px }
.navbar .navbar-collapse {border-color: #A40303;}
``````

Checking for an empty file in C++

use this: data.peek() != '\0'

I've been searching for an hour until finaly this helped!

jQuery check if an input is type checkbox?

A non-jQuery solution is much like a jQuery solution:

``````document.querySelector('#myinput').getAttribute('type') === 'checkbox'
``````

When should an IllegalArgumentException be thrown?

Any API should check the validity of the every parameter of any public method before executing it:

``````void setPercentage(int pct, AnObject object) {
if( pct < 0 || pct > 100) {
throw new IllegalArgumentException("pct has an invalid value");
}
if (object == null) {
throw new IllegalArgumentException("object is null");
}
}
``````

They represent 99.9% of the times errors in the application because it is asking for impossible operations so in the end they are bugs that should crash the application (so it is a non recoverable error).

In this case and following the approach of fail fast you should let the application finish to avoid corrupting the application state.

How to yum install Node.JS on Amazon Linux

As others mentioned using `epel` gives a really outdated version, here is a little script I just wrote instead to add to the CI pipeline or pass it to ec2 `user-data` to install the latest version of node, simply replace the `version` with what you want, and the appropriate `distro` of Linux you are using.

The following example is for amazon-Linux-2-AMI

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

version='v14.13.1'
distro='linux-x64'
package_name="node-\$version-\$distro"
package_location="/usr/local/lib/"

tar -xvf \$package_name.tar.gz -C \$package_location
rm -rfv \$package_name.tar.gz

echo "export PATH=\$package_location/\$package_name/bin:\\$PATH" >> ~/.profile

``````

if you want to test it in the same shell simply run

``````. ~/.profile
``````

How to fix "Root element is missing." when doing a Visual Studio (VS) Build?

In my case the RDLC files work with resource files (.resx), I had this error because I hadn't created the correspondent resx file for my rdlc report.

My solution was add the file .resx inside the App_LocalResources in this way:

``````\rep
\rep\myreport.rdlc
\rep\App_LocalResources\myreport.rdlc.resx
``````

Get JSONArray without array name?

`JSONArray` has a constructor which takes a `String` source (presumed to be an array).

So something like this

``````JSONArray array = new JSONArray(yourJSONArrayAsString);
``````

java.util.zip.ZipException: error in opening zip file

Make sure your jar file is not corrupted. If it's corrupted or not able to unzip, this error will occur.

Using Docker-Compose, how to execute multiple commands

Another idea:

If, as in this case, you build the container just place a startup script in it and run this with command. Or mount the startup script as volume.

How can I verify if an AD account is locked?

Here's another one:

``````PS> Search-ADAccount -Locked | Select Name, LockedOut, LastLogonDate

Name                                       LockedOut LastLogonDate
----                                       --------- -------------
Yxxxxxxx                                        True 14/11/2014 10:19:20
Bxxxxxxx                                        True 18/11/2014 08:38:34
Administrator                                   True 03/11/2014 20:32:05
``````

Other parameters worth mentioning:

``````Search-ADAccount -AccountExpired

``````

PHP: How to send HTTP response code?

We can get different return value from http_response_code via the two different environment:

1. Web Server Environment
2. CLI environment

At the web server environment, return previous response code if you provided a response code or when you do not provide any response code then it will be print the current value. Default value is 200 (OK).

At CLI Environment, true will be return if you provided a response code and false if you do not provide any response_code.

Example of Web Server Environment of Response_code's return value:

``````var_dump(http_respone_code(500)); // int(200)
var_dump(http_response_code()); // int(500)
``````

Example of CLI Environment of Response_code's return value:

``````var_dump(http_response_code()); // bool(false)
var_dump(http_response_code(501)); // bool(true)
var_dump(http_response_code()); // int(501)
``````

The OutputPath property is not set for this project

I encountered the same error but the problem turned out to be because I had created a new configuration in my solution that didn't exist in referenced assemblies from another solution.

This can be resolved by opening the related solution and adding the new configuration to it as well.

This post gave me the idea to check the referenced assemblies after I'd already confirmed that all projects within my solution had the correct configuration:

http://gabrielmagana.com/2010/04/solution-to-the-outputpath-property-is-not-set-for-this-project/

jQuery click function doesn't work after ajax call?

Here's the FIDDLE

Same code as yours but it will work on dynamically created elements.

``````\$(document).on('click', '.deletelanguage', function () {
\$('#LangTable').append(' <br>------------<br> <a class="deletelanguage">Now my class is deletelanguage. click me to test it is not working.</a>');
});
``````

Compilation fails with "relocation R_X86_64_32 against `.rodata.str1.8' can not be used when making a shared object"

Simply cleaning the project solved it for me.

My project is a C++ application (not a shared library). I randomly got this error after a lot of successful builds.

How do I find the length (or dimensions, size) of a numpy matrix in python?

`shape` is a property of both numpy ndarray's and matrices.

``````A.shape
``````

will return a tuple (m, n), where m is the number of rows, and n is the number of columns.

In fact, the numpy `matrix` object is built on top of the `ndarray` object, one of numpy's two fundamental objects (along with a universal function object), so it inherits from `ndarray`

Printing Batch file results to a text file

For showing result of batch file in text file, you can use

this command

``````chdir > test.txt
``````

This command will redirect result to test.txt.

When you open test.txt you will found current path of directory in test.txt

What is the bit size of long on 64-bit Windows?

Microsoft has also defined UINT_PTR and INT_PTR for integers that are the same size as a pointer.

Here is a list of Microsoft specific types - it's part of their driver reference, but I believe it's valid for general programming as well.

Count unique values in a column in Excel

Another tricky way that just occurred to me (tested and it worked!).

• Select the data in the column
• In the menu, select `Conditional Formatting`, `Highlight Cells`, `Duplicate Values`
• Select whether you want to highlight unique or duplicate values.
• Save the highlight
• Select the data
• Go to `Data` and then `Filter`

Filter based on color:

Admittedly, this is more for one-off checks of data than a spreadsheet you'll use often, since it requires some formatting changes.

Swift Open Link in Safari

since iOS 10 you should use:

``````guard let url = URL(string: linkUrlString) else {
return
}

if #available(iOS 10.0, *) {
UIApplication.shared.open(url, options: [:], completionHandler: nil)
} else {
UIApplication.shared.openURL(url)
}
``````

assign function return value to some variable using javascript

The result is `undefined` since `\$.ajax` runs an asynchronous operation. Meaning that `return status` gets executed before the `\$.ajax` operation finishes with the request.

You may use Promise to have a syntax which feels synchronous.

``````function doSomething() {
return new Promise((resolve, reject) => {
\$.ajax({
url:'action.php',
type: "POST",
data: dataString,
success: function (txtBack) {
if(txtBack==1) {
resolve(1);
} else {
resolve(0);
}
},
error: function (jqXHR, textStatus, errorThrown) {
reject(textStatus);
}
});
});
}
``````

You can call the promise like this

``````doSomething.then(function (result) {
console.log(result);
}).catch(function (error) {
console.error(error);
});
``````

or this

``````(async () => {
try {
let result = await doSomething();
console.log(result);
} catch (error) {
console.error(error);
}
})();
``````

How do I Geocode 20 addresses without receiving an OVER_QUERY_LIMIT response?

No, there is not really any other way : if you have many locations and want to display them on a map, the best solution is to :

• fetch the latitude+longitude, using the geocoder, when a location is created
• store those in your database, alongside the address
• and use those stored latitude+longitude when you want to display the map.

This is, of course, considering that you have a lot less creation/modification of locations than you have consultations of locations.

Yes, it means you'll have to do a bit more work when saving the locations -- but it also means :

• You'll be able to search by geographical coordinates
• i.e. "I want a list of points that are near where I'm now"
• Displaying the map will be a lot faster
• Even with more than 20 locations on it
• Oh, and, also (last but not least) : this will work ;-)
• You will less likely hit the limit of X geocoder calls in N seconds.
• And you will less likely hit the limit of Y geocoder calls per day.

How do I change TextView Value inside Java Code?

First we need to find a `Button`:

``````Button mButton = (Button) findViewById(R.id.my_button);
``````

After that, you must implement `View.OnClickListener` and there you should find the `TextView` and execute the method `setText`:

``````mButton.setOnClickListener(new View.OnClickListener {
public void onClick(View v) {
final TextView mTextView = (TextView) findViewById(R.id.my_text_view);
mTextView.setText("Some Text");
}
});
``````

How to return Json object from MVC controller to view

``````\$.ajax({
dataType: "json",
type: "POST",
url: "/Home/AutocompleteID",
data: data,
success: function (data) {
\$('#search').html('');
\$('#search').append(data[0].Scheme_Code);
\$('#search').append(data[0].Scheme_Name);
}
});
``````

How to sort a List of objects by their date (java collections, List<Object>)

You can use this:

``````Collections.sort(list, org.joda.time.DateTimeComparator.getInstance());
``````

Accessing JSON object keys having spaces

The way to do this is via the bracket notation.

_x000D_
_x000D_
``````var test = {_x000D_
"id": "109",_x000D_
"No. of interfaces": "4"_x000D_
}_x000D_
_x000D_
_x000D_
_x000D_

How to refresh an IFrame using Javascript?

This should help:

``````document.getElementById('FrameID').contentWindow.location.reload(true);
``````

EDIT: Fixed the object name as per @Joro's comment.

How to assign a value to a TensorFlow variable?

Use Tensorflow eager execution mode which is latest.

``````import tensorflow as tf
tf.enable_eager_execution()
my_int_variable = tf.get_variable("my_int_variable", [1, 2, 3])
print(my_int_variable)
``````

Bogus foreign key constraint fail

Cannot delete or update a parent row: a foreign key constraint fails (`table1`.`user_role`, CONSTRAINT `FK143BF46A8dsfsfds@#5A6BD60` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`))

What i did in two simple steps . first i delete the child row in child table like

mysql> delete from table2 where role_id = 2 && user_id =20;

Query OK, 1 row affected (0.10 sec)

and second step as deleting the parent

delete from table1 where id = 20;

Query OK, 1 row affected (0.12 sec)

By this i solve the Problem which means Delete Child then Delete parent

i Hope You got it. :)

OS X Bash, 'watch' command

Or, in your ~/.bashrc file:

``````function watch {
while :; do clear; date; echo; \$@; sleep 2; done
}
``````

How to get request URI without context path?

getPathInfo() sometimes return null. In documentation HttpServletRequest

This method returns null if there was no extra path information.

I need get path to file without context path in Filter and getPathInfo() return me null. So I use another method: httpRequest.getServletPath()

``````public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException
{
HttpServletRequest httpRequest = (HttpServletRequest) request;
HttpServletResponse httpResponse = (HttpServletResponse) response;

String newPath = parsePathToFile(httpRequest.getServletPath());
...

}
``````

How to print out a variable in makefile

if you use android make (mka) `@echo \$(NDK_PROJECT_PATH)` will not work and gives you error `*** missing separator. Stop."` use this answer if you are trying to print variables in android make

``````NDK_PROJECT_PATH := some_value
\$(warning \$(NDK_PROJECT_PATH))
``````

that worked for me

What is the difference between a mutable and immutable string in C#?

in implementation detail.

CLR2's System.String is mutable. StringBuilder.Append calling String.AppendInplace (private method)

CLR4's System.String is immutable. StringBuilder have Char array with chunking.

How to resolve "Input string was not in a correct format." error?

Replace with

``````imageWidth = 1 * Convert.ToInt32(Label1.Text);
``````

Why does Vim save files with a ~ extension?

I think the better solution is to place these lines in your vimrc file

``````set backupdir=~/vimtmp//,.
set directory=~/vimtmp//,.
``````

The first line is for backup files, the second line for swap files. The double slash at the end ensures that there is no conflict in case of two files having the same name, see comments (at the time of this edit this option is only honored for swap files, not yet for backup files). The `,.` allow `vim` to use the current directory if the former doesn't exist.

You have to create a directory in your home directory called vimtmp for this to work. Also, check that backups are enabled in your config (add `set backup` if not).

That way you get the benefit of both worlds, you don't have to see the files, but if something does get futzed you can go get your backup file from vimtmp. Don't forget to clean the directory out every now and then.

Why AVD Manager options are not showing in Android Studio

After updating Android Studio to the latest version I finally found the AVD Manager:

1. (Update Android Studio)
2. Create a new project
3. Click on the device config dropdown:

CUDA incompatible with my gcc version

I had to install the older versions of gcc, g++.

``````    sudo apt-get install gcc-4.4
sudo apt-get install g++-4.4
``````

Check that gcc-4.4 is in /usr/bin/, and same for g++ Then I could use the solution above:

``````    sudo ln -s /usr/bin/gcc-4.4 /opt/cuda/bin/gcc
sudo ln -s /usr/bin/g++-4.4 /opt/cuda/bin/g++
``````

How to restore PostgreSQL dump file into Postgres databases?

I find that psql.exe is quite picky with the slash direction, at least on windows (which the above looks like).

Here's an example. In a cmd window:

``````C:\Program Files\PostgreSQL\9.2\bin>psql.exe -U postgres
psql (9.2.4)
Type "help" for help.

postgres=# \i c:\temp\try1.sql
c:: Permission denied
postgres=# \i c:/temp/try1.sql
CREATE TABLE
postgres=#
``````

You can see it fails when I use "normal" windows slashes in a `\i` call. However both slash styles work if you pass them as input params to `psql.exe`, for example:

``````C:\Program Files\PostgreSQL\9.2\bin>psql.exe -U postgres -f c:\TEMP\try1.sql
CREATE TABLE

C:\Program Files\PostgreSQL\9.2\bin>psql.exe -U postgres -f c:/TEMP/try1.sql
CREATE TABLE

C:\Program Files\PostgreSQL\9.2\bin>
``````

C# winforms combobox dynamic autocomplete

This code is write on your form load. It display all the Tour in database when user type letter in combo box. This code automatically suggest and append the right choice as user want.

``````            con.Open();
cmd = new SqlCommand("SELECT DISTINCT Tour FROM DetailsTB", con);
DataTable dt = new DataTable();
combo_search2.DisplayMember = "Tour";
combo_search2.DroppedDown = true;

List<string> list = new List<string>();
foreach (DataRow row in dt.Rows)
{
}
combo_search2.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
combo_search2.AutoCompleteSource = AutoCompleteSource.ListItems;
con.Close();
``````

How to print a float with 2 decimal places in Java?

You may use this quick codes below that changed itself at the end. Add how many zeros as refers to after the point

``````float y1 = 0.123456789;
DecimalFormat df = new DecimalFormat("#.00");
y1 = Float.valueOf(df.format(y1));
``````

The variable y1 was equals to 0.123456789 before. After the code it turns into 0.12 only.

Docker expose all ports or range of ports from 7000 to 8000

For anyone facing this issue and ending up on this post...the issue is still open - https://github.com/moby/moby/issues/11185

Can you install and run apps built on the .NET framework on a Mac?

You can use a .Net environment Visual studio, Take a look at the differences with the PC version.

A lighter editor would be Visual Code

Alternatives :

1. Installing the Mono Project runtime . It allows you to re-compile the code and run it on a Mac, but this requires various alterations to the codebase, as the fuller .Net Framework is not available. (Also, WPF applications aren't supported here either.)

2. Virtual machine (VMWare Fusion perhaps)

3. Update your codebase to .Net Core, (before choosing this option take a look at this migration process)

• .Net Core 3.1 is an open-source, free and available on Window, MacOs and Linux

• As of September 14, a release candidate 1 of .Net Core 5.0 has been deployed on Window, MacOs and Linux.

[1] : Release candidate (RC) : releases providing early access to complete features. These releases are supported for production use when they have a go-live license

Search for one value in any column of any table inside a database

After trying @regeter's solution and seeing it didn't solve my problem when I was searching for a foreign/primary key to see all tables/columns where it exists, it didn't work. After reading how it failed for another who tried to use a unique identifier, I have made the modifications and here is the updated result: (works with both int, and guids... you will see how to easily extend)

``````CREATE PROC [dbo].[SearchAllTables_Like]
(
@SearchStr nvarchar(100)
)
AS
BEGIN

-- Purpose: To search all columns of all tables for a given search string
-- Written by: Narayana Vyas Kondreddi
-- Tested on: SQL Server 7.0 and SQL Server 2000
-- Date modified: 28th July 2002 22:50 GMT

CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))

SET NOCOUNT ON

DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
SET  @TableName = ''
SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')

WHILE @TableName IS NOT NULL
BEGIN
SET @ColumnName = ''
SET @TableName =
(
SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))
FROM    INFORMATION_SCHEMA.TABLES
WHERE       TABLE_TYPE = 'BASE TABLE'
AND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName
AND OBJECTPROPERTY(
OBJECT_ID(
QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)
), 'IsMSShipped'
) = 0
)

WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)
BEGIN

SET @ColumnName =
(
SELECT MIN(QUOTENAME(COLUMN_NAME))
FROM    INFORMATION_SCHEMA.COLUMNS
WHERE       TABLE_SCHEMA    = PARSENAME(@TableName, 2)
AND TABLE_NAME  = PARSENAME(@TableName, 1)
AND DATA_TYPE IN ('guid', 'int', 'char', 'varchar', 'nchar', 'nvarchar')
AND QUOTENAME(COLUMN_NAME) > @ColumnName
)

IF @ColumnName IS NOT NULL
BEGIN
INSERT INTO #Results
EXEC
(
'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630)
FROM ' + @TableName + ' (NOLOCK) ' +
' WHERE ' + @ColumnName + ' LIKE ' + @SearchStr2
)
END
END
END

SELECT ColumnName, ColumnValue FROM #Results
END
``````

Apache server keeps crashing, "caught SIGTERM, shutting down"

Try to upgrade and install new packages

``````sudo apt-get update && sudo apt-get upgrade -y
``````

"echo -n" prints "-n"

Just for the most popular linux `Ubuntu` & it's `bash`:

1. Check which shell are you using? Mostly below works, else see this:

`echo \$0`

2. If above prints `bash`, then below will work:

`printf "hello with no new line printed at end"`
OR
`echo -n "hello with no new line printed at end"`

Change Date Format(DD/MM/YYYY) in SQL SELECT Statement

Changed to:

``````SELECT FORMAT(SA.[RequestStartDate],'dd/MM/yyyy') as 'Service Start Date', SA.[RequestEndDate] as 'Service End Date', FROM (......)SA WHERE......
``````

Have no idea which SQL engine you are using, for other SQL engine, CONVERT can be used in SELECT statement to change the format in the form you needed.

How to sort a dataFrame in python pandas by two or more columns?

As of the 0.17.0 release, the `sort` method was deprecated in favor of `sort_values`. `sort` was completely removed in the 0.20.0 release. The arguments (and results) remain the same:

``````df.sort_values(['a', 'b'], ascending=[True, False])
``````

You can use the ascending argument of `sort`:

``````df.sort(['a', 'b'], ascending=[True, False])
``````

For example:

``````In [11]: df1 = pd.DataFrame(np.random.randint(1, 5, (10,2)), columns=['a','b'])

In [12]: df1.sort(['a', 'b'], ascending=[True, False])
Out[12]:
a  b
2  1  4
7  1  3
1  1  2
3  1  2
4  3  2
6  4  4
0  4  3
9  4  3
5  4  1
8  4  1
``````

As commented by @renadeen

Sort isn't in place by default! So you should assign result of the sort method to a variable or add inplace=True to method call.

that is, if you want to reuse df1 as a sorted DataFrame:

``````df1 = df1.sort(['a', 'b'], ascending=[True, False])
``````

or

``````df1.sort(['a', 'b'], ascending=[True, False], inplace=True)
``````

How to query SOLR for empty fields?

you can do it with filter query q=*:*&fq=-id:*

Create Generic method constraining T to an Enum

Just for completeness, the following is a Java solution. I am certain the same could be done in C# as well. It avoids having to specify the type anywhere in code - instead, you specify it in the strings you are trying to parse.

The problem is that there isn't any way to know which enumeration the String might match - so the answer is to solve that problem.

Instead of accepting just the string value, accept a String that has both the enumeration and the value in the form "enumeration.value". Working code is below - requires Java 1.8 or later. This would also make the XML more precise as in you would see something like color="Color.red" instead of just color="red".

You would call the acceptEnumeratedValue() method with a string containing the enum name dot value name.

The method returns the formal enumerated value.

``````import java.util.HashMap;
import java.util.Map;
import java.util.function.Function;

public class EnumFromString {

enum NumberEnum {One, Two, Three};
enum LetterEnum {A, B, C};

Map<String, Function<String, ? extends Enum>> enumsByName = new HashMap<>();

public static void main(String[] args) {
EnumFromString efs = new EnumFromString();

System.out.print("\nFirst string is NumberEnum.Two - enum is " + efs.acceptEnumeratedValue("NumberEnum.Two").name());
System.out.print("\nSecond string is LetterEnum.B - enum is " + efs.acceptEnumeratedValue("LetterEnum.B").name());

}

public EnumFromString() {
enumsByName.put("NumberEnum", s -> {return NumberEnum.valueOf(s);});
enumsByName.put("LetterEnum", s -> {return LetterEnum.valueOf(s);});
}

public Enum acceptEnumeratedValue(String enumDotValue) {

int pos = enumDotValue.indexOf(".");

String enumName = enumDotValue.substring(0, pos);
String value = enumDotValue.substring(pos + 1);

Enum enumeratedValue = enumsByName.get(enumName).apply(value);

return enumeratedValue;
}

}
``````

Node.js console.log() not logging anything

In a node.js server `console.log` outputs to the terminal window, not to the browser's console window.

How are you running your server? You should see the output directly after you start it.

You can't directly add custom headers with window.open() in popup window but to work that we have two possible solutions

1. Write Ajax method to call that particular URL with headers in a separate HTML file and use that HTML as url in`<i>window.open()</i>` here is abc.html
``````        \$.ajax({
url: "ORIGIONAL_URL",
type: 'GET',
dataType: 'json',
Authorization : 'Bearer ' + data.id_token,
AuthorizationCheck : 'AccessCode ' +data.checkSum ,
ContentType :'application/json'
},

success: function (result) {
console.log(result);
},
error: function (error) {

} });
``````

call html

``````window.open('*\abc.html')
``````

here CORS policy can block the request if CORS is not enabled in requested URL.

1. You can request a URL that triggers a server-side program which makes the request with custom headers and then returns the response redirecting to that particular url.

Suppose in Java Servlet(/requestURL) we'll make this request

`

``````        String[] responseHeader= new String[2];
responseHeader[0] = "Bearer " + id_token;
responseHeader[1] = "AccessCode " + checkSum;

String url = "ORIGIONAL_URL";

URL obj = new URL(url);
HttpURLConnection urlConnection = (HttpURLConnection) obj.openConnection();
urlConnection.setRequestMethod("GET");
urlConnection.setDoInput(true);
urlConnection.setDoOutput(true);
urlConnection.setRequestProperty("Content-Type", "application/json");
urlConnection.setRequestProperty("Accept", "application/json");
int responseCode = urlConnection.getResponseCode();
if (responseCode == HttpURLConnection.HTTP_OK) {
String inputLine;
StringBuffer response1 = new StringBuffer();

while ((inputLine = in.readLine()) != null) {
response1.append(inputLine);
}
in.close();
response.sendRedirect(response1.toString());
// print result
System.out.println(response1.toString());
} else {
System.out.println("GET request not worked");
}
``````

`

call servlet in `window.open('/requestURL')`

Using Mockito to mock classes with generic parameters

Here is an interesting case: method receieves generic collection and returns generic collection of same base type. For example:

``````Collection<? extends Assertion> map(Collection<? extends Assertion> assertions);
``````

This method can be mocked with combination of Mockito anyCollectionOf matcher and the Answer.

``````when(mockedObject.map(anyCollectionOf(Assertion.class))).thenAnswer(
@Override
public Collection<Assertion> answer(InvocationOnMock invocation) throws Throwable {
return new ArrayList<Assertion>();
}
});
``````

Java - how do I write a file to a specified directory

Just put the full directory location in the File object.

``````File file = new File("z:\\results.txt");
``````

CodeIgniter Active Record - Get number of returned rows

``````\$this->db->select('count(id) as rows');
\$this->db->from('table_name');
\$this->db->where('active',1);
\$query = \$this->db->get();
foreach(\$query->result() as \$r)
{
return \$r->rows;
}
``````

SAP Crystal Reports runtime for .Net 4.0 (64-bit)

SAP is notoriously bad at making these downloads available... or in an easily accessible location so hopefully this link still works by the time you read this answer.

< original link no longer active >

http://scn.sap.com/docs/DOC-7824 `Updated Link 2/6/13:`

http://www.crystalreports.com/crvs/confirm/ - "Updated 10/31/2017"

Paste MS Excel data to SQL Server

The simplest way is to create a computed column in XLS that would generate the syntax of the insert statement. Then copy these insert into a text file and then execute on the SQL. The other alternatives are to buy database connectivity add-on's for Excel and write VBA code to accomplish the same.

Change color of Back button in navigation bar

All the answers setting `UINavigationBar.appearance().tintColor` conflict with Apple's documentation in `UIAppearance.h`.

Note for iOS7: On iOS7 the `tintColor` property has moved to `UIView`, and now has special inherited behavior described in `UIView.h`. This inherited behavior can conflict with the appearance proxy, and therefore `tintColor` is now disallowed with the appearance proxy.

In Xcode, you need to command-click on each property you want to use with appearance proxy to inspect the header file and make sure the property is annotated with `UI_APPEARANCE_SELECTOR`.

So the correct way to color the navigation bar purple and the title and buttons white throughout the app via the appearance proxy is:

``````UINavigationBar.appearance().isTranslucent = false
UINavigationBar.appearance().titleTextAttributes = [NSAttributedStringKey.foregroundColor: UIColor.white]
UIBarButtonItem.appearance().tintColor = .white
``````

Note that `UIBarButtonItem` is not a subclass of `UIView` but rather `NSObject`. So its `tintColor` property is not the inherited `tintColor` from `UIView`.

Unfortunately, `UIBarButtonItem.tintColor` is not annotated with `UI_APPEARANCE_SELECTOR` – but that seems to me a documentation bug. The response from Apple Engineering in this radar states it is supported.

querySelector and querySelectorAll vs getElementsByClassName and getElementById in JavaScript

I would like to know what exactly is the difference between querySelector and querySelectorAll against getElementsByClassName and getElementById?

The syntax and the browser support.

`querySelector` is more useful when you want to use more complex selectors.

e.g. All list items descended from an element that is a member of the foo class: `.foo li`

document.querySelector("#view:_id1:inputText1") it doesn't work. But writing document.getElementById("view:_id1:inputText1") works. Any ideas why?

The `:` character has special meaning inside a selector. You have to escape it. (The selector escape character has special meaning in a JS string too, so you have to escape that too).

``````document.querySelector("#view\\:_id1\\:inputText1")
``````

Add tooltip to font awesome icon

The issue of adding tooltips to any HTML-Output (not only FontAwesome) is an entire book on its own. ;-)

The default way would be to use the title-attribute:

``````  <div id="welcomeText" title="So nice to see you!">
<p>Welcome Harriet</p>
</div>
``````

or

``````<i class="fa fa-cog" title="Do you like my fa-coq icon?"></i>
``````

But since most people (including me) do not like the standard-tooltips, there are MANY tools out there which will "beautify" them and offer all sort of enhancements. My personal favourites are jBox and qtip2.

How to handle checkboxes in ASP.NET MVC forms?

You should also use `<label for="checkbox1">Checkbox 1</label>` because then people can click on the label text as well as the checkbox itself. Its also easier to style and at least in IE it will be highlighted when you tab through the page's controls.

``````<%= Html.CheckBox("cbNewColors", true) %><label for="cbNewColors">New colors</label>
``````

This is not just a 'oh I could do it' thing. Its a significant user experience enhancement. Even if not all users know they can click on the label many will.

Composer is avialble and install the packages in the global path but they are not available in the shell, Mac in my case. I managed to fix this by adding the global bin to the path at my bash file.

Steps:

First, check what is your home directory by typing in the shell:

``````cd ~
pwd
``````

this will tell you the home path

The next step is to verify that composer set the global directory there:

``````ls -al .composer
``````

If you got list of files that's mean composer set up the directory, if not - look above or in the documentation.

The next step is to edit the bash profile. Mine is ~/.bash_profile but other can ~/.zshrc. If you don't have any one like this try to see how to set up aliases and place the the code in aliases file:

``````PATH="YOUR_HOME_PATH/.composer/vendor/bin:\${PATH}"
export PATH
``````

That's it! just reload the file with

``````source PATH_TO_FILE
``````

And you good to go!

SelectedValue vs SelectedItem.Value of DropDownList

One important distinction between the two (which is visible in the Reflected code) is that SelectedValue will return an empty string if a nothing is selected, whereas SelectedItem.Value will throw a NullReference exception.

How do I generate a random integer between min and max in Java?

As the solutions above do not consider the possible overflow of doing `max-min` when `min` is negative, here another solution (similar to the one of kerouac)

``````public static int getRandom(int min, int max) {
if (min > max) {
throw new IllegalArgumentException("Min " + min + " greater than max " + max);
}
return (int) ( (long) min + Math.random() * ((long)max - min + 1));
}
``````

this works even if you call it with:

``````getRandom(Integer.MIN_VALUE, Integer.MAX_VALUE)
``````

Center a H1 tag inside a DIV

There is a new way using transforms. Apply this to the element to centre. It nudges down by half the container height and then 'corrects' by half the element height.

``````position: relative;
top: 50%;
transform: translateY(-50%);
-webkit-transform: translateY(-50%);
-ms-transform: translateY(-50%);
``````

It works most of the time. I did have a problem where a `div` was in a `div` in a `li`. The list item had a height set and the outer `div`s made up 3 columns (Foundation). The 2nd and 3rd column divs contained images, and they centered just fine with this technique, however the heading in the first column needed a wrapping div with an explicit height set.

Now, does anyone know if the CSS people are working on a way to align stuff, like, easily? Seeing that its 2014 and even some of my friends are regularly using the internet, I wondered if anyone had considered that centering would be a useful styling feature yet. Just us then?

SeekBar and media player in android

Try this Code:

``````public class MainActivity extends AppCompatActivity {

MediaPlayer mplayer;

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

//You create MediaPlayer variable ==> set the path and start the audio.

mplayer = MediaPlayer.create(this, R.raw.example);
mplayer.start();

//Find the seek bar by Id (which you have to create in layout)
// Set seekBar max with length of audio
// You need a Timer variable to set progress with position of audio

final SeekBar seekBar = (SeekBar) findViewById(R.id.seekBar);
seekBar.setMax(mplayer.getDuration());

new Timer().scheduleAtFixedRate(new TimerTask() {
@Override
public void run() {
seekBar.setProgress(mplayer.getCurrentPosition());
}
}, 0, 1000);

seekBar.setOnSeekBarChangeListener(new SeekBar.OnSeekBarChangeListener() {
@Override
public void onProgressChanged(SeekBar seekBar, int progress, boolean fromUser) {

// Update the progress depending on seek bar
mplayer.seekTo(progress);

}

@Override
public void onStartTrackingTouch(SeekBar seekBar) {

}

@Override
public void onStopTrackingTouch(SeekBar seekBar) {

}
});
}
``````

PHP Get URL with Parameter

`\$_SERVER['PHP_SELF']` for the page name and `\$_GET['id']` for a specific parameter.

try `print_r(\$_GET);` to print out all the parameters.

for your request `echo \$_SERVER['PHP_SELF']."?id=".\$_GET['id'];`

return all the parameters `echo \$_SERVER['PHP_SELF']."?".\$_SERVER['QUERY_STRING'];`

What is the difference between a deep copy and a shallow copy?

Shallow Copy- Reference variable inside original and shallow-copied objects have reference to common object.

Deep Copy- Reference variable inside original and deep-copied objects have reference to different object.

clone always does shallow copy.

``````public class Language implements Cloneable{

String name;
public Language(String name){
this.name=name;
}

public String getName() {
return name;
}

@Override
protected Object clone() throws CloneNotSupportedException {
return super.clone();
}
}
``````

main class is following-

``````public static void main(String args[]) throws ClassNotFoundException, CloneNotSupportedException{

ArrayList<Language> list=new ArrayList<Language>();

ArrayList<Language> shallow=(ArrayList<Language>) list.clone();
//We used here clone since this always shallow copied.

System.out.println(list==shallow);

for(int i=0;i<list.size();i++)
System.out.println(list.get(i)==shallow.get(i));//true

ArrayList<Language> deep=new ArrayList<Language>();
for(Language language:list){
}
System.out.println(list==deep);
for(int i=0;i<list.size();i++)
System.out.println(list.get(i)==deep.get(i));//false

}
``````

OutPut of above will be-

false true true

false false false

Any change made in origional object will reflect in shallow object not in deep object.

``````  list.get(0).name="ViSuaLBaSiC";
System.out.println(shallow.get(0).getName()+"  "+deep.get(0).getName());
``````

OutPut- ViSuaLBaSiC C

What is dtype('O'), in pandas?

It means "a python object", i.e. not one of the builtin scalar types supported by numpy.

``````np.array([object()]).dtype
=> dtype('O')
``````

How to scale Docker containers in production

Have a look at Rancher.com - it can manage multiple Docker hosts and much more.

PHP AES encrypt / decrypt

Here's an improved version based on code written by blade

• overwrite arguments before throwing to avoid leaking secrets with the exception
• check return values from openssl and hmac functions

The code:

``````class Crypto
{
/**
* Encrypt data using OpenSSL (AES-256-CBC)
* @param string \$plaindata Data to be encrypted
* @param string \$cryptokey key for encryption (with 256 bit of entropy)
* @param string \$hashkey key for hashing (with 256 bit of entropy)
* @return string IV+Hash+Encrypted as raw binary string. The first 16
*     bytes is IV, next 32 bytes is HMAC-SHA256 and the rest is
*     \$plaindata as encrypted.
* @throws Exception on internal error
*
* Based on code from: https://stackoverflow.com/a/46872528
*/
public static function encrypt(\$plaindata, \$cryptokey, \$hashkey)
{
\$method = "AES-256-CBC";
\$key = hash('sha256', \$cryptokey, true);
\$iv = openssl_random_pseudo_bytes(16);

\$cipherdata = openssl_encrypt(\$plaindata, \$method, \$key, OPENSSL_RAW_DATA, \$iv);

if (\$cipherdata === false)
{
\$cryptokey = "**REMOVED**";
\$hashkey = "**REMOVED**";
throw new \Exception("Internal error: openssl_encrypt() failed:".openssl_error_string());
}

\$hash = hash_hmac('sha256', \$cipherdata.\$iv, \$hashkey, true);

if (\$hash === false)
{
\$cryptokey = "**REMOVED**";
\$hashkey = "**REMOVED**";
throw new \Exception("Internal error: hash_hmac() failed");
}

return \$iv.\$hash.\$cipherdata;
}

/**
* Decrypt data using OpenSSL (AES-256-CBC)
* @param string \$encrypteddata IV+Hash+Encrypted as raw binary string
*     where the first 16 bytes is IV, next 32 bytes is HMAC-SHA256 and
*     the rest is encrypted payload.
* @param string \$cryptokey key for decryption (with 256 bit of entropy)
* @param string \$hashkey key for hashing (with 256 bit of entropy)
* @return string Decrypted data
* @throws Exception on internal error
*
* Based on code from: https://stackoverflow.com/a/46872528
*/
public static function decrypt(\$encrypteddata, \$cryptokey, \$hashkey)
{
\$method = "AES-256-CBC";
\$key = hash('sha256', \$cryptokey, true);
\$iv = substr(\$encrypteddata, 0, 16);
\$hash = substr(\$encrypteddata, 16, 32);
\$cipherdata = substr(\$encrypteddata, 48);

if (!hash_equals(hash_hmac('sha256', \$cipherdata.\$iv, \$hashkey, true), \$hash))
{
\$cryptokey = "**REMOVED**";
\$hashkey = "**REMOVED**";
throw new \Exception("Internal error: Hash verification failed");
}

\$plaindata = openssl_decrypt(\$cipherdata, \$method, \$key, OPENSSL_RAW_DATA, \$iv);

if (\$plaindata === false)
{
\$cryptokey = "**REMOVED**";
\$hashkey = "**REMOVED**";
throw new \Exception("Internal error: openssl_decrypt() failed:".openssl_error_string());
}

return \$plaindata;
}
}
``````

If you truly cannot have proper encryption and hash keys but have to use an user entered password as the only secret, you can do something like this:

``````/**
* @param string \$password user entered password as the only source of
*   entropy to generate encryption key and hash key.
* @return array(\$encryption_key, \$hash_key) - note that PBKDF2 algorithm
*   has been configured to take around 1-2 seconds per conversion
*   from password to keys on a normal CPU to prevent brute force attacks.
*/
{
return str_split(\$hash, 64);
}
``````

how to Call super constructor in Lombok

Version 1.18 of Lombok introduced the @SuperBuilder annotation. We can use this to solve our problem in a simpler way.

so in your child class, you will need these annotations:

``````@Data
@SuperBuilder
@NoArgsConstructor
@EqualsAndHashCode(callSuper = true)
``````

in your parent class:

``````@Data
@SuperBuilder
@NoArgsConstructor
``````

How to insert a file in MySQL database?

File size by MySQL type:

• TINYBLOB 255 bytes = 0.000255 Mb
• BLOB 65535 bytes = 0.0655 Mb
• MEDIUMBLOB 16777215 bytes = 16.78 Mb
• LONGBLOB 4294967295 bytes = 4294.97 Mb = 4.295 Gb

How to export JavaScript array info to csv (on client side)?

I would recommend using a library like PapaParse: https://github.com/mholt/PapaParse

The accepted answer currently has multiple issues including:

• it fails if the data contains a comma
• it fails if the data contains a linebreak
• it (kind of) fails if the data contains a quotation mark

How can I make a TextBox be a "password box" and display stars when using MVVM?

To get or set the Password in a PasswordBox, use the Password property. Such as

``````string password = PasswordBox.Password;
``````

This doesn't support Databinding as far as I know, so you'd have to set the value in the codebehind, and update it accordingly.

How do I set default values for functions parameters in Matlab?

There isn't a direct way to do this like you've attempted.

The usual approach is to use "varargs" and check against the number of arguments. Something like:

``````function f(arg1, arg2, arg3)

if nargin < 3
arg3 =   'some default'
end

end
``````

There are a few fancier things you can do with `isempty`, etc., and you might want to look at Matlab central for some packages that bundle these sorts of things.

You might have a look at `varargin`, `nargchk`, etc. They're useful functions for this sort of thing. varargs allow you to leave a variable number of final arguments, but this doesn't get you around the problem of default values for some/all of them.

Python: How to convert datetime format?

@Tim's answer only does half the work -- that gets it into a datetime.datetime object.

To get it into the string format you require, you use datetime.strftime:

``````print(datetime.strftime('%b %d,%Y'))
``````

What's the difference between next() and nextLine() methods from Scanner class?

• A `Scanner` breaks its input into tokens using a delimiter pattern, which by default matches whitespace.
• `next()`: Finds and returns the next complete token from this scanner.
• `nextLine()`: Advances this scanner past the current line and returns the input that was skipped.

So in case of `"small example<eol>text"` `next()` should return "small" and `nextLine()` should return "small example"

Select the top N values by group

``````# start with the mtcars data frame (included with your installation of R)
mtcars

# pick your 'group by' variable
gbv <- 'cyl'
# IMPORTANT NOTE: you can only include one group by variable here
# ..if you need more, the `order` function below will need
# one per inputted parameter: order( x\$cyl , x\$am )

# choose whether you want to find the minimum or maximum
find.maximum <- FALSE

# create a simple data frame with only two columns
x <- mtcars

# order it based on
x <- x[ order( x[ , gbv ] , decreasing = find.maximum ) , ]

# figure out the ranks of each miles-per-gallon, within cyl columns
if ( find.maximum ){
# note the negative sign (which changes the order of mpg)
# *and* the `rev` function, which flips the order of the `tapply` result
x\$ranks <- unlist( rev( tapply( -x\$mpg , x[ , gbv ] , rank ) ) )
} else {
x\$ranks <- unlist( tapply( x\$mpg , x[ , gbv ] , rank ) )
}
# now just subset it based on the rank column
result <- x[ x\$ranks <= 3 , ]

# look at your results
result

# done!

# but note only *two* values where cyl == 4 were kept,
# because there was a tie for third smallest, and the `rank` function gave both '3.5'
x[ x\$ranks == 3.5 , ]

# ..if you instead wanted to keep all ties, you could change the
# tie-breaking behavior of the `rank` function.
# using the `min` *includes* all ties.  using `max` would *exclude* all ties
if ( find.maximum ){
# note the negative sign (which changes the order of mpg)
# *and* the `rev` function, which flips the order of the `tapply` result
x\$ranks <- unlist( rev( tapply( -x\$mpg , x[ , gbv ] , rank , ties.method = 'min' ) ) )
} else {
x\$ranks <- unlist( tapply( x\$mpg , x[ , gbv ] , rank , ties.method = 'min' ) )
}
# and there are even more options..
# see ?rank for more methods

# now just subset it based on the rank column
result <- x[ x\$ranks <= 3 , ]

# look at your results
result
# and notice *both* cyl == 4 and ranks == 3 were included in your results
# because of the tie-breaking behavior chosen.
``````

SQL Server add auto increment primary key to existing table

alter table /** paste the tabal's name **/ add id int IDENTITY(1,1)

delete from /** paste the tabal's name **/ where id in

(

select a.id FROM /** paste the tabal's name / as a LEFT OUTER JOIN ( SELECT MIN(id) as id FROM / paste the tabal's name / GROUP BY / paste the columns c1,c2 .... **/

``````) as t1
ON a.id = t1.id
``````

WHERE t1.id IS NULL

)

alter table /** paste the tabal's name **/ DROP COLUMN id

How do I compare two files using Eclipse? Is there any option provided by Eclipse?

Just select all of the files you want to compare, then open the context menu (Right-Click on the file) and choose Compare With, Then select each other..

Can I delete data from the iOS DeviceSupport directory?

Yes, you can delete data from iOS device support by the symbols of the operating system, one for each version for each architecture. It's used for debugging. If you don't need to support those devices any more, you can delete the directory without ill effect

python ignore certificate validation urllib2

For those who uses an opener, you can achieve the same thing based on Enno Gröper's great answer:

``````import urllib2, ssl

ctx = ssl.create_default_context()
ctx.check_hostname = False
ctx.verify_mode = ssl.CERT_NONE

opener = urllib2.build_opener(urllib2.HTTPSHandler(context=ctx), your_first_handler, your_second_handler[...])

``````

And then use it as before.

According to build_opener and HTTPSHandler, a HTTPSHandler is added if `ssl` module exists, here we just specify our own instead of the default one.

PowerShell script to return members of multiple security groups

``````Get-ADGroupMember "Group1" -recursive | Select-Object Name | Export-Csv c:\path\Groups.csv
``````

I got this to work for me... I would assume that you could put "Group1, Group2, etc." or try a wildcard. I did pre-load AD into PowerShell before hand:

``````Get-Module -ListAvailable | Import-Module
``````

How to get id from URL in codeigniter?

Check the below code hope that you get your parameter

``````echo \$this->uri->segment('3');
``````

How to avoid using Select in Excel VBA

These methods are rather stigmatized, so taking the lead of Vityata and Jeeped for the sake of drawing a line in the sand:

Call `.Activate`, `.Select`, `Selection`, `ActiveSomething` methods/properties

Basically because they're called primarily to handle user input through the application UI. Since they're the methods called when the user handles objects through the UI, they're the ones recorded by the macro-recorder, and that's why calling them is either brittle or redundant for most situations: you don't have to select an object so as to perform an action with `Selection` right afterwards.

However, this definition settles situations on which they are called for:

When to call `.Activate`, `.Select`, `.Selection`, `.ActiveSomething` methods/properties

Basically when you expect the final user to play a role in the execution.

If you are developing and expect the user to choose the object instances for your code to handle, then `.Selection` or `.ActiveObject` are apropriate.

On the other hand, `.Select` and `.Activate` are of use when you can infer the user's next action and you want your code to guide the user, possibly saving him/her some time and mouse clicks. For example, if your code just created a brand new instance of a chart or updated one, the user might want to check it out, and you could call `.Activate` on it or its sheet to save the user the time searching for it; or if you know the user will need to update some range values, you can programmatically select that range.

Foreign key constraints: When to use ON UPDATE and ON DELETE

Addition to @MarkR answer - one thing to note would be that many PHP frameworks with ORMs would not recognize or use advanced DB setup (foreign keys, cascading delete, unique constraints), and this may result in unexpected behaviour.

For example if you delete a record using ORM, and your `DELETE CASCADE` will delete records in related tables, ORM's attempt to delete these related records (often automatic) will result in error.

Windows batch file file download from a URL

With PowerShell 2.0 (Windows 7 preinstalled) you can use:

``````(New-Object Net.WebClient).DownloadFile('http://www.example.com/package.zip', 'package.zip')
``````

Starting with PowerShell 3.0 (Windows 8 preinstalled) you can use `Invoke-WebRequest`:

``````Invoke-WebRequest http://www.example.com/package.zip -OutFile package.zip
``````

From a batch file they are called:

``````powershell -Command "(New-Object Net.WebClient).DownloadFile('http://www.example.com/package.zip', 'package.zip')"
powershell -Command "Invoke-WebRequest http://www.example.com/package.zip -OutFile package.zip"
``````

(PowerShell 2.0 is available for installation on XP, 3.0 for Windows 7)

javascript createElement(), style problem

Others have given you the answer about appendChild.

Calling `document.write()` on a page that is not open (e.g. has finished loading) first calls `document.open()` which clears the entire content of the document (including the script calling document.write), so it's rarely a good idea to do that.

Post Build exited with code 1

For those, who use 'copy' command in Build Events (Pre-build event command line or/and Post-build event command line) from Project -> Properties: you 'copy' command parameters should look like here: `copy "source of files" "destination for files"`. Remember to use quotation marks (to avoid problems with spaces in strings of address).

MongoDB: Is it possible to make a case-insensitive query?

One very important thing to keep in mind when using a Regex based query - When you are doing this for a login system, escape every single character you are searching for, and don't forget the ^ and \$ operators. Lodash has a nice function for this, should you be using it already:

``````db.stuff.find({\$regex: new RegExp(_.escapeRegExp(bar), \$options: 'i'})
``````

Why? Imagine a user entering `.*` as his username. That would match all usernames, enabling a login by just guessing any user's password.

My Routes are Returning a 404, How can I Fix Them?

Just Run in your terminal.

`````` composer dump-autoload
``````

What is the correct way to free memory in C#

Here's a quick overview:

• Once references are gone, your object will likely be garbage collected.
• You can only count on statistical collection that keeps your heap size normal provided all references to garbage are really gone. In other words, there is no guarantee a specific object will ever be garbage collected.
• It follows that your finalizer will also never be guaranteed to be called. Avoid finalizers.
• Two common sources of leaks:
• Event handlers and delegates are references. If you subscribe to an event of an object, you are referencing to it. If you have a delegate to an object's method, you are referencing it.
• Unmanaged resources, by definition, are not automatically collected. This is what the IDisposable pattern is for.
• Finally, if you want a reference that does not prevent the object from getting collected, look into WeakReference.

One last thing: If you declare `Foo foo;` without assigning it you don't have to worry - nothing is leaked. If Foo is a reference type, nothing was created. If Foo is a value type, it is allocated on the stack and thus will automatically be cleaned up.

Javascript call() & apply() vs bind()?

Both `Function.prototype.call()` and `Function.prototype.apply()` call a function with a given `this` value, and return the return value of that function.

`Function.prototype.bind()`, on the other hand, creates a new function with a given `this` value, and returns that function without executing it.

So, let's take a function that looks like this :

``````var logProp = function(prop) {
console.log(this[prop]);
};
``````

Now, let's take an object that looks like this :

``````var Obj = {
x : 5,
y : 10
};
``````

We can bind our function to our object like this :

``````Obj.log = logProp.bind(Obj);
``````

Now, we can run `Obj.log` anywhere in our code :

``````Obj.log('x'); // Output : 5
Obj.log('y'); // Output : 10
``````

Where it really gets interesting, is when you not only bind a value for `this`, but also for for its argument `prop` :

``````Obj.logX = logProp.bind(Obj, 'x');
Obj.logY = logProp.bind(Obj, 'y');
``````

We can now do this :

``````Obj.logX(); // Output : 5
Obj.logY(); // Output : 10
``````

What is an undefined reference/unresolved external symbol error and how do I fix it?

An “Undefined Reference” error occurs when we have a reference to object name (class, function, variable, etc.) in our program and the linker cannot find its definition when it tries to search for it in all the linked object files and libraries.

Thus when the linker cannot find the definition of a linked object, it issues an “undefined reference” error. As clear from definition, this error occurs in the later stages of the linking process. There are various reasons that cause an “undefined reference” error.

Some possible reason(more frequent):

#1) No Definition Provided For Object

This is the simplest reason for causing an “undefined reference” error. The programmer has simply forgotten to define the object.

Consider the following C++ program. Here we have only specified the prototype of function and then used it in the main function.

``````#include <iostream>
int func1();
int main()
{

func1();
}
``````

Output:

``````main.cpp:(.text+0x5): undefined reference to 'func1()'
collect2: error ld returned 1 exit status
``````

So when we compile this program, the linker error that says “undefined reference to ‘func1()’” is issued.

In order to get rid of this error, we correct the program as follows by providing the definition of the function func1. Now the program gives the appropriate output.

``````#include <iostream>
using namespace std;
int func1();

int main()
{

func1();
}
int func1(){
cout<<"hello, world!!";
}
``````

Output:

``````hello, world!!
``````

#2) Wrong Definition (signatures don’t match) Of Objects Used

Yet another cause for “undefined reference” error is when we specify wrong definitions. We use any object in our program and its definition is something different.

Consider the following C++ program. Here we have made a call to func1 (). Its prototype is int func1 (). But its definition does not match with its prototype. As we see, the definition of the function contains a parameter to the function.

Thus when the program is compiled, the compilation is successful because of the prototype and function call match. But when the linker is trying to link the function call with its definition, it finds the problem and issues the error as “undefined reference”.

``````#include <iostream>
using namespace std;
int func1();
int main()
{

func1();
}
int func1(int n){
cout<<"hello, world!!";
}
``````

Output:

``````main.cpp:(.text+0x5): undefined reference to 'func1()'
collect2: error ld returned 1 exit status
``````

Thus to prevent such errors, we simply cross-check if the definitions and usage of all the objects are matching in our program.

#3) Object Files Not Linked Properly

This issue can also give rise to the “undefined reference” error. Here, we may have more than one source files and we might compile them independently. When this is done, the objects are not linked properly and it results in “undefined reference”.

Consider the following two C++ programs. In the first file, we make use of the “print ()” function which is defined in the second file. When we compile these files separately, the first file gives “undefined reference” for the print function, while the second file gives “undefined reference” for the main function.

``````int print();
int main()
{
print();
}
``````

Output:

``````main.cpp:(.text+0x5): undefined reference to 'print()'
collect2: error ld returned 1 exit status

int print() {
return 42;
}
``````

Output:

``````(.text+0x20): undefined reference to 'main'
collect2: error ld returned 1 exit status
``````

The way to resolve this error is to compile both the files simultaneously (For example, by using g++).

Apart from the causes already discussed, “undefined reference” may also occur because of the following reasons.

#4) Wrong Project Type

When we specify wrong project types in C++ IDEs like the visual studio and try to do things that the project does not expect, then, we get “undefined reference”.

#5) No Library

If a programmer has not specified the library path properly or completely forgotten to specify it, then we get an “undefined reference” for all the references the program uses from the library.

#6) Dependent Files Are Not Compiled

A programmer has to ensure that we compile all the dependencies of the project beforehand so that when we compile the project, the compiler finds all the dependencies and compiles successfully. If any of the dependencies are missing then the compiler gives “undefined reference”.

Apart from the causes discussed above, the “undefined reference” error can occur in many other situations. But the bottom line is that the programmer has got the things wrong and in order to prevent this error they should be corrected.

Excel VBA code to copy a specific string to clipboard

If you want to put a variable's value in the clipboard using the Immediate window, you can use this single line to easily put a breakpoint in your code:

``````Set MSForms_DataObject = CreateObject("new:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}"): MSForms_DataObject.SetText VARIABLENAME: MSForms_DataObject.PutInClipboard: Set MSForms_DataObject = Nothing
``````

How to resolve "must be an instance of string, string given" prior to PHP 7?

I think typecasting on php on inside block, String on PHP is not object as I know:

``````<?php
function phpwtf(\$s) {
\$s = (string) \$s;
echo "\$s\n";
}
phpwtf("Type hinting is da bomb");
``````

What is the difference between java and core java?

I think when you see the phrase "core Java," they are talking about the basics of the language and maybe some knowledge of Java SE. I don't know why they would bother to put the "core" on there.

jquery function val() is not equivalent to "\$(this).value="?

One thing you can do is this:

``````\$(this)[0].value = "Something";
``````

This allows jQuery to return the javascript object for that element, and you can bypass jQuery Functions.

Init function in javascript and how it works

I can't believe no-one has answered the ops question!

The last set of brackets are used for passing in the parameters to the anonymous function. So, the following example creates a function, then runs it with the x=5 and y=8

``````(function(x,y){
//code here
})(5,8)
``````

This may seem not so useful, but it has its place. The most common one I have seen is

``````(function(\$){
//code here
})(jQuery)
``````

which allows for jQuery to be in compatible mode, but you can refer to it as "\$" within the anonymous function.

"Rate This App"-link in Google Play store app on the phone

Best Way

From now you can use In App Rating feature by Google.

Here is Kotlin/Java integration official guide

The Google Play In-App Review API lets you prompt users to submit Play Store ratings and reviews without the inconvenience of leaving your app or game.

Generally, the in-app review flow (see figure 1) can be triggered at any time throughout the user journey of your app. During the flow, the user has the ability to rate your app using the 1 to 5 star system and to add an optional comment. Once submitted, the review is sent to the Play Store and eventually displayed.