Andreas Tille wrote at 2006-11-23 16:06 +0100:
>
>Unfortunately
>
>does not seem to work transparently in the SQL-Method
Right.
"ZSQL Method"s take their parameters either from explicitly passed
keyword arguments or from the request but not from the DTML namespace.
--
Dieter
__
Hi
you remember my report
http://mail.zope.org/pipermail/zope/2005-August/160762.html
of an BUG for the handling of LONGs in DCO2?
The consequence of this BUG is stochastic results for LONG fields
We use an Fix of this BUG:
Hint: The Documentation of the OCI from Oracle say us:
defn
Am 23.11.2006, 17:03 Uhr, schrieb Andreas Tille <[EMAIL PROTECTED]>:
You are right here and I would definitely prefer Python scripts. The
problem is that I'm using the Formulator Product and despite there are
descriptions how to use it with Python scripts I failed while it was
very straigtforew
- Original Message -
From: "Andreas Tille" <[EMAIL PROTECTED]>
To: "Jonathan" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, November 23, 2006 11:03 AM
Subject: Re: dtml-let variables in sql queries
On Thu, 23 Nov 2006, Jonathan wrote:
name nameid
SELECT * FROM names
WHERE fake = 0
On Thu, 23 Nov 2006, Jonathan wrote:
name nameid
SELECT * FROM names
WHERE fake = 0
AND
AND
First off, i would highly recommend using python scripts instead of DTML for
the kind of processing you have described.
You are right here and I would definitely prefer Python scripts. T
- Original Message -
From: "Andreas Tille" <[EMAIL PROTECTED]>
To:
Sent: Thursday, November 23, 2006 10:06 AM
Subject: [Zope-DB] dtml-let variables in sql queries
Hi,
I have defined the following table
CREATE TABLE names (
nameid int,
name text,
fake int
);
INS
Hi,
I have defined the following table
CREATE TABLE names (
nameid int,
name text,
fake int
);
INSERT INTO names values ( 1, 'Alfons',0 );
INSERT INTO names values ( 2, 'Alberto', 0 );
INSERT INTO names values ( 3, 'Adam', 0 );
INSERT INTO names values ( 4, 'Anibal