db.table(1).field.isocalendar()[1] will works because you have a record
selected...
But you don't have access to any field value in context of where clause
db(** where clause **).select()
Richard
On Thu, Mar 13, 2014 at 2:17 PM, Richard Vézina <ml.richard.vez...@gmail.com
> wrote:
> 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.
