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

Reply via email to