Stuck in step 7 in tutorial (using value list)

Archived from the Xataface Users forum.

jprieto — Tue Jan 08, 2013 1:02 pm

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

shannah — Tue Jan 08, 2013 1:22 pm

It is probably one of the following options:

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
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

jprieto — Tue Jan 08, 2013 10:17 pm

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

shannah — Wed Jan 09, 2013 10:03 am

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