web2py-users

why not just: # start to form query: q = db.counters.c_date >= datum_od if ...: # continue to form

Solved. The problem was that I was addressing 'single_value_field' without the context of the

I forgot to say on the previous message that if you need I can show you the code. sábado, 4 de Maio

The solution is .belongs() http://web2py.com/books/default/chapter/29/06/the-database-abstraction-

On Thursday, October 12, 2017 at 12:45:05 PM UTC-4, Ricardo Oliveira wrote: Hi Anthony, Thanks for

workers_infos = db((query_wi)&(db.workers_info.wi_organization == org) & (db.workers_info.

In SQL Server, you can run queries across database tables following the syntax you mention if you

here: http://web2py.com/books/default/search/29?search=groupby s = db.table.field_a | db.table.

Its help me alot Thanks

Thanks Anthony, I should use rows... I had investigate that with help postgresql log and as you said

I used event handler as you said now the issue i have is to set the value of amt to the one returned

> Common filters only add to query, but I need to change/replace fields/expressions . Why don'

Thanks for exploring this Anthony, Yes, I guess having .limit() and .offset() would make it easier to

On Friday, December 23, 2016 at 10:24:29 PM UTC-5, Jurgis Pralgauskis wrote: Yes, I did --recursive,

Maybe try to replace db.auth_user.id with auth.user.id or just auth.user_id On Friday, December 9,

The great job .. I am just looking in your project awesome.. Now I go studying more framework to help

You can also simply specify a query as raw SQL: db(('1 = 1')).select(db.mytable.ALL) Anthony

Notice : db().select(...) empty set will be abandonned (deprecated) probably... So better to specify

Many Thks. It looks nice:) I'll give a try bye On Fri, May 13, 2016 at 2:21 PM, Anthony <

Use the argument groupby instead of distinct, and you'll get the desired results. so groupby

Wouldn't the sort in numpy will do the same? http://docs.scipy.org/doc/numpy-1.10.1/reference/

Thanks that's exactly what I was looking for! On Tuesday, 24 November 2015 14:44:18 UTC-5, Jim S

Workaround it like that : if someflag: try: base_date = db.other_table.received_timestamp.date()

I managed it by using older answers on post: https://groups.google.com/forum/#!searchin/web2py/grid

Ok you right... orderby=id On Wed, Sep 9, 2015 at 3:06 PM, Michele Comitini <michele.comitini@

Hi, With user logged in on 2.11.2-stable+timestamp.2015.05.30.16.33.24 (Running on Apache/2.4.7 (

Done! El domingo, 23 de agosto de 2015, 2:10:27 (UTC+2), Massimo Di Pierro escribió: Can you please

El domingo, 28 de junio de 2015, 10:06:53 (UTC+2), Davy Jacops escribió: Villas's solution works

I figured out my problem. By changing the query to: query = db.auth_user.id>0 query = query&db

Here what I got for now : from pyparsing import nestedExpr # Not the worse case but has enough