SELECT t.* FROM (SELECT * FROM jobs WHERE `status` IN (0,1,2,3) ORDER BY `status` DESC, job_datetime LIMIT 11, 20) AS t That's a cut down sample of my sql. It was more complicated, but I've pared it down to this just to see why I was getting some strange numbers for pagination (e.g. 10 records per page). The above returns 12 records. With the LIMIT clause on the outside, it works as expected, but that's not something I'm able to do as I need to limit the subquery for additional joins later on. Can somebody shed some light on this …

Member Avatar
Member Avatar
+0 forum 3

Just in the news: A Miami police officer fatally shot a naked man who refused to stop chewing on the face of another naked man — even after being shot once by the officer — on a busy downtown highway ramp. Have you read any other strange news lately?

Member Avatar
Member Avatar
+0 forum 3

Hello DaniWeb community! I am writing code for problem 10 of Project Euler. I have decided that the Sieve of Eratosthenes was the best option for creating a list of primes less than two million. Here is my code (yes, I mis-spelled Sieve and Eratosthenes): [CODE]package projecteulerjava; class ProblemTen { public ProblemTen() { boolean Primes[] = Erasthones(2000000); int Total = 0; for (int i = 2; i < Primes.length; i ++) { if (!Primes[i]) { boolean IsPrime = Primes[i]; Total += i; } } System.out.println("The sum of the primes up to two million is " + Total); } public static …

Member Avatar
Member Avatar
+0 forum 28

Ok, so I have an old Dell Dimension C300. It originally came with 128mb of RAM. I purchased 512mb x2, and made sure that it was "PC133U-333-542", and 133mhz - Just like the 128mb module that came with it. I installed the new RAM, and the computer turns on, but it says I only have 128mb of RAM still? Any help on this would be great - Michael

Member Avatar
Member Avatar
+0 forum 10

Hello, [I]Before you get scared away - my issue does not particular seem to relate to Quaternions or Vectors. More generally, it appears to be something compiler or C++ standard related, as my return call from the function is acting strange. You can eventually start reading the [U]concluding issue at the bottom[/U]. [B]Thank you so much![/B][/I] So I've got this class with Quaternion mathematics. This particular function (operator *) is to rotate a Vector3 based on the current Quaternion. Here's the code I want to discuss. Vector3 Class [CODE] class Vector3 { float y, z, x; ... }; Vector3 Vector3::crossProduct(const …

Member Avatar
Member Avatar
+0 forum 20

The End.