you should set a primaryekey into the definition of the table.. (see http://groups.google.com/group/web2py/msg/c9848792a8999c5f)
I think that simple selects are possibile on views.... On 13 Giu, 08:57, Sky <[email protected]> wrote: > I need to display data from a VIEW ( not table) of database. > can any one help me ? > i used dein_table, am i correct ? > db.define_table("vwparts_inetflowbase", > SQLField("pyear", "string"), > SQLField("pmonth", "string"), > SQLField("pday", "string"), > SQLField("phour", "string"), > SQLField("portsd","string"), > SQLField("portnumber", "string"),migrate=False) > > my does not have 'id' column. > and when i run "db.vwparts_inetflowbase.portnumber <> 0" query in > "appadmin/select/db" i get > "Invalid Query : column vwparts_inetflowbase.id does not exist" > is this problem occurs for function calls too ? > my database is PostgreSQL. > > thanks :-)
