slightly disagree - there is nothing like going through that, explaining it to someone who is willing to help and skilled. Thanks to you Yarko and also Massimo I got some enlightment along the way.
ciao Stefan On Oct 3, 8:22 pm, Yarko Tymciurak <[email protected]> wrote: > :-) > > Sometimes there's nothing like just going through that yourself. > > I know all the structures exposed aren't completely transparent, don't > immediately seem to correlate to the written code, the expression. > > On Sat, Oct 3, 2009 at 1:14 PM, znafets <[email protected]> wrote: > > > 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 -~----------~----~----~----~------~----~------~--~---
