you can try off the class, as Tgmouse.c.pathnum
On Sep 21, 2006, at 2:36 PM, [EMAIL PROTECTED] wrote:
> Dear Sqlalchemy group,
>
> I'm pretty new to sqlalchemy and trying it out on a new project at
> work.
> I've been looking that the docs, and I've got a really simple
> question.
> I've set up a session ( db = create_session() ) and now want to do a
> query with said session, but i want to do "like" type of query, so:
>
>
> without a like clause I could do:
> db.query(Tgmouse).select_by(pathnum = 'TG02-0010SK') or
> db.query(Tgmouse).select_by(tgmouse_table.c.pathnum == 'TG02-0010SK')
>
> but or a like clause the only thing I've figured out i can do is:
> db.query(Tgmouse).select_by(tgmouse_table.c.pathnum.like('%
> TG02-0010SK%'))
>
> Is there a way to do the query with with our referring directly to
> tgmouse_table?
> Thanks for any and all help
>
> Jose
>
>
> ----------------------------------------------------------------------
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to
> share your
> opinions on IT & business topics through brief surveys -- and earn
> cash
> http://www.techsay.com/default.php?
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Sqlalchemy-users mailing list
> Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
