Yes. With a simple window function: SELECT *, count(*) OVER() AS full_count FROM tbl WHERE /* whatever */ ORDER BY col1 OFFSET ? LIMIT ? Be aware that the cost will be substantially higher than without the total number, but typically still cheaper than two separate queries. Postgres has to actually count all rows either … Read more
Use the third parameter ($limit) of explode. The resulting array will have $limit Elements. list($postcode, $city) = explode(” “, $string, 2);
You can use memcache to do this .. Simple Demo Script $memcache = new Memcache (); $memcache->connect ( ‘localhost’, 11211 ); $runtime = $memcache->get ( ‘floodControl’ ); if ((time () – $runtime) < 2) { die ( “Die! Die! Die!” ); } else { echo “Welcome”; $memcache->set ( “floodControl”, time () ); } This is … Read more
This is a limitation on the Jet OLEDB driver. One solution that might work (i.e. I haven’t tried it) would be to breakup the sheet into named ranges that are no wider than 255 columns and query for each of those separately (e.g. Select * From RangeName) and then merge the results into a single … Read more
Try something like this: class User < ActiveRecord::Base has_many :things end class Things <ActiveRecord::Base belongs_to :user validate :thing_count_within_limit, :on => :create def thing_count_within_limit if self.user.things(:reload).count >= 5 errors.add(:base, “Exceeded thing limit”) end end end Edit: updated for Rails 3
Others have explained why you might sleep for less than you asked for, but didn’t show you how to deal with this. If you need to make sure you sleep for at least n seconds you can use code like: from time import time, sleep def trusty_sleep(n): start = time() while (time() – start < … Read more
Usually you can use LIMIT and ORDER in your UPDATE statements, but in your case not, as written in the MySQL Documentation 12.2.10. UPDATE Syntax: For the multiple-table syntax, UPDATE updates rows in each table named in table_references that satisfy the conditions. In this case, ORDER BY and LIMIT cannot be used. Try the following: … Read more
You can change your input text as below: <input type=”text” pattern=”[a-zA-Z0-9!@#$%^*_|]{6,25}” /> So the code changes look like below: <form action=”#” method=”get”> User Name:<br /> <input type=”text” pattern=”[a-zA-Z0-9!@#$%^*_|]{6,25}” /><br /> Password:<br /> <input type=”password” /><br /> <input type=”submit” value=”Log In” /> </form> This will work without using JavaScript. pattern can be used instead. It is … Read more
Suppose the bottom left coordinates and the upper right coordinates are respectively [0, 0] and [100, 100]. From MongoDB 3.2 you can use the $slice operator to return a subset of an array which is what you want. db.collection.aggregate([ { “$match”: { “loc”: { “$geoWithin”: { “$box”: [ [0, 0], [100, 100] ] } }} … Read more
I recommend working by obtaining the first page using: LIMIT 0, 10 then for the second page LIMIT 10, 10 then LIMIT 20, 10 for the third page, and so on.