Xataface Forums

OK, I.m going for broke to solve my two or three 'Select' issues -

First up - I's like to return two values from a lookup.

I have a table of ISO country codes (pais) and the associated names (nombre)

I'd like to have the Select widget display both the ISO Country Code and the Country's proper name.

I had used this code before to work with a relationship, but I can't seem to get it turned around for this exercise
/tables/casos/ casos is the table that will store the value of pais_codigo from the table pais.
pais.php

Code: Select all

<?php
/* I need to declare a class - its the table with the info */
   class tables_pais {
   function getTitle(&$record) {
      return $record->val('codigo_pais');
   }
   function titleColumn(){
      return "CONCAT(codigo_pais,' ',nombre_pais)";
   }
}
?>


valuelists.ini

Code: Select all

[pais]
__sql__ = "SELECT id_pais, codigo_pais FROM pais ORDER BY id_pais"
[regiones_departmentos]'


fields.ini

Code: Select all

[codigo_pais]
widget:type = select
vocabulary = pais


Is my problem that I have both a pais.php and a valuelists.ini entry ??? n Or do I just have the wrong returned value?