Re: [SQLObject] PickleCol limited to 255 bytes?

2006-07-02 Thread Michael Gauckler
sophana zizi.ath.cx> writes: > > Hi > I've tried PickleCol, it seems to work fine, but I have an error message > sometimes: insecure string pickle (when loading the pickled object) > > looking at phpmyadmin, it seems that all rows that show this error have > the pickle col telling the BLOB size

Re: [SQLObject] SQL'ish count versus len()

2006-06-27 Thread Michael Gauckler
Luke Opperman metathusalan.com> writes: > > Forgot to copy the list before, gist was use SQL*Join instead, so that it uses > a SelectResults instance. That's also the answer here: you can then use > .count, .filter, .sum, etc on the join property. > > j.transactions.count() > Thank you, this

Re: [SQLObject] Reuducing the number of SQL Queries for MultipleJoins

2006-06-27 Thread Michael Gauckler
Forwarded Message From: Luke Opperman <[EMAIL PROTECTED]> To: Michael Gauckler <[EMAIL PROTECTED]> Subject: Re: [SQLObject] Reuducing the number of SQL Queries for MultipleJoins Date: Mon, 26 Jun 2006 19:14:02 -0500 I haven't looked closely at it, and it see

Re: [SQLObject] SQL'ish count versus len()

2006-06-27 Thread Michael Gauckler
> have I missed something ? > I've not seen the reply on the list. The reply went to my private address, see below. Forwarded Message From: Luke Opperman <[EMAIL PROTECTED]> To: Michael Gauckler <[EMAIL PROTECTED]> Subject: Re: [SQLObject] Reuducing th

[SQLObject] SQL'ish count versus len()

2006-06-26 Thread Michael Gauckler
([a.id for a in page.job.transactions]) (Pythonic, This loads all data and counts it) Where 1) is fast and 2) is elegant. Is there a fast and elegant way? Thanks again for suggestions. Regards, Michael Gauckler Using Tomcat but need to do more? Need to support web services, security? Get stuff done q

[SQLObject] Reuducing the number of SQL Queries for MultipleJoins

2006-06-26 Thread Michael Gauckler
help is appreciated. Thank you! Yours, Michael Gauckler Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-u