Yes, you'll need the source code. You can get it here...: http://www.web2py.com/examples/static/web2py_src.zip
...then extract it to the folder of your choice (c:\web2py for me) Now open a command prompt, cd into that folder and type: python web2py.py -S yourapp -M The -S switch is for shell mode and the -M switch is to auto-import your models from the specified app. If it gives you grief about not being able to find python then just add it to the path: path %PATH%;C:\Python25 If iPython is installed, then it will start up instead of the regular python shell. From there you can try database queries to get a feel for things: dir(db) q = db(db.person.id==1).select() dir(q) q.colnames etc... On Aug 25, 7:47 pm, jayvandal <jayvan...@gmail.com> wrote: > 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 -- 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 -~----------~----~----~----~------~----~------~--~---