[Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

2001-04-19 Thread The Doctor What
Does any one have an example of ZSQL being used witha normalized database? Or is ZSQL just useless? Near as I can tell, between: * Broken type marshalling * Loosing the variable between the form and dtml-if * Inability to handle table.field names for variables * And enough flexibility to work ar

Re: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

2001-04-19 Thread The Doctor What
* The Doctor What ([EMAIL PROTECTED]) [010419 11:57]: > Does any one have an example of ZSQL being used witha normalized > database? Or is ZSQL just useless? > > Near as I can tell, between: > * Broken type marshalling > * Loosing the variable between the form and dtml-if > * Inability to handle

Re: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

2001-04-19 Thread Paul Browning
--On 19 April 2001 13:00 -0500 The Doctor What <[EMAIL PROTECTED]> wrote: > * The Doctor What ([EMAIL PROTECTED]) [010419 11:57]: >> Does any one have an example of ZSQL being used witha normalized >> database? Or is ZSQL just useless? [intemperate stuff snipped] I wouldn't dream of posting

Re: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

2001-04-19 Thread Andy McKay
gt; Cc: <[EMAIL PROTECTED]> Sent: Thursday, April 19, 2001 11:48 AM Subject: Re: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks) > > > --On 19 April 2001 13:00 -0500 The Doctor What <[EMAIL PROTECTED]> wrote: > > > * The Doctor What ([EMAIL PROTECTED]) [

Re: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

2001-04-19 Thread The Doctor What
* Paul Browning ([EMAIL PROTECTED]) [010419 13:53]: > I wouldn't dream of posting to zope-dev myself until > I'd read around a bit. And I've been reading around > for more than a year and I still haven't posted ... 10 months, thought it was enough. Two and half on this problem alone. Thanks for

Re: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

2001-04-19 Thread The Doctor What
* Andy McKay ([EMAIL PROTECTED]) [010419 14:26]: > Whats the problem with ZSQL? It calls a sql db with the sql statement, what > more could you want. If you want more, use python. How?!?! Documentation? Examples? Ciao! -- A fail-safe circuit will destroy others. -- Klipstein The Do

Re: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

2001-04-19 Thread Paul Erickson
The Doctor What wrote: > > * The Doctor What ([EMAIL PROTECTED]) [010419 11:57]: > > Does any one have an example of ZSQL being used witha normalized > > database? Or is ZSQL just useless? > > > > Near as I can tell, between: > > * Broken type marshalling > > * Loosing the variable between the f

Re: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

2001-04-19 Thread The Doctor What
* Paul Erickson ([EMAIL PROTECTED]) [010419 17:02]: > The Doctor What wrote: > > > * Loosing the variable between the form and dtml-if > > I don't understand this. I'm assuming that you are losing values that > are not in your argument list. All you have to do is add the arguments. That isn't

Re: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

2001-04-19 Thread The Doctor What
> Thanks. So I'm still having trouble. I can't get any of the list > examples to work. > > I build a select multiple list, and then try to dtml-in on it. It > doesn't seem to work. REQUEST shows in it th other and form > namespaces, as a list, but I can't actually dtml-var it or anything. >

Re: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

2001-04-19 Thread Casey Duncan
The Doctor What wrote: > > * Paul Erickson ([EMAIL PROTECTED]) [010419 17:02]: > > The Doctor What wrote: > > > > * Loosing the variable between the form and dtml-if > > > > I don't understand this. I'm assuming that you are losing values that > > are not in your argument list. All you have to

Re: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

2001-04-19 Thread The Doctor What
* Casey Duncan ([EMAIL PROTECTED]) [010419 17:45]: > Reason: foo=0 is actually foo='0'. foo:int=0 should work like you want. Same behaviour. I opened a bug in the collector a while ago about this: http://classic.zope.org:8080/Collector/2053/view A related bug: http://classic.zope.org:8080/Colle

RE: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

2001-04-20 Thread Adrian Hungate
Title: RE: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks) May be I am misunderstanding your problem here, but are you suggesting that     SELECT tab1.col1 col1, tab2.col1 col2     FROM ... etc ... Does not expose 'col1' and 'col2' in the namespace for

Re: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

2001-04-20 Thread The Doctor What
* Adrian Hungate ([EMAIL PROTECTED]) [010420 05:06]: > May be I am misunderstanding your problem here, but are you suggesting that > > SELECT tab1.col1 col1, tab2.col1 col2 > FROM ... etc ... > > Does not expose 'col1' and 'col2' in the namespace for you? This is not my > experience. Ok,

RE: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

2001-04-20 Thread Bryan Baszczewski
FROM etc... -Original Message- From: The Doctor What [mailto:[EMAIL PROTECTED]] Sent: Friday, April 20, 2001 10:21 AM To: [EMAIL PROTECTED] Subject: Re: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks) * Adrian Hungate ([EMAIL PROTECTED]) [010420 05:06]: &g

RE: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

2001-04-20 Thread Peter Sabaini
On Fri, 20 Apr 2001, Bryan Baszczewski wrote: > ...I mean that: >SELECT tab1.col1, tab2.col1 >FROM ... etc ... > Does not expose 'tab1.col1' and 'tab2.col1'. In otherwords, it > doesn't gracefully handle name clashes. I realize that calling out > the variable 'tab1.col1' out of the

Re: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

2001-04-20 Thread Hannu Krosing
The Doctor What wrote: > > * Adrian Hungate ([EMAIL PROTECTED]) [010420 05:06]: > > May be I am misunderstanding your problem here, but are you suggesting that > > > > SELECT tab1.col1 col1, tab2.col1 col2 > > FROM ... etc ... > > > > Does not expose 'col1' and 'col2' in the namespace for

RE: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

2001-04-20 Thread Adrian Hungate
Title: RE: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks) I am using ZODBC talking to an MS-SQL7 database (Yack spit), so the syntax is a little different. As for the unchangeable defaults, I use defaults a lot, and I don't think I've ever seen your problem. What