I see you want to make a query but why you want to make that?
Also, more experienced user correct me if I am wrong, but personnally I
never had good result doing what you are doing, I mean I don't remember
having it working correctly (even in SQL)...
In :
(db.sale_order_header.sale_order_date.isocalendar() ==
request.now.isocalendar() )
You say transform my field value before checking if it equal to some value
db.sale_order_header.sale_order_date.isocalendar()
How dow you want the DAL translate that into SQL?
Did you have a look at the SQL generated by the DAL?
(db.sale_order_header.sale_order_date.isocalendar() ==
request.now.isocalendar() ).*_*select(...)
Richard
On Thu, Mar 13, 2014 at 1:59 PM, 黄祥 <steve.van.chris...@gmail.com> wrote:
> yes, already tried but got an error traceback. what i want to achieve is
> something like example below, but when i've tested it, i got an error
> traceback. any idea how to achieve it in web2py?
> e.g.
> import datetime
>
> (db.sale_order_header.sale_order_date.strftime("%U") ==
> request.now.strftime("%U") )
> *AttributeError: 'Field' object has no attribute 'strftime'*
>
> (db.sale_order_header.sale_order_date.isocalendar() ==
> request.now.isocalendar() )
> (db.sale_order_header.sale_order_date.isocalendar()[1] ==
> request.now.isocalendar()[1] )
> *AttributeError: 'Field' object has no attribute 'isocalendar'*
>
> 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 web2py+unsubscr...@googlegroups.com.
> 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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
