values not displaying after I created valuelist

Archived from the Xataface Users forum.

chapin — Sat Nov 08, 2008 9:15 am

Hello folks!

I have a strange issue with Xataface, I first created a database and everything worked well. After some time I decided to create a select list for some fields. So I created a fields.ini file in which I put for example:

Code: Select all

... [Fakultet] widget:type = select vocabulary = Fakulteter ...

Then I created a valuelists.ini file in which I put the vocabulary

Code: Select all

... [Fakulteter] __sql__ = "select id, fakultet from Fakultet order by fakultet" ...

which as you can see fetches values from a table.

The problem is that the values that I entered previously do not display any more! When I see directly into the database my old values are still there! Weird!

When I comment the fields.ini file

Code: Select all

;[Fakultet] ;widget:type = select ;vocabulary = Fakulteter

then the previous values display again. What I am doing wrong? Maybe I forgot some settings? Any clues?

Thanks in advance!

---

shannah — Sat Nov 08, 2008 5:31 pm

If you are using a vocabulary on a field, that effectively puts a limit on the values that the field can have. If you field contains a value that is not in the valuelist it will not be displayed.

Solution. Make sure that all possible values for that field are in the valuelist.

-Steve