For my first question, I ended up doing:
standard_characters=db.executesql("Select Characterz.id,
Characterz_NameLOL from Characterz where
Characterz.Characterz_IsStandard=1")
db.Story.Char_ID_Player.requires = IS_IN_SET(standard_characters,
'%(Characterz_NameLOL)s')
Which appears to work. It seems like it should be fairly
straightforward to translate this into Web2Py's query syntax.
I am still not able to see col3 in my form though, despite playing
with the 'formstyle' parameter.
On Dec 14, 3:30 pm, Shel <[email protected]> wrote:
> I have been searching for answers to a couple of questions, but
> nothing I have tried has worked so far. Any help or advice would be
> appreciated.
>
> Q1 - I have a dropdown in an SQLFORM that shows a list of character
> names based on the model in Db.Py (db.Story.Char_ID_Player.requires =
> IS_IN_DB(db, db.Characterz.id, '%(Characterz_NameLOL)s')
>
> I would like to limit this dropdown so that it only contains rows
> where the field Characterz.Characterz_IsStandard == Is there a way to
> do this?
>
> *******
>
> Q2 - I am trying to experiment with "col3" in my SQLFORM, using a
> modified version of the example in the book, but I don't see the third
> column in my form for some reason. The rest of the form looks fine.
> My form definition in the controller looks like:
>
> form = SQLFORM(db.Story,
> fields=['Char_ID_Player', 'Story_Name', 'Story_MagicWord'],
> labels={'Char_ID_Player':'Pick a karakturr', 'Story_Name':'Enter
> ur story name', 'Story_MagicWord':'Enter ur majik wurd'},
> comments=True,
> col3 = {'name':A('what is this?', _href='http://www.google.com/
> search?q=define:name')},
> submit_button='Kthx')
