order

E-commerce package for PHP / Customer management and "order tracking"

Hi, We're developing a PHP based website through which people can subscribe to certain services. I'm looking for a solution (open-source or reasonably priced) that helps track customer's orders - what have they ordered --> have they paid or not --> has that been approved by the site administrator, etc. The end-user can have multiple sub...

How do I get previous and next rows even though some rows have been deleted?

Hello all, I have the following PHP functions that determine the next and previous rows in a database. However, there are lots of occasions when rows can be deleted and therefore my functions will not work as all they do is decrement the auto_increment field. For example, current row 5. My function gives: 4 (previous) and 6 (next). Wha...

How to Determine the Sort Order of an NHibernate ICriteria Object?

What is the best way to retrieve the list of Orders added to an ICriteria object using the AddOrder method? I believe this will have to be accomplished using Reflection, but what to reflect on? The purpose of doing this is that I would like to pass the sort order back to the UI so an indication of the sort order can be provided to the u...

How do I return rows with a specific value first?

I want my query to return the rows of the table where a column contains a specific value first, and then return the rest of the rows alphabetized. If I have a table something like this example: - Table: Users - id - name - city - 1 George Seattle - 2 Sam Miami - 3 John New York - 4 Amy New York - 5 Er...

MySQL indices and order

This is a question that I've had forever. As far as I know the order of indices matter. So an index like [first_name, last_name] is not the same as [last_name, first_name], right? If I only define the first index, does it mean that it will only used for SELECT * FROM table WHERE first_name="john" AND last_name="doe"; and not for SELEC...

Is Perl guaranteed to return consistently-ordered hash keys?

Given something like foreach (keys %myHash) { ... do stuff ... } foreach (keys %myHash) { ... do more stuff ... } Is Perl guaranteed to iterate over the keys in a consistent order if the hash is not altered? ...

Using ORDER and GROUP with MySQL to get the highest number for each GROUP

I have made a simple auction section on my site, and I would like to display the user's current high bid on their My Bids page. I have a table that holds each unique bid that has the unique auction_id. My current query is as follows, but this only orders the groups instead of ordering what is inside the groups as well. I only want the...

How to force sequence of updates in DB

I have this table: old_id integer NOT NULL, new_id integer Now I want to update new_id with a sequence in such a way that the order of old_id is preserved. Basically: update table set new_id = sequence.NEXTVAL order by old_id Is something like this possible? If it matters, I'm on Oracle 10g. ...

Google AppEngine Query Order

How can I order the results of Query using more than 1 property? For example, I want to order my Query results by 'lastname' and order by 'firstname' in each group of 'lastname'. ...

Ordering a django change list page via jQuery?

I would like to be able to reorder lists of Models via a jQuery script. I already have reordering within inLines on the Model update page, but I'd like to add it to the change_list page aswell? Is this possible? I'm using Django 1.1 so have access to action sheets, if that makes things easier... Any information would be appreciated. ...

How to change TestNG dataProvider order

Hi, I am running hundreds of tests against a large publishing system and would like to paralellize the tests using TestNG. However, I cannot find any easy way of doing this. Each test case instanciates an instance of this publisher, send some messages, wait for those messages to be published, then dump out the contents of the publish qu...

Reversed order of constructor calls by inheriting a constructor

I have a class that first needs to call the derived class constructor before it calls the base constructor. I know that by the following code the base constructor will be called first public class A { protected A () { //do something } } public class B : A { public B () : base() { //do something else }...

C# Winform UI Componets Layer Order

C# | Winforms When we add any UI or container in winforms, the later added component comes over the earlier added components, we can say it is in a higher layer..how to change that layer order or component order after adding components ...

manual orders problem, more then 10 products in an order will let the order disapear (oscommerce)

Hi, I got the Order Editor contribution, it's working fine. But when i make a manual order in the admin panel, with order editor some orders dissapear when i add more then 10 products. Also the Total order with price, tax and discount will dissapear when I add more then 10. How can I solve this ? Thanks in advance, djairo ...

Ruby - Executing tests in a random order with rake

How can I have the tests for my Rails app to be executed in a random order? Is there a simple solution using rake? ...

Can Doxygen output members purely in order of declaration?

Which Doxygen option can completely disable sorting members by type (Private / Public / Method / Variable), and output members purely based on the order in which they were declared? ...

What is the most efficent way of updating an "order" column in MySQL via PHP.

I'm currently creating a Flash CMS via Flex and the Zend Framework. In the Flex interface, I have a list of drag-able items pulled from a MySQL database via the Zend Framework. The user can rearrange the items by dragging and dropping them which will change their order in the mapped Flex array. Back on the server I have a column in my ...

SQL Mass Reordering of rows

Hi, I have a table with a list of records, and a column called order. I have an AJAX script to drag and drop the table rows up or down which I want to use to perform a query, reordering the rows as they have been dragged. In the PHP, I perform a query to get the current order of the records. eg 1, 2, 3 ,4 The AJAX function passes the ...

Ordering by multiple fields in SQLite.

I have a simple table, something like: int id, date created_at, date updated_at. I'd like to order the rows so that any rows that have an updated_at will be sorted by that, and any that don't will be sorted by the created_at. The problem is that something like: SELECT * FROM table ORDER BY updated_at, created_at doesn't work. I've bee...

Order Django admin change list column by output of __unicode()__ method

Here's part of my Django app's models.py: class Person(models.Model): birth_year = WideYear(null=True, blank=True) birth_year_uncertain = models.BooleanField() death_year = WideYear(null=True, blank=True) death_year_uncertain = models.BooleanField() flourit_year = WideYear(null=True, blank=True) flourit_year_unce...