Okay, never mind, I just removed the big piece of wood from my forehead. I see clearer now..
thanks a lot for your patience, sorry for being a doofus ciao Stefan On Oct 3, 5:46 pm, znafets <[email protected]> wrote: > Getting crazed about not being able to retrieve the values from the > database. > > query= db.user.name==uname > records=db(query).select() > > I get at least something that looks somehow that I am getting closer. > Looking in WingIDE on what I get, records comes with a __dict__ which > contains _db and colnames which is a tupel that contains the > fieldnames (user.id, user.name, etc) > > How can I access the values ? > Something like records.colnames.user.name doesn't work and throws > "Rows object has no attribute user" > > best regards > Stefan > > On 2 Okt., 21:11, Yarko Tymciurak <[email protected]> wrote: > > > wing will run with whatever python you have setup (you can run one project > > w/ 2.5, another w/ 2.6); > > web2py will run fine w/ 2.6, as long as you are on at least 2.6.2 (I'm have > > run web2py with both 2.5 and 2.6.2 on Windows, and on Ubuntu and Fedora). > > > On Fri, Oct 2, 2009 at 2:06 PM, znafets <[email protected]> wrote: > > > > Actually I have WingIDE personal v.3.2 but it runs with python2.6 and > > > definetely not with python2.5, tried it. While web2py needs python2.5 > > > as I understand this is mandatory. I'll try it out with iPython. > > > > thanks again. > > > > Stefan > > > > On 2 Okt., 20:50, Yarko Tymciurak <[email protected]> wrote: > > > > On Fri, Oct 2, 2009 at 1:35 PM, znafets <[email protected]> wrote: > > > > > > Thanks for the hint, vars seems definetly the better choice. > > > > > But the db part drives me to desperation: > > > > > doing in controller: > > > > > > uname=request.vars.uname > > > > > query=db(db.user.name==uname) > > > > > should be: > > > > > query = db.user.name==uname > > > > > you really need to download / install ipython first ( > > >http://ipython.scipy.org), and get used to trying your expressions in a > > > > shell to see what they return: > > > > > python web2py.py -S myapp -M > > > > > >>> uname="Mytest" > > > > >>> query= db.user.name==uname > > > > > etc. > > > > > The problems you are having are basic programing things (not even so > > > > much > > > > python), so you might want to get something like wingIDE (there is a 30 > > > day > > > > trial that is given out in 10-day chunks, so prepare and use like the > > > > dickens for 10 days at a stretch, single step a LOT and observe local > > > > variables and their values as you go - then digest what you've learned) > > > -www.wingware.com > > > > > > records=db(query).select() > > > > > > the select statement already throws up an exception (key error key > > > > > (gluon)) or so > > > > > > seems I won't discover my secret love to database programming > > > > > anymore :) > > > > > > ciao > > > > > Stefan > > > > > > On 2 Okt., 19:48, mdipierro <[email protected]> wrote: > > > > > > Mind that URLs are validate on input and if uname contains spaces > > > > > > things will not work because spaces will be replace by _. I suggest: > > > > > > > <td>{{=A(uname, _href=URL(r=request, f='edit_user',vars=dict > > > > > > (uname=uname)))}}</td> > > > > > > > and in edit_user > > > > > > > rows=db(db.....==request.vars.uname).select() > > > > > > > On Oct 2, 12:42 pm, znafets <[email protected]> wrote: > > > > > > > > Nah, don't worry, I'll figure that out somehow. Can't ask that > > > > > > > much > > > of > > > > > > > you. > > > > > > > > Thank you very much for the offer though. I am a web2py rookie > > > (just > > > > > > > started), never used django or alike. > > > > > > > > So thanks again > > > > > > > > ciao > > > > > > > Stefan > > > > > > > > On 2 Okt., 19:22, Yarko Tymciurak <[email protected]> wrote: > > > > > > > > > If no one else can help you, I'll put together an example for > > > > > > > > you > > > > > tonight > > > > > > > > (tied up this afternoon) > > > > > > > > > On Fri, Oct 2, 2009 at 12:07 PM, znafets <[email protected] > > > > > > wrote: > > > > > > > > > > > not sure why you think it doesn't work; it should work > > > just > > > > > fine: > > > > > > > > > > > x = request.args[0] > > > > > > > > > > y = request.args[1] > > > > > > > > > > well, as soon as I try something like args=[uname, uloc] in > > > > > > > > > the > > > > > view > > > > > > > > > it comes up with "Invalid request". > > > > > > > > > args=[uname] works just fine and can be retrieved via > > > > > request.args[0] > > > > > > > > > > working on linux (ubuntu karmic), python 2.5, web2py 1.67x > > > > > > > > > > > > row=db(db.user.uname==request.args[0]).select() > > > > > > > > > > can you give me a hand on this ? Trying to take the value > > > > > > > > > which > > > > > comes > > > > > > > > > back from the view (username) and can be retrieved form > > > > > request.args > > > > > > > > > [0] and get the according record with all the it's fields to > > > > > iterate > > > > > > > > > through it. > > > > > > > > > If it's not asked too much. > > > > > > > > > > best regards > > > > > > > > > Stefan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
