order

How can I order entries in a UNION without ORDER BY?

How can I be sure that my result set will have a first and b second? It would help me to solve a tricky ordering problem. Here is a simplified example of what I'm doing: SELECT a FROM A LIMIT 1 UNION SELECT b FROM B LIMIT 1; ...

Is there a way in SQL (MySQL) to do a "round robin" ORDER BY on a particular field?

Is there a way in SQL (MySQL) to do a "round robin" ORDER BY on a particular field? As an example, I would like to take a table such as this one: +-------+------+ | group | name | +-------+------+ | 1 | A | | 1 | B | | 1 | C | | 2 | D | | 2 | E | | 2 | F | | 3 | G | | 3 | H | | ...

SQL, Order By - How to give more authority to other columns?

Hello all, I have this SQL statement: SELECT * FROM converts WHERE email='[email protected]' AND status!='1' ORDER BY date ASC, priority DESC This just orders by date but I want to give my column "priority" more authority. How can I do this? It should order by date first but if the time between two records is 10 mintues then...

Is Java foreach iteration order over primitives precisely defined?

Example code: int a[] = new double[]{0, 1, 2, 3}; int result = 0; for (int i : a) result += i; Is the loop guaranteed to iterate across a[0], a[1], a[2], a[3] in that order? I strongly believe the answer is yes, but this page seems to not unambiguously state order. Got a solid reference? ...

When does a java object become non-null during construction?

Hi, Say you are creating a java object like so: SomeClass someObject = null; someObject = new SomeClass(); At what point does the someObject become non-null? Is it before the SomeClass() constructor runs or after? To clarify a little, say if another thread was to check if someObject was null while the SomeClass() constructor was hal...

With partial classes, what controls order?

As discussed in http://stackoverflow.com/questions/431203/does-the-order-of-fields-in-c-matter, the order of serializable properties affects, among other things, XmlSerializer output. But if fields are in 2 files (using partial classes), does anyone know what in fact controls the resulting order? That is, which file's properties comes ...

How to bypass Safari option re-ordering in a select ?

Hello everybody! Im writing a admin panel for a customer's sites, and at few places, i need to put a list of country. He want's to get Canada and US in first place, because his market are mainly US and Canada. So, i write something like that : <select name="customerCoutry"> <option value="US">United States</option> <option ...

Updating display order of multiple MySQL rows in one or very few queries

I have a table with say 20 rows each with a number for display order (1-20). SELECT * FROM `mytable` ORDER BY `display_order` DESC; From an admin area you can drag the rows around or type a new number manually for each row. Surely it's not good to loop over an UPDATE query for every row, what's an alternative in one or very few queri...

In which order should classes be declared in C++?

Say I got this C++ code: class class1{ class2 *x; } class class2{ class1 *x; } The compiler would give an error in line 2 because it couldn't find class2, and the same if i switched the order of the classes. How do I solve this? ...

Ruby: Want a Set-like object which preserves order

... or alternatively an Array which prevents duplicate entries. Is there some kind of object in Ruby which: responds to [], []= and << silently drops duplicate entries is Enumerable (or at least supports find_all) preserves the order in which entries were inserted ? As far as I can tell, an Array supports points 1, 3 and 4; while a Se...

Order of condition checking?

(EDIT: Duplicate of "Why does one often see “null != variable” instead of “variable != null” in C#?". Even if C# isn't the language in question, the answers to that question give the reason one might want to do it in some languages.) This is a somewhat philosophical question. However,... maybe there is a technical answer. I don't know. ...

Nhibernate criteria query inserts an extra order by expression when using JoinType.LeftOuterJoin and Projections

Why would this nhibernate criteria query produce the sql query below? return Session.CreateCriteria(typeof(FundingCategory), "fc") .CreateCriteria("FundingPrograms", "fp") .CreateCriteria("Projects", "p", JoinType.LeftOuterJoin) .Add(Restrictions.Disjunction() .Add(Restrictions.Eq("fp.Recipient.Id", recipientId)) ....

MyEclipse+Hibernate does not order property sets by ID?

I use Hibernate with Java. I have two tables which are associated with foreign keys. Table: country Fields: ID, Name POJO class name : Country POJO class properties: id, name, cities Table: city Fields: ID, Name, CountryID POJO class name : Country Then I use "hibernate reverse engineering" of MyEclipse. It creates DAOs, abstracts ...

mysql order by select -- possible?

Here is my table setup: mysql> describe a; +-------+------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | x | int(11) | YES | | NULL ...

How to sort search results on multiple fields using a weighting function?

I have a Lucene index where every document has several fields which contain numeric values. Now I would like to sort the search result on a weighted sum of this field. For example: field1=100 field2=002 field3=014 And the weighting function looks like: f(d) = field1 * 0.5 + field2 * 1.4 + field3 * 1.8 The results should be ordered ...

Saving the order of a list (php/zend/jquery)

I'm using the jQuery library to have an ordered list with the ability to re-order items with drag and drop. I want to send the information of the order to the database and the next time you refresh the page (or load it on another browser/computer) it would have your order. I have a table for each element of the list in mySQL and right n...

MySQL query ordering data two ways

Hello, I am tracking page views within modules using the following table: id | page_id | user_id | session_id | created Every page is unique to a certain module; so page 14 only exists in module 2, for instance. I am trying to write a query that tells me when a viewing session began (GROUP BY session_id) for a particular module, but...

Why does the order of my #includes matter? (C++)

I've created a header file called "list_dec.h", put it in a folder "C:\Headers", and set my compiler to include files from "C:\Headers", so now I can do things like #include<list_dec.h> int main(){return(0);} but when I try to do something like #include<iostream> #include<list_dec.h> int main(){return(0);} I get an error (not anyth...

How to force destruction order of static objects in different dlls?

I have 2 static objects in 2 different dlls: An object Resources (which is a singleton), and an object User. Object User in its destructor has to access object Resources. How can I force object Resources not to be destructed before object User? ...

C# tree/collection algorithm

I need to fill a tree-like UI control with some items (of course in parent-child1-child2-...childN relations) and before proceeding I want to ensure that the my collection that holds the content is ordered properly as follows: Each object(in this case an instance of my Category class) from my collection (ObservableCollection that is not...