Programs & Examples On #Existential type

Existential types are types that provide a collection of operations that act on an unspecified, or abstract, type. They thus capture notions of interface and abstraction in a type theoretic setting.

In SQL how to compare date values?

Uh, WHERE mydate<='2008-11-25' is the way to do it. That should work.

Do you get an error message? Are you using an ancient version of MySQL?

Edit: The following works fine for me on MySQL 5.x

create temporary table foo(d datetime);
insert into foo(d) VALUES ('2000-01-01');
insert into foo(d) VALUES ('2001-01-01');
select * from foo where d <= '2000-06-01';

Handlebars.js Else If

The spirit of handlebars is that it is "logicless". Sometimes this makes us feel like we are fighting with it, and sometimes we end up with ugly nested if/else logic. You could write a helper; many people augment handlebars with a "better" conditional operator or believe that it should be part of the core. I think, though, that instead of this,

{{#if FriendStatus.IsFriend}}
  <div class="ui-state-default ui-corner-all" title=".ui-icon-mail-closed"><span class="ui-icon ui-icon-mail-closed"></span></div>
{{else}}
  {{#if FriendStatus.FriendRequested}}
    <div class="ui-state-default ui-corner-all" title=".ui-icon-check"><span class="ui-icon ui-icon-check"></span></div>
  {{else}}
    <div class="ui-state-default ui-corner-all" title=".ui-icon-plusthick"><span class="ui-icon ui-icon-plusthick"></span></div>
  {{/if}}
{{/if}}

you might want to arrange things in your model so that you can have this,

{{#if is_friend }}
  <div class="ui-state-default ui-corner-all" title=".ui-icon-mail-closed"><span class="ui-icon ui-icon-mail-closed"></span></div>
{{/if}}

{{#if is_not_friend_yet }}
    <div class="ui-state-default ui-corner-all" title=".ui-icon-check"><span class="ui-icon ui-icon-check"></span></div>
{{/if}}

{{#if will_never_be_my_friend }}
    <div class="ui-state-default ui-corner-all" title=".ui-icon-plusthick"><span class="ui-icon ui-icon-plusthick"></span></div>
{{/if}}

Just make sure that only one of these flags is ever true. Chances are, if you are using this if/elsif/else in your view, you are probably using it somewhere else too, so these variables might not end up being superfluous.

Keep it lean.

Android Text over image

That is how I did it and it worked exactly as you asked for inside a RelativeLayout:

<RelativeLayout 
    xmlns:android="http://schemas.android.com/apk/res/android"
    android:id="@+id/relativelayout"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent" >

    <ImageView
        android:id="@+id/myImageView"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:src="@drawable/myImageSouce" />

    <TextView
        android:id="@+id/myImageViewText"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignLeft="@id/myImageView"
        android:layout_alignTop="@id/myImageView"
        android:layout_alignRight="@id/myImageView"
        android:layout_alignBottom="@id/myImageView"
        android:layout_margin="1dp"
        android:gravity="center"
        android:text="Hello"
        android:textColor="#000000" />

</RelativeLayout>

regex match any whitespace

Your regex should work 'as-is'. Assuming that it is doing what you want it to.

wordA(\s*)wordB(?! wordc)

This means match wordA followed by 0 or more spaces followed by wordB, but do not match if followed by wordc. Note the single space between ?! and wordc which means that wordA wordB wordc will not match, but wordA wordB wordc will.

Here are some example matches and the associated replacement output:

enter image description here

Note that all matches are replaced no matter how many spaces. There are a couple of other points: -

  • (?! wordc) is a negative lookahead, so you wont match lines wordA wordB wordc which is assume is intended (and is why the last line is not matched). Currently you are relying on the space after ?! to match the whitespace. You may want to be more precise and use (?!\swordc). If you want to match against more than one space before wordc you can use (?!\s*wordc) for 0 or more spaces or (?!\s*+wordc) for 1 or more spaces depending on what your intention is. Of course, if you do want to match lines with wordc after wordB then you shouldn't use a negative lookahead.

  • * will match 0 or more spaces so it will match wordAwordB. You may want to consider + if you want at least one space.

  • (\s*) - the brackets indicate a capturing group. Are you capturing the whitespace to a group for a reason? If not you could just remove the brackets, i.e. just use \s.

Update based on comment

Hello the problem is not the expression but the HTML out put   that are not considered as whitespace. it's a Joomla website.

Preserving your original regex you can use:

wordA((?:\s|&nbsp;)*)wordB(?!(?:\s|&nbsp;)wordc)

The only difference is that not the regex matches whitespace OR &nbsp;. I replaced wordc with \swordc since that is more explicit. Note as I have already pointed out that the negative lookahead ?! will not match when wordB is followed by a single whitespace and wordc. If you want to match multiple whitespaces then see my comments above. I also preserved the capture group around the whitespace, if you don't want this then remove the brackets as already described above.

Example matches:

enter image description here

NuGet auto package restore does not work with MSBuild

Nuget's Automatic Package Restore is a feature of the Visual Studio (starting in 2013), not MSBuild. You'll have to run nuget.exe restore if you want to restore packages from the command line.

You can also use the Enable Nuget Package Restore feature, but this is no longer recommended by the nuget folks because it makes intrusive changes to the project files and may cause problems if you build those projects in another solution.

Assigning more than one class for one event

Have you tried this:

 function doSomething() {
     if ($(this).hasClass('clickedTag')){
         // code here
     } else {
         // and here
     }
 }

 $('.tag1, .tag2').click(doSomething);

Sum function in VBA

Range("A10") = WorksheetFunction.Sum(Worksheets("Sheet1").Range("A1", "A9"))

Where

Range("A10") is the answer cell

Range("A1", "A9") is the range to calculate

Getting all types in a namespace via reflection

Namespaces are actually rather passive in the design of the runtime and serve primarily as organizational tools. The Full Name of a type in .NET consists of the Namespace and Class/Enum/Etc. combined. If you only wish to go through a specific assembly, you would simply loop through the types returned by assembly.GetExportedTypes() checking the value of type.Namespace. If you were trying to go through all assemblies loaded in the current AppDomain it would involve using AppDomain.CurrentDomain.GetAssemblies()

PHP Sort a multidimensional array by element containing date

Use usort() and a custom comparison function:

function date_compare($a, $b)
{
    $t1 = strtotime($a['datetime']);
    $t2 = strtotime($b['datetime']);
    return $t1 - $t2;
}    
usort($array, 'date_compare');

EDIT: Your data is organized in an array of arrays. To better distinguish those, let's call the inner arrays (data) records, so that your data really is an array of records.

usort will pass two of these records to the given comparison function date_compare() at a a time. date_compare then extracts the "datetime" field of each record as a UNIX timestamp (an integer), and returns the difference, so that the result will be 0 if both dates are equal, a positive number if the first one ($a) is larger or a negative value if the second argument ($b) is larger. usort() uses this information to sort the array.

Copying a HashMap in Java

Java supports shallow(not deep) copy concept

You can archive it using:

  • constructor
  • clone()
  • putAll()

How to make html table vertically scrollable

The jQuery plugin is probably the best option. http://farinspace.com/jquery-scrollable-table-plugin/

To fixing header you can check this post

Fixing Header of GridView or HtmlTable (there might be issue that this should work in IE only)

CSS for fixing header

div#gridPanel 
{
   width:900px;
   overflow:scroll;
   position:relative;
}


div#gridPanel th
{  
   top: expression(document.getElementById("gridPanel").scrollTop-2);
   left:expression(parentNode.parentNode.parentNode.parentNode.scrollLeft);
   position: relative;
   z-index: 20;
  }

<div height="200px" id="gridPanel" runat="server" scrollbars="Auto" width="100px">
table..
</div>

or

Very good post is here for this

How to Freeze Columns Using JavaScript and HTML.

or

No its not possible but you can make use of div and put table in div

<div style="height: 100px; overflow: auto">
  <table style="height: 500px;">
   ...
  </table>
</div>

How to set an iframe src attribute from a variable in AngularJS

select template; iframe controller, ng model update

index.html

angularapp.controller('FieldCtrl', function ($scope, $sce) {
        var iframeclass = '';
        $scope.loadTemplate = function() {
            if ($scope.template.length > 0) {
                // add iframe classs
                iframeclass = $scope.template.split('.')[0];
                iframe.classList.add(iframeclass);
                $scope.activeTemplate = $sce.trustAsResourceUrl($scope.template);
            } else {
                iframe.classList.remove(iframeclass);
            };
        };

    });
    // custom directive
    angularapp.directive('myChange', function() {
        return function(scope, element) {
            element.bind('input', function() {
                // the iframe function
                iframe.contentWindow.update({
                    name: element[0].name,
                    value: element[0].value
                });
            });
        };
    });

iframe.html

   window.update = function(data) {
        $scope.$apply(function() {
            $scope[data.name] = (data.value.length > 0) ? data.value: defaults[data.name];
        });
    };

Check this link: http://plnkr.co/edit/TGRj2o?p=preview

how to print a string to console in c++

yes it's possible to print a string to the console.

#include "stdafx.h"
#include <string>
#include <iostream>

using namespace std;

int _tmain(int argc, _TCHAR* argv[])
{
    string strMytestString("hello world");
    cout << strMytestString;
    return 0;
}

stdafx.h isn't pertinent to the solution, everything else is.

What's the difference between an element and a node in XML?

Different W3C specifications define different sets of "Node" types.

Thus, the DOM spec defines the following types of nodes:

  • Document -- Element (maximum of one), ProcessingInstruction, Comment, DocumentType
  • DocumentFragment -- Element, ProcessingInstruction, Comment, Text, CDATASection, EntityReference
  • DocumentType -- no children
  • EntityReference -- Element, ProcessingInstruction, Comment, Text, CDATASection, EntityReference
  • Element -- Element, Text, Comment, ProcessingInstruction, CDATASection, EntityReference
  • Attr -- Text, EntityReference
  • ProcessingInstruction -- no children
  • Comment -- no children
  • Text -- no children
  • CDATASection -- no children
  • Entity -- Element, ProcessingInstruction, Comment, Text, CDATASection, EntityReference
  • Notation -- no children

The XML Infoset (used by XPath) has a smaller set of nodes:

  • The Document Information Item
  • Element Information Items
  • Attribute Information Items
  • Processing Instruction Information Items
  • Unexpanded Entity Reference Information Items
  • Character Information Items
  • Comment Information Items
  • The Document Type Declaration Information Item
  • Unparsed Entity Information Items
  • Notation Information Items
  • Namespace Information Items
  • XPath has the following Node types:

    • root nodes
    • element nodes
    • text nodes
    • attribute nodes
    • namespace nodes
    • processing instruction nodes
    • comment nodes

    The answer to your question "What is the difference between an element and a node" is:

    An element is a type of node. Many other types of nodes exist and serve different purposes.

    Why is a div with "display: table-cell;" not affected by margin?

    If you have div next each other like this

    <div id="1" style="float:left; margin-right:5px">
    
    </div>
    <div id="2" style="float:left">
    
    </div>
    

    This should work!

    How to use "/" (directory separator) in both Linux and Windows in Python?

    Use:

    import os
    print os.sep
    

    to see how separator looks on a current OS.
    In your code you can use:

    import os
    path = os.path.join('folder_name', 'file_name')
    

    How to use external ".js" files

    This is the way to include an external javascript file to you HTML markup.

    <script type="text/javascript" src="/js/external-javascript.js"></script>
    

    Where external-javascript.js is the external file to be included. Make sure the path and the file name are correct while you including it.

    <a href="javascript:showCountry('countryCode')">countryCode</a>
    

    The above mentioned method is correct for anchor tags and will work perfectly. But for other elements you should specify the event explicitly.

    Example:

    <select name="users" onChange="showUser(this.value)">
    

    Thanks, XmindZ

    Dealing with float precision in Javascript

    You could do something like this:

    > +(Math.floor(y/x)*x).toFixed(15);
    1.2
    

    Deserializing JSON array into strongly typed .NET object

    try

    List<TheUser> friends = jsonSerializer.Deserialize<List<TheUser>>(response);
    

    Write Base64-encoded image to file

    import java.util.Base64;
    

    .... Just making it clear that this answer uses the java.util.Base64 package, without using any third-party libraries.

    String crntImage=<a valid base 64 string>
    
    byte[] data = Base64.getDecoder().decode(crntImage);
    
    try( OutputStream stream = new FileOutputStream("d:/temp/abc.pdf") ) 
    {
       stream.write(data);
    }
    catch (Exception e) 
    {
       System.err.println("Couldn't write to file...");
    }
    

    How can I kill whatever process is using port 8080 so that I can vagrant up?

    In case above-accepted answer did not work, try below solution. You can use it for port 8080 or for any other ports.

    sudo lsof -i tcp:3000 
    

    Replace 3000 with whichever port you want. Run below command to kill that process.

    sudo kill -9 PID
    

    PID is process ID you want to kill.

    Below is the output of commands on mac Terminal.

    Command output

    How do I change the hover over color for a hover over table in Bootstrap?

    This is for bootstrap v4 compiled via grunt or some other task runner

    You would need to change $table-hover-bg to set the highlight on hover

    $table-cell-padding:            .75rem !default;
    $table-sm-cell-padding:         .3rem !default;
    
    $table-bg:                      transparent !default;
    $table-accent-bg:               rgba(0,0,0,.05) !default;
    $table-hover-bg:                rgba(0,0,0,.075) !default;
    $table-active-bg:               $table-hover-bg !default;
    
    $table-border-width:            $border-width !default;
    $table-border-color:            $gray-lighter !default;
    

    $_POST vs. $_SERVER['REQUEST_METHOD'] == 'POST'

    Well, they don't do the same thing, really.

    $_SERVER['REQUEST_METHOD'] contains the request method (surprise).

    $_POST contains any post data.

    It's possible for a POST request to contain no POST data.

    I check the request method — I actually never thought about testing the $_POST array. I check the required post fields, though. So an empty post request would give the user a lot of error messages - which makes sense to me.

    how to reset <input type = "file">

    Just use:

    $('input[type=file]').val('');
    

    How is TeamViewer so fast?

    It sounds indeed like video streaming more than image streaming, as someone suggested. JPEG/PNG compression isn't targeted for these types of speeds, so forget them.

    Imagine having a recording codec on your system that can realtime record an incoming video stream (your screen). A bit like Fraps perhaps. Then imagine a video playback codec on the other side (the remote client). As HD recorders can do it (record live and even playback live from the same HD), so should you, in the end. The HD surely can't deliver images quicker than you can read your display, so that isn't the bottleneck. The bottleneck are the video codecs. You'll find the encoder much more of a problem than the decoder, as all decoders are mostly free.

    I'm not saying it's simple; I myself have used DirectShow to encode a video file, and it's not realtime by far. But given the right codec I'm convinced it can work.

    Mapping a JDBC ResultSet to an object

    Complete solution using @TEH-EMPRAH ideas and Generic casting from Cast Object to Generic Type for returning

    import annotations.Column;
    import java.lang.reflect.Field;
    import java.lang.reflect.InvocationTargetException;
    import java.sql.SQLException;
    import java.util.*;
    
    public class ObjectMapper<T> {
    
        private Class clazz;
        private Map<String, Field> fields = new HashMap<>();
        Map<String, String> errors = new HashMap<>();
    
        public DataMapper(Class clazz) {
            this.clazz = clazz;
    
            List<Field> fieldList = Arrays.asList(clazz.getDeclaredFields());
            for (Field field : fieldList) {
                Column col = field.getAnnotation(Column.class);
                if (col != null) {
                    field.setAccessible(true);
                    fields.put(col.name(), field);
                }
            }
        }
    
        public T map(Map<String, Object> row) throws SQLException {
            try {
                T dto = (T) clazz.getConstructor().newInstance();
                for (Map.Entry<String, Object> entity : row.entrySet()) {
                    if (entity.getValue() == null) {
                        continue;  // Don't set DBNULL
                    }
                    String column = entity.getKey();
                    Field field = fields.get(column);
                    if (field != null) {
                        field.set(dto, convertInstanceOfObject(entity.getValue()));
                    }
                }
                return dto;
            } catch (IllegalAccessException | InstantiationException | NoSuchMethodException | InvocationTargetException e) {
                e.printStackTrace();
                throw new SQLException("Problem with data Mapping. See logs.");
            }
        }
    
        public List<T> map(List<Map<String, Object>> rows) throws SQLException {
            List<T> list = new LinkedList<>();
    
            for (Map<String, Object> row : rows) {
                list.add(map(row));
            }
    
            return list;
        }
    
        private T convertInstanceOfObject(Object o) {
            try {
                return (T) o;
            } catch (ClassCastException e) {
                return null;
            }
        }
    }
    

    and then in terms of how it ties in with the database, I have the following:

    // connect to database (autocloses)
    try (DataConnection conn = ds1.getConnection()) {
    
        // fetch rows
        List<Map<String, Object>> rows = conn.nativeSelect("SELECT * FROM products");
    
        // map rows to class
        ObjectMapper<Product> objectMapper = new ObjectMapper<>(Product.class);
        List<Product> products = objectMapper.map(rows);
    
        // display the rows
        System.out.println(rows);
    
        // display it as products
        for (Product prod : products) {
            System.out.println(prod);
        }
    
    } catch (Exception e) {
        e.printStackTrace();
    }
    

    How to filter in NaN (pandas)?

    Pandas uses numpy's NaN value. Use numpy.isnan to obtain a Boolean vector from a pandas series.

    Convert string to title case with JavaScript

    My list is based on three quick searches. One for a list of words not to be capitalized, and one for a full list of prepositions.

    One final search made the suggestion that prepositions 5 letters or longer should be capitalized, which is something I liked. My purpose is for informal use. I left 'without' in their, because it's the obvious counterpart to with.

    So it capitalizes acronyms, the first letter of the title, and the first letter of most words.

    It is not intended to handle words in caps-lock. I wanted to leave those alone.

    _x000D_
    _x000D_
    function camelCase(str) {_x000D_
      return str.replace(/((?:^|\.)\w|\b(?!(?:a|amid|an|and|anti|as|at|but|but|by|by|down|for|for|for|from|from|in|into|like|near|nor|of|of|off|on|on|onto|or|over|past|per|plus|save|so|than|the|to|to|up|upon|via|with|without|yet)\b)\w)/g, function(character) {_x000D_
      return character.toUpperCase();_x000D_
    })}_x000D_
        _x000D_
    console.log(camelCase('The quick brown fox jumped over the lazy dog, named butter, who was taking a nap outside the u.s. Post Office. The fox jumped so high that NASA saw him on their radar.'));
    _x000D_
    _x000D_
    _x000D_

    Java verify void method calls n times with Mockito

    The necessary method is Mockito#verify:

    public static <T> T verify(T mock,
                               VerificationMode mode)
    

    mock is your mocked object and mode is the VerificationMode that describes how the mock should be verified. Possible modes are:

    verify(mock, times(5)).someMethod("was called five times");
    verify(mock, never()).someMethod("was never called");
    verify(mock, atLeastOnce()).someMethod("was called at least once");
    verify(mock, atLeast(2)).someMethod("was called at least twice");
    verify(mock, atMost(3)).someMethod("was called at most 3 times");
    verify(mock, atLeast(0)).someMethod("was called any number of times"); // useful with captors
    verify(mock, only()).someMethod("no other method has been called on the mock");
    

    You'll need these static imports from the Mockito class in order to use the verify method and these verification modes:

    import static org.mockito.Mockito.atLeast;
    import static org.mockito.Mockito.atLeastOnce;
    import static org.mockito.Mockito.atMost;
    import static org.mockito.Mockito.never;
    import static org.mockito.Mockito.only;
    import static org.mockito.Mockito.times;
    import static org.mockito.Mockito.verify;
    

    So in your case the correct syntax will be:

    Mockito.verify(mock, times(4)).send()
    

    This verifies that the method send was called 4 times on the mocked object. It will fail if it was called less or more than 4 times.


    If you just want to check, if the method has been called once, then you don't need to pass a VerificationMode. A simple

    verify(mock).someMethod("was called once");
    

    would be enough. It internally uses verify(mock, times(1)).someMethod("was called once");.


    It is possible to have multiple verification calls on the same mock to achieve a "between" verification. Mockito doesn't support something like this verify(mock, between(4,6)).someMethod("was called between 4 and 6 times");, but we can write

    verify(mock, atLeast(4)).someMethod("was called at least four times ...");
    verify(mock, atMost(6)).someMethod("... and not more than six times");
    

    instead, to get the same behaviour. The bounds are included, so the test case is green when the method was called 4, 5 or 6 times.

    How to run a program without an operating system?

    How do you run a program all by itself without an operating system running?

    You place your binary code to a place where processor looks for after rebooting (e.g. address 0 on ARM).

    Can you create assembly programs that the computer can load and run at startup ( e.g. boot the computer from a flash drive and it runs the program that is on the drive)?

    General answer to the question: it can be done. It's often referred to as "bare metal programming". To read from flash drive, you want to know what's USB, and you want to have some driver to work with this USB. The program on this drive would also have to be in some particular format, on some particular filesystem... This is something that boot loaders usually do, but your program could include its own bootloader so it's self-contained, if the firmware will only load a small block of code.

    Many ARM boards let you do some of those things. Some have boot loaders to help you with basic setup.

    Here you may find a great tutorial on how to do a basic operating system on a Raspberry Pi.

    Edit: This article, and the whole wiki.osdev.org will anwer most of your questions http://wiki.osdev.org/Introduction

    Also, if you don't want to experiment directly on hardware, you can run it as a virtual machine using hypervisors like qemu. See how to run "hello world" directly on virtualized ARM hardware here.

    Where can I set path to make.exe on Windows?

    Or you can just run power-shell command to append extra folder to the existing path:

    $env:Path += ";C:\temp\terraform" 
    

    os.path.dirname(__file__) returns empty

    Because os.path.abspath = os.path.dirname + os.path.basename does not hold. we rather have

    os.path.dirname(filename) + os.path.basename(filename) == filename
    

    Both dirname() and basename() only split the passed filename into components without taking into account the current directory. If you want to also consider the current directory, you have to do so explicitly.

    To get the dirname of the absolute path, use

    os.path.dirname(os.path.abspath(__file__))
    

    Grep for beginning and end of line?

    You probably want egrep. Try:

    egrep '^[d-]rwx.*[0-9]$' usrLog.txt
    

    How do I purge a linux mail box with huge number of emails?

    You can simply delete the /var/mail/username file to delete all emails for a specific user. Also, emails that are outgoing but have not yet been sent will be stored in /var/spool/mqueue.

    How to find nth occurrence of character in a string?

    You can try something like this:

    import java.util.regex.Matcher;
    import java.util.regex.Pattern;
    
    public class Main {
        public static void main(String[] args) {
          System.out.println(from3rd("/folder1/folder2/folder3/"));
        }
    
        private static Pattern p = Pattern.compile("(/[^/]*){2}/([^/]*)");
    
        public static String from3rd(String in) {
            Matcher m = p.matcher(in);
    
            if (m.matches())
                return m.group(2);
            else
                return null;
        }
    }
    

    Note that I did some assumptions in the regex:

    • the input path is absolute (i.e. starts with "/");
    • you do not need the 3rd "/" in the result.

    As requested in a comment, I'll try to explain the regex: (/[^/]*){2}/([^/]*)

    Regular expression visualization

    • /[^/]* is a / followed by [^/]* (any number of characters that are not a /),
    • (/[^/]*) groups the previous expression in a single entity. This is the 1st group of the expression,
    • (/[^/]*){2} means that the group must match extactly {2} times,
    • [^/]* is again any number of characters that are not a /,
    • ([^/]*) groups the previos expression in a single entity. This is the 2nd group of the expression.

    This way you have only to get the substring that matches the 2nd group: return m.group(2);

    Image courtesy by Debuggex

    Change size of text in text input tag?

    In your CSS stylesheet, try adding:

    input[type="text"] {
        font-size:25px;
    }
    

    See this jsFiddle example

    TypeError: Converting circular structure to JSON in nodejs

    I came across this issue when not using async/await on a asynchronous function (api call). Hence adding them / using the promise handlers properly cleared the error.

    TypeError: method() takes 1 positional argument but 2 were given

    Pass cls parameter into @classmethod to resolve this problem.

    @classmethod
    def test(cls):
        return ''
    

    How to change port number in vue-cli project

    Go to node_modules/@vue/cli-service/lib/options.js
    At the bottom inside the "devServer" unblock the codes
    Now give your desired port number in the "port" :)

    devServer: {
       open: process.platform === 'darwin',
       host: '0.0.0.0',
       port: 3000,  // default port 8080
       https: false,
       hotOnly: false,
       proxy: null, // string | Object
       before: app => {}
    }
    

    Refused to display in a frame because it set 'X-Frame-Options' to 'SAMEORIGIN'

    I found a better solution, maybe it can help somebody replace "watch?v=" by "v/" and it will work

    var url = url.replace("watch?v=", "v/");
    

    Pandas unstack problems: ValueError: Index contains duplicate entries, cannot reshape

    I had such problem. In my case problem was in data - my column 'information' contained 1 unique value and it caused error

    UPDATE: to correct work 'pivot' pairs (id_user,information) cannot have duplicates

    It works:

    df2 = pd.DataFrame({'id_user':[1,2,3,4,4,5,5], 
    'information':['phon','phon','phone','phone1','phone','phone1','phone'], 
    'value': [1, '01.01.00', '01.02.00', 2, '01.03.00', 3, '01.04.00']})
    df2.pivot(index='id_user', columns='information', values='value')
    

    it doesn't work:

    df2 = pd.DataFrame({'id_user':[1,2,3,4,4,5,5], 
    'information':['phone','phone','phone','phone','phone','phone','phone'], 
    'value': [1, '01.01.00', '01.02.00', 2, '01.03.00', 3, '01.04.00']})
    df2.pivot(index='id_user', columns='information', values='value')
    

    source: https://stackoverflow.com/a/37021196/6088984

    How to convert a full date to a short date in javascript?

    You could do this pretty easily with my date-shortcode package:

    const dateShortcode = require('date-shortcode')
    
    var startDate = 'Monday, January 9, 2010'
    dateShortcode.parse('{M/D/YYYY}', startDate)
    //=> '1/9/2010'
    

    Handling errors in Promise.all

    if you get to use the q library https://github.com/kriskowal/q it has q.allSettled() method that can solve this problem you can handle every promise depending on its state either fullfiled or rejected so

    existingPromiseChain = existingPromiseChain.then(function() {
    var arrayOfPromises = state.routes.map(function(route){
      return route.handler.promiseHandler();
    });
    return q.allSettled(arrayOfPromises)
    });
    
    existingPromiseChain = existingPromiseChain.then(function(arrayResolved) {
    //so here you have all your promises the fulfilled and the rejected ones
    // you can check the state of each promise
    arrayResolved.forEach(function(item){
       if(item.state === 'fulfilled'){ // 'rejected' for rejected promises
         //do somthing
       } else {
         // do something else
       }
    })
    // do stuff with my array of resolved promises, eventually ending with a res.send();
    });
    

    find -mtime files older than 1 hour

    What about -mmin?

    find /var/www/html/audio -daystart -maxdepth 1 -mmin +59 -type f -name "*.mp3" \
        -exec rm -f {} \;
    

    From man find:

    -mmin n
            File's data was last modified n minutes ago.
    

    Also, make sure to test this first!

    ... -exec echo rm -f '{}' \;
              ^^^^ Add the 'echo' so you just see the commands that are going to get
                   run instead of actual trying them first.
    

    Editing hosts file to redirect url?

    Apply this trick.

    First you need IP address of url you want to redirect to. Lets say you want to redirect to stackoverflow.com To find it, use the ping command in a Command Prompt. Type in:

    ping stackoverflow.com
    

    into the command prompt window and you’ll see stackoverflow's numerical IP address. Now use that IP into your host file

    104.16.36.249 google.com

    yay now google is serving stackoverflow :)

    How to display gpg key details without importing it?

    pgpdump (https://www.lirnberger.com/tools/pgpdump/) is a tool that you can use to inspect pgp blocks.

    It is not user friendly, and fairly technical, however,

    • it parses public or private keys (without warning)
    • it does not modify any keyring (sometimes it is not so clear what gpg does behind the hood, in my experience)
    • it prints all packets, specifically userid's packets which shows the various text data about the keys.
    pgpdump -p test.asc 
    New: Secret Key Packet(tag 5)(920 bytes)
        Ver 4 - new
        Public key creation time - Fri May 24 00:33:48 CEST 2019
        Pub alg - RSA Encrypt or Sign(pub 1)
        RSA n(2048 bits) - ...
        RSA e(17 bits) - ...
        RSA d(2048 bits) - ...
        RSA p(1024 bits) - ...
        RSA q(1024 bits) - ...
        RSA u(1020 bits) - ...
        Checksum - 49 2f 
    New: User ID Packet(tag 13)(18 bytes)
        User ID - test (test) <tset>                        
    New: Signature Packet(tag 2)(287 bytes)
        Ver 4 - new
        Sig type - Positive certification of a User ID and Public Key packet(0x13).
        Pub alg - RSA Encrypt or Sign(pub 1)
        Hash alg - SHA256(hash 8)
        Hashed Sub: signature creation time(sub 2)(4 bytes)
            Time - Fri May 24 00:33:49 CEST 2019
        Hashed Sub: issuer key ID(sub 16)(8 bytes)
            Key ID - 0x396D5E4A2E92865F
        Hashed Sub: key flags(sub 27)(1 bytes)
            Flag - This key may be used to certify other keys
            Flag - This key may be used to sign data
        Hash left 2 bytes - 74 7a 
        RSA m^d mod n(2048 bits) - ...
            -> PKCS-1
    

    unfortunately it does not read stdin : /

    How to set label size in Bootstrap

    In Bootstrap 3 they do not have separate classes for different styles of labels.

    http://getbootstrap.com/components/

    However, you can customize bootstrap classes that way. In your css file

    .lb-sm {
      font-size: 12px;
    }
    
    .lb-md {
      font-size: 16px;
    }
    
    .lb-lg {
      font-size: 20px;
    }
    

    Alternatively, you can use header tags to change the sizes. For example, here is a medium sized label and a small-sized label

    _x000D_
    _x000D_
    <link href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet"/>_x000D_
    <h3>Example heading <span class="label label-default">New</span></h3>_x000D_
    <h6>Example heading <span class="label label-default">New</span></h6>
    _x000D_
    _x000D_
    _x000D_

    They might add size classes for labels in future Bootstrap versions.

    How to create cron job using PHP?

    function _cron_exe($schedules) {
            if ($obj->get_option('cronenabledisable') == "yes") {
                // $interval = 1*20;
                $interval = $obj->get_option('cronhowtime');
                if ($obj->get_option('crontiming') == 'minutes') {
                    $interval = $interval * 60;
                } else if ($obj->get_option('crontiming') == 'hours') {
                    $interval = $interval * 3600;
                } else if ($obj->get_option('crontiming') == 'days') {
                    $interval = $interval * 86400;
                }
                $schedules['hourlys'] = array(
                    'interval' => $interval,
                    'display' => 'cronjob'
                );
                return $schedules;
            }
    
    }
    

    Timestamp Difference In Hours for PostgreSQL

    postgresql get seconds difference between timestamps

    SELECT (
        (extract (epoch from (
            '2012-01-01 18:25:00'::timestamp - '2012-01-01 18:25:02'::timestamp
                             )
                 )
        )
    )::integer
    

    which prints:

    -2
    

    Because the timestamps are two seconds apart. Take the number and divide by 60 to get minutes, divide by 60 again to get hours.

    Easy way to export multiple data.frame to multiple Excel worksheets

    For me, WriteXLS provides the functionality you are looking for. Since you did not specify which errors it returns, I show you an example:

    Example

    library(WriteXLS)
    x <- list(sheet_a = data.frame(a=letters), sheet_b = data.frame(b = LETTERS))
    WriteXLS(x, "test.xlsx", names(x))
    

    Explanation

    If x is:

    • a list of data frames, each one is written to a single sheet
    • a character vector (of R objects), each object is written to a single sheet
    • something else, then see also what the help states:

    More on usage

    ?WriteXLS
    

    shows:

    `x`: A character vector or factor containing the names of one or
         more R data frames; A character vector or factor containing
         the name of a single list which contains one or more R data
         frames; a single list object of one or more data frames; a
         single data frame object.
    

    Solution

    For your example, you would need to collect all data.frames in a list during the loop, and use WriteXLS after the loop has finished.

    Session info

    • R 3.2.4
    • WriteXLS 4.0.0

    How to use ClassLoader.getResources() correctly?

    The Spring Framework has a class which allows to recursively search through the classpath:

    PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
    resolver.getResources("classpath*:some/package/name/**/*.xml");
    

    CSS how to make an element fade in and then fade out?

    A way to do this would be to set the color of the element to black, and then fade to the color of the background like this:

    <style> 
    p {
    animation-name: example;
    animation-duration: 2s;
    }
    
    @keyframes example {
    from {color:black;}
    to {color:white;}
    }
    </style>
    <p>I am FADING!</p>
    

    I hope this is what you needed!

    Override browser form-filling and input highlighting with HTML/CSS

    The screenshot you linked to says that WebKit is using the selector input:-webkit-autofill for those elements. Have you tried putting this in your CSS?

    input:-webkit-autofill {
        background-color: white !important;
    }
    

    If that doesn't work, then nothing probably will. Those fields are highlighted to alert the user that they have been autofilled with private information (such as the user's home address) and it could be argued that allowing a page to hide that is allowing a security risk.

    How to solve munmap_chunk(): invalid pointer error in C++

    The hint is, the output file is created even if you get this error. The automatic deconstruction of vector starts after your code executed. Elements in the vector are deconstructed as well. This is most probably where the error occurs. The way you access the vector is through vector::operator[] with an index read from stream. Try vector::at() instead of vector::operator[]. This won't solve your problem, but will show which assignment to the vector causes error.

    How to compare two columns in Excel and if match, then copy the cell next to it

    try this formula in column E:

    =IF( AND( ISNUMBER(D2), D2=G2), H2, "")

    your error is the number test, ISNUMBER( ISMATCH(D2,G:G,0) )

    you do check if ismatch is-a-number, (i.e. isNumber("true") or isNumber("false"), which is not!.

    I hope you understand my explanation.

    Apk location in New Android Studio

    I am on Android Studio 0.6 and the apk was generated in

    MyApp/myapp/build/outputs/apk/myapp-debug.apk
    

    It included all libraries so I could share it.


    Update on Android Studio 0.8.3 Beta. The apk is now in

    MyApp/myapp/build/apk/myapp-debug.apk
    

    Update on Android Studio 0.8.6 - 2.0. The apk is now in

    MyApp/myapp/build/outputs/apk/myapp-debug.apk
    

    How to plot all the columns of a data frame in R

    The ggplot2 package takes a little bit of learning, but the results look really nice, you get nice legends, plus many other nice features, all without having to write much code.

    require(ggplot2)
    require(reshape2)
    df <- data.frame(time = 1:10,
                     a = cumsum(rnorm(10)),
                     b = cumsum(rnorm(10)),
                     c = cumsum(rnorm(10)))
    df <- melt(df ,  id.vars = 'time', variable.name = 'series')
    
    # plot on same grid, each series colored differently -- 
    # good if the series have same scale
    ggplot(df, aes(time,value)) + geom_line(aes(colour = series))
    
    # or plot on different plots
    ggplot(df, aes(time,value)) + geom_line() + facet_grid(series ~ .)
    

    enter image description here enter image description here

    In Java, how do you determine if a thread is running?

    To be precise,

    Thread.isAlive() returns true if the thread has been started (may not yet be running) but has not yet completed its run method.

    Thread.getState() returns the exact state of the thread.

    Change the name of a key in dictionary

    You can associate the same value with many keys, or just remove a key and re-add a new key with the same value.

    For example, if you have keys->values:

    red->1
    blue->2
    green->4
    

    there's no reason you can't add purple->2 or remove red->1 and add orange->1

    How do I use namespaces with TypeScript external modules?

    Several of the questions/comments I've seen around this subject sound to me as if the person is using Namespace where they mean 'module alias'. As Ryan Cavanaugh mentioned in one of his comments you can have a 'Wrapper' module re-export several modules.

    If you really want to import it all from the same module name/alias, combine a wrapper module with a paths mapping in your tsconfig.json.

    Example:

    ./path/to/CompanyName.Products/Foo.ts

    export class Foo {
        ...
    }
    


    ./path/to/CompanyName.Products/Bar.ts

    export class Bar {
        ...
    }
    


    ./path/to/CompanyName.Products/index.ts

    export { Foo } from './Foo';
    export { Bar } from './Bar';
    



    tsconfig.json

    {
        "compilerOptions": {
            ...
            paths: {
                ...
                "CompanyName.Products": ["./path/to/CompanyName.Products/index"],
                ...
            }
            ...
        }
        ...
    }
    



    main.ts

    import { Foo, Bar } from 'CompanyName.Products'
    

    Note: The module resolution in the output .js files will need to be handled somehow, such as with this https://github.com/tleunen/babel-plugin-module-resolver

    Example .babelrc to handle the alias resolution:

    {
        "plugins": [
            [ "module-resolver", {
                "cwd": "babelrc",
                "alias": {
                    "CompanyName.Products": "./path/to/typescript/build/output/CompanyName.Products/index.js"
                }
            }],
            ... other plugins ...
        ]
    }
    

    How can I add JAR files to the web-inf/lib folder in Eclipse?

    • Add the jar file to your WEB-INF/lib folder.
    • Right-click your project in Eclipse, and go to "Build Path > Configure Build Path"
    • Add the "Web App Libraries" library

    This will ensure all WEB-INF/lib jars are included on the classpath.

    How can I make a float top with CSS?

    I think the best way to accomplish what you're talking about is to have a set of divs that will be your columns, and populate those in the way you described. Then fill those divs vertically with the content you're talking about.

    How to start MySQL with --skip-grant-tables?

    On the Linux system you can do following (Should be similar for other OS)

    Check if mysql process is running:

    sudo service mysql status
    

    If runnning then stop the process: (Make sure you close all mysql tool)

    sudo service mysql stop
    

    If you have issue stopping then do following

    Search for process: ps aux | grep mysqld Kill the process: kill -9 process_id

    Now start mysql in safe mode with skip grant

    sudo mysqld_safe --skip-grant-tables &
    

    How to fix getImageData() error The canvas has been tainted by cross-origin data?

    When working on local add a server

    I had a similar issue when working on local. You url is going to be the path to the local file e.g. file:///Users/PeterP/Desktop/folder/index.html.

    Please note that I am on a MAC.

    I got round this by installing http-server globally. https://www.npmjs.com/package/http-server

    Steps:

    1. Global install: npm install http-server -g
    2. Run server: http-server ~/Desktop/folder/

    PS: I assume you have node installed, otherwise you wont get very far running npm commands.

    Set View Width Programmatically

    check it in mdpi device.. If the ad displays correctly, the error should be in "px" to "dip" conversion..

    Send data through routing paths in Angular

    There is a lot of confusion on this topic because there are so many different ways to do it.

    Here are the appropriate types used in the following screen shots:

    private route: ActivatedRoute
    private router: Router
    

    1) Required Routing Parameters:

    enter image description here

    2) Route Optional Parameters:

    enter image description here

    3) Route Query Parameters:

    enter image description here

    4) You can use a service to pass data from one component to another without using route parameters at all.

    For an example see: https://blogs.msmvps.com/deborahk/build-a-simple-angular-service-to-share-data/

    I have a plunker of this here: https://plnkr.co/edit/KT4JLmpcwGBM2xdZQeI9?p=preview

    How can I make all images of different height and width the same via CSS?

    can i just throw in that if you distort your images too much, ie take them out of a ratio, they may not look right, - a tiny amount is fine, but one way to do this is put the images inside a 'container' and set the container to the 100 x 100, then set your image to overflow none, and set the smallest width to the maximum width of the container, this will crop a bit of your image though,

    for example

    <h4>Products</h4>
    <ul class="products">
        <li class="crop">
            <img src="ipod.jpg" alt="iPod" />
        </li>
    </ul>
    
    
    
    .crop {
     height: 300px;
     width: 400px;
     overflow: hidden;
    }
    .crop img {
     height: auto;
     width: 400px;
    }
    

    This way the image will stay the size of its container, but will resize without breaking constraints

    How do I raise the same Exception with a custom message in Python?

    if you want to custom the error type, a simple thing you can do is to define an error class based on ValueError.

    Disable Button in Angular 2

    Change ng-disabled="!contractTypeValid" to [disabled]="!contractTypeValid"

    How can I bind to the change event of a textarea in jQuery?

    Try to do it with focusout

    $("textarea").focusout(function() {
       alert('textarea focusout');
    });
    

    Get array of object's keys

    You can use jQuery's $.map.

    var foo = { 'alpha' : 'puffin', 'beta' : 'beagle' },
    keys = $.map(foo, function(v, i){
      return i;
    });
    

    Can't change table design in SQL Server 2008

    Just go to the SQL Server Management Studio -> Tools -> Options -> Designer; and Uncheck the option "prevent saving changes that require table re-creation".

    JavaScript unit test tools for TDD

    You should have a look at env.js. See my blog for an example how to write unit tests with env.js.

    How to Allow Remote Access to PostgreSQL database

    After set listen_addresses = '*' in postgresql.conf

    Edit the pg_hba.conf file and add the following entry at the very end of file:

    host    all             all              0.0.0.0/0                       md5
    host    all             all              ::/0                            md5
    

    For finding the config files this link might help you.

    Python 2.7 getting user input and manipulating as string without quotations

    My Working code with fixes:

    import random
    import math
    print "Welcome to Sam's Math Test"
    num1= random.randint(1, 10)
    num2= random.randint(1, 10)
    num3= random.randint(1, 10)
    list=[num1, num2, num3]
    maxNum= max(list)
    minNum= min(list)
    sqrtOne= math.sqrt(num1)
    
    correct= False
    while(correct == False):
        guess1= input("Which number is the highest? "+ str(list) + ": ")
        if maxNum == guess1:
            print("Correct!")
            correct = True
        else:
            print("Incorrect, try again")
    
    correct= False
    while(correct == False):
    guess2= input("Which number is the lowest? " + str(list) +": ")
    if minNum == guess2:
         print("Correct!")
         correct = True
    else:
        print("Incorrect, try again")
    
    correct= False
    while(correct == False):
        guess3= raw_input("Is the square root of " + str(num1) + " greater than or equal to 2? (y/n): ")
        if sqrtOne >= 2.0 and str(guess3) == "y":
            print("Correct!")
            correct = True
        elif sqrtOne < 2.0 and str(guess3) == "n":
            print("Correct!")
            correct = True
        else:
            print("Incorrect, try again")
    
    print("Thanks for playing!")
    

    Oracle: how to add minutes to a timestamp?

    SELECT to_char(sysdate + (1/24/60) * 30, 'dd/mm/yy HH24:MI am') from dual;
    

    simply you can use this with various date format....

    Enable CORS in fetch api

    Browser have cross domain security at client side which verify that server allowed to fetch data from your domain. If Access-Control-Allow-Origin not available in response header, browser disallow to use response in your JavaScript code and throw exception at network level. You need to configure cors at your server side.

    You can fetch request using mode: 'cors'. In this situation browser will not throw execption for cross domain, but browser will not give response in your javascript function.

    So in both condition you need to configure cors in your server or you need to use custom proxy server.

    Can I give a default value to parameters or optional parameters in C# functions?

    Yes. See Named and Optional Arguments. Note that the default value needs to be a constant, so this is OK:

    public string Foo(string myParam = "default value") // constant, OK
    {
    }
    

    but this is not:

    public void Bar(string myParam = Foo()) // not a constant, not OK
    {
    }
    

    How to run Linux commands in Java?

    You can call run-time commands from java for both Windows and Linux.

    import java.io.*;
    
    public class Test{
       public static void main(String[] args) 
       {
                try
                { 
                Process process = Runtime.getRuntime().exec("pwd"); // for Linux
                //Process process = Runtime.getRuntime().exec("cmd /c dir"); //for Windows
    
                process.waitFor();
                BufferedReader reader = new BufferedReader(new InputStreamReader(process.getInputStream()));
                String line;
                   while ((line=reader.readLine())!=null)
                   {
                    System.out.println(line);   
                    }
                 }       
                    catch(Exception e)
                 { 
                     System.out.println(e); 
                 }
                 finally
                 {
                   process.destroy();
                 }  
        }
    }
    

    Hope it Helps.. :)

    How to reset radiobuttons in jQuery so that none is checked

    I know this is old and that this is a little off topic, but supposing you wanted to uncheck only specific radio buttons in a collection:

    _x000D_
    _x000D_
    $("#go").click(function(){_x000D_
        $("input[name='correctAnswer']").each(function(){_x000D_
          if($(this).val() !== "1"){_x000D_
            $(this).prop("checked",false);_x000D_
          }_x000D_
        });_x000D_
      });
    _x000D_
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>_x000D_
    <input id="radio1" type="radio" name="correctAnswer" value="1">1</input>_x000D_
    <input id="radio2" type="radio" name="correctAnswer" value="2">2</input>_x000D_
    <input id="radio3" type="radio" name="correctAnswer" value="3">3</input>_x000D_
    <input id="radio4" type="radio" name="correctAnswer" value="4">4</input>_x000D_
    <input type="button" id="go" value="go">
    _x000D_
    _x000D_
    _x000D_

    And if you are dealing with a radiobutton list, you can use the :checked selector to get just the one you want.

    $("#go").click(function(){
      $("input[name='correctAnswer']:checked").prop("checked",false);
    });
    
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
    <input id="radio1" type="radio" name="correctAnswer" value="1">1</input>
    <input id="radio2" type="radio" name="correctAnswer" value="2">2</input>
    <input id="radio3" type="radio" name="correctAnswer" value="3">3</input>
    <input id="radio4" type="radio" name="correctAnswer" value="4">4</input>
    <input type="button" id="go" value="go">
    

    Could not connect to SMTP host: localhost, port: 25; nested exception is: java.net.ConnectException: Connection refused: connect

    The mail server on CentOS 6 and other IPv6 capable server platforms may be bound to IPv6 localhost (::1) instead of IPv4 localhost (127.0.0.1).

    Typical symptoms:

    [root@host /]# telnet 127.0.0.1 25
    Trying 127.0.0.1...
    telnet: connect to address 127.0.0.1: Connection refused
    
    [root@host /]# telnet localhost 25
    Trying ::1...
    Connected to localhost.
    Escape character is '^]'.
    220 host ESMTP Exim 4.72 Wed, 14 Aug 2013 17:02:52 +0100
    
    [root@host /]# netstat -plant | grep 25
    tcp        0      0 :::25                       :::*                        LISTEN      1082/exim           
    

    If this happens, make sure that you don't have two entries for localhost in /etc/hosts with different IP addresses, like this (bad) example:

    [root@host /]# cat /etc/hosts
    127.0.0.1 localhost.localdomain localhost localhost4.localdomain4 localhost4
    ::1       localhost localhost.localdomain localhost6 localhost6.localdomain6
    

    To avoid confusion, make sure you only have one entry for localhost, preferably an IPv4 address, like this:

    [root@host /]# cat /etc/hosts
    127.0.0.1 localhost  localhost.localdomain   localhost4.localdomain4 localhost4
    ::1       localhost6 localhost6.localdomain6
    

    Cannot connect to the Docker daemon on macOS

    This problem:

    $ brew install docker docker-machine
    $ docker ps
    
    Cannot connect to the Docker daemon at unix:///var/run/docker.sock. Is the docker daemon running?
    

    This apparently meant do the following:

    $ docker-machine create default # default driver is apparently vbox:
    Running pre-create checks...
    Error with pre-create check: "VBoxManage not found. Make sure VirtualBox is installed and VBoxManage is in the path"
    $  brew cask install virtualbox
    …
    $ docker-machine create default 
    # works this time
    $ docker ps
    Cannot connect to the Docker daemon at unix:///var/run/docker.sock. Is the docker daemon running?
    $ eval "$(docker-machine env default)"
    $ docker ps
    CONTAINER ID        IMAGE               COMMAND             CREATED             STATUS              PORTS               NAMES
    

    It finally works.

    You can use the “xhyve” driver if you don’t want to install virtual box. Also you can install the “docker app” (then run it) which apparently makes it so you don’t have to run some of the above. brew cask install docker then run the app, see the other answers. But apparently isn't necessary per se.

    No 'Access-Control-Allow-Origin' header is present on the requested resource—when trying to get data from a REST API

    This error occurs when the client URL and server URL don't match, including the port number. In this case you need to enable your service for CORS which is cross origin resource sharing.

    If you are hosting a Spring REST service then you can find it in the blog post CORS support in Spring Framework.

    If you are hosting a service using a Node.js server then

    1. Stop the Node.js server.
    2. npm install cors --save
    3. Add following lines to your server.js

      var cors = require('cors')
      
      app.use(cors()) // Use this after the variable declaration
      

    How to return only the Date from a SQL Server DateTime datatype

    The easiest way would be to use: SELECT DATE(GETDATE())

    How can I join multiple SQL tables using the IDs?

    SELECT 
        a.nameA, /* TableA.nameA */
        d.nameD /* TableD.nameD */
    FROM TableA a 
        INNER JOIN TableB b on b.aID = a.aID 
        INNER JOIN TableC c on c.cID = b.cID 
        INNER JOIN TableD d on d.dID = a.dID 
    WHERE DATE(c.`date`) = CURDATE()
    

    Refresh Page C# ASP.NET

    To refresh the whole page, but it works normally:

    Response.Redirect(url,bool) 
    

    How do I convert a double into a string in C++?

    Herb Sutter has an excellent article on string formatting. I recommend reading it. I've linked it before on SO.

    Handling NULL values in Hive

    What is the datatype for column1 in your Hive table? Please note that if your column is STRING it won't be having a NULL value even though your external file does not have any data for that column.

    Call async/await functions in parallel

    TL;DR

    Use Promise.all for the parallel function calls, the answer behaviors not correctly when the error occurs.


    First, execute all the asynchronous calls at once and obtain all the Promise objects. Second, use await on the Promise objects. This way, while you wait for the first Promise to resolve the other asynchronous calls are still progressing. Overall, you will only wait for as long as the slowest asynchronous call. For example:

    // Begin first call and store promise without waiting
    const someResult = someCall();
    
    // Begin second call and store promise without waiting
    const anotherResult = anotherCall();
    
    // Now we await for both results, whose async processes have already been started
    const finalResult = [await someResult, await anotherResult];
    
    // At this point all calls have been resolved
    // Now when accessing someResult| anotherResult,
    // you will have a value instead of a promise
    

    JSbin example: http://jsbin.com/xerifanima/edit?js,console

    Caveat: It doesn't matter if the await calls are on the same line or on different lines, so long as the first await call happens after all of the asynchronous calls. See JohnnyHK's comment.


    Update: this answer has a different timing in error handling according to the @bergi's answer, it does NOT throw out the error as the error occurs but after all the promises are executed. I compare the result with @jonny's tip: [result1, result2] = Promise.all([async1(), async2()]), check the following code snippet

    _x000D_
    _x000D_
    const correctAsync500ms = () => {_x000D_
      return new Promise(resolve => {_x000D_
        setTimeout(resolve, 500, 'correct500msResult');_x000D_
      });_x000D_
    };_x000D_
    _x000D_
    const correctAsync100ms = () => {_x000D_
      return new Promise(resolve => {_x000D_
        setTimeout(resolve, 100, 'correct100msResult');_x000D_
      });_x000D_
    };_x000D_
    _x000D_
    const rejectAsync100ms = () => {_x000D_
      return new Promise((resolve, reject) => {_x000D_
        setTimeout(reject, 100, 'reject100msError');_x000D_
      });_x000D_
    };_x000D_
    _x000D_
    const asyncInArray = async (fun1, fun2) => {_x000D_
      const label = 'test async functions in array';_x000D_
      try {_x000D_
        console.time(label);_x000D_
        const p1 = fun1();_x000D_
        const p2 = fun2();_x000D_
        const result = [await p1, await p2];_x000D_
        console.timeEnd(label);_x000D_
      } catch (e) {_x000D_
        console.error('error is', e);_x000D_
        console.timeEnd(label);_x000D_
      }_x000D_
    };_x000D_
    _x000D_
    const asyncInPromiseAll = async (fun1, fun2) => {_x000D_
      const label = 'test async functions with Promise.all';_x000D_
      try {_x000D_
        console.time(label);_x000D_
        let [value1, value2] = await Promise.all([fun1(), fun2()]);_x000D_
        console.timeEnd(label);_x000D_
      } catch (e) {_x000D_
        console.error('error is', e);_x000D_
        console.timeEnd(label);_x000D_
      }_x000D_
    };_x000D_
    _x000D_
    (async () => {_x000D_
      console.group('async functions without error');_x000D_
      console.log('async functions without error: start')_x000D_
      await asyncInArray(correctAsync500ms, correctAsync100ms);_x000D_
      await asyncInPromiseAll(correctAsync500ms, correctAsync100ms);_x000D_
      console.groupEnd();_x000D_
    _x000D_
      console.group('async functions with error');_x000D_
      console.log('async functions with error: start')_x000D_
      await asyncInArray(correctAsync500ms, rejectAsync100ms);_x000D_
      await asyncInPromiseAll(correctAsync500ms, rejectAsync100ms);_x000D_
      console.groupEnd();_x000D_
    })();
    _x000D_
    _x000D_
    _x000D_

    JBoss AS 7: How to clean up tmp?

    Files related for deployment (and others temporary items) are created in standalone/tmp/vfs (Virtual File System). You may add a policy at startup for evicting temporary files :

    -Djboss.vfs.cache=org.jboss.virtual.plugins.cache.IterableTimedVFSCache 
    -Djboss.vfs.cache.TimedPolicyCaching.lifetime=1440
    

    What should be the sizeof(int) on a 64-bit machine?

    Size of a pointer should be 8 byte on any 64-bit C/C++ compiler, but not necessarily size of int.

    Why is using onClick() in HTML a bad practice?

    Revision

    Unobtrusive JavaScript approach was good in the PAST - especially events handler bind in HTML was considered as bad practice (mainly because onclick events run in the global scope and may cause unexpected error what was mention by YiddishNinja)

    However...

    Currently it seems that this approach is a little outdated and needs some update. If someone want to be professional frontend developper and write large and complicated apps then he need to use frameworks like Angular, Vue.js, etc... However that frameworks usually use (or allow to use) HTML-templates where event handlers are bind in html-template code directly and this is very handy, clear and effective - e.g. in angular template usually people write:

    <button (click)="someAction()">Click Me</button> 
    

    In raw js/html the equivalent of this will be

    <button onclick="someAction()">Click Me</button>
    

    The difference is that in raw js onclick event is run in the global scope - but the frameworks provide encapsulation.

    So where is the problem?

    The problem is when novice programmer who always heard that html-onclick is bad and who always use btn.addEventListener("onclick", ... ) wants to use some framework with templates (addEventListener also have drawbacks - if we update DOM in dynamic way using innerHTML= (which is pretty fast) - then we loose events handlers bind in that way). Then he will face something like bad-habits or wrong-approach to framework usage - and he will use framework in very bad way - because he will focus mainly on js-part and no on template-part (and produce unclear and hard to maintain code). To change this habits he will loose a lot of time (and probably he will need some luck and teacher).

    So in my opinion, based on experience with my students, better would be for them if they use html-handlers-bind at the beginning. As I say it is true that handlers are call in global scope but a this stage students usually create small applications which are easy to control. To write bigger applications they choose some frameworks.

    So what to do?

    We can UPDATE the Unobtrusive JavaScript approach and allow bind event handlers (eventually with simple parameters) in html (but only bind handler - not put logic into onclick like in OP quesiton). So in my opinion in raw js/html this should be allowed

    <button onclick="someAction(3)">Click Me</button>
    

    or

    _x000D_
    _x000D_
    function popup(num,str,event) {_x000D_
       let re=new RegExp(str);  _x000D_
       // ... _x000D_
       event.preventDefault();_x000D_
       console.log("link was clicked");_x000D_
    }
    _x000D_
    <a href="https://example.com" onclick="popup(300,'map',event)">link</a>
    _x000D_
    _x000D_
    _x000D_

    But below examples should NOT be allowed

    <button onclick="console.log('xx'); someAction(); return true">Click Me</button>
    
    <a href="#" onclick="popup('/map/', 300, 300, 'map'); return false;">link</a>
    

    The reality changes, our point of view should too

    Check whether there is an Internet connection available on Flutter app

    For anyone else who lands here I'd like to add on to Günter Zöchbauer's answer this was my solution for implementing a utility to know if there's internet or not regardless of anything else.

    Disclaimer:

    I'm new to both Dart and Flutter so this may not be the best approach, but would love to get feedback.


    Combining flutter_connectivity and Günter Zöchbauer's connection test

    My requirements

    I didn't want to have a bunch of repeated code anywhere I needed to check the connection and I wanted it to automatically update components or anything else that cared about the connection whenever there was a change.

    ConnectionStatusSingleton

    First we setup a Singleton. If you're unfamiliar with this pattern there's a lot of good info online about them. But the gist is that you want to make a single instance of a class during the application life cycle and be able to use it anywhere.

    This singleton hooks into flutter_connectivity and listens for connectivity changes, then tests the network connection, then uses a StreamController to update anything that cares.

    It looks like this:

    import 'dart:io'; //InternetAddress utility
    import 'dart:async'; //For StreamController/Stream
    
    import 'package:connectivity/connectivity.dart';
    
    class ConnectionStatusSingleton {
        //This creates the single instance by calling the `_internal` constructor specified below
        static final ConnectionStatusSingleton _singleton = new ConnectionStatusSingleton._internal();
        ConnectionStatusSingleton._internal();
    
        //This is what's used to retrieve the instance through the app
        static ConnectionStatusSingleton getInstance() => _singleton;
    
        //This tracks the current connection status
        bool hasConnection = false;
    
        //This is how we'll allow subscribing to connection changes
        StreamController connectionChangeController = new StreamController.broadcast();
    
        //flutter_connectivity
        final Connectivity _connectivity = Connectivity();
    
        //Hook into flutter_connectivity's Stream to listen for changes
        //And check the connection status out of the gate
        void initialize() {
            _connectivity.onConnectivityChanged.listen(_connectionChange);
            checkConnection();
        }
    
        Stream get connectionChange => connectionChangeController.stream;
    
        //A clean up method to close our StreamController
        //   Because this is meant to exist through the entire application life cycle this isn't
        //   really an issue
        void dispose() {
            connectionChangeController.close();
        }
    
        //flutter_connectivity's listener
        void _connectionChange(ConnectivityResult result) {
            checkConnection();
        }
    
        //The test to actually see if there is a connection
        Future<bool> checkConnection() async {
            bool previousConnection = hasConnection;
    
            try {
                final result = await InternetAddress.lookup('google.com');
                if (result.isNotEmpty && result[0].rawAddress.isNotEmpty) {
                    hasConnection = true;
                } else {
                    hasConnection = false;
                }
            } on SocketException catch(_) {
                hasConnection = false;
            }
    
            //The connection status changed send out an update to all listeners
            if (previousConnection != hasConnection) {
                connectionChangeController.add(hasConnection);
            }
    
            return hasConnection;
        }
    }
    

    Usage

    Initialization

    First we have to make sure we call the initialize of our singleton. But only once. This parts up to you but I did it in my app's main():

    void main() {
        ConnectionStatusSingleton connectionStatus = ConnectionStatusSingleton.getInstance();
        connectionStatus.initialize();
    
        runApp(MyApp());
    
        //Call this if initialization is occuring in a scope that will end during app lifecycle
        //connectionStatus.dispose();   
    }
    

    In Widget or elsewhere

    import 'dart:async'; //For StreamSubscription
    
    ...
    
    class MyWidgetState extends State<MyWidget> {
        StreamSubscription _connectionChangeStream;
    
        bool isOffline = false;
    
        @override
        initState() {
            super.initState();
    
            ConnectionStatusSingleton connectionStatus = ConnectionStatusSingleton.getInstance();
            _connectionChangeStream = connectionStatus.connectionChange.listen(connectionChanged);
        }
    
        void connectionChanged(dynamic hasConnection) {
            setState(() {
                isOffline = !hasConnection;
            });
        }
    
        @override
        Widget build(BuildContext ctxt) {
            ...
        }
    }
    

    Hope somebody else finds this useful!


    Example github repo: https://github.com/dennmat/flutter-connectiontest-example

    Toggle airplane mode in the emulator to see the result

    How to reduce the image size without losing quality in PHP

    If you are looking to reduce the size using coding itself, you can follow this code in php.

    <?php 
    function compress($source, $destination, $quality) {
    
        $info = getimagesize($source);
    
        if ($info['mime'] == 'image/jpeg') 
            $image = imagecreatefromjpeg($source);
    
        elseif ($info['mime'] == 'image/gif') 
            $image = imagecreatefromgif($source);
    
        elseif ($info['mime'] == 'image/png') 
            $image = imagecreatefrompng($source);
    
        imagejpeg($image, $destination, $quality);
    
        return $destination;
    }
    
    $source_img = 'source.jpg';
    $destination_img = 'destination .jpg';
    
    $d = compress($source_img, $destination_img, 90);
    ?>
    

    $d = compress($source_img, $destination_img, 90);
    

    This is just a php function that passes the source image ( i.e., $source_img ), destination image ( $destination_img ) and quality for the image that will take to compress ( i.e., 90 ).

    $info = getimagesize($source);
    

    The getimagesize() function is used to find the size of any given image file and return the dimensions along with the file type.

    What is username and password when starting Spring Boot with Tomcat?

    When I started learning Spring Security, then I overrided the method userDetailsService() as in below code snippet:

    @Configuration
    @EnableWebSecurity
    public class ApplicationSecurityConfiguration extends WebSecurityConfigurerAdapter{
    
        @Override
        protected void configure(HttpSecurity http) throws Exception {
            http
                    .csrf().disable()
                    .authorizeRequests()
                    .antMatchers("/", "/index").permitAll()
                    .anyRequest().authenticated()
                    .and()
                    .httpBasic();
        }
    
        @Override
        @Bean
        public UserDetailsService userDetailsService() {
            List<UserDetails> users= new ArrayList<UserDetails>();
            users.add(User.withDefaultPasswordEncoder().username("admin").password("nimda").roles("USER","ADMIN").build());
            users.add(User.withDefaultPasswordEncoder().username("Spring").password("Security").roles("USER").build());
            return new InMemoryUserDetailsManager(users);
        }
    }
    

    So we can log in to the application using the above-mentioned creds. (e.g. admin/nimda)

    Note: This we should not use in production.

    NodeJS - What does "socket hang up" actually mean?

    I do both web (node) and Android development, and open Android Studio device simulator and docker together, both of them use port 8601, it complained socket hang up error, after close Android Studio device simulator and it works well in node side. Don’t use Android Studio device simulator and docker together.

    How to compare 2 files fast using .NET?

    The only thing that might make a checksum comparison slightly faster than a byte-by-byte comparison is the fact that you are reading one file at a time, somewhat reducing the seek time for the disk head. That slight gain may however very well be eaten up by the added time of calculating the hash.

    Also, a checksum comparison of course only has any chance of being faster if the files are identical. If they are not, a byte-by-byte comparison would end at the first difference, making it a lot faster.

    You should also consider that a hash code comparison only tells you that it's very likely that the files are identical. To be 100% certain you need to do a byte-by-byte comparison.

    If the hash code for example is 32 bits, you are about 99.99999998% certain that the files are identical if the hash codes match. That is close to 100%, but if you truly need 100% certainty, that's not it.

    Rails where condition using NOT NIL

    It's not a bug in ARel, it's a bug in your logic.

    What you want here is:

    Foo.includes(:bar).where(Bar.arel_table[:id].not_eq(nil))
    

    How to perform keystroke inside powershell?

    If I understand correctly, you want PowerShell to send the ENTER keystroke to some interactive application?

    $wshell = New-Object -ComObject wscript.shell;
    $wshell.AppActivate('title of the application window')
    Sleep 1
    $wshell.SendKeys('~')
    

    If that interactive application is a PowerShell script, just use whatever is in the title bar of the PowerShell window as the argument to AppActivate (by default, the path to powershell.exe). To avoid ambiguity, you can have your script retitle its own window by using the title 'new window title' command.

    A few notes:

    • The tilde (~) represents the ENTER keystroke. You can also use {ENTER}, though they're not identical - that's the keypad's ENTER key. A complete list is available here: http://msdn.microsoft.com/en-us/library/office/aa202943%28v=office.10%29.aspx.
    • The reason for the Sleep 1 statement is to wait 1 second because it takes a moment for the window to activate, and if you invoke SendKeys immediately, it'll send the keys to the PowerShell window, or to nowhere.
    • Be aware that this can be tripped up, if you type anything or click the mouse during the second that it's waiting, preventing to window you activate with AppActivate from being active. You can experiment with reducing the amount of time to find the minimum that's reliably sufficient on your system (Sleep accepts decimals, so you could try .5 for half a second). I find that on my 2.6 GHz Core i7 Win7 laptop, anything less than .8 seconds has a significant failure rate. I use 1 second to be safe.
    • IMPORTANT WARNING: Be extra careful if you're using this method to send a password, because activating a different window between invoking AppActivate and invoking SendKeys will cause the password to be sent to that different window in plain text!

    Sometimes wscript.shell's SendKeys method can be a little quirky, so if you run into problems, replace the fourth line above with this:

    Add-Type -AssemblyName System.Windows.Forms
    [System.Windows.Forms.SendKeys]::SendWait('~');
    

    How do I overload the [] operator in C#

    public int this[int key]
    {
        get => GetValue(key);
        set => SetValue(key, value);
    }
    

    Django set default form values

    You can use initial which is explained here

    You have two options either populate the value when calling form constructor:

    form = JournalForm(initial={'tank': 123})
    

    or set the value in the form definition:

    tank = forms.IntegerField(widget=forms.HiddenInput(), initial=123) 
    

    How to replace innerHTML of a div using jQuery?

    $("#regTitle")[0].innerHTML = 'Hello World';
    

    How to set default value for HTML select?

    Simplay you can place HTML select attribute to option a like shown below

    Define the attributes like selected="selected"

    <select>
       <option selected="selected">a</option>
       <option>b</option>
       <option>c</option>
    </select>
    

    Javascript window.open pass values using POST

    Even though this question was long time ago, thanks all for the inputs that helping me out a similar problem. I also made a bit modification based on the others' answers here and making multiple inputs/valuables into a Single Object (json); and hope this helps someone.

    js:

    //example: params={id:'123',name:'foo'};
    
    mapInput.name = "data";
    mapInput.value = JSON.stringify(params); 
    

    php:

    $data=json_decode($_POST['data']); 
    
    echo $data->id;
    echo $data->name;
    

    Scrollview can host only one direct child

    Wrap all the children inside of another LinearLayout with wrap_content for both the width and the height as well as the vertical orientation.

    CSS :selected pseudo class similar to :checked, but for <select> elements

    This worked for me :

    select option {
       color: black;
    }
    select:not(:checked) {
       color: gray;
    }
    

    Execute a large SQL script (with GO commands)

    For anyone still having the problem. You could use official Microsoft SMO

    https://docs.microsoft.com/en-us/sql/relational-databases/server-management-objects-smo/overview-smo?view=sql-server-2017

    using (var connection = new SqlConnection(connectionString))
    {
      var server = new Server(new ServerConnection(connection));
      server.ConnectionContext.ExecuteNonQuery(sql);
    }
    

    How to change the background color of Action Bar's Option Menu in Android 4.2?

    Try this code. Add this snippet to your res>values>styles.xml

    <style name="AppTheme" parent="AppBaseTheme">
        <item name="android:actionBarWidgetTheme">@style/Theme.stylingactionbar.widget</item>
    </style>
    <style name="PopupMenu" parent="@android:style/Widget.Holo.ListPopupWindow">
        <item name="android:popupBackground">@color/DarkSlateBlue</item>
     <!-- for @color you have to create a color.xml in res > values -->
    </style>
    <style name="Theme.stylingactionbar.widget" parent="@android:style/Theme.Holo">
        <item name="android:popupMenuStyle">@style/PopupMenu</item>
    </style>
    

    And in Manifest.xml add below snippet under application

     <application
        android:allowBackup="true"
        android:icon="@drawable/ic_launcher"
        android:label="@string/app_name"
    
         android:theme="@style/AppTheme"  >
    

    How do I grep for all non-ASCII characters?

    The easy way is to define a non-ASCII character... as a character that is not an ASCII character.

    LC_ALL=C grep '[^ -~]' file.xml
    

    Add a tab after the ^ if necessary.

    Setting LC_COLLATE=C avoids nasty surprises about the meaning of character ranges in many locales. Setting LC_CTYPE=C is necessary to match single-byte characters — otherwise the command would miss invalid byte sequences in the current encoding. Setting LC_ALL=C avoids locale-dependent effects altogether.

    Angular 2 Show and Hide an element

    @inoabrian solution above worked for me. I ran into a situation where I would refresh my page and my hidden element would reappear on my page. Here's what I did to resolve it.

    export class FooterComponent implements OnInit {
    public showJoinTodayBtn: boolean = null;
    
    ngOnInit() {
          if (condition is true) {
            this.showJoinTodayBtn = true;
          } else {
            this.showJoinTodayBtn = false;
          }
    }
    

    jQuery, simple polling example

    (function poll() {
        setTimeout(function() {
            //
            var search = {}
            search["ssn"] = "831-33-6049";
            search["first"] = "Harve";
            search["last"] = "Veum";
            search["gender"] = "M";
            search["street"] = "5017 Ottis Tunnel Apt. 176";
            search["city"] = "Shamrock";
            search["state"] = "OK";
            search["zip"] = "74068";
            search["lat"] = "35.9124";
            search["long"] = "-96.578";
            search["city_pop"] = "111";
            search["job"] = "Higher education careers adviser";
            search["dob"] = "1995-08-14";
            search["acct_num"] = "11220423";
            search["profile"] = "millenials.json";
            search["transnum"] = "9999999";
            search["transdate"] = $("#datepicker").val();
            search["category"] = $("#category").val();
            search["amt"] = $("#amt").val();
            search["row_key"] = "831-33-6049_9999999";
    
    
    
            $.ajax({
                type : "POST",
                headers : {
                    contentType : "application/json"
                },
                contentType : "application/json",
                url : "/stream_more",
                data : JSON.stringify(search),
                dataType : 'json',
                complete : poll,
                cache : false,
                timeout : 600000,
                success : function(data) {
                    //
                    //alert('jax')
                    console.log("SUCCESS : ", data);
                    //$("#btn-search").prop("disabled", false);
                    // $('#feedback').html("");
                    for (var i = 0; i < data.length; i++) {
                        //
                        $('#feedback').prepend(
                                '<tr><td>' + data[i].ssn + '</td><td>'
                                        + data[i].transdate + '</td><td>'
                                        + data[i].category + '</td><td>'
                                        + data[i].amt + '</td><td>'
                                        + data[i].purch_prob + '</td><td>'
                                        + data[i].offer + '</td></tr>').html();
                    }
    
                },
                error : function(e) {
                    //alert("error" + e);
    
                    var json = "<h4>Ajax Response</h4><pre>" + e.responseText
                            + "</pre>";
                    $('#feedback').html(json);
    
                    console.log("ERROR : ", e);
                    $("#btn-search").prop("disabled", false);
    
                }
            });
    
        }, 3000);
    })();
    

    How to pass a parameter to Vue @click event handler

    I had the same issue and here is how I manage to pass through:

    In your case you have addToCount() which is called. now to pass down a param when user clicks, you can say @click="addToCount(item.contactID)"

    in your function implementation you can receive the params like:

    addToCount(paramContactID){
     // the paramContactID contains the value you passed into the function when you called it
     // you can do what you want to do with the paramContactID in here!
    
    }
    

    Google Maps v3 - limit viewable area and zoom level

    You can listen to the dragend event, and if the map is dragged outside the allowed bounds, move it back inside. You can define your allowed bounds in a LatLngBounds object and then use the contains() method to check if the new lat/lng center is within the bounds.

    You can also limit the zoom level very easily.

    Consider the following example: Fiddle Demo

    <!DOCTYPE html>
    <html> 
    <head> 
       <meta http-equiv="content-type" content="text/html; charset=UTF-8"/> 
       <title>Google Maps JavaScript API v3 Example: Limit Panning and Zoom</title> 
       <script type="text/javascript" 
               src="http://maps.google.com/maps/api/js?sensor=false"></script>
    </head> 
    <body> 
       <div id="map" style="width: 400px; height: 300px;"></div> 
    
       <script type="text/javascript"> 
    
       // This is the minimum zoom level that we'll allow
       var minZoomLevel = 5;
    
       var map = new google.maps.Map(document.getElementById('map'), {
          zoom: minZoomLevel,
          center: new google.maps.LatLng(38.50, -90.50),
          mapTypeId: google.maps.MapTypeId.ROADMAP
       });
    
       // Bounds for North America
       var strictBounds = new google.maps.LatLngBounds(
         new google.maps.LatLng(28.70, -127.50), 
         new google.maps.LatLng(48.85, -55.90)
       );
    
       // Listen for the dragend event
       google.maps.event.addListener(map, 'dragend', function() {
         if (strictBounds.contains(map.getCenter())) return;
    
         // We're out of bounds - Move the map back within the bounds
    
         var c = map.getCenter(),
             x = c.lng(),
             y = c.lat(),
             maxX = strictBounds.getNorthEast().lng(),
             maxY = strictBounds.getNorthEast().lat(),
             minX = strictBounds.getSouthWest().lng(),
             minY = strictBounds.getSouthWest().lat();
    
         if (x < minX) x = minX;
         if (x > maxX) x = maxX;
         if (y < minY) y = minY;
         if (y > maxY) y = maxY;
    
         map.setCenter(new google.maps.LatLng(y, x));
       });
    
       // Limit the zoom level
       google.maps.event.addListener(map, 'zoom_changed', function() {
         if (map.getZoom() < minZoomLevel) map.setZoom(minZoomLevel);
       });
    
       </script> 
    </body> 
    </html>
    

    Screenshot from the above example. The user will not be able to drag further south or far east in this case:

    Google Maps JavaScript API v3 Example: Force stop map dragging

    Is Python faster and lighter than C++?

    The problem here is that you have two different languages that solve two different problems... its like comparing C++ with assembler.

    Python is for rapid application development and for when performance is a minimal concern.

    C++ is not for rapid application development and inherits a legacy of speed from C - for low level programming.

    How to validate date with format "mm/dd/yyyy" in JavaScript?

    I would use Moment.js for date validation.

    alert(moment("05/22/2012", 'MM/DD/YYYY',true).isValid()); //true
    

    Jsfiddle: http://jsfiddle.net/q8y9nbu5/

    true value is for strict parsing credit to @Andrey Prokhorov which means

    you may specify a boolean for the last argument to make Moment use strict parsing. Strict parsing requires that the format and input match exactly, including delimeters.

    Connect with SSH through a proxy

    $ which nc
    /bin/nc
    
    $ rpm -qf /bin/nc
    nmap-ncat-7.40-7.fc26.x86_64
    
    $ ssh -o "ProxyCommand nc --proxy <addr[:port]> %h %p" USER@HOST
    
    $ ssh -o "ProxyCommand nc --proxy <addr[:port]> --proxy-type <type> --proxy-auth <auth> %h %p" USER@HOST
    

    JavaScript: How to find out if the user browser is Chrome?

    Check this: How to detect Safari, Chrome, IE, Firefox and Opera browser?

    In your case:

    var isChrome = (window.chrome.webstore || window.chrome.runtime) && !!window.chrome;
    

    Programmatically getting the MAC of an Android device

    public static String getMacAddr() {
        try {
            List<NetworkInterface> all = Collections.list(NetworkInterface.getNetworkInterfaces());
            for (NetworkInterface nif : all) {
                if (!nif.getName().equalsIgnoreCase("wlan0")) continue;
    
                byte[] macBytes = nif.getHardwareAddress();
                if (macBytes == null) {
                    return "";
                }
    
                StringBuilder res1 = new StringBuilder();
                for (byte b : macBytes) {
                    res1.append(String.format("%02X:",b));
                }
    
                if (res1.length() > 0) {
                    res1.deleteCharAt(res1.length() - 1);
                }
                return res1.toString();
            }
        } catch (Exception ex) {
        }
        return "02:00:00:00:00:00";
    }
    

    What is the worst real-world macros/pre-processor abuse you've ever come across?

    #include <iostream>
    #define public_static_void_main(x) int main()
    #define System_out_println(x) std::cout << x << std::endl
    
    public_static_void_main(String[] args) {
      System_out_println("Hello World!");
    }
    

    Java Date cut off time information

    The question is contradictory. It asks for a date without a time of day yet displays an example with a time of 00:00:00.

    Joda-Time

    UPDATE: The Joda-Time project is now in maintenance mode, with the team advising migration to the java.time classes. See my other Answer for java.time solution.

    If instead you want the time-of-day set to the first moment of the day, use a DateTime object on the Joda-Time library and call its withTimeAtStartOfDay method. Be aware that the first moment may not be the time 00:00:00 because of Daylight Saving Time or perhaps other anomalies.

    how do I get the bullet points of a <ul> to center with the text?

    ul {
      padding-left: 0;
      list-style-position: inside;
    }
    

    Explanation: The first property padding-left: 0 clears the default padding/spacing for the ul element while list-style-position: inside makes the dots/bullets of li aligned like a normal text.

    So this code

    <p>The ul element</p>
    <ul>
    asdfas
      <li>Coffee</li>
      <li>Tea</li>
      <li>Milk</li>
    </ul>
    

    without any CSS will give us this:
    enter image description here
    but if we add in the CSS give at the top, that will give us this:
    enter image description here

    Entity Framework select distinct name

    The way that @alliswell showed is completely valid, and there's another way! :)

    var result = EFContext.TestAddresses
        .GroupBy(ta => ta.Name)
        .Select(ta => ta.Key);
    

    I hope it'll be useful to someone.

    Conversion of a datetime2 data type to a datetime data type results out-of-range value

    Created a base class based on @sky-dev implementation. So this can be easily applied to multiple contexts, and entities.

    public abstract class BaseDbContext<TEntity> : DbContext where TEntity : class
    {
        public BaseDbContext(string connectionString)
            : base(connectionString)
        {
        }
        public override int SaveChanges()
        {
    
            UpdateDates();
            return base.SaveChanges();
        }
    
        private void UpdateDates()
        {
            foreach (var change in ChangeTracker.Entries<TEntity>())
            {
                var values = change.CurrentValues;
                foreach (var name in values.PropertyNames)
                {
                    var value = values[name];
                    if (value is DateTime)
                    {
                        var date = (DateTime)value;
                        if (date < SqlDateTime.MinValue.Value)
                        {
                            values[name] = SqlDateTime.MinValue.Value;
                        }
                        else if (date > SqlDateTime.MaxValue.Value)
                        {
                            values[name] = SqlDateTime.MaxValue.Value;
                        }
                    }
                }
            }
        }
    }
    

    Usage:

    public class MyContext: BaseDbContext<MyEntities>
    {
    
        /// <summary>
        /// Initializes a new instance of the <see cref="MyContext"/> class.
        /// </summary>
        public MyContext()
            : base("name=MyConnectionString")
        {
        }
        /// <summary>
        /// Initializes a new instance of the <see cref="MyContext"/> class.
        /// </summary>
        /// <param name="connectionString">The connection string.</param>
        public MyContext(string connectionString)
            : base(connectionString)
        {
        }
    
         //DBcontext class body here (methods, overrides, etc.)
     }
    

    How to change the font color of a disabled TextBox?

    If you want to display text that cannot be edited or selected you can simply use a label

    Android Webview - Webpage should fit the device screen

    Try with this HTML5 tips

    http://www.html5rocks.com/en/mobile/mobifying.html

    And with this if your Android Version is 2.1 or greater

      WebView.getSettings().setLayoutAlgorithm(LayoutAlgorithm.SINGLE_COLUMN);
    

    How to calculate the intersection of two sets?

    Yes there is retainAll check out this

    Set<Type> intersection = new HashSet<Type>(s1);
    intersection.retainAll(s2);
    

    What algorithm for a tic-tac-toe game can I use to determine the "best move" for the AI?

    The brute force method of generating every single possible board and scoring it based on the boards it later produces further down the tree doesn't require much memory, especially once you recognize that 90 degree board rotations are redundant, as are flips about the vertical, horizontal, and diagonal axis.

    Once you get to that point, there's something like less than 1k of data in a tree graph to describe the outcome, and thus the best move for the computer.

    -Adam

    How do I use properly CASE..WHEN in MySQL

    CASE case_value
        WHEN when_value THEN statements
        [WHEN when_value THEN statements]
        ELSE statements
    END 
    

    Or:

    CASE
    WHEN <search_condition> THEN statements
    [WHEN <search_condition> THEN statements] 
    ELSE statements
    END 
    

    here CASE is an expression in 2nd scenario search_condition will evaluate and if no search_condition is equal then execute else

    SELECT
       CASE course_enrollment_settings.base_price
        WHEN course_enrollment_settings.base_price = 0      THEN 1
    

    should be

    SELECT
       CASE 
        WHEN course_enrollment_settings.base_price = 0      THEN 1
    

    How to enter newline character in Oracle?

    begin   
       dbms_output.put_line( 'hello' ||chr(13) || chr(10) || 'world' );
    end;
    

    How can I align button in Center or right using IONIC framework?

    You should put the button inside a div, and in the div you should be able to use the classes:
    text-left, text-center and text-right.

    for example:

    <div class="row">
       <div class="col text-center">
          <button class="button button-small button-light">Search</button>
       </div>
    </div>
    

    And about the "textarea" position:

    <div class="list">
    <label class="item item-input">
        <span class="input-label">Date</span>
        <input type="text" placeholder="Text Area">
    </label>
    

    Demo using your code:
    http://codepen.io/douglask/pen/zxXvYY

    RuntimeError on windows trying python multiprocessing

    In my case it was a simple bug in the code, using a variable before it was created. Worth checking that out before trying the above solutions. Why I got this particular error message, Lord knows.

    How to enable zoom controls and pinch zoom in a WebView?

    Inside OnCreate, add:

     webview.getSettings().setSupportZoom(true);
     webview.getSettings().setBuiltInZoomControls(true);
     webview.getSettings().setDisplayZoomControls(false);
    

    Inside the html document, add:

    <html>
    <head>
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=2, user-scalable=yes">
    </head>
    </html>
    

    Inside javascript, omit:

    //event.preventDefault ? event.preventDefault() : (event.returnValue = false);
    

    Working with a List of Lists in Java

    Something like this would work for reading:

    String filename = "something.csv";
    BufferedReader input = null;
    List<List<String>> csvData = new ArrayList<List<String>>();
    try 
    {
        input =  new BufferedReader(new FileReader(filename));
        String line = null;
        while (( line = input.readLine()) != null)
        {
            String[] data = line.split(",");
            csvData.add(Arrays.toList(data));
        }
    }
    catch (Exception ex)
    {
          ex.printStackTrace();
    }
    finally 
    {
        if(input != null)
        {
            input.close();
        }
    }
    

    passing 2 $index values within nested ng-repeat

    Just to help someone who get here... You should not use $parent.$index as it's not really safe. If you add an ng-if inside the loop, you get the $index messed!

    Right way

      <table>
        <tr ng-repeat="row in rows track by $index" ng-init="rowIndex = $index">
            <td ng-repeat="column in columns track by $index" ng-init="columnIndex = $index">
    
              <b ng-if="rowIndex == columnIndex">[{{rowIndex}} - {{columnIndex}}]</b>
              <small ng-if="rowIndex != columnIndex">[{{rowIndex}} - {{columnIndex}}]</small>
    
            </td>
        </tr>
      </table>
    

    Check: plnkr.co/52oIhLfeXXI9ZAynTuAJ

    Invalid attempt to read when no data is present

    I would check to see if the SqlDataReader has rows returned first:

    SqlDataReader dr = cmd10.ExecuteReader();
    if (dr.HasRows)
    {
       ...
    }
    

    How do I add images in laravel view?

    <img src="/images/yourfile.png">
    

    Store your files in public/images directory.

    Convert an enum to List<string>

    I want to add another solution: In my case, I need to use a Enum group in a drop down button list items. So they might have space, i.e. more user friendly descriptions needed:

      public enum CancelReasonsEnum
    {
        [Description("In rush")]
        InRush,
        [Description("Need more coffee")]
        NeedMoreCoffee,
        [Description("Call me back in 5 minutes!")]
        In5Minutes
    }
    

    In a helper class (HelperMethods) I created the following method:

     public static List<string> GetListOfDescription<T>() where T : struct
        {
            Type t = typeof(T);
            return !t.IsEnum ? null : Enum.GetValues(t).Cast<Enum>().Select(x => x.GetDescription()).ToList();
        }
    

    When you call this helper you will get the list of item descriptions.

     List<string> items = HelperMethods.GetListOfDescription<CancelReasonEnum>();
    

    ADDITION: In any case, if you want to implement this method you need :GetDescription extension for enum. This is what I use.

     public static string GetDescription(this Enum value)
        {
            Type type = value.GetType();
            string name = Enum.GetName(type, value);
            if (name != null)
            {
                FieldInfo field = type.GetField(name);
                if (field != null)
                {
                    DescriptionAttribute attr =Attribute.GetCustomAttribute(field,typeof(DescriptionAttribute)) as DescriptionAttribute;
                    if (attr != null)
                    {
                        return attr.Description;
                    }
                }
            }
            return null;
            /* how to use
                MyEnum x = MyEnum.NeedMoreCoffee;
                string description = x.GetDescription();
            */
    
        }
    

    Adding an onclick event to a div element

    I'm not sure what the problem is; running the below works as expected:

    <div id="thumb0" class="thumbs" onclick="klikaj('rad1')">knock knock</div>
    ?<div id="rad1" style="visibility: hidden">hello world</div>????????????????????????????????
    <script>
    function klikaj(i) {
        document.getElementById(i).style.visibility='visible';
    }
    </script>
    

    See also: http://jsfiddle.net/5tD4P/

    Write to Windows Application Event Log

    Yes, there is a way to write to the event log you are looking for. You don't need to create a new source, just simply use the existent one, which often has the same name as the EventLog's name and also, in some cases like the event log Application, can be accessible without administrative privileges*.

    *Other cases, where you cannot access it directly, are the Security EventLog, for example, which is only accessed by the operating system.

    I used this code to write directly to the event log Application:

    using (EventLog eventLog = new EventLog("Application")) 
    {
        eventLog.Source = "Application"; 
        eventLog.WriteEntry("Log message example", EventLogEntryType.Information, 101, 1); 
    }
    

    As you can see, the EventLog source is the same as the EventLog's name. The reason of this can be found in Event Sources @ Windows Dev Center (I bolded the part which refers to source name):

    Each log in the Eventlog key contains subkeys called event sources. The event source is the name of the software that logs the event. It is often the name of the application or the name of a subcomponent of the application if the application is large. You can add a maximum of 16,384 event sources to the registry.

    IOError: [Errno 13] Permission denied

    IOError: [Errno 13] Permission denied: 'juliodantas2015.json'
    

    tells you everything you need to know: though you successfully made your python program executable with your chmod, python can't open that juliodantas2015.json' file for writing. You probably don't have the rights to create new files in the folder you're currently in.

    How to remove close button on the jQuery UI dialog?

    As shown on the official page and suggested by David:

    Create a style:

    .no-close .ui-dialog-titlebar-close {
        display: none;
    }
    

    Then, you can simply add the no-close class to any dialog in order to hide it's close button:

    $( "#dialog" ).dialog({
        dialogClass: "no-close",
        buttons: [{
            text: "OK",
            click: function() {
                $( this ).dialog( "close" );
            }
        }]
    });
    

    any tool for java object to object mapping?

    Use Apache commons beanutils:

    static void copyProperties(Object dest, Object orig) -Copy property values from the origin bean to the destination bean for all cases where the property names are the same.

    http://commons.apache.org/proper/commons-beanutils/

    What are your favorite extension methods for C#? (codeplex.com/extensionoverflow)

    Here is another ThrowIfNull implementation:

    [ThreadStatic]
    private static string lastMethodName = null;
    
    [ThreadStatic]
    private static int lastParamIndex = 0;
    
    [MethodImpl(MethodImplOptions.NoInlining)]
    public static void ThrowIfNull<T>(this T parameter)
    {
        var currentStackFrame = new StackFrame(1);
        var props = currentStackFrame.GetMethod().GetParameters();
    
        if (!String.IsNullOrEmpty(lastMethodName)) {
            if (currentStackFrame.GetMethod().Name != lastMethodName) {
                lastParamIndex = 0;
            } else if (lastParamIndex >= props.Length - 1) {
                lastParamIndex = 0;
            } else {
                lastParamIndex++;
            }
        } else {
            lastParamIndex = 0;
        }
    
        if (!typeof(T).IsValueType) {
            for (int i = lastParamIndex; i &lt; props.Length; i++) {
                if (props[i].ParameterType.IsValueType) {
                    lastParamIndex++;
                } else {
                    break;
                }
            }
        }
    
        if (parameter == null) {
            string paramName = props[lastParamIndex].Name;
            throw new ArgumentNullException(paramName);
        }
    
        lastMethodName = currentStackFrame.GetMethod().Name;
    }
    

    It's not as efficient as the other impementations, but has cleaner usage:

    public void Foo()
    {
        Bar(1, 2, "Hello", "World"); //no exception
        Bar(1, 2, "Hello", null); //exception
        Bar(1, 2, null, "World"); //exception
    }
    
    public void Bar(int x, int y, string someString1, string someString2)
    {
        //will also work with comments removed
        //x.ThrowIfNull();
        //y.ThrowIfNull();
        someString1.ThrowIfNull();
        someString2.ThrowIfNull();
    
        //Do something incredibly useful here!
    }
    

    Changing the parameters to int? will also work.

    -bill

    SQL distinct for 2 fields in a database

    If you still want to group only by one column (as I wanted) you can nest the query:

    select c1, count(*) from (select distinct c1, c2 from t) group by c1
    

    How do I change the text of a span element using JavaScript?

    _x000D_
    _x000D_
    (function ($) {
        $(document).ready(function(){
        $("#myspan").text("This is span");
      });
    }(jQuery));
    _x000D_
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
    <span id="myspan"> hereismytext </span>
    _x000D_
    _x000D_
    _x000D_

    user text() to change span text.

    Android Linear Layout - How to Keep Element At Bottom Of View?

    Update: I still get upvotes on this question, which is still the accepted answer and which I think I answered poorly. In the spirit of making sure the best info is out there, I have decided to update this answer.

    In modern Android I would use ConstraintLayout to do this. It is more performant and straightforward.

    <ConstraintLayout>
       <View
          android:id="@+id/view1"
          ...other attributes elided... />
       <View
          android:id="@id/view2"        
          app:layout_constraintTop_toBottomOf="@id/view1" />
          ...other attributes elided... />
    
       ...etc for other views that should be aligned top to bottom...
    
       <TextView
        app:layout_constraintBottom_toBottomOf="parent" />
    

    If you don't want to use a ConstraintLayout, using a LinearLayout with an expanding view is a straightforward and great way to handle taking up the extra space (see the answer by @Matthew Wills). If you don't want to expand the background of any of the Views above the bottom view, you can add an invisible View to take up the space.

    The answer I originally gave works but is inefficient. Inefficiency may not be a big deal for a single top level layout, but it would be a terrible implementation in a ListView or RecyclerView, and there just isn't any reason to do it since there are better ways to do it that are roughly the same level of effort and complexity if not simpler.

    Take the TextView out of the LinearLayout, then put the LinearLayout and the TextView inside a RelativeLayout. Add the attribute android:layout_alignParentBottom="true" to the TextView. With all the namespace and other attributes except for the above attribute elided:

    <RelativeLayout>
      <LinearLayout>
        <!-- All your other elements in here -->
      </LinearLayout>
      <TextView
        android:layout_alignParentBottom="true" />
    </RelativeLayout>
    

    How to add custom Http Header for C# Web Service Client consuming Axis 1.4 Web service

    Here is what worked for me:

    protected override System.Net.WebRequest GetWebRequest(Uri uri)
    {
            HttpWebRequest request;
            request = (HttpWebRequest)base.GetWebRequest(uri);
            NetworkCredential networkCredentials =
            Credentials.GetCredential(uri, "Basic");
            if (networkCredentials != null)
            {
                byte[] credentialBuffer = new UTF8Encoding().GetBytes(
                networkCredentials.UserName + ":" +
                networkCredentials.Password);
                request.Headers["Authorization"] =
                "Basic " + Convert.ToBase64String(credentialBuffer);
                request.Headers["Cookie"] = "BCSI-CS-2rtyueru7546356=1";
                request.Headers["Cookie2"] = "$Version=1";
            }
            else
            {
                throw new ApplicationException("No network credentials");
            }
            return request;
    }
    

    Don't forget to set this property:

    service.Credentials = new NetworkCredential("username", "password");  
    

    Cookie and Cookie2 are set in header because java service was not accepting the request and I was getting Unauthorized error.

    Adding simple legend to plot in R

    Take a look at ?legend and try this:

    legend('topright', names(a)[-1] , 
       lty=1, col=c('red', 'blue', 'green',' brown'), bty='n', cex=.75)
    

    enter image description here

    Converting Milliseconds to Minutes and Seconds?

    I was creating a mp3 player app for android, so I did it like this to get current time and duration

     private String millisecondsToTime(long milliseconds) {
        long minutes = (milliseconds / 1000) / 60;
        long seconds = (milliseconds / 1000) % 60;
        String secondsStr = Long.toString(seconds);
        String secs;
        if (secondsStr.length() >= 2) {
            secs = secondsStr.substring(0, 2);
        } else {
            secs = "0" + secondsStr;
        }
    
        return minutes + ":" + secs;
    }
    

    How do I convert 2018-04-10T04:00:00.000Z string to DateTime?

    Using Date pattern yyyy-MM-dd'T'HH:mm:ss.SSS'Z' and Java 8 you could do

    String string = "2018-04-10T04:00:00.000Z";
    DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'", Locale.ENGLISH);
    LocalDate date = LocalDate.parse(string, formatter);
    System.out.println(date);
    

    Update: For pre 26 use Joda time

    String string = "2018-04-10T04:00:00.000Z";
    DateTimeFormatter formatter = DateTimeFormat.forPattern("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'");
    LocalDate date = org.joda.time.LocalDate.parse(string, formatter);
    

    In app/build.gradle file, add like this-

    dependencies {    
        compile 'joda-time:joda-time:2.9.4'
    }
    

    How do I use Docker environment variable in ENTRYPOINT array?

    After much pain, and great assistance from @vitr et al above, i decided to try

    • standard bash substitution
    • shell form of ENTRYPOINT (great tip from above)

    and that worked.

    ENV LISTEN_PORT=""
    
    ENTRYPOINT java -cp "app:app/lib/*" hello.Application --server.port=${LISTEN_PORT:-80}
    

    e.g.

    docker run --rm -p 8080:8080 -d --env LISTEN_PORT=8080 my-image
    

    and

    docker run --rm -p 8080:80 -d my-image
    

    both set the port correctly in my container

    Refs

    see https://www.cyberciti.biz/tips/bash-shell-parameter-substitution-2.html

    How to get the previous page URL using JavaScript?

    You can use the following to get the previous URL.

    var oldURL = document.referrer;
    alert(oldURL);
    

    I do not understand how execlp() works in Linux

    The limitation of execl is that when executing a shell command or any other script that is not in the current working directory, then we have to pass the full path of the command or the script. Example:

    execl("/bin/ls", "ls", "-la", NULL);
    

    The workaround to passing the full path of the executable is to use the function execlp, that searches for the file (1st argument of execlp) in those directories pointed by PATH:

    execlp("ls", "ls", "-la", NULL);
    

    Oracle - Why does the leading zero of a number disappear when converting it TO_CHAR

    Seems like the only way to get decimal in a pretty (for me) form requires some ridiculous code.

    The only solution I got so far:

    CASE WHEN xy>0 and xy<1 then '0' || to_char(xy) else to_char(xy)
    

    xy is a decimal.

    xy             query result
    0.8            0.8  --not sth like .80
    10             10  --not sth like 10.00
    

    "Cannot update paths and switch to branch at the same time"

    'origin/master' which can not be resolved as commit

    Strange: you need to check your remotes:

    git remote -v
    

    And make sure origin is fetched:

    git fetch origin
    

    Then:

    git branch -avv
    

    (to see if you do have fetched an origin/master branch)

    Finally, use git switch instead of the confusing git checkout, with Git 2.23+ (August 2019).

    git switch -c test --track origin/master
    

    MySQL remove all whitespaces from the entire column

    Since the question is how to replace ALL whitespaces

    UPDATE `table` 
    SET `col_name` = REPLACE
    (REPLACE(REPLACE(`col_name`, ' ', ''), '\t', ''), '\n', '');
    

    Set a default parameter value for a JavaScript function

    As per the syntax

    function [name]([param1[ = defaultValue1 ][, ..., paramN[ = defaultValueN ]]]) {
       statements
    }
    

    you can define the default value of formal parameters. and also check undefined value by using typeof function.

    URL encoding in Android

    You don't encode the entire URL, only parts of it that come from "unreliable sources".

    • Java:

      String query = URLEncoder.encode("apples oranges", "utf-8");
      String url = "http://stackoverflow.com/search?q=" + query;
      
    • Kotlin:

      val query: String = URLEncoder.encode("apples oranges", "utf-8")
      val url = "http://stackoverflow.com/search?q=$query"
      

    Alternatively, you can use Strings.urlEncode(String str) of DroidParts that doesn't throw checked exceptions.

    Or use something like

    String uri = Uri.parse("http://...")
                    .buildUpon()
                    .appendQueryParameter("key", "val")
                    .build().toString();
    

    How can multiple rows be concatenated into one in Oracle without creating a stored procedure?

    There are many way to do the string aggregation, but the easiest is a user defined function. Try this for a way that does not require a function. As a note, there is no simple way without the function.

    This is the shortest route without a custom function: (it uses the ROW_NUMBER() and SYS_CONNECT_BY_PATH functions )

    SELECT questionid,
           LTRIM(MAX(SYS_CONNECT_BY_PATH(elementid,','))
           KEEP (DENSE_RANK LAST ORDER BY curr),',') AS elements
    FROM   (SELECT questionid,
                   elementid,
                   ROW_NUMBER() OVER (PARTITION BY questionid ORDER BY elementid) AS curr,
                   ROW_NUMBER() OVER (PARTITION BY questionid ORDER BY elementid) -1 AS prev
            FROM   emp)
    GROUP BY questionid
    CONNECT BY prev = PRIOR curr AND questionid = PRIOR questionid
    START WITH curr = 1;
    

    How do I configure Maven for offline development?

    You have two options for this:

    1.) make changes in the settings.xml add this in first tag

    <localRepository>C:/Users/admin/.m2/repository</localRepository>
    

    2.) use the -o tag for offline command.

    mvn -o clean install -DskipTests=true
    mvn -o jetty:run
    

    How do you attach and detach from Docker's process?

    to stop a docker process and release the ports, first use ctrl-c to leave the exit the container then use docker ps to find the list of running containers. Then you can use the docker container stop to stop that process and release its ports. The container name you can find from the docker ps command which gives the name in the name column. Hope this solves your queries....

    maximum value of int

    I know it's an old question but maybe someone can use this solution:

    int size = 0; // Fill all bits with zero (0)
    size = ~size; // Negate all bits, thus all bits are set to one (1)
    

    So far we have -1 as result 'till size is a signed int.

    size = (unsigned int)size >> 1; // Shift the bits of size one position to the right.
    

    As Standard says, bits that are shifted in are 1 if variable is signed and negative and 0 if variable would be unsigned or signed and positive.

    As size is signed and negative we would shift in sign bit which is 1, which is not helping much, so we cast to unsigned int, forcing to shift in 0 instead, setting the sign bit to 0 while letting all other bits remain 1.

    cout << size << endl; // Prints out size which is now set to maximum positive value.
    

    We could also use a mask and xor but then we had to know the exact bitsize of the variable. With shifting in bits front, we don't have to know at any time how many bits the int has on machine or compiler nor need we include extra libraries.

    Declaring variables in Excel Cells

    I also just found out how to do this with the Excel Name Manager (Formulas > Defined Names Section > Name Manager).

    You can define a variable that doesn't have to "live" within a cell and then you can use it in formulas.

    Excel Name Manager

    How do I set headers using python's urllib?

    adding HTTP headers using urllib2:

    from the docs:

    import urllib2
    req = urllib2.Request('http://www.example.com/')
    req.add_header('Referer', 'http://www.python.org/')
    resp = urllib2.urlopen(req)
    content = resp.read()
    

    Recommended Fonts for Programming?

    @modesty:

    I wish there was a Mac version.

    You can install the font on a Mac. I use it all the time, everywhere, without any problem. The only thing to pay attention for is to set nomacatsui when working with GVIM, or better yet, switch to MacVim.

    How to upgrade OpenSSL in CentOS 6.5 / Linux / Unix from source?

    The fix for the heartbleed vulnerability has been backported to 1.0.1e-16 by Red Hat for Enterprise Linux see, and this is therefore the official fix that CentOS ships.

    Replacing OpenSSL with the latest version from upstream (i.e. 1.0.1g) runs the risk of introducing functionality changes which may break compatibility with applications/clients in unpredictable ways, causes your system to diverge from RHEL, and puts you on the hook for personally maintaining future updates to that package. By replacing openssl using a simple make config && make && make install means that you also lose the ability to use rpm to manage that package and perform queries on it (e.g. verifying all the files are present and haven't been modified or had permissions changed without also updating the RPM database).

    I'd also caution that crypto software can be extremely sensitive to seemingly minor things like compiler options, and if you don't know what you're doing, you could introduce vulnerabilities in your local installation.

    How to test if JSON object is empty in Java

    Try /*string with {}*/ string.trim().equalsIgnoreCase("{}")), maybe there is some extra spaces or something

    How to indent HTML tags in Notepad++

    The answers on this question are not only wrong, but dangerous. CTRL+ALT+SHIFT+B will not indent HTML but XML. Consider the following HTML code:

    <span class="myClass"></span>
    

    The function 'Notepad++ -> Plugins -> XmlTools -> Pretty print (Xml only with line breaks)' (CTRL+ALT+SHIFT+B) will transform this to:

    <span class="myClass"/>
    

    which will not be displayed correctly anymore by your browser! I strongly advice against using this function to indent HTML.

    Instead use the plugin Tidy2. This will indent the HTML correctly without bad side-effects (but it will also create <html>, <head>, <body>, ... elements around your code, if these are not there).

    How do I update Node.js?

    According to Nodejs Official Page, you can install&update new node version on windows using Chocolatey or Scoop

    Using(Chocolatey):

    cinst nodejs
    # or for full install with npm
    cinst nodejs.install
    

    Using(Scoop):

    scoop install nodejs
    

    Also you can download the Windows Installer directly from the nodejs.org web site

    Trees in Twitter Bootstrap

    Building on Vitaliy's CSS and Mehmet's jQuery, I changed the a tags to span tags and incorporated some Glyphicons and badging into my take on a Bootstrap tree widget.

    Example: my take on a Bootstrap tree widget

    For extra credit, I've created a Github iconGitHub project to host the jQuery and LESS code that goes into adding this tree component to Bootstrap. Please see the project documentation at http://jhfrench.github.io/bootstrap-tree/docs/example.html.

    Alternately, here is the LESS source to generate that CSS (the JS can be picked up from the jsFiddle):

    @import "../../../external/bootstrap/less/bootstrap.less"; /* substitute your path to the bootstrap.less file */
    @import "../../../external/bootstrap/less/responsive.less"; /* optional; substitute your path to the responsive.less file */
    
    /* collapsable tree */
    .tree {
        .border-radius(@baseBorderRadius);
        .box-shadow(inset 0 1px 1px rgba(0,0,0,.05));
        background-color: lighten(@grayLighter, 5%);
        border: 1px solid @grayLight;
        margin-bottom: 10px;
        max-height: 300px;
        min-height: 20px;
        overflow-y: auto;
        padding: 19px;
        a {
            display: block;
            overflow: hidden;
            text-overflow: ellipsis;
            width: 90%;
        }
        li {
            list-style-type: none;
            margin: 0px 0;
            padding: 4px 0px 0px 2px;
            position: relative;
            &::before, &::after {
                content: '';
                left: -20px;
                position: absolute;
                right: auto;
            }
            &::before {
                border-left: 1px solid @grayLight;
                bottom: 50px;
                height: 100%;
                top: 0;
                width: 1px;
            }
            &::after {
                border-top: 1px solid @grayLight;
                height: 20px;
                top: 13px;
                width: 23px;
            }
            span {
                -moz-border-radius: 5px;
                -webkit-border-radius: 5px;
                border: 1px solid @grayLight;
                border-radius: 5px;
                display: inline-block;
                line-height: 14px;
                padding: 2px 4px;
                text-decoration: none;
            }
            &.parent_li > span {
                cursor: pointer;
                /*Time for some hover effects*/
                &:hover, &:hover+ul li span {
                    background: @grayLighter;
                    border: 1px solid @gray;
                    color: #000;
                }
            }
            /*Remove connectors after last child*/
            &:last-child::before {
                height: 30px;
            }
        }
        /*Remove connectors before root*/
        > ul > li::before, > ul > li::after {
            border: 0;
        }
    }
    

    Greater than and less than in one statement

    Several third-party libraries have classes encapsulating the concept of a range, such as Apache commons-lang's Range (and subclasses).

    Using classes such as this you could express your constraint similar to:

    if (new IntRange(0, 5).contains(orderBean.getFiles().size())
    // (though actually Apache's Range is INclusive, so it'd be new Range(1, 4) - meh
    

    with the added bonus that the range object could be defined as a constant value elsewhere in the class.

    However, without pulling in other libraries and using their classes, Java's strong syntax means you can't massage the language itself to provide this feature nicely. And (in my own opinion), pulling in a third party library just for this small amount of syntactic sugar isn't worth it.

    Disable click outside of bootstrap modal area to close modal

    This is the easiest one

    You can define your modal behavior, defining data-keyboard and data-backdrop.

    <div id="modal" class="modal hide fade in" data-keyboard="false" data-backdrop="static">
    

    fs.writeFile in a promise, asynchronous-synchronous stuff

    As of 2019...

    ...the correct answer is to use async/await with the native fs promises module included in node. Upgrade to Node.js 10 or 11 (already supported by major cloud providers) and do this:

    const fs = require('fs').promises;
    
    // This must run inside a function marked `async`:
    const file = await fs.readFile('filename.txt', 'utf8');
    await fs.writeFile('filename.txt', 'test');
    

    Do not use third-party packages and do not write your own wrappers, that's not necessary anymore.

    No longer experimental

    Before Node 11.14.0, you would still get a warning that this feature is experimental, but it works just fine and it's the way to go in the future. Since 11.14.0, the feature is no longer experimental and is production-ready.

    What if I prefer import instead of require?

    It works, too - but only in Node.js versions where this feature is not marked as experimental.

    import { promises as fs } from 'fs';
    
    (async () => {
        await fs.writeFile('./test.txt', 'test', 'utf8');
    })();
    

    OnClick Send To Ajax

    <textarea name='Status'> </textarea>
    <input type='button' value='Status Update'>
    

    You have few problems with your code like using . for concatenation

    Try this -

    $(function () {
        $('input').on('click', function () {
            var Status = $(this).val();
            $.ajax({
                url: 'Ajax/StatusUpdate.php',
                data: {
                    text: $("textarea[name=Status]").val(),
                    Status: Status
                },
                dataType : 'json'
            });
        });
    });
    

    Where can I get a list of Ansible pre-defined variables?

    The debug module can be used to analyze variables. Be careful running the following command. In our setup it generates 444709 lines with 16MB:

    ansible -m debug -a 'var=hostvars' localhost
    

    I am not sure but it might be necessary to enable facts caching.

    If you need just one host use the host name as a key for the hostvars hash:

    ansible -m debug -a 'var=hostvars.localhost' localhost
    

    This command will display also group and host variables.

    How to sum columns in a dataTable?

    There is also a way to do this without loops using the DataTable.Compute Method. The following example comes from that page. You can see that the code used is pretty simple.:

    private void ComputeBySalesSalesID(DataSet dataSet)
    {
        // Presumes a DataTable named "Orders" that has a column named "Total."
        DataTable table;
        table = dataSet.Tables["Orders"];
    
        // Declare an object variable. 
        object sumObject;
        sumObject = table.Compute("Sum(Total)", "EmpID = 5");
    }
    

    I must add that if you do not need to filter the results, you can always pass an empty string:

    sumObject = table.Compute("Sum(Total)", "")
    

    Bootstrap modal not displaying

    Sometimes other css conflicts as well - CSS priority issue.

    to check, Go to your modal fade class on browser and then check if there is any custom file comes on top. such as .fade:not(.show) where it was using its own information not the bootstrap. if you find then you have to change it to your needs . Hope this helps.

    Change default date time format on a single database in SQL Server

    In order to avoid dealing with these very boring issues, I advise you to always parse your data with the standard and unique SQL/ISO date format which is YYYY-MM-DD. Your queries will then work internationally, no matter what the date parameters are on your main server or on the querying clients (where local date settings might be different than main server settings)!

    Finding common rows (intersection) in two Pandas dataframes

    If I understand you correctly, you can use a combination of Series.isin() and DataFrame.append():

    In [80]: df1
    Out[80]:
       rating  user_id
    0       2  0x21abL
    1       1  0x21abL
    2       1   0xdafL
    3       0  0x21abL
    4       4  0x1d14L
    5       2  0x21abL
    6       1  0x21abL
    7       0   0xdafL
    8       4  0x1d14L
    9       1  0x21abL
    
    In [81]: df2
    Out[81]:
       rating      user_id
    0       2      0x1d14L
    1       1    0xdbdcad7
    2       1      0x21abL
    3       3      0x21abL
    4       3      0x21abL
    5       1  0x5734a81e2
    6       2      0x1d14L
    7       0       0xdafL
    8       0      0x1d14L
    9       4  0x5734a81e2
    
    In [82]: ind = df2.user_id.isin(df1.user_id) & df1.user_id.isin(df2.user_id)
    
    In [83]: ind
    Out[83]:
    0     True
    1    False
    2     True
    3     True
    4     True
    5    False
    6     True
    7     True
    8     True
    9    False
    Name: user_id, dtype: bool
    
    In [84]: df1[ind].append(df2[ind])
    Out[84]:
       rating  user_id
    0       2  0x21abL
    2       1   0xdafL
    3       0  0x21abL
    4       4  0x1d14L
    6       1  0x21abL
    7       0   0xdafL
    8       4  0x1d14L
    0       2  0x1d14L
    2       1  0x21abL
    3       3  0x21abL
    4       3  0x21abL
    6       2  0x1d14L
    7       0   0xdafL
    8       0  0x1d14L
    

    This is essentially the algorithm you described as "clunky", using idiomatic pandas methods. Note the duplicate row indices. Also, note that this won't give you the expected output if df1 and df2 have no overlapping row indices, i.e., if

    In [93]: df1.index & df2.index
    Out[93]: Int64Index([], dtype='int64')
    

    In fact, it won't give the expected output if their row indices are not equal.

    get list of pandas dataframe columns based on data type

    If you want a list of only the object columns you could do:

    non_numerics = [x for x in df.columns \
                    if not (df[x].dtype == np.float64 \
                            or df[x].dtype == np.int64)]
    

    and then if you want to get another list of only the numerics:

    numerics = [x for x in df.columns if x not in non_numerics]
    

    DataGridView - how to set column width?

    Regarding your final bullet

    make width fit the text

    You can experiment with the .AutoSizeMode of your DataGridViewColumn, setting it to one of these values:

    None
    AllCells
    AllCellsExceptHeader
    DisplayedCells
    DisplayedCellsExceptHeader
    ColumnHeader
    Fill
    

    More info on the MSDN page

    How do I remove duplicate items from an array in Perl?

    The Perl documentation comes with a nice collection of FAQs. Your question is frequently asked:

    % perldoc -q duplicate
    

    The answer, copy and pasted from the output of the command above, appears below:

    Found in /usr/local/lib/perl5/5.10.0/pods/perlfaq4.pod
     How can I remove duplicate elements from a list or array?
       (contributed by brian d foy)
    
       Use a hash. When you think the words "unique" or "duplicated", think
       "hash keys".
    
       If you don't care about the order of the elements, you could just
       create the hash then extract the keys. It's not important how you
       create that hash: just that you use "keys" to get the unique elements.
    
           my %hash   = map { $_, 1 } @array;
           # or a hash slice: @hash{ @array } = ();
           # or a foreach: $hash{$_} = 1 foreach ( @array );
    
           my @unique = keys %hash;
    
       If you want to use a module, try the "uniq" function from
       "List::MoreUtils". In list context it returns the unique elements,
       preserving their order in the list. In scalar context, it returns the
       number of unique elements.
    
           use List::MoreUtils qw(uniq);
    
           my @unique = uniq( 1, 2, 3, 4, 4, 5, 6, 5, 7 ); # 1,2,3,4,5,6,7
           my $unique = uniq( 1, 2, 3, 4, 4, 5, 6, 5, 7 ); # 7
    
       You can also go through each element and skip the ones you've seen
       before. Use a hash to keep track. The first time the loop sees an
       element, that element has no key in %Seen. The "next" statement creates
       the key and immediately uses its value, which is "undef", so the loop
       continues to the "push" and increments the value for that key. The next
       time the loop sees that same element, its key exists in the hash and
       the value for that key is true (since it's not 0 or "undef"), so the
       next skips that iteration and the loop goes to the next element.
    
           my @unique = ();
           my %seen   = ();
    
           foreach my $elem ( @array )
           {
             next if $seen{ $elem }++;
             push @unique, $elem;
           }
    
       You can write this more briefly using a grep, which does the same
       thing.
    
           my %seen = ();
           my @unique = grep { ! $seen{ $_ }++ } @array;
    

    NewtonSoft.Json Serialize and Deserialize class with property of type IEnumerable<ISomeInterface>

    I got this to work:

    explicit conversion

        public override object ReadJson(JsonReader reader, Type objectType, object existingValue,
                                        JsonSerializer serializer)
        {
            var jsonObj = serializer.Deserialize<List<SomeObject>>(reader);
            var conversion = jsonObj.ConvertAll((x) => x as ISomeObject);
    
            return conversion;
        }
    

    Rails: Missing host to link to! Please provide :host parameter or set default_url_options[:host]

    Adding the default_url in routes not the right solution although, it works for some cases.

    You've to set the default_url in each environment(development, test, production).

    You need make these changes.

        config/environments/development.rb
         config.action_mailer.default_url_options = 
          { :host => 'your-host-name' }  #if it is local then 'localhost:3000'
    
     config/environments/test.rb
          config.action_mailer.default_url_options = 
          { :host => 'your-host-name' }  #if it is local then 'localhost:3000'
    
      config/environments/development.rb
         config.action_mailer.default_url_options = 
          { :host => 'your-host-name' }  #if it is local then 'localhost:3000'
    

    How to dynamically change a web page's title?

    I just want to add something here: changing the title via JavaScript is actually useful if you're updating a database via AJAX, so then the title changes without you having to refresh the page. The title actually changes via your server side scripting language, but having it change via JavaScript is just a usability and UI thing that makes the user experience more enjoyable and fluid.

    Now, if you're changing the title via JavaScript just for the hell of it, then you should not be doing that.

    Add property to an array of objects

    It goes through the object as a key-value structure. Then it will add a new property named 'Active' and a sample value for this property ('Active) to every single object inside of this object. this code can be applied for both array of objects and object of objects.

       Object.keys(Results).forEach(function (key){
                Object.defineProperty(Results[key], "Active", { value: "the appropriate value"});
            });
    

    Joining 2 SQL SELECT result sets into one

    SELECT table1.col_a, table1.col_b, table2.col_c 
      FROM table1 
      INNER JOIN table2 ON table1.col_a = table2.col_a
    

    How to put individual tags for a scatter plot

    Perhaps use plt.annotate:

    import numpy as np
    import matplotlib.pyplot as plt
    
    N = 10
    data = np.random.random((N, 4))
    labels = ['point{0}'.format(i) for i in range(N)]
    
    plt.subplots_adjust(bottom = 0.1)
    plt.scatter(
        data[:, 0], data[:, 1], marker='o', c=data[:, 2], s=data[:, 3] * 1500,
        cmap=plt.get_cmap('Spectral'))
    
    for label, x, y in zip(labels, data[:, 0], data[:, 1]):
        plt.annotate(
            label,
            xy=(x, y), xytext=(-20, 20),
            textcoords='offset points', ha='right', va='bottom',
            bbox=dict(boxstyle='round,pad=0.5', fc='yellow', alpha=0.5),
            arrowprops=dict(arrowstyle = '->', connectionstyle='arc3,rad=0'))
    
    plt.show()
    

    enter image description here

    Nothing was returned from render. This usually means a return statement is missing. Or, to render nothing, return null

    i solved the problem i exlained...for example in the file we render the other component,other component name is same with me method of current component such as:

    const Login = () => {
    
    }
    
    render(
      <Login/>
    )
    

    ..for solve this we must change the method name

    Run Python script at startup in Ubuntu

    Create file ~/.config/autostart/MyScript.desktop with

    [Desktop Entry]
    Encoding=UTF-8
    Name=MyScript
    Comment=MyScript
    Icon=gnome-info
    Exec=python /home/your_path/script.py
    Terminal=false
    Type=Application
    Categories=
    
    X-GNOME-Autostart-enabled=true
    X-GNOME-Autostart-Delay=0
    

    It helps me!

    Best way to parse RSS/Atom feeds with PHP

    I've always used the SimpleXML functions built in to PHP to parse XML documents. It's one of the few generic parsers out there that has an intuitive structure to it, which makes it extremely easy to build a meaningful class for something specific like an RSS feed. Additionally, it will detect XML warnings and errors, and upon finding any you could simply run the source through something like HTML Tidy (as ceejayoz mentioned) to clean it up and attempt it again.

    Consider this very rough, simple class using SimpleXML:

    class BlogPost
    {
        var $date;
        var $ts;
        var $link;
    
        var $title;
        var $text;
    }
    
    class BlogFeed
    {
        var $posts = array();
    
        function __construct($file_or_url)
        {
            $file_or_url = $this->resolveFile($file_or_url);
            if (!($x = simplexml_load_file($file_or_url)))
                return;
    
            foreach ($x->channel->item as $item)
            {
                $post = new BlogPost();
                $post->date  = (string) $item->pubDate;
                $post->ts    = strtotime($item->pubDate);
                $post->link  = (string) $item->link;
                $post->title = (string) $item->title;
                $post->text  = (string) $item->description;
    
                // Create summary as a shortened body and remove images, 
                // extraneous line breaks, etc.
                $post->summary = $this->summarizeText($post->text);
    
                $this->posts[] = $post;
            }
        }
    
        private function resolveFile($file_or_url) {
            if (!preg_match('|^https?:|', $file_or_url))
                $feed_uri = $_SERVER['DOCUMENT_ROOT'] .'/shared/xml/'. $file_or_url;
            else
                $feed_uri = $file_or_url;
    
            return $feed_uri;
        }
    
        private function summarizeText($summary) {
            $summary = strip_tags($summary);
    
            // Truncate summary line to 100 characters
            $max_len = 100;
            if (strlen($summary) > $max_len)
                $summary = substr($summary, 0, $max_len) . '...';
    
            return $summary;
        }
    }
    

    Android - Using Custom Font

    Update answer: Android 8.0 (API level 26) introduces a new feature, Fonts in XML. just use the Fonts in XML feature on devices running Android 4.1 (API level 16) and higher, use the Support Library 26.

    see this link


    Old answer

    There are two ways to customize fonts :

    !!! my custom font in assets/fonts/iran_sans.ttf



    Way 1 : Refrection Typeface.class ||| best way

    call FontsOverride.setDefaultFont() in class extends Application, This code will cause all software fonts to be changed, even Toasts fonts

    AppController.java

    public class AppController extends Application {
    
        @Override
        public void onCreate() {
            super.onCreate();
    
            //Initial Font
            FontsOverride.setDefaultFont(getApplicationContext(), "MONOSPACE", "fonts/iran_sans.ttf");
    
        }
    }
    

    FontsOverride.java

    public class FontsOverride {
    
        public static void setDefaultFont(Context context, String staticTypefaceFieldName, String fontAssetName) {
            final Typeface regular = Typeface.createFromAsset(context.getAssets(), fontAssetName);
            replaceFont(staticTypefaceFieldName, regular);
        }
    
        private static void replaceFont(String staticTypefaceFieldName, final Typeface newTypeface) {
            try {
                final Field staticField = Typeface.class.getDeclaredField(staticTypefaceFieldName);
                staticField.setAccessible(true);
                staticField.set(null, newTypeface);
            } catch (NoSuchFieldException e) {
                e.printStackTrace();
            } catch (IllegalAccessException e) {
                e.printStackTrace();
            }
        }
    }
    



    Way 2: use setTypeface

    for special view just call setTypeface() to change font.

    CTextView.java

    public class CTextView extends TextView {
    
        public CTextView(Context context) {
            super(context);
            init(context,null);
        }
    
        public CTextView(Context context, @Nullable AttributeSet attrs) {
            super(context, attrs);
            init(context,attrs);
        }
    
        public CTextView(Context context, @Nullable AttributeSet attrs, int defStyleAttr) {
            super(context, attrs, defStyleAttr);
            init(context,attrs);
        }
    
        @RequiresApi(api = Build.VERSION_CODES.LOLLIPOP)
        public CTextView(Context context, @Nullable AttributeSet attrs, int defStyleAttr, int defStyleRes) {
            super(context, attrs, defStyleAttr, defStyleRes);
            init(context,attrs);
        }
    
        public void init(Context context, @Nullable AttributeSet attrs) {
    
            if (isInEditMode())
                return;
    
            // use setTypeface for change font this view
            setTypeface(FontUtils.getTypeface("fonts/iran_sans.ttf"));
    
        }
    }
    

    FontUtils.java

    public class FontUtils {
    
        private static Hashtable<String, Typeface> fontCache = new Hashtable<>();
    
        public static Typeface getTypeface(String fontName) {
            Typeface tf = fontCache.get(fontName);
            if (tf == null) {
                try {
                    tf = Typeface.createFromAsset(AppController.getInstance().getApplicationContext().getAssets(), fontName);
                } catch (Exception e) {
                    e.printStackTrace();
                    return null;
                }
                fontCache.put(fontName, tf);
            }
            return tf;
        }
    
    }