the problem is not the resultset: it's how it's injected into the view!!!!
On Tuesday, August 9, 2016 at 8:28:23 PM UTC+2, Dave S wrote:
>
>
>
> On Tuesday, August 9, 2016 at 10:56:48 AM UTC-7, madhu nomula wrote:
>>
>> db.define_table('ActivityMapping',
>> Field('mapping_id'),
>> Field('resource_id',db.auth_user),
>> Field('org_id',db.Organization),
>> Field('solution_id',db.Solution),
>> Field('activity_id',db.Activity),
>> Field('activity_date','datetime', requires=IS_DATE()),
>> Field('effort')
>> )
>>
>>
> Thank you. Which database engine are you connecting to?
>
> /dps
>
>
>> On Tue, Aug 9, 2016 at 11:11 PM, Dave S <[email protected]> wrote:
>> >
>> >
>> > On Tuesday, August 9, 2016 at 9:09:08 AM UTC-7, madhu nomula wrote:
>> >>
>> >> Hi,
>> >>
>> >> I am trying to read date output from controller, but I am getting
>> value in
>> >> View as decimal values:
>> >
>> >
>> > Which DB backend are you using?
>> >
>> > Can you show your define_table() code?
>> >
>> > /dps
>> >
>> >
>> >>
>> >>
>> >> controller Code:
>> >>
>> >> rowslistPeriod = db((
>> >> (db.AM.resource_id==db.auth_user.id)&
>> >>
>> >> (db.auth_user.id==auth.user.id)
>> >>
>> ).select(db.auth_user.first_name,db.db.Solution.solution_code,db.Activity.activity_name,
>>
>>
>> >> db.AM.effort, db.AM.activity_date)
>> >> return dict(recordlistPeriod=rowslistPeriod
>> >>
>> >>
>> >> View Code:
>> >>
>> >> $(containerPreviousRecords).append('{{for x in recordlistPeriod:}}');
>> >>
>> >>
>> >> var ceffort= {{=x.AM.effort}};
>> >> var cDate= {{=x.AM.activity_date.strftime("%m/%d/%Y")}};
>> >> alert(cDate);
>> >>
>> >>
>> >> -----------------
>> >>
>> >> Here I am able to get number value (effort), when I am getting alert
>> >> getting x.AM.activity_date.strftime("%m/%d/%Y") values as
>> >> decimal(0.0036789......) instead of Date.
>> >>
>> >> Please help me to get date.
>> >>
>> >> Thanks,
>> >> MC
>> >
>> > --
>> > 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.
>>
>
--
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.
