On Thu, 2007-01-11 at 15:13 -0400, Michael Bayer wrote:
> for now, Resource.query.filter(resource_table.c.somecol.op('rlike') 
> (<value>)) will work.

Thanks. Going through the SA0.4 tutorial, it seems this would be easier
if I abandon rlike and just go with like, which ( thinking about it )
will be just fine in this case. So I got the following working, now
using mapper instead of assign_mapper to map my objects:

session.query(Client).filter( Client.name_last.like('dunc%') ).select()

This is still a ways from what I was hoping for, but it's a start.
However, I'm confused as to what I need to do from within turbogears to
be able to use this syntax:

Resource.query.filter( etc )

I'm just getting a message that the resource has no attribute named
query. It could be an omission in tg though. If anyone else has
encountered this and has tips, that would be great.

Iain



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to