Questions

What's the difference between RANK() and DENSE_RANK() functions in oracle?

What's the difference between `RANK()` and `DENSE_RANK()` functions? How to find out nth salary in the following `emptbl` table? ``` DEPTNO EMPNAME SAL ------------------------------ 10 rrr...

11 Sep at 08:2

How do I express "if value is not empty" in the VBA language?

How do I express the condition "if value is not empty" in the VBA language? Is it something like this? ``` "if value is not empty then..." Edit/Delete Message ```

4 Jul at 11:49

HTTP Error 403.14 - Forbidden - The Web server is configured to not list the contents of this directory

I just created a new empty website in Visual Studio 2012 and clicked on run (i.e view in browser) and I get this error: > The Web server is configured to not list the contents of this directory. I we...

3 Jan at 19:25

How to format date and time in Android?

How to format correctly according to the device configuration date and time when having a year, month, day, hour and minute?

27 Nov at 07:54

When to use .First and when to use .FirstOrDefault with LINQ?

I've searched around and haven't really found a clear answer as to when you'd want to use `.First` and when you'd want to use `.FirstOrDefault` with LINQ. - When would you want to use `.First`? Only ...

3 Dec at 22:3

How do I get currency exchange rates via an API such as Google Finance?

Now, I did find the [Google Finance API](http://code.google.com/apis/finance/) and started looking through that but I found a lot of info about portfolios, transactions, positions & other stuff I know...

27 Feb at 20:12

How do I list all remote branches in Git 1.7+?

I've tried `git branch -r`, but that only lists remote branches that I've tracked locally. How do I find the list of those that I haven't? (It doesn't matter to me whether the command lists remote br...

12 Aug at 20:37

Nginx 403 error: directory index of [folder] is forbidden

I have 3 domain names and am trying to host all 3 sites on one server (a Digital Ocean droplet) using Nginx. mysite1.name mysite2.name mysite3.name Only 1 of them works. The other two result in 403...

How to get the class of the clicked element?

I can't figure it out how to get the `class` value of the clicked element. When I use the code below, I get `"node-205"` every time. jQuery: ``` .find('> ul') .tabs( { selectedClass: 'active', ...

21 Dec at 14:36

Validate phone number with JavaScript

I found this code in some website, and it works perfectly. It validates that the phone number is in one of these formats: or The problem is that my client (I don't know why, maybe client stuffs) ...

4 Mar at 20:10

Wait until page is loaded with Selenium WebDriver for Python

I want to scrape all the data of a page implemented by a infinite scroll. The following python code works. ``` for i in range(100): driver.execute_script("window.scrollTo(0, document.body.scrollH...

24 Jun at 08:6

Using Auto Layout in UITableView for dynamic cell layouts & variable row heights

How do you use Auto Layout within `UITableViewCell`s in a table view to let each cell's content and subviews determine the row height (itself/automatically), while maintaining smooth scrolling perform...

How to make layout with rounded corners..?

How can I make a layout with rounded corners? I want to apply rounded corners to my `LinearLayout`.

Append values to a set in Python

How do I add values to an existing `set`?

18 Jul at 03:45

MySQL server startup error 'The server quit without updating PID file'

On [Mac OS X v10.6](https://en.wikipedia.org/wiki/Mac_OS_X_Snow_Leopard) (Snow Leopard), starting MySQL gives the following error: > The server quit without updating PID file ### File my.cnf ``` [m...

29 Oct at 20:37

How do I reset a sequence in Oracle?

In [PostgreSQL](http://en.wikipedia.org/wiki/PostgreSQL), I can do something like this: ``` ALTER SEQUENCE serial RESTART WITH 0; ``` Is there an Oracle equivalent?

25 Aug at 15:48

Replace whole line containing a string using Sed

I have a text file which has a particular line something like ``` sometext sometext sometext TEXT_TO_BE_REPLACED sometext sometext sometext ``` I need to replace the whole line above with ``` Thi...

30 May at 09:14

Function to Calculate Median in SQL Server

According to [MSDN](http://msdn.microsoft.com/en-us/library/ms173454.aspx), Median is not available as an aggregate function in Transact-SQL. However, I would like to find out whether it is possible t...

What is correct content-type for excel files?

I want excel files on a website to open in Excel when clicked, not get saved on desktop, or get opened embedded in a browser etc. Now obviously it all depends on how everything is configured for each ...

30 May at 03:54

Meaning of - <?xml version="1.0" encoding="utf-8"?>

I am new to XML and I am trying to understand the basics. I read the line below in "Learning XML", but it is still not clear, for me. Can someone point me to a book or website which explains these ba...

What is a "static" function in C?

The question was about plain [c](/questions/tagged/c) functions, not [c++](/questions/tagged/c%2b%2b) `static` methods, as clarified in comments. I understand what a `static` variable is, but what is...

3 Nov at 22:48

Abort Ajax requests using jQuery

Is it possible that using jQuery, I that I have not yet received the response from?

8 Jul at 00:24

Node.js quick file server (static files over HTTP)

Is there Node.js ready-to-use tool (installed with `npm`), that would help me expose folder content as file server over HTTP. Example, if I have ``` D:\Folder\file.zip D:\Folder\file2.html D:\Folder...

23 May at 12:18

What is the best way to implement a "timer"?

What is the best way to implement a timer? A code sample would be great! For this question, "best" is defined as most reliable (least number of misfires) and precise. If I specify an interval of 15 se...

23 May at 10:31

Changing an element's ID with jQuery

I need to change an element's ID using jQuery. Apparently these don't work: ``` jQuery(this).prev("li").attr("id")="newid" jQuery(this).prev("li")="newid" ``` I found out that I can make it happ...

29 Mar at 20:0