[Zope-DB] dco2 and bind variables

[Jim Abramson]

Rather than rolling my own subclass of DCO2 (sounds like fun but...), I'm inclined to start using external methods instead of sql methods, which import DCO2 and now I have direct access to the execute() method.

Ideally, I'd like to pass the zope database connection object to the external method, let the method call execute/fetchall, and return the results, because sometimes the same sql is run against different connections. A few quick tests of this worked just fine, hooray. But does it introduce any risk, as far as the pooling of connections or handling of transactions that may be going on elsewhere in zope? Is there some pitfall I'm not aware of here? It almost seems, well, too easy...

Thanks for advice.
Jim

-----Original Message-----
From: Matthew T. Kromer [mailto:matt at zope.com]
Sent: Friday, October 03, 2003 4:02 PM
To: b.maryniuk at forbis.lt
Cc: zope-db at zope.org
Subject: Re: [Zope-DB] dco2 and bind variables


Bo M. Maryniuck wrote:

>On Friday 03 October 2003 15:33, Matthew T. Kromer wrote:
>  
>
>>No :(
>>    
>>
>
>And what about binding array in DCOracle2?
>
>  
>

The question was with regards to SQL Methods in Zope, which don't know 
anything about binds.

-- 
Matt Kromer
Zope Corporation  http://www.zope.com/ 



_______________________________________________
Zope-DB mailing list
Zope-DB at zope.org
http://mail.zope.org/mailman/listinfo/zope-db