Hi there, I'm new to Web2Py and Python as well and I'm having trouble creating a form that does a search using a select/option, itself built with a query.
I can get the result I want from the web2py shell: >>> for row in db4().select(db4.data_table.MacAddr, distinct=True): ... print row.MacAddr ... 00000000000000E0 00000000000000DF 00000000000000BB 00000000000000D1 00000000000000BD 00000000000000C0 00000000000000B1 00000000000000E5 00000000000000B3 00000000000000B4 00000000000000D2 00000000000000DA 00000000000000C1 00000000000000D8 00000000000000AF 00000000000000BE 00000000000000D9 00000000000000DC 00000000000000BA 00000000000000B5 00000000000000B9 but what I want is a popup in a form that will allow the user to choose which MacAddr to pull the data for (as well as a time span, the database contains data for each MacAddr every 6 seconds, the sample data set I have contains over 2.5M records). I did some googling and found this: <http://wiki.web2py.com/Form_Select_Options_from_DB>, but my version was giving me line continuation errors. I could use some hand-holding, can someone walk me through the parts (i.e., controller and view code to achieve this)? -- Lorin Rivers Mosasaur: Killer Technical Marketing <http://www.mosasaur.com> <mailto:lriv...@mosasaur.com> 512/203.3198 (m)
