2007/8/20, Oleg Broytmann <[EMAIL PROTECTED]>:
>    1 contradicts 2 because SQLBuilder doesn't perform any conversion.
> Column objects perform conversions. So, either SQLObject with conversions
> or SQLBuilder with raw data,

I see.

> > for row in connection.queryAll( 'SELECT DISTINCT date(entry.begin)
>
>    SELECT DISTINCT in SQLBuilder is implemented in the trunk by Luke
> Opperman. Wait until it will be released as SQLObject 0.10, or use the code
> from the trunk, it is stable enough to be useable.
>
> from sqlobject.sqlbuilder import Select, func
> for row in conn.queryAll(conn.sqlrepr(
>    Select(func.date(Entry.q.begin), distinct=True)
> ))

Ok.  And is there a way to put the 'query' variable, which is of
__class__ sqlobject.sqlbuilder.SQLOp, from my original code into the
SQLBuilder version?  The query is already constructed elsewhere and
passed around in my program.

Kind regards,
Markus

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to