Hi- maybe this is really easy and I havent found it yet..
I now have a table defined in db.py, like so
db.define_table('ratings_view',
Field('flat_key', type='integer'),
Field('rating_value', type='double'),
Field('category', type='text'),
Field('credit', type='text'),
Field('subcredit', type='text'),
Field('credit_weighting', type='integer'),
Field('category_weighting', type='integer'),
Field('subcredit_weighting', type='integer'),
Field('affirm_pkey', type='integer'),
Field('date_executed', type='date'),
Field('who_string', type='text'),
primarykey=['flat_key'],
migrate=migrate) ##<- I dont know what this does yet --
I want an HTML page that has two parts, a pop-up menu with a list of
DISTINCT(affirm_pkey) at the top, and a table display below. The user
chooses an affirm_pkey, and the display table is filled with results.
In my case, there are always 253 rows per affirm_key. (this table
definition is actually a VIEW defined in postgres.. it seems to work
fine)
thanks in advance -Brian
