I suggested you have ipython installed, because web2py shell will use ipython if it's available (and you then get completion facilities).
Sorry for any confusion. On Tue, Aug 25, 2009 at 8:52 AM, mr.freeze<nat...@freezable.com> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
