Thanks I have the book. I downloaded the book and then printed it . I don't remember any ipython. i have the web2py windows installed and python 26 installed. I have downloaded ipython installed in python folder in script , but I don't have a web2py.py file. Do I need a ppython file of web2py to run in ipython? Jim
On Aug 25, 7: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 downloadeipythonand it installed it in python26\lib\site packages > > \ipythonas per the installer..(I am running Windows Vista) > > I ranipythonand 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 installiPython(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 -- 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 -~----------~----~----~----~------~----~------~--~---
