Hello!
I guess I was not clear in the question .... I wanted to replicate information that is static in the query, it does not come from the database ... Another example: select name, address, phone number, 'marked' category from client (MS-SQL) In this case, the specific information 'marked' is replicated to all rows of the query ... De: [email protected] [mailto:[email protected]] Em nome de ?? Enviada em: quinta-feira, 17 de outubro de 2013 13:13 Para: [email protected] Assunto: [web2py] Re: Static column with value in query what do you mean about 'admin' as permission? is it user that has admin membership or alias name for column name? for query : select name, age from table_client you can do : db().select(db.table_client.name, db.table_client.age) ref: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer <http://web2py.com/books/default/chapter/29/06/the-database-abstraction-laye r#select> best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to <mailto:[email protected]> [email protected]. For more options, visit https://groups.google.com/groups/opt_out. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
