Xataface Forums

I am trying to follow the suggestion in the wiki here http://xataface.com/documentation/how-to/list_tab. I want my application to start with a particular column sorted in descending order. I have added a line to my index.php as follows. It is a vinyl record collection database and the 'latestmusic' table has a 'Shelf' field with the catalog number in it that I want to be sorted in descending order. The code seems to have to effect.

Code: Select all

<?php
if ( !isset($_REQUEST['-sort']) and @$_REQUEST['-table'] == 'latestmusic' ){
    $_REQUEST['-sort'] = $_GET['-sort'] = 'Shelf desc';
}
/**
* File: index.php
* Description:
* -------------
*
* This is an entry file for this Dataface Application.  To use your application
* simply point your web browser to this file.
*/
$time = microtime(true);
   // use the timer to time how long it takes to generate a page
require_once '/var/www/xataface/dataface-public-api.php';
   // include the initialization file
df_init(__FILE__, '/xataface');
   // initialize the site
$app =& Dataface_Application::getInstance();
   // get an application instance and perform initialization

$app->display();
   // display the application
$time = microtime(true) - $time;
echo "<p>Execution Time: $time</p>";
?>