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 :-)