Oops, that first question should be: I would like to limit this dropdown so that it only contains rows where the field Characterz.Characterz_IsStandard == 1
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')
