Going by the general rule that explicit is good and implicit is bad. I would
disagree with this. ZSQL Methods do have some oddities in the lookup that
seem strange, but making it more "magical" is a path to ruin.
Cheers.
--
Andy McKay.
___
Zope-Dev
On Thursday 11 October 2001 07:29 am, you wrote:
> I've been asked too many times now by developers what is wrong when they
> call ZSQL Methods without passing parameters because their parameters
> are in the namespace. This seems to make sense to all new Zopers (and
> some older ones like myself
1 2:43 PM
To: [EMAIL PROTECTED]
Cc: Paul Zwarts; [EMAIL PROTECTED]
Subject: Re: [Zope-dev] ZSQL methods lookup vars in REQUEST only (why?)
>>> Anyway, I propose that ZSQLMethods change and do variable lookups in
the
>>> entire namespace, not just the REQUEST object. It seems to be
>>> Anyway, I propose that ZSQLMethods change and do variable lookups in the
>>> entire namespace, not just the REQUEST object. It seems to be a simple
>>> enough change (at least it looks it) and I can submit the patches, but
>>> the harder thing is to get people to agree that it is a change fo
ggest a way around this?
>
> Thanks,
> Paul Zwarts
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf
> Of Tim McLaughlin
> Sent: Thursday, October 11, 2001 1:30 PM
> To: [EMAIL PROTECTED]
> Cc: Micah Martin
> Subject: [Zope-dev] ZSQ
--
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf
Of Tim McLaughlin
Sent: Thursday, October 11, 2001 1:30 PM
To: [EMAIL PROTECTED]
Cc: Micah Martin
Subject: [Zope-dev] ZSQL methods lookup vars in REQUEST only (why?)
I've been asked too many times now by developers what is wrong
I've been asked too many times now by developers what is wrong when they
call ZSQL Methods without passing parameters because their parameters
are in the namespace. This seems to make sense to all new Zopers (and
some older ones like myself) because all other DTML lookups are in the
entire namesp
Hi Guys,
I wanted to use ZSQL Methods in Z Classes to share code between different
parts of a large project. The different parts need to use similar, but
separate, database namespaces, but I still wanted to use the same methods.
Now, ZSQL Methods treat their Database connection ID, for some reas
[browsing through old versions of Zope]
I can't find any code that's supposed to do this in old versions of
Zope either. (I may be missing something, though)
If this feature was never there, I'd consider the ZSQL documentation
(for instance in the Zope help) to be quite broken however.
Regard
Hi there,
Type marshalling is seriously broken in ZSQL methods. The bug is a bit
subtle, though. There are reports of this in the collector almost a month
old, and the severity of this bug is pretty high (could seriously disrupt Zope
upgrades to recent versions which apparently have this bug; I
"Phillip J. Eby" wrote:
>
> At 12:49 PM 9/22/00 -0400, Jim Fulton wrote:
> >"Phillip J. Eby" wrote:
> >>
> >> Ty and I have put together a Stored Procedure method for Sybase; it
> >> requires a minor patch to ZSybaseDA, however, to allow for the status code
> >> return. I'm not sure how useful i
At 12:49 PM 9/22/00 -0400, Jim Fulton wrote:
>"Phillip J. Eby" wrote:
>>
>> Ty and I have put together a Stored Procedure method for Sybase; it
>> requires a minor patch to ZSybaseDA, however, to allow for the status code
>> return. I'm not sure how useful it would be to anyone else, though, sin
"Phillip J. Eby" wrote:
>
> At 08:43 AM 9/22/00 -0400, Jim Fulton wrote:
> >> Also, does anyone know of any work done to extend ZSQL Methods to allow
> >> stored-procedure calls?
> >
> >No, but I'd love to see someone tackle it. The semantics
> >of stored procedures varies so widely accross datab
At 08:43 AM 9/22/00 -0400, Jim Fulton wrote:
>> Also, does anyone know of any work done to extend ZSQL Methods to allow
>> stored-procedure calls?
>
>No, but I'd love to see someone tackle it. The semantics
>of stored procedures varies so widely accross databases, that
>I doubt that it would be ea
Monty Taylor wrote:
>
> Jim Fulton wrote:
>
(snip)
> > Note that one of the things I like about Oracle's stored procedures
> > is that they allow me to avoid screwing with cursors in the common case
> > that I'm getting one row of data. I can just get the data I need through
> > a straight func
Jim Fulton wrote:
> Monty Taylor wrote:
>
> > Also, does anyone know of any work done to extend ZSQL Methods to allow
> > stored-procedure calls?
>
> No, but I'd love to see someone tackle it. The semantics
> of stored procedures varies so widely accross databases, that
> I doubt that it would be
Monty Taylor wrote:
>
> Hey, is there any doco about using ZSQL Methods from Python Products?
Not that I'm aware of. You simply call them pretty much like
any other Python callable thing. The signature is:
someMethod([mapping, **other_arguments])
where:
mapping is a mapping object th
Hey, is there any doco about using ZSQL Methods from Python Products?
Also, does anyone know of any work done to extend ZSQL Methods to allow
stored-procedure calls? I know I can do an Oracle Procedure call from
DCOracle that returns a cursor, but I'd love to combine that with the
caching/pluggabl
Using ZSQLMethods against an ORACLE 8.0.6 Database.
I have two tables, each with a NUMBER(6) key field.
If I create a method which selects against each of the tables
then method returns an integer (e.g. 5040), as expected.
select index_number
from names
where name = 'name'
or
select index_n
I want to create a ZClass that will incorporate a number of ZSQL methods.
I have a couple of questions about how I should do this.
1. I don't want to tie my ZClass to a particular database adapter. But
to create my ZSQL methods inside of my zclass I need a connection. How
do I circumvent this?
20 matches
Mail list logo
