On 8/8/07, akira <[EMAIL PROTECTED]> wrote:
> columns = (parent.link, Count()-1)
> where = And(node.lft > parent.lft, node.lft < parent.rgt)
> expr = Select(columns, where, order_by=node.lft)
>
> test = SQL(("%s") % expr)
>
> this gives me this:
>
> <storm.expr.SQL object at 0x009F0230>
>
> Which is not a result set, does this have to be executed?You probably don't want to pass that expression to 'SQL'. Just pass it to store.execute (without stringifying it). store.execute(expr) -- Christopher Armstrong International Man of Twistery http://radix.twistedmatrix.com/ http://twistedmatrix.com/ http://canonical.com/ -- storm mailing list [email protected] Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/storm
