Hey SP, i dont think the problem was the code itself, there must have been
something wrong with the version of web2py i had implemented my application
on because when i switched to version 2.17.2 that problem disappeard, so i
just assumed the problem was with the previous version of web2py i was
using.
Regards
Mostwanted
On Friday, October 26, 2018 at 7:20:22 AM UTC+2, sandeep patel wrote:
>
> I think there is a problem in field type in Days because the default is a
> string so days have a string value, you are multiplying string with an
> integer in the computed field.
>
> # 1
> db.define_table('ClientDetails',
> Field('CheckIn', 'date', label=SPAN('Check-In Date',
> _style="font-weight: bold;")),
> Field('CheckOut', 'date', label=SPAN('Check-Out Date',
> _style="font-weight: bold;")),
> Field('Days', compute=lambda r: (r['CheckOut']-r['CheckIn'
> ]).days),
> Field('Amount', compute=lambda r: int(r['Days'])*int(r[
> 'Number_of_Guests'])*650))
>
> # 2
> db.define_table('ClientDetails',
> Field('CheckIn', 'date', label=SPAN('Check-In Date',
> _style="font-weight: bold;")),
> Field('CheckOut', 'date', label=SPAN('Check-Out Date',
> _style="font-weight: bold;")),
> Field('Days', compute=lambda r: (r['CheckOut']-r['CheckIn'
> ]).days),
> Field('Amount', compute=lambda r: ((r['CheckOut']-r[
> 'CheckIn']).days)*int(r['Number_of_Guests'])*650))
>
> Let me know this will work for you.
>
> Thanks
> SP
>
> On Fri, Oct 26, 2018 at 10:27 AM mostwanted <godir...@gmail.com
> <javascript:>> wrote:
>
>> With this one there was no error traceback, the form just failed to
>> submit showed a message that read *Error in form, please check it out *and
>> i do have a field Number_of_Guests i just didnt include it coz i thought i
>> was minimizing the whole code to show what could the root cause of the
>> problem. When i remove the *Days *and* Amount *fields I am able to
>> update the form but when put them back it gives an error!
>>
>> On Friday, October 26, 2018 at 12:13:55 AM UTC+2, 黄祥 wrote:
>>>
>>> pls show the error traceback, it's hard to know what the root cause.
>>> just a quick analyze (guess), perhaps it's no Number_of_Guests field in
>>> your table definition, so it can't be calculated
>>>
>>> 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+un...@googlegroups.com <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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
