On Aug 1, 10:14 am, Pynthon <[email protected]> wrote:
> 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?
rows=db().select(db.table.field1,db.table.field2)
> 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#
all = db( db.leden.id == request.args[0] ).select
(db.leden.id,db.leden.naam)
> 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/m1c7e0e1therequestmean?
>
> > 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
-~----------~----~----~----~------~----~------~--~---
