[Zope3-dev] Re: RDB support

[Stephan Richter]

>>Can you elaborate on that? I am a little lost. Also, an example might be 
>>nice. :-)
>
>Well, what I'm after is something that will help construct query strings, 
>e.g. to build the string
>
>'select * from table where foo=:foo'
>
>the bind string is DA specific -- for instance, DCOracle2 can bind by name 
>or by position ':foo' vs ':1'.  Other DA's can use different methods.  So 
>what you want is a mechanism to tell the DA "help me build the next 
>binding parameter string for this value."
>
>For things like positional binding, its pretty evident you'll need to keep 
>some kind of state so you can increment the position.

Okay, I see now.

>You probably want some kind of querybuilder object which keeps track of 
>its own state, and either knows about all kinds of DBAPI 2.0 parameter 
>binding styles, or leverages a DA-specific binding routine.

But shouldn't this be on a higher level? What if I do not want this 
service? Or do you mean more you want to replace what is currently done 
with DTML in SQL Methods?

Regards,
Stephan

--
Stephan Richter
CBU - Physics and Chemistry Student
Web2k - Web Design/Development & Technical Project Management