Select Widget properties

A place for users and developers of the Xataface to discuss and receive support.

Select Widget properties

Postby jonbfl » Mon Oct 17, 2011 12:08 pm

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?

:?:
jonbfl
 
Posts: 66
Joined: Thu Jul 28, 2011 8:20 pm

Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 21 guests

Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved