|
I am trying to create a form for my php/mysql application. I want my users to list the priority of thier choices where they have 5 options and they have to choose each in order of preference
Started by prince on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
For example, start with:
Favorite Friends: 1 Pax ^ v 2 Litb ^ v .
A higher/lower control on the right of each to change the order? That's always more attractive than assigning an out-of-order sequence number.
|
|
I have two tables
order [ order_id ] order_line [ order_id, product_id, cat_id ]
I want to select every order & associated order_line, but I want row per order, and i only want to select cat_id from order_line
so i want a result like this..
results: [...
Started by pablo on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
GetCateogriesForOrder(order_ID) FROM order GO
Try this example:
if object_id('tempdb @maxOrderCat=(....
Output + ', ', '') + cat_id from order_line where order_id = @orderID return @output END GO SELECT order_ID, dbo.
|
|
Why does STL work with a comparison function that is strict weak ordering? Why can't it be partial ordering?
Started by FL4SOF on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
A partial order would not be sufficient to implement some algorithms, such as a sorting algorithm of the set, how would you sort a list of two items that do not have an order relationship within the partial order?
You can implement....
|
Ask your Facebook Friends
|
Let's say I have a list of objects:
var items = new { new { Order = 0 }, new { Order = 1 }, new { Order = -1 }, new { Order = 3 }, new { Order = 2 }, new { Order = -1 } };
I need to order it so that items with "Order > -1" be on top of the list ordered...
Started by Koistya Navin on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
This....
Public class MyComparer : IComparer<int> in a descending order.
Use a custom comparer to define the order you want.
If you order by ascending, -1 should already be at the top of the list, because it is the smallest for.
|
|
Hello
I have the following query (I'm using mysql)
SELECT * FROM campaigns where campaign_id IN ( 'idStrOne', 'idStrTwo', 'idStrThree' );
The results of which are being ordered by the primary key of the table campaigns which is 'id'. This is not the order...
Started by neilc on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You could try adding a CASE expression in the ORDER BY Clause
SELECT * FROM campaigns WHERE campaign_id IN ( 'idStrOne', 'idStrTwo', 'idStrThree' ) ORDER BY (CASE campaign_id WHEN 'idStrOne' THEN 1/questions/396748/ordering-by-the-order....
|
|
What is the best structure for an Orders table having OrderNumber, ItemNumber and CustID that allows for 1 or more item numbers for each order number?
Started by ScottK on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Orders orderid custid
Order Items orderid itemnumber
basket/order - table
1 : order-id -- item-id -- item-count/Quantity
cust/order history table
2 : cust-id -- order-id -- status (when you find out which keeps....
|
|
I have a model that has an ordering field under its Meta class. When I perform a query and get back a QuerySet for the model it is in the order specified. However if I have instances of this model that are in a list and execute the sort method on the ...
Started by hekevintran on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Class Person(models.Model): for order in self._meta.ordering: if order.startswith('-'): order = order[1:] mode = -1 else: mode = 1 if hasattr(self....
The ordering fields and even detect the ones that are in reverse order.
|
|
Is order of elements returned from query supposed to match order of elements in document in 1.3.2 version of jQuery. I am doing following select from unordered list.
$el.parents('li')
and it is returning it in reversed order, from bottom up.
$el is three...
Started by epitka on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
This is because maybe you want the first <li> parent of traversal is top to bottom, the... .
That is the order of parents for the element, it's the order they come in when looking at parents...the order is by definition backwards.
|
|
Hello,
I have an already existing order class with many properties and methods. I need to now create a suborder class which is a subset of the order class. It not only has many of the fields that order class has, it also would have many of the same calculation...
Answer Snippets (Read the full thread at stackoverflow):
Although the Order a common base class (or....
It seems to be a case for refactoring...
If a suborder does not share all of the properties of order, I would not derive Suborder from Order Order and Suborder from the base class.
|
|
I am wondering if there is away (possibly a better way) to order by the order of the values in an IN() clause.
The problem is that I have 2 queries, one that gets all of the IDs and the second that retrieves all the information. The first creates the ...
Started by Darryl Hein on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
WHERE id IN (SELECT id FROM table1 WHERE...) ORDER BY (SELECT display_order FROM table1 WHERE...), (SELECT name FROM table1 WHERE...)
The WHEREs id IN ([ids from first]) ORDER BY field....
Give this a shot:
SELECT name, description, ...
|
