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] <javascript:>>
> 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] <javascript:>.
> > 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.
