You may want to follow this thread as well:
http://groups.google.com/group/turbogears/browse_thread/thread/88c26060d16ea11e
Sounds like it might be the same issue.
Rick
On May 1, 10:10 pm, [EMAIL PROTECTED] wrote:
> Rick> a) using the included pysqlite in Python 2.5+ and issues with
>
query like:
q =
Query(cls).join('parent').group_by(cls.c.user_id).order_by(func.count(cls.c.user_id)).limit(limit).offset(offset)
thanks
On 4/29/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
> On Apr 29, 2007, at 1:07 AM, Ram Yalamanchili wrote:
>
> >
> >
Hey,
I had this issue where doing something like:
My hosting server uses: MySQL 4.1.13a (MacOS), and they wont be
upgrading till Mac OS panther is out unfortunately :(
I use a later version on my dev box, and things work fine with a query like:
In my User table mapper object:
def getMostActive
On 4/20/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> On Friday 20 April 2007 16:59:55 Michael Bayer wrote:
> > On Apr 20, 2007, at 5:00 AM, Ram Yalamanchili wrote:
> > > I have this piece of code which I came across accidentally:
> > >
> > >
x27;
Now this query fails because offset part of the query isn't
constructed properly. I think the correct behaviour should be to
ignore the offset part of the query?
I can reproduce on any table on 0.3.6.
thanks.
--
Ram
--~--~-~--~~~---~--~~
You received thi
was filter_by added recently? I have a assign_mapped class User from
TG, and doing a session.query(User).filter_by doesn't work (no such
method).
On 4/4/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
> My preference with assign_mapper at this point is to say:
>
> Client.query.filter_by(sites=site
Hi,
that worked great! thanks :)
- tml
On Mar 15, 9:10 am, svilen <[EMAIL PROTECTED]> wrote:
> use table.alias() for one of the roles - or for both.
>
> > Hi,
>
> > I doing a msg board with nested sets as descrived on
> >http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
>
> >
As far as I know, sqlite will "support" just about any datetime type
you want, including fractional seconds.
I put the word "support" in quotes because sqlite doesn't really HAVE a
date, time, or datetime type -- it stores all of those items as
strings, and will then allow you to pretend that you
Is it possible to specify a DISTINCT option to select_by()? Couldn't
find it in the docs. In general, what select() options does select_by()
take, if any?
Thx,
Rick
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
