[Zope-DB] Dynamically generate sql-query in ZSQL Method

Bo M. Maryniuck b.maryniuk at forbis.lt
Fri Apr 9 03:21:11 EDT 2004

On Thursday 08 April 2004 19:37, Peter Sabaini wrote:
> But one can still do this with ZSQL Methods, right? 

Not Right Way but just ZSQL is the only way Zope can eat SQL through.
And ZSQL is still quite crappy: to define NUMBER (eq long), I need type a

      <dtml-sqlvar foo type=float>

Then it works because DB converts types. But if I do "type=long" ZSQL
sais does not support it. Therefore you get messed up with the types.

And, to dynamically generate SQL I'd like to use Python Script and
let SQL Method will run it and eat its output instead of use complicated
DTML crap for SQL: sqlgroup, sqlvar, sqltest...

Regards, Bogdan T. M. Maryniuck

System programmer, Forbis UAB

More information about the Zope-DB mailing list