1. I think I understand but what If I want only to get the db.table.id and the db.table.name fields? Can you or someone please give me some examples :$? BTW if you do all does it this (in MySQL)
SELECT * FROM table or SELECT field1, field2 FROM table? 2. Sorry but I still do not understand? Why you cant just do this: all = db( db.leden.id == request.args ).select() This is the same as: SELECT leden_id, leden_naam FROM leden WHERE leden_id = #url.id# 3. Ah, ok :) Thanks and sorry that I don't understand that much :$. On 1 aug, 17:02, mdipierro <[email protected]> wrote: > > Maybe I will switch back to Web2Py but I still have some questions :P. > > 1. Why it is herehttp://pastebin.com/f4c8cd718db().select(query) and > > herehttp://pastebin.com/m291dbd6ddb(query).select? > > the syntax is always > > db(query).select(*fields,*attributes) > > db.table.ALL is not a query, means all fields of "table". If you need > all fields of a table you can omit a query and web2py assumes you want > all fields and all records of that table. > > > 2. What does herehttp://pastebin.com/m3869a9bthe[0] in the line and at the > > end? > > This means you only want the first record. It is the same as > > all = db.leden[request.args[0]] > > (the latter is better because retruns None if no records, the example > you posted would raise an Exception instead). > > > 3. What does herehttp://pastebin.com/m1c7e0e1therequest mean? > > Normally > > url= URL(applicaiton, controller, function) > > but if you do > > url = URL(r=request,f=funciton) > > it gets the application name and controller name from the current > request. It is a shortcut that is used often. > > Massimo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
