Hi Anthony,
Thanks, is ok to use sql or is there a better way of doing this, been new I
would rather learn the proper way rather just making it work.
cheers
Anthony
On Friday, 20 November 2015 20:05:06 UTC+11, Anthony Smith wrote:
>
> Hi
>
> This has been driving me crazy, and dont what I am doing wrong
>
>
> db.define_table('product',
> Field('product_name'),
> Field('batch_no'),
> Field('withholding_period','integer'),
> format='%(product_name)s %(batch_no)s')
>
> db.define_table('stock_task',
> Field('completed_date', 'date',default=request.now),
> Field('product', db.product),
> Field('withhold_until_date', 'date'),
> Field('ESI_withhold_until_date', 'date'), #default=withheld),
> # need to use the completed date and product withhold peroid
>
> def create_stock_task():
> form = SQLFORM <http://127.0.0.1:8000/examples/global/vars/SQLFORM>
> (db.stock_task).process()
> if form.accepted:
> task = db(db.stock_task.id>0).select(limitby=(0,1),
> orderby=~db.stock_task.id).first()
> pdays_row = db(db.stock_task.product==db.product._format)
> pdays = pdays_row.withholding_period.select()
> wdate_row =db(db.stock_task.completed_date>0).select().first()
> fdate = wdate + datetime.timedelta (days + pdays)
> ndate_row = db(db.stock_task.withhold_until_date>0).select().first()
> ndate = ndate_row.withhold_until_date
> db(db.stock_task.id == task).update(ndate=fdate)
> session
> <http://127.0.0.1:8000/examples/global/vars/session>.flash="New Task Added"
> redirect <http://127.0.0.1:8000/examples/global/vars/redirect>(URL
> <http://127.0.0.1:8000/examples/global/vars/URL>('stock_tasks'))
> return dict( form=form)
>
> Traceback
>
> 1.
> 2.
> 3.
> 4.
> 5.
> 6.
> 7.
> 8.
> 9.
> 10.
> 11.
> 12.
>
> Traceback (most recent call last):
> File "/home/tony/web2py/gluon/restricted.py", line 227, in restricted
> exec ccode in environment
> File "/home/tony/web2py/applications/cps21/controllers/default.py"
> <http://127.0.0.1:8000/admin/default/edit/cps21/controllers/default.py>, line
> 553, in <module>
> File "/home/tony/web2py/gluon/globals.py", line 412, in <lambda>
> self._caller = lambda f: f()
> File "/home/tony/web2py/gluon/tools.py", line 3774, in f
> return action(*a, **b)
> File "/home/tony/web2py/applications/cps21/controllers/default.py"
> <http://127.0.0.1:8000/admin/default/edit/cps21/controllers/default.py>, line
> 277, in create_stock_task
> pdays = pdays_row.withholding_period.select()
> AttributeError: 'Set' object has no attribute 'withholding_period'
>
> any help appreciated
>
> thanks Anthony
>
>
--
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.
