Programs & Examples On #Rowset

The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"

For me, these two things helped on different occasions:

1) If you've just installed the MS Access runtime, reboot the server. Bouncing the database instance isn't enough.

2) As well as making sure the Excel file isn't open, check you haven't got Windows Explorer open with the preview pane switched on - that locks it too.

Import Excel Spreadsheet Data to an EXISTING sql table?

You can use import data with wizard and there you can choose destination table.

Run the wizard. In selecting source tables and views window you see two parts. Source and Destination.

Click on the field under Destination part to open the drop down and select you destination table and edit its mappings if needed.

EDIT

Merely typing the name of the table does not work. It appears that the name of the table must include the schema (dbo) and possibly brackets. Note the dropdown on the right hand side of the text field.

enter image description here

how to resolve DTS_E_OLEDBERROR. in ssis

Knowing the version of Windows and SQL Server might be helpful in some cases. From the Native Client 10.0 I infer either SQL Server 2008 or SQL Server 2008 R2.

There are a few possible things to check, but I would check to see if 'priority boost' was configured on the SQL Server. This is a deprecated setting and will eventually be removed. The problem is that it can rob the operating system of needed resources. See the notes at:

http://msdn.microsoft.com/en-in/library/ms180943(v=SQL.105).aspx

If 'priority boost' has been configured to 1, then get it configured back to 0.

exec sp_configure 'priority boost', 0;
RECONFIGURE;

How to enable Ad Hoc Distributed Queries

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO

"Cannot create an instance of OLE DB provider" error as Windows Authentication user

For error 7302 in particular, I discovered, in my registry, when looking for OraOLEDB.Oracle that the InprocServer32 location was wrong.

If that's the case, or you can't find that string in the registry, then you'll have to install or re-register the component.

I had to delete the key from the GUID level, and then find the ProgID (OraOLEDB.Oracle) key, and delete that too. (The ProgID links to the CLSID as a pair).

Then I re-registered OraOLEDB.Oracle by calling regsvr32.exe on ORAOLEDB*.dll.

Just re-registering alone didn't solve the problem, I had to delete the registry keys to make it point to the correct location. Alternatively, hack the InprocServer32 location.

Now I have error 7308, about single threaded apartments; rolling on!

AppFabric installation failed because installer MSI returned with error code : 1603

In my case it was: - My system account contained two words -- Name and Surname, like "Vasya Pupkin", so web platform installer saw only first "Vasya", so you need to rename system user to "VasyaPupkin" without space symbol, or install under different account. - Also I've noticed error in PowerShell env path, so check System variables PSModulePath, and remove unnecessary - symbol (") (SQL server path contains error, \PowerShell\Modules")

Escaping backslash in string - javascript

Add an input id to the element and do something like that:

document.getElementById('inputId').value.split(/[\\$]/).pop()

How to call a stored procedure (with parameters) from another stored procedure without temp table

You can create table variable instead of tamp table in procedure A and execute procedure B and insert into temp table by below query.

DECLARE @T TABLE
(
TABLE DEFINITION
)
.
.
.
INSERT INTO @T
EXEC B @MYDATE

and you continue operation.

How to loop through Excel files and load them into a database using SSIS package?

I ran into an article that illustrates a method where the data from the same excel sheet can be imported in the selected table until there is no modifications in excel with data types.

If the data is inserted or overwritten with new ones, importing process will be successfully accomplished, and the data will be added to the table in SQL database.

The article may be found here: http://www.sqlshack.com/using-ssis-packages-import-ms-excel-data-database/

Hope it helps.

How can I get the SQL of a PreparedStatement?

I'm using Java 8, JDBC driver with MySQL connector v. 5.1.31.

I may get real SQL string using this method:

// 1. make connection somehow, it's conn variable
// 2. make prepered statement template
PreparedStatement stmt = conn.prepareStatement(
    "INSERT INTO oc_manufacturer" +
    " SET" +
    " manufacturer_id = ?," +
    " name = ?," +
    " sort_order=0;"
);
// 3. fill template
stmt.setInt(1, 23);
stmt.setString(2, 'Google');
// 4. print sql string
System.out.println(((JDBC4PreparedStatement)stmt).asSql());

So it returns smth like this:

INSERT INTO oc_manufacturer SET manufacturer_id = 23, name = 'Google', sort_order=0;

jQuery’s .bind() vs. .on()

Internally, .bind maps directly to .on in the current version of jQuery. (The same goes for .live.) So there is a tiny but practically insignificant performance hit if you use .bind instead.

However, .bind may be removed from future versions at any time. There is no reason to keep using .bind and every reason to prefer .on instead.

What is wrong with this code that uses the mysql extension to fetch data from a database in PHP?

Change the "WHILE" to "while". Because php is case sensitive like c/c++.

How to get bitmap from a url in android?

This is a simple one line way to do it:

    try {
        URL url = new URL("http://....");
        Bitmap image = BitmapFactory.decodeStream(url.openConnection().getInputStream());
    } catch(IOException e) {
        System.out.println(e);
    }

How to determine the encoding of text?

This site has python code for recognizing ascii, encoding with boms, and utf8 no bom: https://unicodebook.readthedocs.io/guess_encoding.html. Read file into byte array (data): http://www.codecodex.com/wiki/Read_a_file_into_a_byte_array. Here's an example. I'm in osx.

#!/usr/bin/python                                                                                                  

import sys

def isUTF8(data):
    try:
        decoded = data.decode('UTF-8')
    except UnicodeDecodeError:
        return False
    else:
        for ch in decoded:
            if 0xD800 <= ord(ch) <= 0xDFFF:
                return False
        return True

def get_bytes_from_file(filename):
    return open(filename, "rb").read()

filename = sys.argv[1]
data = get_bytes_from_file(filename)
result = isUTF8(data)
print(result)


PS /Users/js> ./isutf8.py hi.txt                                                                                     
True

jquery background-color change on focus and blur

#FFFFEEE is not a correct color code. Try with #FFFFEE instead.

sklearn: Found arrays with inconsistent numbers of samples when calling LinearRegression.fit()

To analyze two arrays (array1 and array2) they need to meet the following two requirements:

1) They need to be a numpy.ndarray

Check with

type(array1)
# and
type(array2)

If that is not the case for at least one of them perform

array1 = numpy.ndarray(array1)
# or
array2 = numpy.ndarray(array2)

2) The dimensions need to be as follows:

array1.shape #shall give (N, 1)
array2.shape #shall give (N,)

N is the number of items that are in the array. To provide array1 with the right number of axes perform:

array1 = array1[:, numpy.newaxis]

Custom Cell Row Height setting in storyboard is not responding

I have recently been wrestling with this. My issue was the solutions posted above using the heightForRowAtIndexPath: method would work for iOS 7.1 in the Simulator but then have completely screwed up results by simply switching to iOS 8.1.

I began reading more about self-sizing cells (introduced in iOS 8, read here). It was apparent that the use of UITableViewAutomaticDimension would help in iOS 8. I tried using that technique and deleted the use of heightForRowAtIndexPath: and voila, it was working perfect in iOS 8 now. But then iOS 7 wasn't. What was I to do? I needed heightForRowAtIndexPath: for iOS 7 and not for iOS 8.

Here is my solution (trimmed up for brevity's sake) which borrow's from the answer @JosephH posted above:

- (void)viewDidLoad {
    [super viewDidLoad];

    self.tableView.estimatedRowHeight = 50.;
    self.tableView.rowHeight = UITableViewAutomaticDimension;

    // ...
}

- (CGFloat)tableView:(UITableView *)tableView heightForRowAtIndexPath:(NSIndexPath *)indexPath
{
    if (SYSTEM_VERSION_GREATER_THAN_OR_EQUAL_TO(@"8.0")) {
        return UITableViewAutomaticDimension;

    } else {
        NSString *cellIdentifier = [self reuseIdentifierForCellAtIndexPath:indexPath];
        static NSMutableDictionary *heightCache;
        if (!heightCache)
            heightCache = [[NSMutableDictionary alloc] init];
        NSNumber *cachedHeight = heightCache[cellIdentifier];
        if (cachedHeight)
            return cachedHeight.floatValue;

    UITableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:cellIdentifier];
    CGFloat height = cell.bounds.size.height;
    heightCache[cellIdentifier] = @(height);
    return height;
    }
}

- (NSString *)reuseIdentifierForCellAtIndexPath:(NSIndexPath *)indexPath {
    NSString * reuseIdentifier;
    switch (indexPath.row) {
        case 0:
            reuseIdentifier = EventTitleCellIdentifier;
            break;
        case 2:
            reuseIdentifier = EventDateTimeCellIdentifier;
            break;
        case 4:
            reuseIdentifier = EventContactsCellIdentifier;
            break;
        case 6:
            reuseIdentifier = EventLocationCellIdentifier;
            break;
        case 8:
            reuseIdentifier = NotesCellIdentifier;
            break;
        default:
            reuseIdentifier = SeparatorCellIdentifier;
            break;
    }

    return reuseIdentifier;
}

SYSTEM_VERSION_GREATER_THAN_OR_EQUAL_TO(@"8.0") is actually from a set of macro definitions I am using which I found somewhere (very helpful). They are defined as:

#define SYSTEM_VERSION_EQUAL_TO(v)                  ([[[UIDevice currentDevice] systemVersion] compare:v options:NSNumericSearch] == NSOrderedSame)
#define SYSTEM_VERSION_GREATER_THAN(v)              ([[[UIDevice currentDevice] systemVersion] compare:v options:NSNumericSearch] == NSOrderedDescending)
#define SYSTEM_VERSION_GREATER_THAN_OR_EQUAL_TO(v)  ([[[UIDevice currentDevice] systemVersion] compare:v options:NSNumericSearch] != NSOrderedAscending)
#define SYSTEM_VERSION_LESS_THAN(v)                 ([[[UIDevice currentDevice] systemVersion] compare:v options:NSNumericSearch] == NSOrderedAscending)
#define SYSTEM_VERSION_LESS_THAN_OR_EQUAL_TO(v)     ([[[UIDevice currentDevice] systemVersion] compare:v options:NSNumericSearch] != NSOrderedDescending)

How to Programmatically Add Views to Views

This is late but this may help someone :) :) For adding the view programmatically try like

LinearLayout rlmain = new LinearLayout(this);      
LinearLayout.LayoutParams llp = new LinearLayout.LayoutParams(LinearLayout.LayoutParams.FILL_PARENT,LinearLayout.LayoutParams.FILL_PARENT);          
LinearLayout   ll1 = new LinearLayout (this);

ImageView iv = new ImageView(this);
iv.setImageResource(R.drawable.logo);              
LinearLayout .LayoutParams lp = new LinearLayout.LayoutParams(LinearLayout.LayoutParams.MATCH_PARENT, LinearLayout.LayoutParams.MATCH_PARENT);

iv.setLayoutParams(lp);
ll1.addView(iv);
rlmain.addView(ll1);              
setContentView(rlmain, llp);

This will create your entire view programmatcally. You can add any number of view as same. Hope this may help. :)

Test if string begins with a string?

The best methods are already given but why not look at a couple of other methods for fun? Warning: these are more expensive methods but do serve in other circumstances.

The expensive regex method and the css attribute selector with starts with ^ operator

Option Explicit

Public Sub test()

    Debug.Print StartWithSubString("ab", "abc,d")

End Sub

Regex:

Public Function StartWithSubString(ByVal substring As String, ByVal testString As String) As Boolean
    'required reference Microsoft VBScript Regular Expressions
    Dim re As VBScript_RegExp_55.RegExp
    Set re = New VBScript_RegExp_55.RegExp

    re.Pattern = "^" & substring

    StartWithSubString = re.test(testString)

End Function

Css attribute selector with starts with operator

Public Function StartWithSubString(ByVal substring As String, ByVal testString As String) As Boolean
    'required reference Microsoft HTML Object Library
    Dim html As MSHTML.HTMLDocument
    Set html = New MSHTML.HTMLDocument

    html.body.innerHTML = "<div test=""" & testString & """></div>"

    StartWithSubString = html.querySelectorAll("[test^=" & substring & "]").Length > 0

End Function

How do I add a placeholder on a CharField in Django?

It's undesirable to have to know how to instantiate a widget when you just want to override its placeholder.

    q = forms.CharField(label='search')
    ...
    q.widget.attrs['placeholder'] = "Search"

How to round float numbers in javascript?

Number((6.688689).toFixed(1)); // 6.7

var number = 6.688689;
var roundedNumber = Math.round(number * 10) / 10;

Use toFixed() function.

(6.688689).toFixed(); // equal to "7"
(6.688689).toFixed(1); // equal to "6.7"
(6.688689).toFixed(2); // equal to "6.69"

How to perform a LEFT JOIN in SQL Server between two SELECT statements?

SELECT [UserID] FROM [User] u LEFT JOIN (
SELECT [TailUser], [Weight] FROM [Edge] WHERE [HeadUser] = 5043) t on t.TailUser=u.USerID

Issue with adding common code as git submodule: "already exists in the index"

if there exists a folder named x under git control, you want add a same name submodule , you should delete folder x and commit it first.

Updated by @ujjwal-singh:

Committing is not needed, staging suffices.. git add / git rm -r

How to launch Windows Scheduler by command-line?

taskschd.msc is available in Windows Vista and later.

http://technet.microsoft.com/en-us/library/cc721871.aspx

I could have sworn I'd seen a little task scheduler GUI like you're talking about prior to Vista, but maybe I was thinking of the "Add Scheduled Task" wizard.

You might have to settle for opening the scheduled tasks explorer with this command:

control schedtasks

I couldn't find any way to launch the "Add Scheduled Task" wizard from the command line, unfortunately (there has to be a way!)

SQL Transaction Error: The current transaction cannot be committed and cannot support operations that write to the log file

I have encountered this error while updating records from table which has trigger enabled. For example - I have trigger 'Trigger1' on table 'Table1'. When I tried to update the 'Table1' using the update query - it throws the same error. THis is because if you are updating more than 1 record in your query, then 'Trigger1' will throw this error as it doesn't support updating multiple entries if it is enabled on same table. I tried disabling trigger before update and then performed update operation and it was completed without any error.

DISABLE TRIGGER Trigger1 ON Table1;
Update query --------
Enable TRIGGER Trigger1 ON Table1;

Removing a Fragment from the back stack

What happens if the fragment that you want to remove is not on top of the stack?

Then you can use theses functions

popBackStack(int arg0, int arg1);

popBackStack(String arg0, int arg1);

Redirecting to a relative URL in JavaScript

I'm trying to redirect my current web site to other section on the same page, using JavaScript. This follow code work for me:

location.href='/otherSection'

Can I use a case/switch statement with two variables?

You could give each position on each slider a different binary value from 1 to 1000000000 and then work with the sum.

C Program to find day of week given date

The answer I came up with:

const int16_t TM_MON_DAYS_ACCU[12] = {
    0, 31, 59, 90, 120, 151, 181, 212, 243, 273, 304, 334
};

int tm_is_leap_year(unsigned year) {
    return ((year & 3) == 0) && ((year % 400 == 0) || (year % 100 != 0));
}

// The "Doomsday" the the day of the week of March 0th,
// i.e the last day of February.
// In common years January 3rd has the same day of the week,
// and on leap years it's January 4th.
int tm_doomsday(int year) {
    int result;
    result  = TM_WDAY_TUE;
    result += year;       // I optimized the calculation a bit:
    result += year >>= 2; // result += year / 4
    result -= year /= 25; // result += year / 100
    result += year >>= 2; // result += year / 400
    return result;
}

void tm_get_wyday(int year, int mon, int mday, int *wday, int *yday) {
    int is_leap_year = tm_is_leap_year(year);
    // How many days passed since Jan 1st?
    *yday = TM_MON_DAYS_ACCU[mon] + mday + (mon <= TM_MON_FEB ? 0 : is_leap_year) - 1;
    // Which day of the week was Jan 1st of the given year?
    int jan1 = tm_doomsday(year) - 2 - is_leap_year;
    // Now just add these two values.
    *wday = (jan1 + *yday) % 7;
}

with these defines (matching struct tm of time.h):

#define TM_WDAY_SUN 0
#define TM_WDAY_MON 1
#define TM_WDAY_TUE 2
#define TM_WDAY_WED 3
#define TM_WDAY_THU 4
#define TM_WDAY_FRI 5
#define TM_WDAY_SAT 6

#define TM_MON_JAN  0
#define TM_MON_FEB  1
#define TM_MON_MAR  2
#define TM_MON_APR  3
#define TM_MON_MAY  4
#define TM_MON_JUN  5
#define TM_MON_JUL  6
#define TM_MON_AUG  7
#define TM_MON_SEP  8
#define TM_MON_OCT  9
#define TM_MON_NOV 10
#define TM_MON_DEC 11

Hosting ASP.NET in IIS7 gives Access is denied?

For me in windows 7 it started to work only after I gave 'Read & execute', 'List folder contents', 'Read' permissions to site folder for both users

  • IUSR
  • NETWORK SERVICE

IUSR permissions NETWORK SERVICE permissions

Can I fade in a background image (CSS: background-image) with jQuery?

With modern browser i prefer a much lightweight approach with a bit of Js and CSS3...

transition: background 300ms ease-in 200ms;

Look at this demo:

http://codepen.io/nicolasbonnici/pen/gPVNbr

Python: 'ModuleNotFoundError' when trying to import module from imported package

For me when I created a file and saved it as python file, I was getting this error during importing. I had to create a filename with the type ".py" , like filename.py and then save it as a python file. post trying to import the file worked for me.

Inserting the same value multiple times when formatting a string

>>> s1 ='arbit'
>>> s2 = 'hello world '.join( [s]*3 )
>>> print s2
arbit hello world arbit hello world arbit

How do I subtract minutes from a date in javascript?

moment.js has some really nice convenience methods to manipulate date objects

The .subtract method, allows you to subtract a certain amount of time units from a date, by providing the amount and a timeunit string.

var now = new Date();
// Sun Jan 22 2017 17:12:18 GMT+0200 ...
var olderDate = moment(now).subtract(3, 'minutes').toDate();
// Sun Jan 22 2017 17:09:18 GMT+0200 ...

How to Fill an array from user input C#?

I've done it finaly check it and if there is a better way tell me guys

    static void Main()
    {
        double[] array = new double[6];
        Console.WriteLine("Please Sir Enter 6 Floating numbers");
        for (int i = 0; i < 6; i++)
        {
            array[i] = Convert.ToDouble(Console.ReadLine());
        }

        double sum = 0;

        foreach (double d in array)
        {
            sum += d;
        }
        double average = sum / 6;
        Console.WriteLine("===============================================");
        Console.WriteLine("The Values you've entered are");
        Console.WriteLine("{0}{1,8}", "index", "value");
        for (int counter = 0; counter < 6; counter++)
            Console.WriteLine("{0,5}{1,8}", counter, array[counter]);
        Console.WriteLine("===============================================");
        Console.WriteLine("The average is ;");
        Console.WriteLine(average);
        Console.WriteLine("===============================================");
        Console.WriteLine("would you like to search for a certain elemnt ? (enter yes or no)");
        string answer = Console.ReadLine();
        switch (answer)
        {
            case "yes":
                Console.WriteLine("===============================================");
                Console.WriteLine("please enter the array index you wish to get the value of it");
                int index = Convert.ToInt32(Console.ReadLine());
                Console.WriteLine("===============================================");
                Console.WriteLine("The Value of the selected index is:");
                Console.WriteLine(array[index]);
                break;

            case "no":
                Console.WriteLine("===============================================");
                Console.WriteLine("HAVE A NICE DAY SIR");
                break;
        }
    }

Convert python long/int to fixed size byte array

long/int to the byte array looks like exact purpose of struct.pack. For long integers that exceed 4(8) bytes, you can come up with something like the next:

>>> limit = 256*256*256*256 - 1
>>> i = 1234567890987654321
>>> parts = []
>>> while i:
        parts.append(i & limit)
        i >>= 32

>>> struct.pack('>' + 'L'*len(parts), *parts )
'\xb1l\x1c\xb1\x11"\x10\xf4'

>>> struct.unpack('>LL', '\xb1l\x1c\xb1\x11"\x10\xf4')
(2976652465L, 287445236)
>>> (287445236L << 32) + 2976652465L
1234567890987654321L

Mvn install or Mvn package

If you're not using a remote repository (like artifactory), use plain old: mvn clean install

Pretty old topic but AFAIK, if you run your own repository (eg: with artifactory) to share jar among your team(s), you might want to use

mvn clean deploy

instead.

This way, your continuous integration server can be sure that all dependencies are correctly pushed into your remote repository. If you missed one, mvn will not be able to find it into your CI local m2 repository.

SELECT *, COUNT(*) in SQLite

If you want to count the number of records in your table, simply run:

    SELECT COUNT(*) FROM your_table;

laravel foreach loop in controller

Hi, this will throw an error:

foreach ($product->sku as $sku){ 
// Code Here
}

because you cannot loop a model with a specific column ($product->sku) from the table.
So you must loop on the whole model:

foreach ($product as $p) {
// code
}

Inside the loop you can retrieve whatever column you want just adding "->[column_name]"

foreach ($product as $p) {
echo $p->sku;
}

Have a great day

How to upgrade Angular CLI to the latest version

In addition to @ShinDarth answer.

I did what he said but my package did not updated the angular version, and I know that this post is about angular-cli, but i think that this can help too.

  • so after doing what @ShinDarth said above, to fix my angular version I had to create a new project with -ng new projectname that generated a package.
  • copy the new package, then paste the new package on all projects packages needing update (remember to add the dependencies you had and change the name on first line) or you can just change the versions manualy without copy and paste.
  • then run -npm install.

Now my ng serve is working again, maybe there is a better way to do all that, if someone know, please share, because this is a pain to do with all projects that need update.

How to compare timestamp dates with date-only parameter in MySQL?

You can use the DATE() function to extract the date portion of the timestamp:

SELECT * FROM table
WHERE DATE(timestamp) = '2012-05-25'

Though, if you have an index on the timestamp column, this would be faster because it could utilize an index on the timestamp column if you have one:

SELECT * FROM table
WHERE timestamp BETWEEN '2012-05-25 00:00:00' AND '2012-05-25 23:59:59'

How to convert object array to string array in Java

For your idea, actually you are approaching the success, but if you do like this should be fine:

for (int i=0;i<String_Array.length;i++) String_Array[i]=(String)Object_Array[i];

BTW, using the Arrays utility method is quite good and make the code elegant.

Updates were rejected because the tip of your current branch is behind its remote counterpart

You must have added new files in your commits which has not been pushed. Check the file and push that file again and the try pull / push it will work. This worked for me..

[Vue warn]: Property or method is not defined on the instance but referenced during render

It's probably caused by spelling error

I got a typo at script closing tag

</sscript>

How to get current SIM card number in Android?

Update: This answer is no longer available as Whatsapp had stopped exposing the phone number as account name, kindly disregard this answer.

=================================================================================

Its been almost 6 months and I believe I should update this with an alternative solution you might want to consider.

As of today, you can rely on another big application Whatsapp, using AccountManager. Millions of devices have this application installed and if you can't get the phone number via TelephonyManager, you may give this a shot.

Permission:

<uses-permission android:name="android.permission.GET_ACCOUNTS" />

Code:

AccountManager am = AccountManager.get(this);
Account[] accounts = am.getAccounts();

ArrayList<String> googleAccounts = new ArrayList<String>();
for (Account ac : accounts) {
    String acname = ac.name;
    String actype = ac.type;
    // Take your time to look at all available accounts
    System.out.println("Accounts : " + acname + ", " + actype);
}

Check actype for whatsapp account

if(actype.equals("com.whatsapp")){
    String phoneNumber = ac.name;
}

Of course you may not get it if user did not install Whatsapp, but its worth to try anyway. And remember you should always ask user for confirmation.

Simple function to sort an array of objects

var data = [ 1, 2, 5, 3, 1]; data.sort(function(a,b) { return a-b });

With a small compartor and using sort, we can do it

Get current working directory in a Qt application

To add on to KaZ answer, Whenever I am making a QML application I tend to add this to the main c++

#include <QGuiApplication>
#include <QQmlApplicationEngine>
#include <QStandardPaths>

int main(int argc, char *argv[])
{
QGuiApplication app(argc, argv);
QQmlApplicationEngine engine;

// get the applications dir path and expose it to QML 

QUrl appPath(QString("%1").arg(app.applicationDirPath()));
engine.rootContext()->setContextProperty("appPath", appPath);


// Get the QStandardPaths home location and expose it to QML 
QUrl userPath;
   const QStringList usersLocation = QStandardPaths::standardLocations(QStandardPaths::HomeLocation);
   if (usersLocation.isEmpty())
       userPath = appPath.resolved(QUrl("/home/"));
   else
      userPath = QString("%1").arg(usersLocation.first());
   engine.rootContext()->setContextProperty("userPath", userPath);

   QUrl imagePath;
      const QStringList picturesLocation = QStandardPaths::standardLocations(QStandardPaths::PicturesLocation);
      if (picturesLocation.isEmpty())
          imagePath = appPath.resolved(QUrl("images"));
      else
          imagePath = QString("%1").arg(picturesLocation.first());
      engine.rootContext()->setContextProperty("imagePath", imagePath);

      QUrl videoPath;
      const QStringList moviesLocation = QStandardPaths::standardLocations(QStandardPaths::MoviesLocation);
      if (moviesLocation.isEmpty())
          videoPath = appPath.resolved(QUrl("./"));
      else
          videoPath = QString("%1").arg(moviesLocation.first());
      engine.rootContext()->setContextProperty("videoPath", videoPath);

      QUrl homePath;
      const QStringList homesLocation = QStandardPaths::standardLocations(QStandardPaths::HomeLocation);
      if (homesLocation.isEmpty())
          homePath = appPath.resolved(QUrl("/"));
      else
          homePath = QString("%1").arg(homesLocation.first());
      engine.rootContext()->setContextProperty("homePath", homePath);

      QUrl desktopPath;
      const QStringList desktopsLocation = QStandardPaths::standardLocations(QStandardPaths::DesktopLocation);
      if (desktopsLocation.isEmpty())
          desktopPath = appPath.resolved(QUrl("/"));
      else
          desktopPath = QString("%1").arg(desktopsLocation.first());
      engine.rootContext()->setContextProperty("desktopPath", desktopPath);

      QUrl docPath;
      const QStringList docsLocation = QStandardPaths::standardLocations(QStandardPaths::DocumentsLocation);
      if (docsLocation.isEmpty())
          docPath = appPath.resolved(QUrl("/"));
      else
          docPath = QString("%1").arg(docsLocation.first());
      engine.rootContext()->setContextProperty("docPath", docPath);


      QUrl tempPath;
      const QStringList tempsLocation = QStandardPaths::standardLocations(QStandardPaths::TempLocation);
      if (tempsLocation.isEmpty())
          tempPath = appPath.resolved(QUrl("/"));
      else
          tempPath = QString("%1").arg(tempsLocation.first());
      engine.rootContext()->setContextProperty("tempPath", tempPath);
engine.load(QUrl(QStringLiteral("qrc:/main.qml")));
return app.exec();
}

Using it in QML

....
........
............
Text{
text:"This is the applications path: " + appPath
+ "\nThis is the users home directory: " + homePath
+ "\nThis is the Desktop path: " desktopPath;
}

How to bring a window to the front?

The rules governing what happens when you .toFront() a JFrame are the same in windows and in linux :

-> if a window of the existing application is currently the focused window, then focus swaps to the requested window -> if not, the window merely flashes in the taskbar

BUT :

-> new windows automatically get focus

So let's exploit this ! You want to bring a window to the front, how to do it ? Well :

  1. Create an empty non-purpose window
  2. Show it
  3. Wait for it to show up on screen (setVisible does that)
  4. When shown, request focus for the window you actually want to bring the focus to
  5. hide the empty window, destroy it

Or, in java code :

// unminimize if necessary
this.setExtendedState(this.getExtendedState() & ~JFrame.ICONIFIED);

// don't blame me, blame my upbringing
// or better yet, blame java !
final JFrame newFrame = new JFrame();
newFrame.add(new JLabel("boembabies, is this in front ?"));

newFrame.pack();
newFrame.setVisible(true);
newFrame.toFront();

this.toFront();
this.requestFocus();

// I'm not 100% positive invokeLater is necessary, but it seems to be on
// WinXP. I'd be lying if I said I understand why
SwingUtilities.invokeLater(new Runnable() {
  @Override public void run() {
    newFrame.setVisible(false);
  }
});

how to use a like with a join in sql?

When writing queries with our server LIKE or INSTR (or CHARINDEX in T-SQL) takes too long, so we use LEFT like in the following structure:

select *
from little
left join big
on left( big.key, len(little.key) ) = little.key

I understand that might only work with varying endings to the query, unlike other suggestions with '%' + b + '%', but is enough and much faster if you only need b+'%'.

Another way to optimize it for speed (but not memory) is to create a column in "little" that is "len(little.key)" as "lenkey" and user that instead in the query above.

npm start error with create-react-app

I might be very late to answer this question but this is what has worked for me and it might help someone to get back on the development track!

nvm install v12.0 // You may need to install nvm, if not already done
rm -rd node_modules/
npm cache clean --force
npm install

Cheers!!

How to scroll to top of long ScrollView layout?

i had the same problem and this fixed it. Hope it helps you.

listView.setFocusable(false);

Div Scrollbar - Any way to style it?

Using javascript you can style the scroll bars. Which works fine in IE as well as FF.

Check the below links

From Twinhelix , Example 2 , Example 3 [or] you can find some 30 type of scroll style types by click the below link 30 scrolling techniques

Why compile Python code?

There is a performance increase in running compiled python. However when you run a .py file as an imported module, python will compile and store it, and as long as the .py file does not change it will always use the compiled version.

With any interpeted language when the file is used the process looks something like this:
1. File is processed by the interpeter.
2. File is compiled
3. Compiled code is executed.

obviously by using pre-compiled code you can eliminate step 2, this applies python, PHP and others.

Heres an interesting blog post explaining the differences http://julipedia.blogspot.com/2004/07/compiled-vs-interpreted-languages.html
And here's an entry that explains the Python compile process http://effbot.org/zone/python-compile.htm

Managing SSH keys within Jenkins for Git

This works for me if you have config and the private key file in the /Jenkins/.ssh/ you need to chown (change owner) for these 2 files then restart jenkins in order for the jenkins instance to read these 2 files.

How to set a default value in react-select

If you are not using redux-form and you are using local state for changes then your react-select component might look like this:

class MySelect extends Component {

constructor() {
    super()
}

state = {
     selectedValue: 'default' // your default value goes here
}

render() {
  <Select
       ...
       value={this.state.selectedValue}
       ...
  />
)}

Get pixel's RGB using PIL

With numpy :

im = Image.open('image.gif')
im_matrix = np.array(im)
print(im_matrix[0][0])

Give RGB vector of the pixel in position (0,0)

What does the CSS rule "clear: both" do?

CSS float and clear

Sample Fiddle

Just try to remove clear:both property from the div with class sample and see how it follows floating divs.

Defined Edges With CSS3 Filter Blur

You can stop the image from overlapping it's edges by clipping the image and applying a wrapper element which sets the blur effect to 0 pixels. This is how it looks like:

HTML

<div id="wrapper">
  <div id="image"></div>
</div>

CSS

#wrapper {
  width: 1024px;
  height: 768px;

  border: 1px solid black;

  // 'blur(0px)' will prevent the wrapped image
  // from overlapping the border
  -webkit-filter: blur(0px);
  -moz-filter: blur(0px);
  -ms-filter: blur(0px);
  filter: blur(0px);
}

#wrapper #image {
  width: 1024px;
  height: 768px;

  background-image: url("../images/cats.jpg");
  background-size: cover;

  -webkit-filter: blur(10px);
  -moz-filter: blur(10px);
  -ms-filter: blur(10px);
  filter: blur(10px);

  // Position 'absolute' is needed for clipping
  position: absolute;
  clip: rect(0px, 1024px, 768px, 0px);
}

Sql Server 'Saving changes is not permitted' error ? Prevent saving changes that require table re-creation

Actually, You are blocked by SSMS not the SQL Server.

So the solution are either change setting of SSMS or use a SQL query.

How do I programmatically set the value of a select box element using JavaScript?

Suppose your form is named form1:

function selectValue(val)
{
  var lc = document.form1.leaveCode;
  for (i=0; i&lt;lc.length; i++)
  {
    if (lc.options[i].value == val)
    {
        lc.selectedIndex = i;
        return;
    }
  }
}

Running Composer returns: "Could not open input file: composer.phar"

I got this error "Could not open input file: composer.phar" while installing Yii2 using below mentioned command.

php composer.phar create-project yiisoft/yii2-app-basic basic

Solutions which worked for me was, I changed the command to

composer create-project yiisoft/yii2-app-basic basic

I hope it help!

Ruby on Rails: Where to define global constants?

If a constant is needed in more than one class, I put it in config/initializers/contant.rb always in all caps (list of states below is truncated).

STATES = ['AK', 'AL', ... 'WI', 'WV', 'WY']

They are available through out the application except in model code as such:

    <%= form.label :states, %>
    <%= form.select :states, STATES, {} %>

To use the constant in a model, use attr_accessor to make the constant available.

class Customer < ActiveRecord::Base
    attr_accessor :STATES

    validates :state, inclusion: {in: STATES, message: "-- choose a State from the drop down list."}
end

javascript how to create a validation error message without using alert

I would strongly suggest you start using jQuery. Your code would look like:

$(function() {
    $('form[name="myform"]').submit(function(e) {
        var username = $('form[name="myform"] input[name="username"]').val();
        if ( username == '') {
            e.preventDefault();
            $('#errors').text('*Please enter a username*');
        }
    });
});

Setting Oracle 11g Session Timeout

Adam has already suggested database profiles.

You could check the SQLNET.ORA file. There's an EXPIRE_TIME parameter but this is for detecting lost connections, rather than terminating existing ones.

Given it happens overnight, it sounds more like an idle timeout, which could be down to a firewall between the app server and database server. Setting the EXPIRE_TIME may stop that happening (as there'll be check every 10 minutes to check the client is alive).

Or possibly the database is being shutdown and restarted and that is killing the connections.

Alternatively, you should be able to configure tomcat with a validationQuery so that it will automatically restart the connection without a tomcat restart

"ImportError: no module named 'requests'" after installing with pip

Opening CMD in the location of the already installed request folder and running "pip install requests" worked for me. I am using two different versions of Python.

I think this works because requests is now installed outside my virtual environment. Haven't checked but just thought I'd write this in, in case anyone else is going crazy searching on Google.

"Field has incomplete type" error

The problem is that your ui property uses a forward declaration of class Ui::MainWindowClass, hence the "incomplete type" error.

Including the header file in which this class is declared will fix the problem.

EDIT

Based on your comment, the following code:

namespace Ui
{
    class MainWindowClass;
}

does NOT declare a class. It's a forward declaration, meaning that the class will exist at some point, at link time.
Basically, it just tells the compiler that the type will exist, and that it shouldn't warn about it.

But the class has to be defined somewhere.

Note this can only work if you have a pointer to such a type.
You can't have a statically allocated instance of an incomplete type.

So either you actually want an incomplete type, and then you should declare your ui member as a pointer:

namespace Ui
{
    // Forward declaration - Class will have to exist at link time
    class MainWindowClass;
}

class MainWindow : public QMainWindow
{
    private:

        // Member needs to be a pointer, as it's an incomplete type
        Ui::MainWindowClass * ui;
};

Or you want a statically allocated instance of Ui::MainWindowClass, and then it needs to be declared. You can do it in another header file (usually, there's one header file per class).
But simply changing the code to:

namespace Ui
{
    // Real class declaration - May/Should be in a specific header file
    class MainWindowClass
    {};
}


class MainWindow : public QMainWindow
{
    private:

        // Member can be statically allocated, as the type is complete
        Ui::MainWindowClass ui;
};

will also work.

Note the difference between the two declarations. First uses a forward declaration, while the second one actually declares the class (here with no properties nor methods).

How can I use a Python script in the command line without cd-ing to its directory? Is it the PYTHONPATH?

I think you're a little confused. PYTHONPATH sets the search path for importing python modules, not for executing them like you're trying.

PYTHONPATH Augment the default search path for module files. The format is the same as the shell’s PATH: one or more directory pathnames separated by os.pathsep (e.g. colons on Unix or semicolons on Windows). Non-existent directories are silently ignored.

In addition to normal directories, individual PYTHONPATH entries may refer to zipfiles containing pure Python modules (in either source or compiled form). Extension modules cannot be imported from zipfiles.

The default search path is installation dependent, but generally begins with prefix/lib/pythonversion (see PYTHONHOME above). It is always appended to PYTHONPATH.

An additional directory will be inserted in the search path in front of PYTHONPATH as described above under Interface options. The search path can be manipulated from within a Python program as the variable sys.path.

http://docs.python.org/2/using/cmdline.html#envvar-PYTHONPATH

What you're looking for is PATH.

export PATH=$PATH:/home/randy/lib/python 

However, to run your python script as a program, you also need to set a shebang for Python in the first line. Something like this should work:

#!/usr/bin/env python

And give execution privileges to it:

chmod +x /home/randy/lib/python/gbmx.py

Then you should be able to simply run gmbx.py from anywhere.

Changing cursor to waiting in javascript/jquery

Override all single element

$("*").css("cursor", "progress");

How to create a backup of a single table in a postgres database?

If you prefer a graphical user interface, you can use pgAdmin III (Linux/Windows/OS X). Simply right click on the table of your choice, then "backup". It will create a pg_dump command for you.

enter image description here

enter image description here

enter image description here

composer laravel create project

composer create-project laravel/laravel ProjectName 

How do I calculate power-of in C#?

Do not use Math.Pow

When i use

for (int i = 0; i < 10e7; i++)
{
    var x3 = x * x * x;
    var y3 = y * y * y;
}

It only takes 230 ms whereas the following takes incredible 7050 ms:

for (int i = 0; i < 10e7; i++)
{
    var x3 = Math.Pow(x, 3);
    var y3 = Math.Pow(x, 3);
}

Read a file line by line with VB.NET

Replaced the reader declaration with this one and now it works!

Dim reader As New StreamReader(filetoimport.Text, Encoding.Default)

Encoding.Default represents the ANSI code page that is set under Windows Control Panel.

How to use a App.config file in WPF applications?

I have a Class Library WPF Project, and I Use:

'Read Settings
Dim value as string = My.Settings.my_key
value = "new value"

'Write Settings
My.Settings.my_key = value
My.Settings.Save()

Find the min/max element of an array in JavaScript

After reading all the answers, I thought it would be good to write the soundest solution (which was not provided here) I have come across. If your value array might grow into the tens of thousands, use a hybrid strategy: apply your function to chunks of the array at a time:

function minOfArray(arr) {
  var min = Infinity;
  var QUANTUM = 32768;

  for (var i = 0, len = arr.length; i < len; i += QUANTUM) {
    var submin = Math.min.apply(null, 
                                arr.slice(i, Math.min(i+QUANTUM, len)));
    min = Math.min(submin, min);
  }

  return min;
}

var min = minOfArray([5, 6, 2, 3, 7]);

Source: MDN

Just disable scroll not hide it?

Four little additions to the accepted solution:

  1. Apply 'noscroll' to html instead of to body to prevent double scroll bars in IE
  2. To check if there's actually a scroll bar before adding the 'noscroll' class. Otherwise, the site will also jump pushed by the new non-scrolling scroll bar.
  3. To keep any possible scrollTop so the entire page doesn't go back to the top (like Fabrizio's update, but you need to grab the value before adding the 'noscroll' class)
  4. Not all browsers handle scrollTop the same way as documented at http://help.dottoro.com/ljnvjiow.php

Complete solution that seems to work for most browsers:

CSS

html.noscroll {
    position: fixed; 
    overflow-y: scroll;
    width: 100%;
}

Disable scroll

if ($(document).height() > $(window).height()) {
     var scrollTop = ($('html').scrollTop()) ? $('html').scrollTop() : $('body').scrollTop(); // Works for Chrome, Firefox, IE...
     $('html').addClass('noscroll').css('top',-scrollTop);         
}

Enable scroll

var scrollTop = parseInt($('html').css('top'));
$('html').removeClass('noscroll');
$('html,body').scrollTop(-scrollTop);

Thanks to Fabrizio and Dejan for putting me on the right track and to Brodingo for the solution to the double scroll bar

Send HTTP POST message in ASP.NET Core using HttpClient PostAsJsonAsync

I would add to the accepted answer that you would also want to add the Accept header to the httpClient:

httpClient.DefaultRequestHeaders.Accept.Clear();
httpClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));

How to 'update' or 'overwrite' a python list

I'm learning to code and I found this same problem. I believe the easier way to solve this is literaly overwriting the list like @kerby82 said:

An item in a list in Python can be set to a value using the form

x[n] = v

Where x is the name of the list, n is the index in the array and v is the value you want to set.

In your exemple:

aList = [123, 'xyz', 'zara', 'abc']
aList[0] = 2014
print aList
>>[2014, 'xyz', 'zara', 'abc']

Placeholder Mixin SCSS/CSS

I use exactly the same sass mixin placeholder as NoDirection wrote. I find it in sass mixins collection here and I'm very satisfied with it. There's a text that explains a mixins option more.

Change Active Menu Item on Page Scroll?

If you want the accepted answer to work in JQuery 3 change the code like this:

var scrollItems = menuItems.map(function () {
    var id = $(this).attr("href");
    try {
        var item = $(id);
      if (item.length) {
        return item;
      }
    } catch {}
  });

I also added a try-catch to prevent javascript from crashing if there is no element by that id. Feel free to improve it even more ;)

Dynamically Add C# Properties at Runtime

Have you taken a look at ExpandoObject?

see: http://blogs.msdn.com/b/csharpfaq/archive/2009/10/01/dynamic-in-c-4-0-introducing-the-expandoobject.aspx

From MSDN:

The ExpandoObject class enables you to add and delete members of its instances at run time and also to set and get values of these members. This class supports dynamic binding, which enables you to use standard syntax like sampleObject.sampleMember instead of more complex syntax like sampleObject.GetAttribute("sampleMember").

Allowing you to do cool things like:

dynamic dynObject = new ExpandoObject();
dynObject.SomeDynamicProperty = "Hello!";
dynObject.SomeDynamicAction = (msg) =>
    {
        Console.WriteLine(msg);
    };

dynObject.SomeDynamicAction(dynObject.SomeDynamicProperty);

Based on your actual code you may be more interested in:

public static dynamic GetDynamicObject(Dictionary<string, object> properties)
{
    return new MyDynObject(properties);
}

public sealed class MyDynObject : DynamicObject
{
    private readonly Dictionary<string, object> _properties;

    public MyDynObject(Dictionary<string, object> properties)
    {
        _properties = properties;
    }

    public override IEnumerable<string> GetDynamicMemberNames()
    {
        return _properties.Keys;
    }

    public override bool TryGetMember(GetMemberBinder binder, out object result)
    {
        if (_properties.ContainsKey(binder.Name))
        {
            result = _properties[binder.Name];
            return true;
        }
        else
        {
            result = null;
            return false;
        }
    }

    public override bool TrySetMember(SetMemberBinder binder, object value)
    {
        if (_properties.ContainsKey(binder.Name))
        {
            _properties[binder.Name] = value;
            return true;
        }
        else
        {
            return false;
        }
    }
}

That way you just need:

var dyn = GetDynamicObject(new Dictionary<string, object>()
    {
        {"prop1", 12},
    });

Console.WriteLine(dyn.prop1);
dyn.prop1 = 150;

Deriving from DynamicObject allows you to come up with your own strategy for handling these dynamic member requests, beware there be monsters here: the compiler will not be able to verify a lot of your dynamic calls and you won't get intellisense, so just keep that in mind.

How do I create a custom Error in JavaScript?

I just had to implement something like this and found that the stack was lost in my own error implementation. What I had to do was create a dummy error and retrieve the stack from that:

My.Error = function (message, innerException) {
    var err = new Error();
    this.stack = err.stack; // IMPORTANT!
    this.name = "Error";
    this.message = message;
    this.innerException = innerException;
}
My.Error.prototype = new Error();
My.Error.prototype.constructor = My.Error;
My.Error.prototype.toString = function (includeStackTrace) {
    var msg = this.message;
    var e = this.innerException;
    while (e) {
        msg += " The details are:\n" + e.message;
        e = e.innerException;
    }
    if (includeStackTrace) {
        msg += "\n\nStack Trace:\n\n" + this.stack;
    }
    return msg;
}

How to set focus on a view when a layout is created and displayed?

You can start by adding android:windowSoftInputMode to your activity in AndroidManifest.xml file.

<activity android:name="YourActivity"
          android:windowSoftInputMode="stateHidden" />

This will make the keyboard to not show, but EditText is still got focus. To solve that, you can set android:focusableInTouchmode and android:focusable to true on your root view.

<LinearLayout android:orientation="vertical"
              android:focusable="true"
              android:focusableInTouchMode="true"
              ...
              >
    <EditText
         ...
       />
    <TextView
         ...
       />
    <Button
         ...
       />
</LinearLayout>

The code above will make sure that RelativeLayout is getting focus instead of EditText

EF Migrations: Rollback last applied migration?

I'm using EntityFrameworkCore and I use the answer by @MaciejLisCK. If you have multiple DB contexts you will also need to specify the context by adding the context parameter e.g. :

Update-Database 201207211340509_MyMigration -context myDBcontext

(where 201207211340509_MyMigration is the migration you want to roll back to, and myDBcontext is the name of your DB context)

Can I make a <button> not submit a form?

The default value for the type attribute of button elements is "submit". Set it to type="button" to produce a button that doesn't submit the form.

<button type="button">Submit</button>

In the words of the HTML Standard: "Does nothing."

MySql sum elements of a column

Try this:

select sum(a), sum(b), sum(c)
from your_table

Launching a website via windows commandline

Using a CLI, the easiest way (cross-platform) I've found is to use the NPM package https://github.com/sindresorhus/open-cli

npm install --global open-cli

Installing it globally allows running something like open-cli https://unlyed.github.io/next-right-now/.

You can also install it locally (e.g: in a project) and run npx open-cli https://unlyed.github.io/next-right-now/

Or, using a NPM script (which is how I actually use it): "doc:online": "open-cli https://unlyed.github.io/next-right-now/",

Running yarn doc:online will open the webpage, and this works on any platform (windows, mac, linux).

css label width not taking effect

Use display: inline-block;

Explanation:

The label is an inline element, meaning it is only as big as it needs to be.

Set the display property to either inline-block or block in order for the width property to take effect.

Example:

_x000D_
_x000D_
#report-upload-form {_x000D_
    background-color: #316091;_x000D_
    color: #ddeff1;_x000D_
    font-weight: bold;_x000D_
    margin: 23px auto 0 auto;_x000D_
    border-radius: 10px;_x000D_
    width: 650px;_x000D_
    box-shadow: 0 0 2px 2px #d9d9d9;_x000D_
_x000D_
}_x000D_
_x000D_
#report-upload-form label {_x000D_
    padding-left: 26px;_x000D_
    width: 125px;_x000D_
    text-transform: uppercase;_x000D_
    display: inline-block;_x000D_
}_x000D_
_x000D_
#report-upload-form input[type=text], _x000D_
#report-upload-form input[type=file],_x000D_
#report-upload-form textarea {_x000D_
    width: 305px;_x000D_
}
_x000D_
<form id="report-upload-form" method="POST" action="" enctype="multipart/form-data">_x000D_
    <p><label for="id_title">Title:</label> <input id="id_title" type="text" class="input-text" name="title"></p>_x000D_
    <p><label for="id_description">Description:</label> <textarea id="id_description" rows="10" cols="40" name="description"></textarea></p>_x000D_
    <p><label for="id_report">Upload Report:</label> <input id="id_report" type="file" class="input-file" name="report"></p>_x000D_
</form>
_x000D_
_x000D_
_x000D_

Why plt.imshow() doesn't display the image?

If you want to print the picture using imshow() you also execute plt.show()

How to generate entire DDL of an Oracle schema (scriptable)?

The get_ddl procedure for a PACKAGE will return both spec AND body, so it will be better to change the query on the all_objects so the package bodies are not returned on the select.

So far I changed the query to this:

SELECT DBMS_METADATA.GET_DDL(REPLACE(object_type, ' ', '_'), object_name, owner)
FROM all_OBJECTS
WHERE (OWNER = 'OWNER1')
and object_type not like '%PARTITION'
and object_type not like '%BODY'
order by object_type, object_name;

Although other changes might be needed depending on the object types you are getting...

Mail multipart/alternative vs multipart/mixed

Messages have content. Content can be text, html, a DataHandler or a Multipart, and there can only be one content. Multiparts only have BodyParts but can have more than one. BodyParts, like Messages, can have content which has already been described.

A message with HTML, text and an a attachment can be viewed hierarchically like this:

message
  mainMultipart (content for message, subType="mixed")
    ->htmlAndTextBodyPart (bodyPart1 for mainMultipart)
      ->htmlAndTextMultipart (content for htmlAndTextBodyPart, subType="alternative")
        ->textBodyPart (bodyPart2 for the htmlAndTextMultipart)
          ->text (content for textBodyPart)
        ->htmlBodyPart (bodyPart1 for htmlAndTextMultipart)
          ->html (content for htmlBodyPart)
    ->fileBodyPart1 (bodyPart2 for the mainMultipart)
      ->FileDataHandler (content for fileBodyPart1 )

And the code to build such a message:

    // the parent or main part if you will
    Multipart mainMultipart = new MimeMultipart("mixed");

    // this will hold text and html and tells the client there are 2 versions of the message (html and text). presumably text
    // being the alternative to html
    Multipart htmlAndTextMultipart = new MimeMultipart("alternative");

    // set text
    MimeBodyPart textBodyPart = new MimeBodyPart();
    textBodyPart.setText(text);
    htmlAndTextMultipart.addBodyPart(textBodyPart);

    // set html (set this last per rfc1341 which states last = best)
    MimeBodyPart htmlBodyPart = new MimeBodyPart();
    htmlBodyPart.setContent(html, "text/html; charset=utf-8");
    htmlAndTextMultipart.addBodyPart(htmlBodyPart);

    // stuff the multipart into a bodypart and add the bodyPart to the mainMultipart
    MimeBodyPart htmlAndTextBodyPart = new MimeBodyPart();
    htmlAndTextBodyPart.setContent(htmlAndTextMultipart);
    mainMultipart.addBodyPart(htmlAndTextBodyPart);

    // attach file body parts directly to the mainMultipart
    MimeBodyPart filePart = new MimeBodyPart();
    FileDataSource fds = new FileDataSource("/path/to/some/file.txt");
    filePart.setDataHandler(new DataHandler(fds));
    filePart.setFileName(fds.getName());
    mainMultipart.addBodyPart(filePart);

    // set message content
    message.setContent(mainMultipart);

References with text in LaTeX

Have a look to this wiki: LaTeX/Labels and Cross-referencing:

The hyperref package automatically includes the nameref package, and a similarly named command. It inserts text corresponding to the section name, for example:

\section{MyFirstSection}
\label{marker}
\section{MySecondSection} In section \nameref{marker} we defined...

Where do I find old versions of Android NDK?

Looks like simply putting the link like this

http://dl.google.com/android/ndk/android-ndk-r7c-windows.zip

on the address bar of your browser

The revision names (r7c, r8c etc.) could be found from the ndk download page

How do I programmatically force an onchange event on an input?

For triggering any event in Javascript.

 document.getElementById("yourid").addEventListener("change", function({
    //your code here
})

A Java collection of value pairs? (tuples?)

What about "Apache Commons Lang 3" Pair class and the relative subclasses ?

    import org.apache.commons.lang3.tuple.ImmutablePair;
    import org.apache.commons.lang3.tuple.Pair;
    ...
    @SuppressWarnings("unchecked")
    Pair<String, Integer>[] arr = new ImmutablePair[]{
            ImmutablePair.of("A", 1),
            ImmutablePair.of("B", 2)};

    // both access the 'left' part
    String key = arr[0].getKey();
    String left = arr[0].getLeft();

    // both access the 'right' part
    Integer value = arr[0].getValue();
    Integer right = arr[0].getRight();

ImmutablePair is a specific subclass that does not allow the values in the pair to be modified, but there are others implementations with different semantic. These are the Maven coordinates, if you need them.

        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-lang3</artifactId>
            <version>3.4</version>
        </dependency>

PUT vs. POST in REST

At the risk of restating what has already been said, it seems important to remember that PUT implies that the client controls what the URL is going to end up being, when creating a resource. So part of the choice between PUT and POST is going to be about how much you can trust the client to provide correct, normalized URL that are coherent with whatever your URL scheme is.

When you can't fully trust the client to do the right thing, it would be more appropriate to use POST to create a new item and then send the URL back to the client in the response.

Counting in a FOR loop using Windows Batch script

It's not working because the entire for loop (from the for to the final closing parenthesis, including the commands between those) is being evaluated when it's encountered, before it begins executing.

In other words, %count% is replaced with its value 1 before running the loop.

What you need is something like:

setlocal enableextensions enabledelayedexpansion
set /a count = 1
for /f "tokens=*" %%a in (config.properties) do (
  set /a count += 1
  echo !count!
)
endlocal

Delayed expansion using ! instead of % will give you the expected behaviour. See also here.


Also keep in mind that setlocal/endlocal actually limit scope of things changed inside so that they don't leak out. If you want to use count after the endlocal, you have to use a "trick" made possible by the very problem you're having:

endlocal && set count=%count%

Let's say count has become 7 within the inner scope. Because the entire command is interpreted before execution, it effectively becomes:

endlocal && set count=7

Then, when it's executed, the inner scope is closed off, returning count to it's original value. But, since the setting of count to seven happens in the outer scope, it's effectively leaking the information you need.

You can string together multiple sub-commands to leak as much information as you need:

endlocal && set count=%count% && set something_else=%something_else%

Windows batch - concatenate multiple text files into one

cat "input files" > "output files"

This works in PowerShell, which is the Windows preferred shell in current Windows versions, therefore it works. It is also the only version of the answers above to work with large files, where 'type' or 'copy' fails.

Why does "pip install" inside Python raise a SyntaxError?

you need to type it in cmd not in the IDLE. becuse IDLE is not an command prompt if you want to install something from IDLE type this

>>>from pip.__main__ import _main as main
>>>main(#args splitted by space in list example:['install', 'requests'])

this is calling pip like pip <commands> in terminal. The commands will be seperated by spaces that you are doing there to.

Force browser to refresh css, javascript, etc

Developer point of view
If you are in development mode (like in the original question), the best approach is to disable caching in the browser via HTML meta tags. To make this approach universal you must insert at least three meta tags as shown below.

<meta http-equiv="Cache-Control" content="no-cache, no-store, must-revalidate" />
<meta http-equiv="Pragma" content="no-cache" />
<meta http-equiv="Expires" content="0" />

In this way, you as a developer, only need to refresh the page to see the changes. But do not forget to comment that code when in production, after all caching is a good thing for your clients.

Production Mode
Because in production you will allow caching and your clients do not need to know how to force a full reload or any other trick, you must warranty the browser will load the new file. And yes, in this case, the best approach I know is to change the name of the file.

Javascript dynamic array of strings

You can go with inserting data push, this is going to be doing in order

var arr = Array();
function arrAdd(value){
    arr.push(value);
}

OnItemCLickListener not working in listview

All of the above failed for me. However, I was able to resolve the problem (after many hours of banging my head - Google, if you're listening, please consider fixing what I encountered below in the form of compiler errors, if possible)

You really have to be careful of what android attributes you add to your xml layout here (in this original question, it is called list_items.xml). For me, what was causing the problem was that I had switched from an EditText view to a TextView and had leftover attribute cruft from the change (in my case, inputType). The compiler didn't catch it and the clickability just failed when I went to run the app. Double check all of the attributes you have in your layout xml nodes.

Dump a mysql database to a plaintext (CSV) backup from the command line

If you can cope with table-at-a-time, and your data is not binary, use the -B option to the mysql command. With this option it'll generate TSV (tab separated) files which can import into Excel, etc, quite easily:

% echo 'SELECT * FROM table' | mysql -B -uxxx -pyyy database

Alternatively, if you've got direct access to the server's file system, use SELECT INTO OUTFILE which can generate real CSV files:

SELECT * INTO OUTFILE 'table.csv'
    FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
    LINES TERMINATED BY '\n'
FROM table

How to disable submit button once it has been clicked?

Another solution i´ve used is to move the button instead of disabling it. In that case you don´t have those "disable" problems. Finally what you really want is people not to press twice, if the button is not there they can´t do it.

You may also replace it with another button.

Equals(=) vs. LIKE

If you search for an exact match, you can use both, = and LIKE.

Using "=" is a tiny bit faster in this case (searching for an exact match) - you can check this yourself by having the same query twice in SQL Server Management Studio, once using "=", once using "LIKE", and then using the "Query" / "Include actual execution plan".

Execute the two queries and you should see your results twice, plus the two actual execution plans. In my case, they were split 50% vs. 50%, but the "=" execution plan has a smaller "estimated subtree cost" (displayed when you hover over the left-most "SELECT" box) - but again, it's really not a huge difference.

But when you start searching with wildcards in your LIKE expression, search performance will dimish. Search "LIKE Mill%" can still be quite fast - SQL Server can use an index on that column, if there is one. Searching "LIKE %expression%" is horribly slow, since the only way SQL Server can satisfy this search is by doing a full table scan. So be careful with your LIKE's !

Marc

How do I use WebRequest to access an SSL encrypted site using https?

This one worked for me:

ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;

react-router scroll to top on every transition

This was my approach based on what everyone else had done in previous posts. Wondering if this would be a good approach in 2020 using location as a dependency to prevent re-renders?

import React, { useEffect } from 'react';
import { useLocation } from 'react-router-dom';

function ScrollToTop( { children } ) {
    let location = useLocation();

    useEffect( () => {
        window.scrollTo(0, 0);
    }, [ location ] );

    return children
}

Set angular scope variable in markup

$scope.$watch('myVar', function (newValue, oldValue) {
        if (typeof (newValue) !== 'undefined') {
            $scope.someothervar= newValue;
//or get some data
            getData();
        }


    }, true);

Variable initializes after controller so you need to watch over it and when it't initialized the use it.

javascript /jQuery - For Loop

Use a regular for loop and format the index to be used in the selector.

var array = [];
for (var i = 0; i < 4; i++) {
    var selector = '' + i;
    if (selector.length == 1)
        selector = '0' + selector;
    selector = '#event' + selector;
    array.push($(selector, response).html());
}

Array initializing in Scala

To initialize an array filled with zeros, you can use:

> Array.fill[Byte](5)(0)
Array(0, 0, 0, 0, 0)

This is equivalent to Java's new byte[5].

Getting file names without extensions

You can use Path.GetFileNameWithoutExtension:

foreach (FileInfo fi in smFiles)
{
    builder.Append(Path.GetFileNameWithoutExtension(fi.Name));
    builder.Append(", ");
}

Although I am surprised there isn't a way to get this directly from the FileInfo (or at least I can't see it).

Deserializing JSON array into strongly typed .NET object

I suspect the problem is because the json represents an object with the list of users as a property. Try deserializing to something like:

public class UsersResponse
{
    public List<User> Data { get; set; }
}

BeautifulSoup getting href

You can use find_all in the following way to find every a element that has an href attribute, and print each one:

from BeautifulSoup import BeautifulSoup

html = '''<a href="some_url">next</a>
<span class="class"><a href="another_url">later</a></span>'''

soup = BeautifulSoup(html)

for a in soup.find_all('a', href=True):
    print "Found the URL:", a['href']

The output would be:

Found the URL: some_url
Found the URL: another_url

Note that if you're using an older version of BeautifulSoup (before version 4) the name of this method is findAll. In version 4, BeautifulSoup's method names were changed to be PEP 8 compliant, so you should use find_all instead.


If you want all tags with an href, you can omit the name parameter:

href_tags = soup.find_all(href=True)

How can labels/legends be added for all chart types in chart.js (chartjs.org)?

You can include a legend template in the chart options:

//legendTemplate takes a template as a string, you can populate the template with values from your dataset 
var options = {
  legendTemplate : '<ul>'
                  +'<% for (var i=0; i<datasets.length; i++) { %>'
                    +'<li>'
                    +'<span style=\"background-color:<%=datasets[i].lineColor%>\"></span>'
                    +'<% if (datasets[i].label) { %><%= datasets[i].label %><% } %>'
                  +'</li>'
                +'<% } %>'
              +'</ul>'
  }

  //don't forget to pass options in when creating new Chart
  var lineChart = new Chart(element).Line(data, options);

  //then you just need to generate the legend
  var legend = lineChart.generateLegend();

  //and append it to your page somewhere
  $('#chart').append(legend);

You'll also need to add some basic css to get it looking ok.

Custom "confirm" dialog in JavaScript?

I managed to find the solution that will allow you to do this using default confirm() with minimum of changes if you have a lot of confirm() actions through out you code. This example uses jQuery and Bootstrap but the same thing can be accomplished using other libraries as well. You can just copy paste this and it should work right away

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>Project Title</title>
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">

    <link href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>

    <!--[if lt IE 9]>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/html5shiv/3.7.3/html5shiv.min.js"></script>
        <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
</head>
<body>
<div class="container">
    <h1>Custom Confirm</h1>
    <button id="action"> Action </button> 
    <button class='another-one'> Another </button>
</div>
<script src="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.6/js/bootstrap.min.js"></script>

<script type="text/javascript">

    document.body.innerHTML += `<div class="modal fade"  style="top:20vh" id="customDialog" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
    <div class="modal-dialog" role="document">
    <div class="modal-content">
    <div class="modal-header">
    <h5 class="modal-title" id="exampleModalLabel">Modal title</h5>
    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
    <span aria-hidden="true">&times;</span>
    </button>
    </div>
    <div class="modal-body">

    </div>
    <div class="modal-footer">
    <button type="button" id='dialog-cancel' class="btn btn-secondary">Cancel</button>
    <button type="button" id='dialog-ok' class="btn btn-primary">Ok</button>
    </div>
    </div>
    </div>
    </div>`;

    function showModal(text) {

        $('#customDialog .modal-body').html(text);
        $('#customDialog').modal('show');

    }

    function startInterval(element) {

         interval = setInterval(function(){

           if ( window.isConfirmed != null ) {

              window.confirm = function() {

                  return window.isConfirmed;
              }

              elConfrimInit.trigger('click');

              clearInterval(interval);
              window.isConfirmed = null;
              window.confirm = function(text) {
                showModal(text);
                startInterval();
            }

           }

        }, 500);

    }

    window.isConfirmed = null;
    window.confirm = function(text,elem = null) {
        elConfrimInit = elem;
        showModal(text);
        startInterval();
    }

    $(document).on('click','#dialog-ok', function(){

        isConfirmed = true;
        $('#customDialog').modal('hide');

    });

    $(document).on('click','#dialog-cancel', function(){

        isConfirmed = false;
        $('#customDialog').modal('hide');

   });

   $('#action').on('click', function(e) {

 

        if ( confirm('Are you sure?',$(this)) ) {

            alert('confrmed');
        }
        else {
            alert('not confimed');
        }
    });

    $('.another-one').on('click', function(e) {


        if ( confirm('Are really, really, really sure ? you sure?',$(this)) ) {

            alert('confirmed');
        }
        else {
            alert('not confimed');
        }
    });


</script>
</body>
</html>

This is the whole example. After you implement it you will be able to use it like this:

if ( confirm('Are you sure?',$(this)) )

How can I disable notices and warnings in PHP within the .htaccess file?

Fortes is right, thank you.

When you have a shared hosting it is usual to obtain an 500 server error.

I have a website with Joomla and I added to the index.php:

ini_set('display_errors','off');

The error line showed in my website disappeared.

How can I switch to another branch in git?

With Git 2.23 onwards, one can use git switch <branch name> to switch branches.

jquery animate .css

If you are needing to use CSS with the jQuery .animate() function, you can use set the duration.

$("#my_image").css({
    'left':'1000px',
    6000, ''
});

We have the duration property set to 6000.

This will set the time in thousandth of seconds: 6 seconds.

After the duration our next property "easing" changes how our CSS happens.

We have our positioning set to absolute.

There are two default ones to the absolute function: 'linear' and 'swing'.

In this example I am using linear.

It allows for it to use a even pace.

The other 'swing' allows for a exponential speed increase.

There are a bunch of really cool properties to use with animate like bounce, etc.

$(document).ready(function(){
    $("#my_image").css({
        'height': '100px',
        'width':'100px',
        'background-color':'#0000EE',
        'position':'absolute'
    });// property than value

    $("#my_image").animate({
        'left':'1000px'
    },6000, 'linear', function(){
        alert("Done Animating");
    });
});

How to get child element by class name?

You can fetch the parent class by adding the line below. If you had an id, it would be easier with getElementById. Nonetheless,

var parentNode = document.getElementsByClassName("progress__container")[0];

Then you can use querySelectorAll on the parent <div> to fetch all matching divs with class .progress__marker

var progressNodes = progressContainer.querySelectorAll('.progress__marker');

querySelectorAll will fetch every div with the class of progress__marker

Position of a string within a string using Linux shell script?

I used awk for this

a="The cat sat on the mat"
test="cat"
awk -v a="$a" -v b="$test" 'BEGIN{print index(a,b)}'

How to show Alert Message like "successfully Inserted" after inserting to DB using ASp.net MVC3

Try using TempData:

public ActionResult Create(FormCollection collection) {
  ...
  TempData["notice"] = "Successfully registered";
  return RedirectToAction("Index");
  ...
}

Then, in your Index view, or master page, etc., you can do this:

<% if (TempData["notice"] != null) { %>
  <p><%= Html.Encode(TempData["notice"]) %></p>
<% } %>

Or, in a Razor view:

@if (TempData["notice"] != null) {
  <p>@TempData["notice"]</p>
}

Quote from MSDN (page no longer exists as of 2014, archived copy here):

An action method can store data in the controller's TempDataDictionary object before it calls the controller's RedirectToAction method to invoke the next action. The TempData property value is stored in session state. Any action method that is called after the TempDataDictionary value is set can get values from the object and then process or display them. The value of TempData persists until it is read or until the session times out. Persisting TempData in this way enables scenarios such as redirection, because the values in TempData are available beyond a single request.

How do I handle a click anywhere in the page, even when a certain element stops the propagation?

I think this is what you need:

$("body").trigger("click");

This will allow you to trigger the body click event from anywhere.

PHP: If internet explorer 6, 7, 8 , or 9

Notice the case in 'Trident':

if (isset($_SERVER['HTTP_USER_AGENT']) &&
    ((strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE') !== false) || strpos($_SERVER['HTTP_USER_AGENT'], 'Trident') !== false)) {   
     // IE is here :-(
    }

Get age from Birthdate

Try this function...

function calculate_age(birth_month,birth_day,birth_year)
{
    today_date = new Date();
    today_year = today_date.getFullYear();
    today_month = today_date.getMonth();
    today_day = today_date.getDate();
    age = today_year - birth_year;

    if ( today_month < (birth_month - 1))
    {
        age--;
    }
    if (((birth_month - 1) == today_month) && (today_day < birth_day))
    {
        age--;
    }
    return age;
}

OR

function getAge(dateString) 
{
    var today = new Date();
    var birthDate = new Date(dateString);
    var age = today.getFullYear() - birthDate.getFullYear();
    var m = today.getMonth() - birthDate.getMonth();
    if (m < 0 || (m === 0 && today.getDate() < birthDate.getDate())) 
    {
        age--;
    }
    return age;
}

See Demo.

imagecreatefromjpeg and similar functions are not working in PHP

You must enable the library GD2.

Find your (proper) php.ini file

Find the line: ;extension=php_gd2.dll and remove the semicolon in the front.

The line should look like this:

extension=php_gd2.dll

Then restart apache and you should be good to go.

How does the keyword "use" work in PHP and can I import classes with it?

No, you can not import a class with the use keyword. You have to use include/require statement. Even if you use a PHP auto loader, still autoloader will have to use either include or require internally.

The Purpose of use keyword:

Consider a case where you have two classes with the same name; you'll find it strange, but when you are working with a big MVC structure, it happens. So if you have two classes with the same name, put them in different namespaces. Now consider when your auto loader is loading both classes (does by require), and you are about to use object of class. In this case, the compiler will get confused which class object to load among two. To help the compiler make a decision, you can use the use statement so that it can make a decision which one is going to be used on.

Nowadays major frameworks do use include or require via composer and psr

1) composer

2) PSR-4 autoloader

Going through them may help you further. You can also use an alias to address an exact class. Suppose you've got two classes with the same name, say Mailer with two different namespaces:

namespace SMTP;
class Mailer{}

and

namespace Mailgun;
class Mailer{}

And if you want to use both Mailer classes at the same time then you can use an alias.

use SMTP\Mailer as SMTPMailer;
use Mailgun\Mailer as MailgunMailer;

Later in your code if you want to access those class objects then you can do the following:

$smtp_mailer = new SMTPMailer;
$mailgun_mailer = new MailgunMailer;

It will reference the original class.

Some may get confused that then of there are not Similar class names then there is no use of use keyword. Well, you can use __autoload($class) function which will be called automatically when use statement gets executed with the class to be used as an argument and this can help you to load the class at run-time on the fly as and when needed.

Refer this answer to know more about class autoloader.

Try-Catch-End Try in VBScript doesn't seem to work

Handling Errors

A sort of an "older style" of error handling is available to us in VBScript, that does make use of On Error Resume Next. First we enable that (often at the top of a file; but you may use it in place of the first Err.Clear below for their combined effect), then before running our possibly-error-generating code, clear any errors that have already occurred, run the possibly-error-generating code, and then explicitly check for errors:

On Error Resume Next
' ...
' Other Code Here (that may have raised an Error)
' ...
Err.Clear      ' Clear any possible Error that previous code raised
Set myObj = CreateObject("SomeKindOfClassThatDoesNotExist")
If Err.Number <> 0 Then
    WScript.Echo "Error: " & Err.Number
    WScript.Echo "Error (Hex): " & Hex(Err.Number)
    WScript.Echo "Source: " &  Err.Source
    WScript.Echo "Description: " &  Err.Description
    Err.Clear             ' Clear the Error
End If
On Error Goto 0           ' Don't resume on Error
WScript.Echo "This text will always print."

Above, we're just printing out the error if it occurred. If the error was fatal to the script, you could replace the second Err.clear with WScript.Quit(Err.Number).

Also note the On Error Goto 0 which turns off resuming execution at the next statement when an error occurs.

If you want to test behavior for when the Set succeeds, go ahead and comment that line out, or create an object that will succeed, such as vbscript.regexp.

The On Error directive only affects the current running scope (current Sub or Function) and does not affect calling or called scopes.


Raising Errors

If you want to check some sort of state and then raise an error to be handled by code that calls your function, you would use Err.Raise. Err.Raise takes up to five arguments, Number, Source, Description, HelpFile, and HelpContext. Using help files and contexts is beyond the scope of this text. Number is an error number you choose, Source is the name of your application/class/object/property that is raising the error, and Description is a short description of the error that occurred.

If MyValue <> 42 Then
    Err.Raise(42, "HitchhikerMatrix", "There is no spoon!")
End If

You could then handle the raised error as discussed above.


Change Log

  • Edit #1: Added an Err.Clear before the possibly error causing line to clear any previous errors that may have been ignored.
  • Edit #2: Clarified.
  • Edit #3: Added comments in code block. Clarified that there was expected to be more code between On Error Resume Next and Err.Clear. Fixed some grammar to be less awkward. Added info on Err.Raise. Formatting.
  • Bootstrap button drop-down inside responsive table not visible because of scroll

    Well, reading the top answer, i saw that it really dont works when you are seeing the scroll bar and the toggle button was on last column (in my case) or other column that is unseen

    pic-error

    But, if you change 'inherit' for 'hidden' it will work.

    $('.table-responsive').on('show.bs.dropdown', function () {
        $('.table-responsive').css( "overflow", "hidden" );
    }).on('hide.bs.dropdown', function () {
        $('.table-responsive').css( "overflow", "auto" );
    })
    

    enter image description here

    Try to do that way.

    Printing the correct number of decimal points with cout

    #include<stdio.h>
    int main()
    
    {
    
     double d=15.6464545347;
    
    printf("%0.2lf",d);
    
    }
    

    How to remove all characters after a specific character in python?

    From a file:

    import re
    sep = '...'
    
    with open("requirements.txt") as file_in:
        lines = []
        for line in file_in:
            res = line.split(sep, 1)[0]
            print(res)
    

    Add Foreign Key to existing table

    Simple Steps...

    ALTER TABLE t_name1 ADD FOREIGN KEY (column_name) REFERENCES t_name2(column_name)
    

    How to make <input type="date"> supported on all browsers? Any alternatives?

    You asked for Modernizr example, so here you go. This code uses Modernizr to detect whether the 'date' input type is supported. If it isn't supported, then it fails back to JQueryUI datepicker.

    Note: You will need to download JQueryUI and possibly change the paths to the CSS and JS files in your own code.

    <!DOCTYPE html>
    <html>
        <head>
            <title>Modernizer Detect 'date' input type</title>
            <link rel="stylesheet" type="text/css" href="jquery-ui-1.10.3/themes/base/jquery.ui.all.css"/>
            <script type="text/javascript" src="http://ajax.aspnetcdn.com/ajax/modernizr/modernizr-1.7-development-only.js"></script>
            <script type="text/javascript" src="http://code.jquery.com/jquery-1.10.2.min.js"></script>
            <script type="text/javascript" src="jquery-ui-1.10.3/ui/jquery.ui.core.js"></script>
            <script type="text/javascript" src="jquery-ui-1.10.3/ui/jquery.ui.widget.js"></script>
            <script type="text/javascript" src="jquery-ui-1.10.3/ui/jquery.ui.datepicker.js"></script>
            <script type="text/javascript">
                $(function(){
                    if(!Modernizr.inputtypes.date) {
                        console.log("The 'date' input type is not supported, so using JQueryUI datepicker instead.");
                        $("#theDate").datepicker();
                    }
                });
            </script>
        </head>
        <body>
            <form>
                <input id="theDate" type="date"/>
            </form>
        </body>
    </html>
    

    I hope this works for you.

    What is the difference between parseInt() and Number()?

    Well, they are semantically different, the Number constructor called as a function performs type conversion and parseInt performs parsing, e.g.:

    // parsing:
    parseInt("20px");       // 20
    parseInt("10100", 2);   // 20
    parseInt("2e1");        // 2
    
    // type conversion
    Number("20px");       // NaN
    Number("2e1");        // 20, exponential notation
    

    Also parseInt will ignore trailing characters that don't correspond with any digit of the currently used base.

    The Number constructor doesn't detect implicit octals, but can detect the explicit octal notation:

    Number("010");         // 10
    Number("0o10")         // 8, explicit octal
    
    parseInt("010");       // 8, implicit octal
    parseInt("010", 10);   // 10, decimal radix used
    

    And it can handle numbers in hexadecimal notation, just like parseInt:

    Number("0xF");   // 15
    parseInt("0xF"); //15
    

    In addition, a widely used construct to perform Numeric type conversion, is the Unary + Operator (p. 72), it is equivalent to using the Number constructor as a function:

    +"2e1";   // 20
    +"0xF";   // 15
    +"010";   // 10
    

    Vertically aligning text next to a radio button

    HTML:

    <label><input type="radio" id="opt1" name="opt1" value="1"> A label</label>
    

    CSS:

    label input[type="radio"] { vertical-align: text-bottom; }
    

    <meta charset="utf-8"> vs <meta http-equiv="Content-Type">

    I would recommend doing it like this to keep things in line with HTML5.

    <meta charset="UTF-8">
    

    EG:

    <!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>Document</title>
    </head>
    <body>
    </body>
    </html>
    

    Center a position:fixed element

    I want to make a popup box centered to the screen with dynamic width and height.

    Here is a modern approach for horizontally centering an element with a dynamic width - it works in all modern browsers; support can be seen here.

    Updated Example

    .jqbox_innerhtml {
        position: fixed;
        left: 50%;
        transform: translateX(-50%);
    }
    

    For both vertical and horizontal centering you could use the following:

    Updated Example

    .jqbox_innerhtml {
        position: fixed;
        left: 50%;
        top: 50%;
        transform: translate(-50%, -50%);
    }
    

    You may wish to add in more vendor prefixed properties too (see the examples).

    Variable used in lambda expression should be final or effectively final

    Java 8 has a new concept called “Effectively final” variable. It means that a non-final local variable whose value never changes after initialization is called “Effectively Final”.

    This concept was introduced because prior to Java 8, we could not use a non-final local variable in an anonymous class. If you wanna have access to a local variable in anonymous class, you have to make it final.

    When lambda was introduced, this restriction was eased. Hence to the need to make local variable final if it’s not changed once it is initialized as lambda in itself is nothing but an anonymous class.

    Java 8 realized the pain of declaring local variable final every time a developer used lambda, introduced this concept, and made it unnecessary to make local variables final. So if you see the rule for anonymous classes has not changed, it’s just you don’t have to write the final keyword every time when using lambdas.

    I found a good explanation here

    How to implement a property in an interface

    You should use abstract class to initialize a property. You can't inititalize in Inteface .

    How do I replace multiple spaces with a single space in C#?

    I like to use:

    myString = Regex.Replace(myString, @"\s+", " ");
    

    Since it will catch runs of any kind of whitespace (e.g. tabs, newlines, etc.) and replace them with a single space.

    How to change the playing speed of videos in HTML5?

    javascript:document.getElementsByClassName("video-stream html5-main-video")[0].playbackRate = 0.1;
    

    you can put any number here just don't go to far so you don't overun your computer.

    Angular 2 - Checking for server errors from subscribe

    As stated in the relevant RxJS documentation, the .subscribe() method can take a third argument that is called on completion if there are no errors.

    For reference:

    1. [onNext] (Function): Function to invoke for each element in the observable sequence.
    2. [onError] (Function): Function to invoke upon exceptional termination of the observable sequence.
    3. [onCompleted] (Function): Function to invoke upon graceful termination of the observable sequence.

    Therefore you can handle your routing logic in the onCompleted callback since it will be called upon graceful termination (which implies that there won't be any errors when it is called).

    this.httpService.makeRequest()
        .subscribe(
          result => {
            // Handle result
            console.log(result)
          },
          error => {
            this.errors = error;
          },
          () => {
            // 'onCompleted' callback.
            // No errors, route to new page here
          }
        );
    

    As a side note, there is also a .finally() method which is called on completion regardless of the success/failure of the call. This may be helpful in scenarios where you always want to execute certain logic after an HTTP request regardless of the result (i.e., for logging purposes or for some UI interaction such as showing a modal).

    Rx.Observable.prototype.finally(action)

    Invokes a specified action after the source observable sequence terminates gracefully or exceptionally.

    For instance, here is a basic example:

    import { Observable } from 'rxjs/Rx';
    import 'rxjs/add/operator/finally';
    
    // ...
    
    this.httpService.getRequest()
        .finally(() => {
          // Execute after graceful or exceptionally termination
          console.log('Handle logging logic...');
        })
        .subscribe (
          result => {
            // Handle result
            console.log(result)
          },
          error => {
            this.errors = error;
          },
          () => {
            // No errors, route to new page
          }
        );
    

    When to use EntityManager.find() vs EntityManager.getReference() with JPA

    I usually use getReference method when i do not need to access database state (I mean getter method). Just to change state (I mean setter method). As you should know, getReference returns a proxy object which uses a powerful feature called automatic dirty checking. Suppose the following

    public class Person {
    
        private String name;
        private Integer age;
    
    }
    
    
    public class PersonServiceImpl implements PersonService {
    
        public void changeAge(Integer personId, Integer newAge) {
            Person person = em.getReference(Person.class, personId);
    
            // person is a proxy
            person.setAge(newAge);
        }
    
    }
    

    If i call find method, JPA provider, behind the scenes, will call

    SELECT NAME, AGE FROM PERSON WHERE PERSON_ID = ?
    
    UPDATE PERSON SET AGE = ? WHERE PERSON_ID = ?
    

    If i call getReference method, JPA provider, behind the scenes, will call

    UPDATE PERSON SET AGE = ? WHERE PERSON_ID = ?
    

    And you know why ???

    When you call getReference, you will get a proxy object. Something like this one (JPA provider takes care of implementing this proxy)

    public class PersonProxy {
    
        // JPA provider sets up this field when you call getReference
        private Integer personId;
    
        private String query = "UPDATE PERSON SET ";
    
        private boolean stateChanged = false;
    
        public void setAge(Integer newAge) {
            stateChanged = true;
    
            query += query + "AGE = " + newAge;
        }
    
    }
    

    So before transaction commit, JPA provider will see stateChanged flag in order to update OR NOT person entity. If no rows is updated after update statement, JPA provider will throw EntityNotFoundException according to JPA specification.

    regards,

    JQuery or JavaScript: How determine if shift key being pressed while clicking anchor tag hyperlink?

    var shiftDown = false;
    this.onkeydown = function(evt){
        var evt2 = evt || window.event;
        var keyCode = evt2.keyCode || evt2.which;       
        if(keyCode==16)shiftDown = true;
    }
    this.onkeyup = function(){
        shiftDown = false;
    }
    

    demo

    Write string to text file and ensure it always overwrites the existing content.

    Generally, FileMode.Create is what you're looking for.

    Spring MVC: How to perform validation?

    Find complete example of Spring Mvc Validation

    import org.springframework.validation.Errors;
    import org.springframework.validation.ValidationUtils;
    import org.springframework.validation.Validator;
    import com.technicalkeeda.bean.Login;
    
    public class LoginValidator implements Validator {
        public boolean supports(Class aClass) {
            return Login.class.equals(aClass);
        }
    
        public void validate(Object obj, Errors errors) {
            Login login = (Login) obj;
            ValidationUtils.rejectIfEmptyOrWhitespace(errors, "userName",
                    "username.required", "Required field");
            ValidationUtils.rejectIfEmptyOrWhitespace(errors, "userPassword",
                    "userpassword.required", "Required field");
        }
    }
    
    
    public class LoginController extends SimpleFormController {
        private LoginService loginService;
    
        public LoginController() {
            setCommandClass(Login.class);
            setCommandName("login");
        }
    
        public void setLoginService(LoginService loginService) {
            this.loginService = loginService;
        }
    
        @Override
        protected ModelAndView onSubmit(Object command) throws Exception {
            Login login = (Login) command;
            loginService.add(login);
            return new ModelAndView("loginsucess", "login", login);
        }
    }
    

    Two-dimensional array in Swift

    In Swift 4

    var arr = Array(repeating: Array(repeating: 0, count: 2), count: 3)
    // [[0, 0], [0, 0], [0, 0]]
    

    Global npm install location on windows?

    If you're just trying to find out where npm is installing your global module (the title of this thread), look at the output when running npm install -g sample_module

    $ npm install -g sample_module C:\Users\user\AppData\Roaming\npm\sample_module -> C:\Users\user\AppData\Roaming\npm\node_modules\sample_module\bin\sample_module.js + [email protected] updated 1 package in 2.821s

    How to read data of an Excel file using C#?

    Using OlebDB, we can read excel file in C#, easily, here is the code while working with Web-Form, where FileUpload1 is file uploading tool

       string path = Server.MapPath("~/Uploads/");
      if (!Directory.Exists(path))
    {
        Directory.CreateDirectory(path);
    }
    //get file path
    filePath = path + Path.GetFileName(FileUpload1.FileName);
    //get file extenstion
    string extension = Path.GetExtension(FileUpload1.FileName);
    //save file on "Uploads" folder of project
    FileUpload1.SaveAs(filePath);
    
    string conString = string.Empty;
    //check file extension
    switch (extension)
    {
        case ".xls": //Excel 97-03.
            conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Excel03ConString;Extended Properties='Excel 8.0;HDR=YES'";
            break;
        case ".xlsx": //Excel 07 and above.
            conString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Excel07ConString;Extended Properties='Excel 8.0;HDR=YES'";
            break;
    }
    
    //create datatable object
    DataTable dt = new DataTable();
    conString = string.Format(conString, filePath);
    
    //Use OldDb to read excel
    using (OleDbConnection connExcel = new OleDbConnection(conString))
    {
        using (OleDbCommand cmdExcel = new OleDbCommand())
        {
            using (OleDbDataAdapter odaExcel = new OleDbDataAdapter())
            {
                cmdExcel.Connection = connExcel;
    
                //Get the name of First Sheet.
                connExcel.Open();
                DataTable dtExcelSchema;
                dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
                string sheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString();
                connExcel.Close();
    
                //Read Data from First Sheet.
                connExcel.Open();
                cmdExcel.CommandText = "SELECT * From [" + sheetName + "]";
                odaExcel.SelectCommand = cmdExcel;
                odaExcel.Fill(dt);
                connExcel.Close();
            }
        }
    }
    
    //bind datatable with GridView
    GridView1.DataSource = dt;
    GridView1.DataBind();
    

    Source : https://qawithexperts.com/article/asp-net/read-excel-file-and-import-data-into-gridview-using-datatabl/209

    Console application similar code example https://qawithexperts.com/article/c-sharp/read-excel-file-in-c-console-application-example-using-oledb/168

    If you need don't want to use OleDB, you can try https://github.com/ExcelDataReader/ExcelDataReader which seems to have the ability to handle both formats (.xls and .xslx)

    detect back button click in browser

    So as far as AJAX is concerned...

    Pressing back while using most web-apps that use AJAX to navigate specific parts of a page is a HUGE issue. I don't accept that 'having to disable the button means you're doing something wrong' and in fact developers in different facets have long run into this problem. Here's my solution:

    window.onload = function () {
        if (typeof history.pushState === "function") {
            history.pushState("jibberish", null, null);
            window.onpopstate = function () {
                history.pushState('newjibberish', null, null);
                // Handle the back (or forward) buttons here
                // Will NOT handle refresh, use onbeforeunload for this.
            };
        }
        else {
            var ignoreHashChange = true;
            window.onhashchange = function () {
                if (!ignoreHashChange) {
                    ignoreHashChange = true;
                    window.location.hash = Math.random();
                    // Detect and redirect change here
                    // Works in older FF and IE9
                    // * it does mess with your hash symbol (anchor?) pound sign
                    // delimiter on the end of the URL
                }
                else {
                    ignoreHashChange = false;   
                }
            };
        }
    }
    

    As far as Ive been able to tell this works across chrome, firefox, haven't tested IE yet.

    jQuery OR Selector?

    Daniel A. White Solution works great for classes.

    I've got a situation where I had to find input fields like donee_1_card where 1 is an index.

    My solution has been

    $("input[name^='donee']" && "input[name*='card']")
    

    Though I am not sure how optimal it is.

    How can I get date and time formats based on Culture Info?

    Culture can be changed for a specific cell in grid view.

    <%# DateTime.ParseExact(Eval("contractdate", "{0}"), "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy", System.Globalization.CultureInfo.CurrentCulture) %>
    

    For more detail check the link.

    Date Format Issue in Gridview binding with #eval()

    Spring RequestMapping for controllers that produce and consume JSON

    The simple answer to your question is that there is no Annotation-Inheritance in Java. However, there is a way to use the Spring annotations in a way that I think will help solve your problem.

    @RequestMapping is supported at both the type level and at the method level.

    When you put @RequestMapping at the type level, most of the attributes are 'inherited' for each method in that class. This is mentioned in the Spring reference documentation. Look at the api docs for details on how each attribute is handled when adding @RequestMapping to a type. I've summarized this for each attribute below:

    • name: Value at Type level is concatenated with value at method level using '#' as a separator.
    • value: Value at Type level is inherited by method.
    • path: Value at Type level is inherited by method.
    • method: Value at Type level is inherited by method.
    • params: Value at Type level is inherited by method.
    • headers: Value at Type level is inherited by method.
    • consumes: Value at Type level is overridden by method.
    • produces: Value at Type level is overridden by method.

    Here is a brief example Controller that showcases how you could use this:

    package com.example;
    
    import org.springframework.http.MediaType;
    import org.springframework.web.bind.annotation.*;
    
    @RestController
    @RequestMapping(path = "/", 
            consumes = MediaType.APPLICATION_JSON_VALUE, 
            produces = MediaType.APPLICATION_JSON_VALUE, 
            method = {RequestMethod.GET, RequestMethod.POST})
    public class JsonProducingEndpoint {
    
        private FooService fooService;
    
        @RequestMapping(path = "/foo", method = RequestMethod.POST)
        public String postAFoo(@RequestBody ThisIsAFoo theFoo) {
            fooService.saveTheFoo(theFoo);
            return "http://myservice.com/foo/1";
        }
    
        @RequestMapping(path = "/foo/{id}", method = RequestMethod.GET)
        public ThisIsAFoo getAFoo(@PathVariable String id) {
            ThisIsAFoo foo = fooService.getAFoo(id);
            return foo;
        }
    
        @RequestMapping(path = "/foo/{id}", produces = MediaType.APPLICATION_XML_VALUE, method = RequestMethod.GET)
        public ThisIsAFooXML getAFooXml(@PathVariable String id) {
            ThisIsAFooXML foo = fooService.getAFoo(id);
            return foo;
        }
    }
    

    How do I make a splash screen?

    Another approach is achieved by using CountDownTimer

    @Override
    public void onCreate(Bundle savedInstanceState) {
         super.onCreate(savedInstanceState);
         setContentView(R.layout.splashscreen);
    
     new CountDownTimer(5000, 1000) { //5 seconds
          public void onTick(long millisUntilFinished) {
              mTextField.setText("seconds remaining: " + millisUntilFinished / 1000);
          }
    
         public void onFinish() {
              startActivity(new Intent(SplashActivity.this, MainActivity.class));
              finish();
         }
    
      }.start();
    }
    

    CSS background image to fit height, width should auto-scale in proportion

    body.bg {
        background-size: cover;
        background-repeat: no-repeat;
        min-height: 100vh;
        background: white url(../images/bg-404.jpg) center center no-repeat;
        -webkit-background-size: cover;
        -moz-background-size: cover;
        -o-background-size: cover;
    }   
    Try This
    
    _x000D_
    _x000D_
        body.bg {_x000D_
         background-size: cover;_x000D_
         background-repeat: no-repeat;_x000D_
         min-height: 100vh;_x000D_
         background: white url(http://lorempixel.com/output/city-q-c-1920-1080-7.jpg) center center no-repeat;_x000D_
         -webkit-background-size: cover;_x000D_
         -moz-background-size: cover;_x000D_
         -o-background-size: cover;_x000D_
        } 
    _x000D_
        <body class="bg">_x000D_
    _x000D_
    _x000D_
         _x000D_
        </body>
    _x000D_
    _x000D_
    _x000D_

    Use -notlike to filter out multiple strings in PowerShell

    Easiest way I find for multiple searches is to pipe them all (probably heavier CPU use) but for your example user:

    Get-EventLog -LogName Security | where {$_.UserName -notlike "*user1"} |  where {$_.UserName -notlike "*user2"}
    

    How can I refresh a page with jQuery?

    To reload a page with jQuery, do:

    $.ajax({
        url: "",
        context: document.body,
        success: function(s,x){
            $(this).html(s);
        }
    });
    

    The approach here that I used was Ajax jQuery. I tested it on Chrome 13. Then I put the code in the handler that will trigger the reload. The URL is "", which means this page.

    Running a simple shell script as a cronjob

    What directory is file.txt in? cron runs jobs in your home directory, so unless your script cds somewhere else, that's where it's going to look for/create file.txt.

    EDIT: When you refer to a file without specifying its full path (e.g. file.txt, as opposed to the full path /home/myUser/scripts/file.txt) in shell, it's taken that you're referring to a file in your current working directory. When you run a script (whether interactively or via crontab), the script's working directory has nothing at all to do with the location of the script itself; instead, it's inherited from whatever ran the script.

    Thus, if you cd (change working directory) to the directory the script's in and then run it, file.txt will refer to a file in the same directory as the script. But if you don't cd there first, file.txt will refer to a file in whatever directory you happen to be in when you ran the script. For instance, if your home directory is /home/myUser, and you open a new shell and immediately run the script (as scripts/test.sh or /home/myUser/scripts/test.sh; ./test.sh won't work), it'll touch the file /home/myUser/file.txt because /home/myUser is your current working directory (and therefore the script's).

    When you run a script from cron, it does essentially the same thing: it runs it with the working directory set to your home directory. Thus all file references in the script are taken relative to your home directory, unless the script cds somewhere else or specifies an absolute path to the file.

    How to check a string starts with numeric number?

    System.out.println(Character.isDigit(mystring.charAt(0));
    

    EDIT: I searched for java docs, looked at methods on string class which can get me 1st character & looked at methods on Character class to see if it has any method to check such a thing.

    I think, you could do the same before asking it.

    EDI2: What I mean is, try to do things, read/find & if you can't find anything - ask.
    I made a mistake when posting it for the first time. isDigit is a static method on Character class.

    Full width layout with twitter bootstrap

    Just create another class and add along with the bootstrap container class. You can also use container-fluid though.

    <div class="container full-width">
        <div class="row">
            ....
        </div>
    </div>
    

    The CSS part is pretty simple

    * {
        margin: 0;
        padding: 0;
    }
    .full-width {
        width: 100%;
        min-width: 100%;
        max-width: 100%;
    }
    

    Hope this helps, Thanks!

    Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at

    The use-case for CORS is simple. Imagine the site alice.com has some data that the site bob.com wants to access. This type of request traditionally wouldn’t be allowed under the browser’s same origin policy. However, by supporting CORS requests, alice.com can add a few special response headers that allows bob.com to access the data. In order to understand it well, please visit this nice tutorial.. How to solve the issue of CORS

    Align text to the bottom of a div

    You now can do this with Flexbox justify-content: flex-end now:

    _x000D_
    _x000D_
    div {_x000D_
      display: flex;_x000D_
      justify-content: flex-end;_x000D_
      align-items: flex-end;_x000D_
      width: 150px;_x000D_
      height: 150px;_x000D_
      border: solid 1px red;_x000D_
    }_x000D_
      
    _x000D_
    <div>_x000D_
      Something to align_x000D_
    </div>
    _x000D_
    _x000D_
    _x000D_

    Consult your Caniuse to see if Flexbox is right for you.

    Convert UTF-8 with BOM to UTF-8 with no BOM in Python

    In Python 3 it's quite easy: read the file and rewrite it with utf-8 encoding:

    s = open(bom_file, mode='r', encoding='utf-8-sig').read()
    open(bom_file, mode='w', encoding='utf-8').write(s)
    

    How to list all files in a directory and its subdirectories in hadoop hdfs

    Now, one can use Spark to do the same and its way faster than other approaches (such as Hadoop MR). Here is the code snippet.

    def traverseDirectory(filePath:String,recursiveTraverse:Boolean,filePaths:ListBuffer[String]) {
        val files = FileSystem.get( sparkContext.hadoopConfiguration ).listStatus(new Path(filePath))
                files.foreach { fileStatus => {
                    if(!fileStatus.isDirectory() && fileStatus.getPath().getName().endsWith(".xml")) {                
                        filePaths+=fileStatus.getPath().toString()      
                    }
                    else if(fileStatus.isDirectory()) {
                        traverseDirectory(fileStatus.getPath().toString(), recursiveTraverse, filePaths)
                    }
                }
        }   
    }
    

    How do I increase the capacity of the Eclipse output console?

    For C++ users, to increase the Build console output size see here

    ie Windows > Preference > C/C++ > Build > Console

    jQuery ajax post file field

    File uploads can not be done this way, no matter how you break it down. If you want to do an ajax/async upload, I would suggest looking into something like Uploadify, or Valums

    Android statusbar icons color

    if you have API level smaller than 23 than you must use it this way. it worked for me declare this under v21/style.

    <item name="colorPrimaryDark" tools:targetApi="23">@color/colorPrimary</item>
            <item name="android:windowLightStatusBar" tools:targetApi="23">true</item>
    

    How do I add records to a DataGridView in VB.Net?

    If you want to use something that is more descriptive than a dumb array without resorting to using a DataSet then the following might prove useful. It still isn't strongly-typed, but at least it is checked by the compiler and will handle being refactored quite well.

    Dim previousAllowUserToAddRows = dgvHistoricalInfo.AllowUserToAddRows
    dgvHistoricalInfo.AllowUserToAddRows = True
    
    Dim newTimeRecord As DataGridViewRow = dgvHistoricalInfo.Rows(dgvHistoricalInfo.NewRowIndex).Clone
    
    With record
        newTimeRecord.Cells(dgvcDate.Index).Value = .Date
        newTimeRecord.Cells(dgvcHours.Index).Value = .Hours
        newTimeRecord.Cells(dgvcRemarks.Index).Value = .Remarks
    End With
    
    dgvHistoricalInfo.Rows.Add(newTimeRecord)
    
    dgvHistoricalInfo.AllowUserToAddRows = previousAllowUserToAddRows
    

    It is worth noting that the user must have AllowUserToAddRows permission or this won't work. That is why I store the existing value, set it to true, do my work, and then reset it to how it was.

    Check if instance is of a type

    Or

    c.getType() == typeOf(TForm)
    

    Java RegEx meta character (.) and ordinary dot?

    Solutions proposed by the other members don't work for me.

    But I found this :

    to escape a dot in java regexp write [.]

    XPath query to get nth instance of an element

    This is a FAQ:

    //somexpression[$N]

    means "Find every node selected by //somexpression that is the $Nth child of its parent".

    What you want is:

    (//input[@id="search_query"])[2]
    

    Remember: The [] operator has higher precedence (priority) than the // abbreviation.

    How can getContentResolver() be called in Android?

      //create activity object to get activity from Activity class for use to content resolver
        private final Activity ActivityObj;
    
      //create constructor with ActivityObj to get activity from Activity class
        public RecyclerViewAdapterClass(Activity activityObj) {
            this.ActivityObj = activityObj;
        }
    
    
         ActivityObj.getContentResolver(),.....,.....,null);
    

    How to reposition Chrome Developer Tools

    After I have placed my dock to the right (see older answers), I still found the panels split vertically.

    To split the panels horizontally - and even got more from your screen width - go to Settings (bottom right corner), and remove the check on 'Split panels vertically when docked to right'.

    Now, you have all panels from left to right :p

    Choosing the best concurrency list in Java

    You might want to look at ConcurrentDoublyLinkedList written by Doug Lea based on Paul Martin's "A Practical Lock-Free Doubly-Linked List". It does not implement the java.util.List interface, but offers most methods you would use in a List.

    According to the javadoc:

    A concurrent linked-list implementation of a Deque (double-ended queue). Concurrent insertion, removal, and access operations execute safely across multiple threads. Iterators are weakly consistent, returning elements reflecting the state of the deque at some point at or since the creation of the iterator. They do not throw ConcurrentModificationException, and may proceed concurrently with other operations.

    Shell Script: How to write a string to file and to stdout on console?

    You can use >> to print in another file.

    echo "hello" >> logfile.txt
    

    ValueError: unsupported pickle protocol: 3, python2 pickle can not load the file dumped by python 3 pickle?

    Pickle uses different protocols to convert your data to a binary stream.

    You must specify in python 3 a protocol lower than 3 in order to be able to load the data in python 2. You can specify the protocol parameter when invoking pickle.dump.

    How to run a .awk file?

    The file you give is a shell script, not an awk program. So, try sh my.awk.

    If you want to use awk -f my.awk life.csv > life_out.cs, then remove awk -F , ' and the last line from the file and add FS="," in BEGIN.

    "Access is denied" JavaScript error when trying to access the document object of a programmatically-created <iframe> (IE-only)

    It seems that the problem with IE comes when you try and access the iframe via the document.frames object - if you store a reference to the created iframe in a variable then you can access the injected iframe via the variable (my_iframe in the code below).

    I've gotten this to work in IE6/7/8

    var my_iframe;
    var iframeId = "my_iframe_name"
    if (navigator.userAgent.indexOf('MSIE') !== -1) {
      // IE wants the name attribute of the iframe set
      my_iframe = document.createElement('<iframe name="' + iframeId + '">');
    } else {
      my_iframe = document.createElement('iframe');
    }
    
    iframe.setAttribute("src", "javascript:void(0);");
    iframe.setAttribute("scrolling", "no");
    iframe.setAttribute("frameBorder", "0");
    iframe.setAttribute("name", iframeId);
    
    var is = iframe.style;
    is.border = is.width = is.height = "0px";
    
    if (document.body) {
      document.body.appendChild(my_iframe);
    } else {
      document.appendChild(my_iframe);
    }
    

    Adding 'serial' to existing column in Postgres

    TL;DR

    Here's a version where you don't need a human to read a value and type it out themselves.

    CREATE SEQUENCE foo_a_seq OWNED BY foo.a;
    SELECT setval('foo_a_seq', coalesce(max(a), 0) + 1, false) FROM foo;
    ALTER TABLE foo ALTER COLUMN a SET DEFAULT nextval('foo_a_seq'); 
    

    Another option would be to employ the reusable Function shared at the end of this answer.


    A non-interactive solution

    Just adding to the other two answers, for those of us who need to have these Sequences created by a non-interactive script, while patching a live-ish DB for instance.

    That is, when you don't wanna SELECT the value manually and type it yourself into a subsequent CREATE statement.

    In short, you can not do:

    CREATE SEQUENCE foo_a_seq
        START WITH ( SELECT max(a) + 1 FROM foo );
    

    ... since the START [WITH] clause in CREATE SEQUENCE expects a value, not a subquery.

    Note: As a rule of thumb, that applies to all non-CRUD (i.e.: anything other than INSERT, SELECT, UPDATE, DELETE) statements in pgSQL AFAIK.

    However, setval() does! Thus, the following is absolutely fine:

    SELECT setval('foo_a_seq', max(a)) FROM foo;
    

    If there's no data and you don't (want to) know about it, use coalesce() to set the default value:

    SELECT setval('foo_a_seq', coalesce(max(a), 0)) FROM foo;
    --                         ^      ^         ^
    --                       defaults to:       0
    

    However, having the current sequence value set to 0 is clumsy, if not illegal.
    Using the three-parameter form of setval would be more appropriate:

    --                                             vvv
    SELECT setval('foo_a_seq', coalesce(max(a), 0) + 1, false) FROM foo;
    --                                                  ^   ^
    --                                                is_called
    

    Setting the optional third parameter of setval to false will prevent the next nextval from advancing the sequence before returning a value, and thus:

    the next nextval will return exactly the specified value, and sequence advancement commences with the following nextval.

    — from this entry in the documentation

    On an unrelated note, you also can specify the column owning the Sequence directly with CREATE, you don't have to alter it later:

    CREATE SEQUENCE foo_a_seq OWNED BY foo.a;
    

    In summary:

    CREATE SEQUENCE foo_a_seq OWNED BY foo.a;
    SELECT setval('foo_a_seq', coalesce(max(a), 0) + 1, false) FROM foo;
    ALTER TABLE foo ALTER COLUMN a SET DEFAULT nextval('foo_a_seq'); 
    

    Using a Function

    Alternatively, if you're planning on doing this for multiple columns, you could opt for using an actual Function.

    CREATE OR REPLACE FUNCTION make_into_serial(table_name TEXT, column_name TEXT) RETURNS INTEGER AS $$
    DECLARE
        start_with INTEGER;
        sequence_name TEXT;
    BEGIN
        sequence_name := table_name || '_' || column_name || '_seq';
        EXECUTE 'SELECT coalesce(max(' || column_name || '), 0) + 1 FROM ' || table_name
                INTO start_with;
        EXECUTE 'CREATE SEQUENCE ' || sequence_name ||
                ' START WITH ' || start_with ||
                ' OWNED BY ' || table_name || '.' || column_name;
        EXECUTE 'ALTER TABLE ' || table_name || ' ALTER COLUMN ' || column_name ||
                ' SET DEFAULT nextVal(''' || sequence_name || ''')';
        RETURN start_with;
    END;
    $$ LANGUAGE plpgsql VOLATILE;
    

    Use it like so:

    INSERT INTO foo (data) VALUES ('asdf');
    -- ERROR: null value in column "a" violates not-null constraint
    
    SELECT make_into_serial('foo', 'a');
    INSERT INTO foo (data) VALUES ('asdf');
    -- OK: 1 row(s) affected
    

    How to add 'ON DELETE CASCADE' in ALTER TABLE statement

    For anyone using MySQL:

    If you head into your PHPMYADMIN webpage and navigate to the table that has the foreign key you want to update, all you have to do is click the Relational view located in the Structure tab and change the On delete select menu option to Cascade.

    Image shown below:

    enter image description here

    instantiate a class from a variable in PHP?

    I would recommend the call_user_func() or call_user_func_arrayphp methods. You can check them out here (call_user_func_array , call_user_func).

    example

    class Foo {
    static public function test() {
        print "Hello world!\n";
    }
    }
    
     call_user_func('Foo::test');//FOO is the class, test is the method both separated by ::
     //or
     call_user_func(array('Foo', 'test'));//alternatively you can pass the class and method as an array
    

    If you have arguments you are passing to the method , then use the call_user_func_array() function.

    example.

    class foo {
    function bar($arg, $arg2) {
        echo __METHOD__, " got $arg and $arg2\n";
    }
    }
    
    // Call the $foo->bar() method with 2 arguments
    call_user_func_array(array("foo", "bar"), array("three", "four"));
    //or
    //FOO is the class, bar is the method both separated by ::
    call_user_func_array("foo::bar"), array("three", "four"));
    

    Hibernate Query By Example and Projections

    I'm facing a similar problem. I'm using Query by Example and I want to sort the results by a custom field. In SQL I would do something like:

    select pageNo, abs(pageNo - 434) as diff
    from relA
    where year = 2009
    order by diff
    

    It works fine without the order-by-clause. What I got is

    Criteria crit = getSession().createCriteria(Entity.class);
    crit.add(exampleObject);
    ProjectionList pl = Projections.projectionList();
    pl.add( Projections.property("id") );
    pl.add(Projections.sqlProjection("abs(`pageNo`-"+pageNo+") as diff", new String[] {"diff"}, types ));
    crit.setProjection(pl);
    

    But when I add

    crit.addOrder(Order.asc("diff"));
    

    I get a org.hibernate.QueryException: could not resolve property: diff exception. Workaround with this does not work either.

    PS: as I could not find any elaborate documentation on the use of QBE for Hibernate, all the stuff above is mainly trial-and-error approach

    EPPlus - Read Excel Table

    This is my working version. Note that the resolvers code is not shown but are a spin on my implementation which allows columns to be resolved even though they are named slightly differently in each worksheet.

    public static IEnumerable<T> ToArray<T>(this ExcelWorksheet worksheet, List<PropertyNameResolver> resolvers) where T : new()
    {
    
      // List of all the column names
      var header = worksheet.Cells.GroupBy(cell => cell.Start.Row).First();
    
      // Get the properties from the type your are populating
      var properties = typeof(T).GetProperties().ToList();
    
    
      var start = worksheet.Dimension.Start;
      var end = worksheet.Dimension.End;
    
      // Resulting list
      var list = new List<T>();
    
      // Iterate the rows starting at row 2 (ie start.Row + 1)
      for (int row = start.Row + 1; row <= end.Row; row++)
      {
        var instance = new T();
        for (int col = start.Column; col <= end.Column; col++)
        {
          object value = worksheet.Cells[row, col].Text;
    
          // Get the column name zero based (ie col -1)
          var column = (string)header.Skip(col - 1).First().Value;
    
          // Gets the corresponding property to set
          var property = properties.Property(resolvers, column);
    
          try
          {
            var propertyName = property.PropertyType.IsGenericType
              ? property.PropertyType.GetGenericArguments().First().FullName
              : property.PropertyType.FullName;
    
    
            // Implement setter code as needed. 
            switch (propertyName)
            {
              case "System.String":
                property.SetValue(instance, Convert.ToString(value));
                break;
              case "System.Int32":
                property.SetValue(instance, Convert.ToInt32(value));
                break;
              case "System.DateTime":
                if (DateTime.TryParse((string) value, out var date))
                {
                  property.SetValue(instance, date);
                }
                property.SetValue(instance, FromExcelSerialDate(Convert.ToInt32(value)));
                break;
              case "System.Boolean":
                property.SetValue(instance, (int)value == 1);
                break;
            }
          }
          catch (Exception e)
          {
            // instance property is empty because there was a problem.
          }
    
        } 
        list.Add(instance);
      }
      return list;
    }
    
    // Utility function taken from the above post's inline function.
    public static DateTime FromExcelSerialDate(int excelDate)
    {
      if (excelDate < 1)
        throw new ArgumentException("Excel dates cannot be smaller than 0.");
    
      var dateOfReference = new DateTime(1900, 1, 1);
    
      if (excelDate > 60d)
        excelDate = excelDate - 2;
      else
        excelDate = excelDate - 1;
      return dateOfReference.AddDays(excelDate);
    }
    

    Sort arrays of primitive types in descending order

    Your implementation (the one in the question) is faster than e.g. wrapping with toList() and using a comparator-based method. Auto-boxing and running through comparator methods or wrapped Collections objects is far slower than just reversing.

    Of course you could write your own sort. That might not be the answer you're looking for, but note that if your comment about "if the array is already sorted quite well" happens frequently, you might do well to choose a sorting algorithm that handles that case well (e.g. insertion) rather than use Arrays.sort() (which is mergesort, or insertion if the number of elements is small).

    Using routes in Express-js

    No one should ever have to keep writing app.use('/someRoute', require('someFile')) until it forms a heap of code.

    It just doesn't make sense at all to be spending time invoking/defining routings. Even if you do need custom control, it's probably only for some of the time, and for the most bit you want to be able to just create a standard file structure of routings and have a module do it automatically.

    Try Route Magic

    As you scale your app, the routing invocations will start to form a giant heap of code that serves no purpose. You want to do just 2 lines of code to handle all the app.use routing invocations with Route Magic like this:

    const magic = require('express-routemagic')
    magic.use(app, __dirname, '[your route directory]')
    

    For those you want to handle manually, just don't use pass the directory to Magic.

    SQL select max(date) and corresponding value

    Each MAX function is evaluated individually. So MAX(CompletedDate) will return the value of the latest CompletedDate column and MAX(Notes) will return the maximum (i.e. alphabeticaly highest) value.

    You need to structure your query differently to get what you want. This question had actually already been asked and answered several times, so I won't repeat it:

    How to find the record in a table that contains the maximum value?

    Finding the record with maximum value in SQL

    How to use format() on a moment.js duration?

    How about native javascript?

    var formatTime = function(integer) {
        if(integer < 10) {
            return "0" + integer; 
        } else {
            return integer;
        }
    }
    
    function getDuration(ms) {
        var s1 = Math.floor(ms/1000);
        var s2 = s1%60;
        var m1 = Math.floor(s1/60);
        var m2 = m1%60;
        var h1 = Math.floor(m1/60);
        var string = formatTime(h1) +":" + formatTime(m2) + ":" + formatTime(s2);
        return string;
    }
    

    While, Do While, For loops in Assembly Language (emu8086)

    For-loops:

    For-loop in C:

    for(int x = 0; x<=3; x++)
    {
        //Do something!
    }
    

    The same loop in 8086 assembler:

            xor cx,cx   ; cx-register is the counter, set to 0
    loop1   nop         ; Whatever you wanna do goes here, should not change cx
            inc cx      ; Increment
            cmp cx,3    ; Compare cx to the limit
            jle loop1   ; Loop while less or equal
    

    That is the loop if you need to access your index (cx). If you just wanna to something 0-3=4 times but you do not need the index, this would be easier:

            mov cx,4    ; 4 iterations
    loop1   nop         ; Whatever you wanna do goes here, should not change cx
            loop loop1  ; loop instruction decrements cx and jumps to label if not 0
    

    If you just want to perform a very simple instruction a constant amount of times, you could also use an assembler-directive which will just hardcore that instruction

    times 4 nop
    

    Do-while-loops

    Do-while-loop in C:

    int x=1;
    do{
        //Do something!
    }
    while(x==1)
    

    The same loop in assembler:

            mov ax,1
    loop1   nop         ; Whatever you wanna do goes here
            cmp ax,1    ; Check wether cx is 1
            je loop1    ; And loop if equal
    

    While-loops

    While-loop in C:

    while(x==1){
        //Do something
    }
    

    The same loop in assembler:

            jmp loop1   ; Jump to condition first
    cloop1  nop         ; Execute the content of the loop
    loop1   cmp ax,1    ; Check the condition
            je cloop1   ; Jump to content of the loop if met
    

    For the for-loops you should take the cx-register because it is pretty much standard. For the other loop conditions you can take a register of your liking. Of course replace the no-operation instruction with all the instructions you wanna perform in the loop.

    PDF files do not open in Internet Explorer with Adobe Reader 10.0 - users get an empty gray screen. How can I fix this for my users?

    Experimenting more, the underlying cause in my app (calling goog.userAgent.adobeReader) was accessing Adobe Reader via an ActiveXObject on the page with the link to the PDF. This minimal test case causes the gray screen for me (however removing the ActiveXObject causes no gray screen).

    <!DOCTYPE html>
    <html lang="en">
      <head>
        <title>hi</title>
        <meta charset="utf-8">
      </head>
      <body>
        <script>
          new ActiveXObject('AcroPDF.PDF.1');
        </script>
        <a target="_blank" href="http://partners.adobe.com/public/developer/en/xml/AdobeXMLFormsSamples.pdf">link</a>
      </body>
    </html>
    

    I'm very interested if others are able to reproduce the problem with this test case and following the steps from my other post ("I don't have an exact solution...") on a "slow" computer.

    Sorry for posting a new answer, but I couldn't figure out how to add a code block in a comment on my previous post.

    For a video example of this minimal test case, see: http://youtu.be/IgEcxzM6Kck

    Find the line number where a specific word appears with "grep"

    Or You can use

       grep -n . file1 |tail -LineNumberToStartWith|grep regEx
    

    This will take care of numbering the lines in the file

       grep -n . file1 
    

    This will print the last-LineNumberToStartWith

       tail -LineNumberToStartWith
    

    And finally it will grep your desired lines(which will include line number as in orignal file)

    grep regEX
    

    How to get size of mysql database?

    To get a result in MB:

    SELECT
    SUM(ROUND(((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024), 2)) AS "SIZE IN MB"
    FROM INFORMATION_SCHEMA.TABLES
    WHERE
    TABLE_SCHEMA = "SCHEMA-NAME";
    

    To get a result in GB:

    SELECT
    SUM(ROUND(((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024 / 1024), 2)) AS "SIZE IN GB"
    FROM INFORMATION_SCHEMA.TABLES
    WHERE
    TABLE_SCHEMA = "SCHEMA-NAME";
    

    Performance differences between ArrayList and LinkedList

    ArrayList: ArrayList has a structure like an array, it has a direct reference to every element. So rendom access is fast in ArrayList.

    LinkedList: In LinkedList for getting nth elemnt you have to traverse whole list, takes time as compared to ArrayList. Every element has a link to its previous & nest element, so deletion is fast.

    How to keep two folders automatically synchronized?

    I use this free program to synchronize local files and directories: https://github.com/Fitus/Zaloha.sh. The repository contains a simple demo as well.

    The good point: It is a bash shell script (one file only). Not a black box like other programs. Documentation is there as well. Also, with some technical talents, you can "bend" and "integrate" it to create the final solution you like.

    Changing text color of menu item in navigation drawer

    This works for me. in place of customTheme you can put you theme in styles. in this code you can also change the font and text size.

        <style name="MyTheme.NavMenu" parent="CustomTheme">
                <item name="android:textSize">16sp</item>
                <item name="android:fontFamily">@font/ssp_semi_bold</item>
                <item name="android:textColorPrimary">@color/yourcolor</item>
            </style>
    

    here is my navigation view

    <android.support.design.widget.NavigationView
            android:id="@+id/navigation_view"
            android:layout_width="wrap_content"
            android:layout_height="match_parent"
            android:layout_gravity="start"
            android:fitsSystemWindows="true"
            app:theme="@style/MyTheme.NavMenu"
            app:headerLayout="@layout/nav_header_main"
            app:menu="@menu/activity_main_drawer">
    
            <include layout="@layout/layout_update_available"/>
    
        </android.support.design.widget.NavigationView>
    

    JSON response parsing in Javascript to get key/value pair

    There are two ways to access properties of objects:

    var obj = {a: 'foo', b: 'bar'};
    
    obj.a //foo
    obj['b'] //bar
    

    Or, if you need to dynamically do it:

    var key = 'b';
    obj[key] //bar
    

    If you don't already have it as an object, you'll need to convert it.

    For a more complex example, let's assume you have an array of objects that represent users:

    var users = [{name: 'Corbin', age: 20, favoriteFoods: ['ice cream', 'pizza']},
                 {name: 'John', age: 25, favoriteFoods: ['ice cream', 'skittle']}];
    

    To access the age property of the second user, you would use users[1].age. To access the second "favoriteFood" of the first user, you'd use users[0].favoriteFoods[2].

    Another example: obj[2].key[3]["some key"]

    That would access the 3rd element of an array named 2. Then, it would access 'key' in that array, go to the third element of that, and then access the property name some key.


    As Amadan noted, it might be worth also discussing how to loop over different structures.

    To loop over an array, you can use a simple for loop:

    var arr = ['a', 'b', 'c'],
        i;
    for (i = 0; i < arr.length; ++i) {
        console.log(arr[i]);
    }
    

    To loop over an object is a bit more complicated. In the case that you're absolutely positive that the object is a plain object, you can use a plain for (x in obj) { } loop, but it's a lot safer to add in a hasOwnProperty check. This is necessary in situations where you cannot verify that the object does not have inherited properties. (It also future proofs the code a bit.)

    var user = {name: 'Corbin', age: 20, location: 'USA'},
        key;
    
    for (key in user) {
        if (user.hasOwnProperty(key)) {
            console.log(key + " = " + user[key]);
        }
    }    
    

    (Note that I've assumed whatever JS implementation you're using has console.log. If not, you could use alert or some kind of DOM manipulation instead.)

    new Image(), how to know if image 100% loaded or not?

    Use the load event:

    img = new Image();
    
    img.onload = function(){
      // image  has been loaded
    };
    
    img.src = image_url;
    

    Also have a look at:

    How do you create a static class in C++?

    You can also create a free function in a namespace:

    In BitParser.h

    namespace BitParser
    {
        bool getBitAt(int buffer, int bitIndex);
    }
    

    In BitParser.cpp

    namespace BitParser
    {
        bool getBitAt(int buffer, int bitIndex)
        {
            //get the bit :)
        }
    }
    

    In general this would be the preferred way to write the code. When there's no need for an object don't use a class.

    Why I got " cannot be resolved to a type" error?

    for some reason, my.demo.service has the same level as src/ in eclise project explorer view. After I move my.demo.service under src/, it is fine. Seems I should not create new package in "Project Explorer" view in Eclipse...

    But thank you for your response:)

    Is <img> element block level or inline level?

    An img element is a replaced inline element.

    It behaves like an inline element (because it is), but some generalizations about inline elements do not apply to img elements.

    e.g.

    Generalization: "Width does not apply to inline elements"

    What the spec actually says: "Applies to: all elements but non-replaced inline elements, table rows, and row groups "

    Since an image is a replaced inline element, it does apply.

    how to git commit a whole folder?

    You don't "commit the folder" - you add the folder, as you have done, and then simply commit all changes. The command should be:

    git add foldername
    git commit -m "commit operation"
    

    How to create a collapsing tree table in html/css/js?

    In modern browsers, you need only very little to code to create a collapsible tree :

    _x000D_
    _x000D_
    var tree = document.querySelectorAll('ul.tree a:not(:last-child)');_x000D_
    for(var i = 0; i < tree.length; i++){_x000D_
        tree[i].addEventListener('click', function(e) {_x000D_
            var parent = e.target.parentElement;_x000D_
            var classList = parent.classList;_x000D_
            if(classList.contains("open")) {_x000D_
                classList.remove('open');_x000D_
                var opensubs = parent.querySelectorAll(':scope .open');_x000D_
                for(var i = 0; i < opensubs.length; i++){_x000D_
                    opensubs[i].classList.remove('open');_x000D_
                }_x000D_
            } else {_x000D_
                classList.add('open');_x000D_
            }_x000D_
            e.preventDefault();_x000D_
        });_x000D_
    }
    _x000D_
    body {_x000D_
        font-family: Arial;_x000D_
    }_x000D_
    _x000D_
    ul.tree li {_x000D_
        list-style-type: none;_x000D_
        position: relative;_x000D_
    }_x000D_
    _x000D_
    ul.tree li ul {_x000D_
        display: none;_x000D_
    }_x000D_
    _x000D_
    ul.tree li.open > ul {_x000D_
        display: block;_x000D_
    }_x000D_
    _x000D_
    ul.tree li a {_x000D_
        color: black;_x000D_
        text-decoration: none;_x000D_
    }_x000D_
    _x000D_
    ul.tree li a:before {_x000D_
        height: 1em;_x000D_
        padding:0 .1em;_x000D_
        font-size: .8em;_x000D_
        display: block;_x000D_
        position: absolute;_x000D_
        left: -1.3em;_x000D_
        top: .2em;_x000D_
    }_x000D_
    _x000D_
    ul.tree li > a:not(:last-child):before {_x000D_
        content: '+';_x000D_
    }_x000D_
    _x000D_
    ul.tree li.open > a:not(:last-child):before {_x000D_
        content: '-';_x000D_
    }
    _x000D_
    <ul class="tree">_x000D_
      <li><a href="#">Part 1</a>_x000D_
        <ul>_x000D_
          <li><a href="#">Item A</a>_x000D_
            <ul>_x000D_
              <li><a href="#">Sub-item 1</a></li>_x000D_
              <li><a href="#">Sub-item 2</a></li>_x000D_
              <li><a href="#">Sub-item 3</a></li>_x000D_
            </ul>_x000D_
          </li>_x000D_
          <li><a href="#">Item B</a>_x000D_
            <ul>_x000D_
              <li><a href="#">Sub-item 1</a></li>_x000D_
              <li><a href="#">Sub-item 2</a></li>_x000D_
              <li><a href="#">Sub-item 3</a></li>_x000D_
            </ul>_x000D_
          </li>_x000D_
          <li><a href="#">Item C</a>_x000D_
            <ul>_x000D_
              <li><a href="#">Sub-item 1</a></li>_x000D_
              <li><a href="#">Sub-item 2</a></li>_x000D_
              <li><a href="#">Sub-item 3</a></li>_x000D_
            </ul>_x000D_
          </li>_x000D_
          <li><a href="#">Item D</a>_x000D_
            <ul>_x000D_
              <li><a href="#">Sub-item 1</a></li>_x000D_
              <li><a href="#">Sub-item 2</a></li>_x000D_
              <li><a href="#">Sub-item 3</a></li>_x000D_
            </ul>_x000D_
          </li>_x000D_
          <li><a href="#">Item E</a>_x000D_
            <ul>_x000D_
              <li><a href="#">Sub-item 1</a></li>_x000D_
              <li><a href="#">Sub-item 2</a></li>_x000D_
              <li><a href="#">Sub-item 3</a></li>_x000D_
            </ul>_x000D_
          </li>_x000D_
        </ul>_x000D_
      </li>_x000D_
    _x000D_
      <li><a href="#">Part 2</a>_x000D_
        <ul>_x000D_
          <li><a href="#">Item A</a>_x000D_
            <ul>_x000D_
              <li><a href="#">Sub-item 1</a></li>_x000D_
              <li><a href="#">Sub-item 2</a></li>_x000D_
              <li><a href="#">Sub-item 3</a></li>_x000D_
            </ul>_x000D_
          </li>_x000D_
          <li><a href="#">Item B</a>_x000D_
            <ul>_x000D_
              <li><a href="#">Sub-item 1</a></li>_x000D_
              <li><a href="#">Sub-item 2</a></li>_x000D_
              <li><a href="#">Sub-item 3</a></li>_x000D_
            </ul>_x000D_
          </li>_x000D_
          <li><a href="#">Item C</a>_x000D_
            <ul>_x000D_
              <li><a href="#">Sub-item 1</a></li>_x000D_
              <li><a href="#">Sub-item 2</a></li>_x000D_
              <li><a href="#">Sub-item 3</a></li>_x000D_
            </ul>_x000D_
          </li>_x000D_
          <li><a href="#">Item D</a>_x000D_
            <ul>_x000D_
              <li><a href="#">Sub-item 1</a></li>_x000D_
              <li><a href="#">Sub-item 2</a></li>_x000D_
              <li><a href="#">Sub-item 3</a></li>_x000D_
            </ul>_x000D_
          </li>_x000D_
          <li><a href="#">Item E</a>_x000D_
            <ul>_x000D_
              <li><a href="#">Sub-item 1</a></li>_x000D_
              <li><a href="#">Sub-item 2</a></li>_x000D_
              <li><a href="#">Sub-item 3</a></li>_x000D_
            </ul>_x000D_
          </li>_x000D_
        </ul>_x000D_
      </li>_x000D_
    _x000D_
      <li><a href="#">Part 3</a>_x000D_
        <ul>_x000D_
          <li><a href="#">Item A</a>_x000D_
            <ul>_x000D_
              <li><a href="#">Sub-item 1</a></li>_x000D_
              <li><a href="#">Sub-item 2</a></li>_x000D_
              <li><a href="#">Sub-item 3</a></li>_x000D_
            </ul>_x000D_
          </li>_x000D_
          <li><a href="#">Item B</a>_x000D_
            <ul>_x000D_
              <li><a href="#">Sub-item 1</a></li>_x000D_
              <li><a href="#">Sub-item 2</a></li>_x000D_
              <li><a href="#">Sub-item 3</a></li>_x000D_
            </ul>_x000D_
          </li>_x000D_
          <li><a href="#">Item C</a>_x000D_
            <ul>_x000D_
              <li><a href="#">Sub-item 1</a></li>_x000D_
              <li><a href="#">Sub-item 2</a></li>_x000D_
              <li><a href="#">Sub-item 3</a></li>_x000D_
            </ul>_x000D_
          </li>_x000D_
          <li><a href="#">Item D</a>_x000D_
            <ul>_x000D_
              <li><a href="#">Sub-item 1</a></li>_x000D_
              <li><a href="#">Sub-item 2</a></li>_x000D_
              <li><a href="#">Sub-item 3</a></li>_x000D_
            </ul>_x000D_
          </li>_x000D_
          <li><a href="#">Item E</a>_x000D_
            <ul>_x000D_
              <li><a href="#">Sub-item 1</a></li>_x000D_
              <li><a href="#">Sub-item 2</a></li>_x000D_
              <li><a href="#">Sub-item 3</a></li>_x000D_
            </ul>_x000D_
          </li>_x000D_
        </ul>_x000D_
      </li>_x000D_
    </ul>
    _x000D_
    _x000D_
    _x000D_

    (see also this Fiddle)

    ssh-copy-id no identities found error

    The simplest way is to:

    ssh-keygen
    [enter]
    [enter]
    [enter]
    
    cd ~/.ssh
    ssh-copy-id -i id_rsa.pub USERNAME@SERVERTARGET
    

    Att:

    Its very very simple.

    In manual of "ss-keygen" explains:

    "DESCRIPTION ssh-keygen generates, manages and converts authentication keys for ssh(1). ssh-keygen can create RSA keys for use by SSH protocol version 1 and DSA, ECDSA or RSA keys for use by SSH protocol version 2. The type of key to be generated is specified with the -t option. If invoked without any arguments, ssh-keygen will generate an RSA key for use in SSH protocol 2 connections."

    Achieving white opacity effect in html/css

    Try RGBA, e.g.

    div { background-color: rgba(255, 255, 255, 0.5); }
    

    As always, this won't work in every single browser ever written.

    Connection Java-MySql : Public Key Retrieval is not allowed

    First of all, please make sure your Database server is up and running. I was getting the same error, after trying all the answers listed here I found out that my Database server was not running.

    You can check the same from MySQL Workbench, or Command line using

    mysql -u USERNAME -p
    

    This sounds obvious, but many times we assume that Database server is up and running all the time, especially when we are working on our local machine, when we restart/shutdown the machine, Database server will be shutdown automatically.

    Anaconda version with Python 3.5

    command install:

    • python3.5: conda install python=3.5
    • python3.6: conda install python=3.6

    download the most recent Anaconda installer:

    • python3.5: Anaconda 4.2.0
    • python3.6: Anaconda 5.2.0

    reference from anaconda doc:

    How to remove the left part of a string?

    Why not using regex with escape? ^ matches the initial part of a line and re.MULTILINE matches on each line. re.escape ensures that the matching is exact.

    >>> print(re.sub('^' + re.escape('path='), repl='', string='path=c:\path\nd:\path2', flags=re.MULTILINE))
    c:\path
    d:\path2
    

    Permissions error when connecting to EC2 via SSH on Mac OSx

    I was getting this error when I was trying to ssh into an ec2 instance on the private subnet from the bastion, to fix this issue, you've to run (ssh-add -K) as follow.
    
        Step 1: run "chmod 400 myEC2Key.pem"
        Step 2: run "ssh-add -K ./myEC2Key.pem" on your local machine
        Step 3: ssh -i myEC2Key.pem [email protected]
        Step 4: Now try to ssh to EC2 instance that is on a private subnet without specifying the key, for example, try ssh ec2-user@ipaddress.
    
        Hope this will help.
    Note: This solution is for Mac.
    

    How to check if two words are anagrams

    Two words are anagrams of each other if they contain the same number of characters and the same characters. You should only need to sort the characters in lexicographic order, and determine if all the characters in one string are equal to and in the same order as all of the characters in the other string.

    Here's a code example. Look into Arrays in the API to understand what's going on here.

    public boolean isAnagram(String firstWord, String secondWord) {
         char[] word1 = firstWord.replaceAll("[\\s]", "").toCharArray();
         char[] word2 = secondWord.replaceAll("[\\s]", "").toCharArray();
         Arrays.sort(word1);
         Arrays.sort(word2);
         return Arrays.equals(word1, word2);
    }
    

    Convert XML to JSON (and back) using Javascript

    Here' a good tool from a documented and very famous npm library that does the xml <-> js conversions very well: differently from some (maybe all) of the above proposed solutions, it converts xml comments also.

    var obj = {name: "Super", Surname: "Man", age: 23};
    
    var builder = new xml2js.Builder();
    var xml = builder.buildObject(obj);
    

    Powershell: count members of a AD group

    In Powershell, you'll need to import the active directory module, then use the get-adgroupmember, and then measure-object. For example, to get the number of users belonging to the group "domain users", do the following:

    Import-Module activedirecotry
    Get-ADGroupMember "domain users" | Measure-Object
    

    When entering the group name after "Get-ADGroupMember", if the name is a single string with no spaces, then no quotes are necessary. If the group name has spaces in it, use the quotes around it.

    The output will look something like:

    Count    : 12345
    Average  :
    Sum      :
    Maximum  :
    Minimum  :
    Property :
    

    Note - importing the active directory module may be redundant if you're already using PowerShell for other AD admin tasks.