As Yarko mentioned, you need to start web2py in shell mode by typing: >>python web2py.py -S yourapp -M This will create all of the variables you need in the shell such as db.
I highly recommend going through the book from start to end. It will save you many hours of frustration and only costs $12. http://www.lulu.com/content/4968879 Good luck! On Aug 25, 8:09 am, jayvandal <jayvan...@gmail.com> wrote: > I downloade ipython and it installed it in python26\lib\site packages > \ipython as per the installer..(I am running Windows Vista) > I ran ipython and typed in > records=db(db.person.last_name==request.vars.last_name)\ > .select(orderby=db.person.last_name) > ----- > It didn't like db. > I dont see it relating to the database in sqlite in web2py > Thanks > Jim > > On Aug 24, 10:14 pm, Yarko Tymciurak <yark...@gmail.com> wrote: > > > > > On Mon, Aug 24, 2009 at 11:02 PM, jayvandal<jayvan...@gmail.com> wrote: > > > > I tried to get the person_id when I got a last name found, but I could > > > not find a way to get the person_id with this code, > > > ...... > > > >> > HI, > > >> > I tried this code > > >> > ================================================= > > >> > records=db(db.person.last_name==request.vars.last_name)\ > > >> > .select(orderby=db.person.last_name) > > >> > =================================================== > > >> > i see that this will find by last name or partial last name. > > > You should really get familiar with running commands in a shell, and > > be sure to install iPython (it will give you TAB completion)- > > > then you could try this line, and inspect the results - > > > python web2py.py -S myapp -M > > [1] records=db(db.person.last_name==request.vars.last_name)\ > > > .select(orderby=db.person.last_name) > > > [2] len(records) > > [3] records[0] > > [4] records[0].[TAB] > > > ("[TAB]" I meant just hit the TAB key) - Try it, let us konw what you see... > > > Regards, > > - Yarko > > > >> > I tried to get the person_id and use it to find all the events for > > >> > that person and then display the event records. > > > >> > Can I do this or should I do this?? > > >> > Thanks > > >> > Jim- Hide quoted text - > > > >> - Show quoted text -- Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
