Xataface Forums

Im following along the tutorial
and went well except in step 7 (using value list)

when i add this code:

Code: Select all

[Programs]
__sql__ = "SELECT ProgramID, ProgramName FROM Program ORDER BY ProgramName"


There is NO options in the drop-down field

everything else works, so the tables are being recognized
I also added 2 programs to the Program's table under the Program tab

I finally started to understand this framework .... please help me get it to work

thanks guys

It is probably one of the following options:

1. Your valuelists.ini file isn't being picked up. Check that it is in the same directory as the fields.ini and that it is named exactly valuelists.ini
2. Your vocabulary directive in the fields.ini file references a different valuelist. Make sure that the value of vocabulary matches exactly the name of the valuelist (case sensitive).

-Steve

oops!! my fault.
i had 'valuelist.ini instead of valuelist.ini
i missed the apostrophy in front of the name, a typo error

it works now
thanks

it now also displas a link "other" to the right .... linking to the add new program form which pops-up
is it supposed to be like that?

thanks

Yes. If the user has the 'new' permission for the valuelist's table, it gives them the option to add an option. If you deny them this permission, then the link should disappear.

_Steve