Note, there is no guarantee that the records in the db at any given time have sequential values in the ID field (e.g., when you delete a record, the value of its ID is then absent from the sequence of IDs).
Can you explain in more detail what you are actually trying to do? Anthony On Tuesday, May 20, 2014 9:32:27 AM UTC-4, Tom Russell wrote: > > Thanks for the comments. I read Chapter 6 which is where I got the bit of > code to access the records. Specifically the fetching a row section. > > I can ensure that there is records with those id's. Its a script that > grabs data off from the internet and inserts that data into that table. > Then I grab the last 5 records including the one it is grabbing to do a > calculation on it. > > It is not too clear in the book how I should be getting a record by the id > is what I think my problem is. > > Thanks, > > Tom > > On Tuesday, May 20, 2014 4:53:13 AM UTC-4, Johann Spies wrote: >> >> On 19 May 2014 22:06, Tom Russell <tsrda...@gmail.com> wrote: >> >> I have some records in my db that I need to access to get them and >>> perform some calculations on. >>> >>> My code to access the records is: >>> >>> rows = db(db.voltrin.id > 0).count() >>> >> >> Let us assume rows = 100 at this point. >> >>> >>> currentrow = rows - 4 >>> >> >> currentrow = 96 >> >> >>> >>> for x in range(currentrow, rows): >>> >> range(96, 100) >> >>> record = db.voltrin(db.voltrin.id==x) >>> >> record = db.voltrin(db.voltrin.id = >> 96).select(whateverfieldsyouwantoworkwith) >> >> >> >>> Is this the right way to access the record at a given id? >>> >>> No. >> >> I would suggest you read Chapter 6 in the web2py book ( >> http://web2py.com/book). >> >> Just a comment about your code: there is no way you can ensure in the >> above example that there will be an id==96 in that database. >> >> Regards >> Johann >> -- >> Because experiencing your loyal love is better than life itself, >> my lips will praise you. (Psalm 63:3) >> > -- 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.
