generate days from date range

generate days from date range

I would like to run a query likeselect ... as days where `date` is between '2010-01-20' and '2010-01-24'And return data like: days----------2010-01-202010-01-212010-01-222010-01-232010-01-24 1:This solution uses no loops, procedures, or

In JavaScript can I make a “click” event fire programmatically for a file input element?

In JavaScript can I make a “click” event fire programmatically for a file input element?

I'd like to make a click event fire on an tag programmatically.Just calling click() doesn't seem to do anything or at least it doesn't pop up a file selection dialog.I've been experimenting with capturing events using li

Update statement with inner join on Oracle

Update statement with inner join on Oracle

I have a query which works fine in MySQL, but when I run it on Oracle I get the following error: SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended"The query is:UPDATE table1INNER JOIN tab

How to make a div 100% height of the browser window?

How to make a div 100% height of the browser window?

I have a layout with two columns - a left div and a right div.The right div has a grey background-color, and I need it to expand vertically depending on the height of the user's browser window. Right now the background-color ends at the la

Websockets and binary data

Websockets and binary data

As far as i know websockets support binary data transfer. Binary support bug is fixed.So, are there any websocket servers which support binary data transfer? Socket.io seems to miss this opportunity. Maybe there are some others? 1:Suppor

jQuery fileupload not working in IE 8 and 9

jQuery fileupload not working in IE 8 and 9

This code works in FF and chrome. In IE 8 or 9 I get a 500 error saying a not null property is null.Here is the html Add Documents... Documents

Switching from Eclipse to IntelliJ: Is there a way to split tool windows?

Switching from Eclipse to IntelliJ: Is there a way to split tool windows?

Having used Eclipse for more years than I care to admit, I'm currently trying to get adjusted to IntelliJ 12 but I'm having a hard time with the totally different UI metaphors/concepts. I'd like to be able to have a window layout like this:

Asset Catalog Compiler Error

Asset Catalog Compiler Error

I'm not sure what I did to get this error in Xcode 5: "None of the input catalogs contained a matching app icon set named "AppIcon"".My app was building fine - then my machine locked up tighter than the arctic - don't know why - and now I

How to compile on multiple cores using mingw inside QTCreator

How to compile on multiple cores using mingw inside QTCreator

I have a quad-core i7 CPU on my windows desktop. I am trying to get mingw32-make to compile using as many core as possible. I have added -j8 into the "Make Arguments" fields under Build Settings->Build Steps. mingw32-make seems to completel

UIButton in Swift is not registering touches

UIButton in Swift is not registering touches

I'm trying to create a UIButton using Swift. It compiles fine and I can see my button in the simulator, but when I click it, nothing happens. This is the code I am using:let settings = UIButton()settings.addTarget(self, action: "touchedSet:

Dynamically define named classes in Ruby

Dynamically define named classes in Ruby

I am writing an internal DSL in Ruby. For this, I need to programmatically create named classes and nested classes. What is the best way to do so? I recon that there are two ways to do so:Use Class.new to create an anonymous class, then

Getting typed results from ActiveRecord raw SQL

Getting typed results from ActiveRecord raw SQL

In Sequel, I can do:irb(main):003:0> DB["select false"].get=> falseWhich returns a false boolean. I'd like to be able to do something similar in ActiveRecord:irb(main):007:0> ActiveRecord::Base.connection.select_value "select false"=> "f"A

ASP.NET MVC Error Handling - Remove aspxerrorpath

ASP.NET MVC Error Handling - Remove aspxerrorpath

I'm working on some error handling in my MVC app, and I'd like to change asperrorpath to something that doesn't give away the fact that I'm using .NET... something like pathCan anyone give me some direction on how to change that out? 1:A

TortoiseGit-git did not exit cleanly (exit code 1)

TortoiseGit-git did not exit cleanly (exit code 1)

I got this message when i tried to create repository by using Git clone.git did not exit cleanly (exit code 1)How to fix this? 1:Try these two commands in git bash:1) git gc --force2) git fetch -p 2:Sometimes it happens because of inc

How do I perform a case-sensitive search using LIKE?

How do I perform a case-sensitive search using LIKE?

I'm trying to find records that contain a string of 6 or more alpha-numeric characters in uppercase. Some examples:PENDING 3RDPARTY CODE27I'm using the following statement:SELECT DetailsFROM MyTableWHERE Details LIKE '%[0-9A-Z][0-9A-Z][0

Loading fixtures in django unit tests

Loading fixtures in django unit tests

I'm trying to start writing unit tests for django and I'm having some questions about fixtures:I made a fixture of my whole project db (not certain application) and I want to load it for each test, because it looks like loading only the fix

android.os.Bundle cannot be resolved in libgdx Android project

android.os.Bundle cannot be resolved in libgdx Android project

I've just started using Libgdx to practice making games and I used the project creation .jar provided on the site to create the initial projects. However an error shows up in the Android project which says: android.os.Bundle cannot be res

Create a class at runtime - Why do NSClassFromString AND objc_getclass return nil?

Create a class at runtime - Why do NSClassFromString AND objc_getclass return nil?

I've tried using both:NSClassFromString and objc_getclass to return a class, so I can create it at runtime, but both functions return nil for some classes, for example "TestClass". Note that NSClassFromString works for me for 99% of classes

Launch Google maps app from iPhone application.

Launch Google maps app from iPhone application.

I'm trying to launch google maps from my iPhone application. The launching part works fine but since the iPhone 3.1 update (i think it was around this time) I get a zoomed out map of the US and Canada rather than zoomed in on my current lo

How to reload a chrome extension automatically?

How to reload a chrome extension automatically?

I am developing a chrome extension, and I found that there are repeating useless manual reloading works.When you save a file, you have to refresh the chrome:\\extensions page to let browser to reload the extension. And then you have to relo

Fast counting of 2D sub-matrices withing a large, dense 2D matrix?

Fast counting of 2D sub-matrices withing a large, dense 2D matrix?

What's a good algorithm for counting submatrices within a larger, dense matrix? If I had a single line of data, I could use a suffix tree, but I'm not sure if generalizing a suffix tree into higher dimensions is exactly straightforward or t

How to compile the smallest possible V8 library for Windows?

How to compile the smallest possible V8 library for Windows?

I'm making a game engine for school, and I want to use Google's V8 to allow for JavaScript scripting in-engine. The engine is written using Visual Studio 2013, and as the final game must not exceed 50MB, I want to keep the V8 filesize impac

Excel won't open/launch VSTO AddIn when running in debug mode of Visual Studio 2010

Excel won't open/launch VSTO AddIn when running in debug mode of Visual Studio 2010

I had previously installed the VS11 beta, and had some issues with my Visual Studio 2010 instance, which you can see here how they were resolved: Excel AddIn Click Once deployment issue.Now I have a code base which compiles/builds a vsto, w

Using IIS Application Request Routing (ARR) for ASP.NET MVC

Using IIS Application Request Routing (ARR) for ASP.NET MVC

I use a simple ASP.NET MVC web (the template you use when you create a new site) and the web works as expected in my live environment.I now try to use IIS Application Request Routing version 2. I have a rule that send all requests to a diff

How to find out if an email is already registered with Firebase Simple Login?

How to find out if an email is already registered with Firebase Simple Login?

I am using firebase (with Angularfire) for an html5 phone app. The user inputs only their email in the start screen, and then, depending on whether that email is already registered or not, the user is redirected to the login or registration