"No records matched your request" non-empty tables

[shannah]

You could also create a View of your table but with different column names, and use that in your application instead.

[dfondente]

I will try the View approach and see if I can get that working. Thanks very much for the suggestions.

[dfondente]

I am still planning on investigating a solution using MySQL Views (not sure if this will be feasible), and also the possibility of adding a new parameter to fields.ini to allow an "alias" for a table name (so problematic tables names such as "locale" can still be used).

In the meantime, if anyone else comes across this issue with a "locale" field, placing the following in the index.php for your application makes the table records visible, allows you to search for values in the "locale" field, etc:

Code: Select all

$arrayOfValidLocaleValues = [VALID LOCALE VALUES HERE];
if ( isset($_REQUEST['locale']) and !in_array($_REQUEST['locale'], $arrayOfValidLocaleValues) ){
    unset($_REQUEST['locale']);
    if ( $_POST ) $_REQUEST['locale'] = $_POST['locale'];
    if ( $_GET ) $_REQUEST['locale'] = $_GET['locale'];
}


[shannah]

I have changed Xataface to draw its query parameters from the GET and POST arrays rather than the REQUEST array. It will be available in the next release, or you can download the latest Dataface/Application.php file from svn.

This will fix this problem without requiring the workaround.

http://weblite.ca/svn/dataface/core/tru ... cation.php