RE: [Zope3-Users] SQL integration

2006-02-22 Thread David Johnson
Here is the kind of thing I've been doing -- keep in mind, I'm still new at this. I'm not using connection caching as I let the database handle that - I find it smarter and more powerful than Zope in this area (and just simpler). I have found the ISQLScript implementation to be a good example; se

RE: [Zope3-Users] SQL integration

2006-02-22 Thread jpenny
Thanks for the response. Are you using ZSQL or DB-ABI? If ZSQL: suppose you want to select * from foo where How is that written in the filesystem (in particular, how are parameters written?) if DB-ABI: are you doing connection caching? jim penny "David Johnson" <[EMAIL PROTECTED]> wr

Re: [Zope3-Users] SQL integration

2006-02-21 Thread Stephan Richter
On Tuesday 21 February 2006 18:51, [EMAIL PROTECTED] wrote: > Can ZSQL methods reside on the filesystem or are they currently TTW only? Of course you can also use ZSQL methods or just the Zope Database adapter API from filesystem code. > Is there any working ODBC access yet? I am not sure anyon

RE: [Zope3-Users] SQL integration

2006-02-21 Thread David Johnson
I've been able to do some basic things, depending upon what you're looking for. I'm still exploring the best methods. So far I've found I have to do everything on the file system. I'm still playing but I'm close mastering the basic database operations. > -Original Message- > From: [EMA