Thx Michael.
this looks better but can't I do a join here and specify absolute column
names like {"User.c.UserId"..}
session.query(User).select_by(**{"id": 1, "foo" : "bar"})
thx
- A
On 4/12/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
>
> On Apr 11, 2007, at 9:56 AM, Arun Kumar PG wrote:
>
> Guys,
>
> I have a search form and I want to compose the select_by() query
> dynamically as per the prameters but the select_by() on query object does
> not accepts string type query i.e. session.query(User).select_by("
> User.c.Id == 1 and ...")
>
>
> the specific thing you want to do there would look like:
>
> session.query(User).select_by(text(" User.c.Id == 1 and ..."))
>
> but maybe you mean:
>
> session.query(User).select_by(**{"id": 1, "foo" : "bar"})
>
> ?
>
>
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
