Hi Akshay,
Thanks for confirming Leandro Paz suggestion and replying me, I truly think
this forum needs all of us (even I still have a lot to learn in web2py) to
participate to share scenarios and solutions.
For smartgrid, you can still use query I believe, I have something like
below. Good luck, hope to see you here again.
query=db.quotation.id == quote_id
grid = SQLFORM.smartgrid(db.quotation, args=request.args[:1],
constraints=dict(quotation=query), ....)
On Monday, June 5, 2017 at 1:11:25 PM UTC+8, [email protected] wrote:
>
> Hi rudy,
> yes you are right. Web2py editor behaves funny sometimes.
> Sometimes you get error and same error goes away when you rewrite the same
> code.
>
> I could't use the smartgrid because smartgrid works on complete table but
> i had to query the table first. so only option for me was SQLFORM.grid.
>
> I still don't know what the problem was but solution given by @Leandro
> Paz worked.
>
> you just have to do:
> grid = SQLFORM.grid (db.auth_user, user_signature = False)
>
>
>
> On Friday, June 2, 2017 at 11:24:12 PM UTC+5:30, Rudy wrote:
>>
>> Hi Akshay,
>>
>> I don’t know where the problem was. As mentioned in previous thread,
>> after i used smartgrid to continue the development for a few days, it went
>> away. One thing i notice is the editor from the administrative interface
>> gets funny behavior sometimes, the compiler raises error but I simply can’t
>> find what goes wrong with the specific line pointed out from the ticket, if
>> I delete the line and retype exactly the same thing (I even had 2 lines
>> side by side to compare the difference), the error goes away. But I can’t
>> explain why below issue complains about “not authorised”, well try to
>> refresh your editor or use another editor to check the code, perhaps
>> restart web2py. I know it sounds silly, but they are quick test. cheers!
>>
>> On 2 Jun, 2017, at 7:07 pm, [email protected] wrote:
>>
>> hi Rudy,
>> I am facing the same issue. Did you get why this is happeneing?
>> On Saturday, April 22, 2017 at 1:49:15 PM UTC+5:30, Rudy wrote:
>>>
>>> Hi there,
>>>
>>> It feels really strange to me that when i used SQLFORM.grid(), I got a
>>> flash message "not authorised", but when i used smartgrid(), it worked just
>>> fine (in both cases i had logged in already). I tried to removed
>>> @auth.requires_login(), but same behaviour happened. I seem to miss some
>>> very fundamental knowledge using SQLFORM.grid(). Below is the simplified
>>> code. Any help is much appreciated.
>>>
>>> @auth.requires_login()
>>> def list_items2():
>>> response.view='accounting/list_items.html'
>>> grid = SQLFORM.grid(db.auth_user)
>>> return locals()
>>>
>>
>> --
>> 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 a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/web2py/yhj6iVXgHEM/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> [email protected].
>> For more options, visit https://groups.google.com/d/optout.
>>
>>
>>
--
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/d/optout.
