You don't select fields in SQLObject, you select rows, which are then
translated into objects using the friendly ORM.

So, you do:

foos = FooClass.selectBy(f1='a', f2='x')
for foo in foos:
        print foo.f1, foo.f2

Stuart


On Wed, 2006-11-01 at 23:14 -0500, Michael Steinfeld wrote:
> Alright, I asked this already, but I cannot find where it is on the
> mailing lists.
> 
> I was asking how I can do "SELECT field1, field2 FROM tablename WHERE
> f1='a' AND f2='x'"
> 
> How do you do it with sqlobject? I spend hours reading different
> approaches and none work ;( 
> 
> thanks guys,
> 
> -- 
> -mike
> 
> 
> > 
-- 
Stuart Clarke <[EMAIL PROTECTED]>


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"TurboGears" 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/turbogears
-~----------~----~----~----~------~----~------~--~---

Reply via email to