seems DAL does not support views, yes ?
On Jun 13, 10:57 am, 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 :-)
