Select n random rows from SQL Server table
I've got a SQL Server table with about 50,000 rows in it. I want to select about 5,000 of those rows at random. I've thought of a complicated way, creating a temp table with a "random number" column, ...
- Modified
- 30 Sep at 04:6
Detect all changes to a <input type="text"> (immediately) using JQuery
There are many ways the value of a `<input type="text">` can change, including: - - - - I want my JavaScript function to be called (with the current input value) any time it changes. And I want it...
- Modified
- 9 Apr at 04:50
How to generate JSON data with PHP?
``` CREATE TABLE Posts { id INT PRIMARY KEY AUTO_INCREMENT, title VARCHAR(200), url VARCHAR(200) } ``` ``` <?php $sql=mysql_query("select * from Posts limit 20"); echo '{"posts": ['; while($row=my...
Copying PostgreSQL database to another server
I'm looking to copy a production PostgreSQL database to a development server. What's the quickest, easiest way to go about doing this?
- Modified
- 19 Jun at 17:7
Can linux cat command be used for writing text to file?
Is something like this: ``` cat "Some text here." > myfile.txt ``` Possible? Such that the contents of `myfile.txt` would now be overwritten to: ``` Some text here. ``` This doesn't work for me,...
How to get the name of the current method from code
I know you can do ``` this.GetType().FullName ``` To get ``` My.Current.Class ``` But what can I call to get ``` My.Current.Class.CurrentMethod ```
- Modified
- 31 Jan at 16:13
How can I iterate over an enum?
I just noticed that you can not use standard math operators on an `enum` such as `++` or `+=`. So what is the best way to iterate through all of the values in a C++ `enum`?
Difference between abstraction and encapsulation?
What is the precise difference between encapsulation and abstraction?
- Modified
- 18 Dec at 08:22
How to update a record using sequelize for node?
I'm creating a RESTful API with NodeJS, express, express-resource, and Sequelize that is used to manage datasets stored in a MySQL database. I'm trying to figure out how to properly update a record u...
- Modified
- 22 Jul at 12:56
Good Hash Function for Strings
I'm trying to think up a good hash function for strings. And I was thinking it might be a good idea to sum up the unicode values for the first five characters in the string (assuming it has five, oth...
jquery $(window).width() and $(window).height() return different values when viewport has not been resized
I am writing a site using jquery that repeatedly calls `$(window).width()` and `$(window).height()` to position and size elements based on the viewport size. In troubleshooting I discovered that I am...
What's the best way to determine which version of Oracle client I'm running?
The subject says it all: What is the best way to determine the exact version of the oracle client I'm running? Our clients are all running Windows. I found one suggestion to run the tnsping utility...
What is the difference between "screen" and "only screen" in media queries?
What is the difference between `screen` and `only screen` in media queries? ``` <link media="screen and (max-device-width: 480px)" rel="stylesheet" href="m.css" /> <link media="only screen and (max-d...
- Modified
- 16 Apr at 22:39
Getting distance between two points based on latitude/longitude
I tried implementing the formula in [Finding distances based on Latitude and Longitude](http://andrew.hedges.name/experiments/haversine/). The applet does good for the two points I am testing: ![Enter...
SQL Server : converting varchar to INT
I am stuck on converting a `varchar` column `UserID` to `INT`. I know, please don't ask why this `UserID` column was not created as INT initially, long story. So I tried this, but it doesn't work. an...
- Modified
- 23 May at 16:14
How to convert a string of numbers to an array of numbers?
I have below string - ``` var a = "1,2,3,4"; ``` when I do - ``` var b = a.split(','); ``` I get `b` as `["1", "2", "3", "4"]` can I do something to get `b` as `[1, 2, 3, 4]` ?
- Modified
- 31 Jul at 22:29
Excel formula to get cell color
I would like to know if we can find out the Color of the CELL with the help of any inline formula (without using any macros) I'm using Home User Office package 2010.
- Modified
- 7 Jul at 08:7
List of foreign keys and the tables they reference in Oracle DB
I'm trying to find a query which will return me a list of the foreign keys for a table and the tables and columns they reference. I am half way there with ``` SELECT a.table_name, a.column_...
- Modified
- 20 Oct at 10:59
Ruby: Can I write multi-line string with no concatenation?
Is there a way to make this look a little better? ``` conn.exec 'select attr1, attr2, attr3, attr4, attr5, attr6, attr7 ' + 'from table1, table2, table3, etc, etc, etc, etc, etc, ' + ...
- Modified
- 13 Feb at 09:18
Validating IPv4 addresses with regexp
I've been trying to get an efficient regex for IPv4 validation, but without much luck. It seemed at one point I had had it with `(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?(\.|$)){4}`, but it produces some ...
- Modified
- 10 May at 08:50
Upgrading PHP in XAMPP for Windows?
I would like to know how you upgrade PHP in Xampp for Windows? I tried to download the latest PHP version from the main PHP site but when I check (phpinfo) I still get that the previous version is sti...
Git command to show which specific files are ignored by .gitignore
I am getting my feet wet with Git and have the following issue: My project source tree: ``` / | +--src/ +----refs/ +----... | +--vendor/ +----... ``` I have code (currently MEF) in my vendor branc...
Loop a multidimensional array and only print two specific column values per row
How can I print the filepath and filename values from each row? ``` Array ( [0] => Array ( [fid] => 14 [list] => 1 [data] => Array ( ...
- Modified
- 16 Jan at 07:56
How do I check if a given Python string is a substring of another one?
I have two strings and I would like to check whether the first is a substring of the other. Does Python have such a built-in functionality?