Another option would be for your form processing action to always store the latest inserted record in the cache -- the scheduler could then just pull the values from the cache.
Anthony On Wednesday, April 29, 2015 at 10:17:57 AM UTC-4, Anthony wrote: > > db.Table1.X is just a field object and doesn't refer to any record in the > database. To retrieve a record, you must create a query. In most databases, > you can just take the record with the largest ID: > > db(db.Table1).select(orderby=~db.Table1.id, limitby=(0, 1)) > > That sorts in reverse order based on ID and takes the first record. > Alternatively, you could include a record creation timestamp and sort based > on that. > > Anthony > > On Wednesday, April 29, 2015 at 9:31:50 AM UTC-4, Aydin S wrote: >> >> Thank you, you are right, right now I have: >> def index(): >> form = SQLFORM(db.X).process() >> return dict(form=form) >> >> and I see the database getting updated with new records. >> One last question, I use db.Table1.X to refer to the last entered record. >> However, this does not work. How can I make it use the last entered row? >> >> On Wednesday, 29 April 2015 08:27:22 UTC-4, Anthony wrote: >>> >>> See answer on SO: http://stackoverflow.com/a/29932995/440323 >>> >>> On Tuesday, April 28, 2015 at 9:35:31 PM UTC-4, Aydin S wrote: >>>> >>>> It looks like the scheduler which is a model file does not see variable >>>> X in the database! >>>> >>>> On Tuesday, 28 April 2015 21:19:14 UTC-4, Aydin S wrote: >>>>> >>>>> No, the value of the form gets processed every time the scheduler runs. >>>>> >>>>> On Tuesday, 28 April 2015 21:07:42 UTC-4, Dave S wrote: >>>>>> >>>>>> >>>>>> >>>>>> On Tuesday, April 28, 2015 at 6:01:04 PM UTC-7, Aydin S wrote: >>>>>>> >>>>>>> This is probably very simple, sorry in advance! >>>>>>> I have a form defined in a model file: >>>>>>> db.define_table('table1', >>>>>>> Field('X', 'integer')) >>>>>>> I have a controller that is also defined as: >>>>>>> def index(): >>>>>>> form = SQLFORM(db.X) >>>>>>> return dict(form=form) >>>>>>> >>>>>>> >>>>>> In my index view file I have: >>>>>>> >>>>>>> <h2>Input form</h2> >>>>>>> {{=form}} >>>>>>> >>>>>>> I want to use value X in a scheduler defined as a model like: >>>>>>> >>>>>>> A = X+2 >>>>>>> >>>>>>> The form shows up as expected. I enter a value in it and submit it. >>>>>>> The scheduler is running as expected. However it looks like the value X >>>>>>> never gets set to what I enter. >>>>>>> Any idea? >>>>>>> >>>>>>> >>>>>> Do you process the form once the user has entered the input? >>>>>> >>>>>> /dps >>>>>> >>>>>> >>>>> -- 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.
