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 you? This is not my

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, I

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

2001-04-20 Thread Bryan Baszczewski
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]: May be I am misunderstanding your problem here, but are you suggesting

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 you? This is

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 you appear

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 to

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

2001-04-19 Thread Andy McKay
MAIL 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]) [010419 11:57]: Does any one have an example of Z

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

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 form and

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 what I

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 do is add the

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: