Under the Hood - Entries from Friday, June 11. 2004

<code>pxdb_collection::set_order()</code> fixed

Friday, June 11. 2004

I updated the pxdb_collection class to no longer need to call pxdb_collection::find() after calling pxdb_collection::set_order(). Now you can either explicitly call pxdb_collection::execute() or simply start iterating through your list with pxdb_collection::fetch_record(), which calls pxdb_collection::execute() automatically if there's no result set.

Posted by sandy in Under the Hood at 12:02

Changing the order of results: set_order() & find()

Friday, June 11. 2004

Problem: I want to change the order in which my records are returned, in SQL this is 'order by my_field ASC'. I see that the pxdb_collection class has the set_order() method, but when I try this it doesn't seem to work. My code is:

        $Records = &new pxdb_collection(DATATYPE_DOCUMENT);
        $Records->set_order('sunrise DESC');
        echo $Records->get_sql();

Continue reading "Changing the order of results: set_order() & find()"

Posted by ncowham in Under the Hood at 11:14 | Comments (0) | Trackbacks (0)

(Page 1 of 1, totaling 2 entries)

About SyntaxCMS

SyntaxCMS is an Open Source Content Management System project sponsored by Forum One Communications. Forum One is a firm based in Washington DC with the singular mission of applying significant technologies to public policy issues of importance.