[Zope] More Zope/PostGreSQL/PoPyDA.

Mon, 27 Aug 2001 14:28:09 +0200

This is a multi-part message in MIME format.

------=_NextPart_000_0127_01C12F04.7EB48920
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

My personal configuration:
 ZPoPyDA 2.0.7
 Zope 2.4.0
 Python 2.1.1   =20
 Debian/GNU Linux

Another bug or is it only a bad dtml construction?
Again from ZopeBook I see this
   =20
Examples

Sample usage:

select * from employees

<dtml-sqlgroup where>

<dtml-sqltest salary op=3Dgt type=3Dfloat optional>

<dtml-and>

<dtml-sqltest first op=3Deq type=3Dstring multiple optional>

<dtml-and>

<dtml-sqltest last op=3Deq type=3Dstring multiple optional>

</dtml-sqlgroup>

(...)

If salary is 50000 and last is Smith it renders:

select * from employees

where

(salary > 50000.0

and

last=3D'Smith'

)

Mmmm..., is ZPoPyDA supposse to do that? I don=B4t think so. My code:

Arguments: id, name.

SELECT * FROM Departments
<dtml-sqlgroup where>
 <dtml-sqltest id op=3Deq type=3Dint optional>
<dtml-and>
 <dtml-sqltest name op=3Deq type=3Dstring optional> IT WORKS!!! with the =
fix by Jim Penny
</dtml-sqlgroup>
ORDER BY id

My Query Result without blanks arguments, Zope renders...

SELECT * FROM Departments
where
name =3D ''
ORDER BY idDepartamento

Ups! Is it my code or is it a new bug? I=B4m thinking about change to =
psicopg... Is it a good idea?

Antonio Carrasco

------=_NextPart_000_0127_01C12F04.7EB48920
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3103.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>My personal configuration:</DIV>
<DIV>&nbsp;ZPoPyDA 2.0.7</DIV>
<DIV>&nbsp;Zope 2.4.0</DIV>
<DIV>&nbsp;Python 2.1.1&nbsp;&nbsp;&nbsp; =
</DIV>
<DIV>&nbsp;Debian/GNU Linux</DIV>
<DIV>&nbsp;</DIV>
<DIV>Another bug or is it only a bad dtml=20
construction?</DIV>
<DIV>Again from ZopeBook I see =
this</DIV>
<DIV>&nbsp;&nbsp;&nbsp; 
Examples
Sample usage:
select * from employees
&lt;dtml-sqlgroup where&gt;
&lt;dtml-sqltest salary op=3Dgt type=3Dfloat optional&gt;
&lt;dtml-and&gt;
&lt;dtml-sqltest first op=3Deq type=3Dstring multiple =
optional&gt;
&lt;dtml-and&gt;
&lt;dtml-sqltest last op=3Deq type=3Dstring multiple optional&gt;
&lt;/dtml-sqlgroup&gt;
(...)
If salary <FONT=20
face=3D"Times New Roman" size=3D3>is 50000 and last=20
is Smith it=20
renders:
select * from employees
where
(salary &gt; 50000.0
and
last=3D'Smith'
)
Mmmm..., is ZPoPyDA supposse to do that? =
I don=B4t=20
think so. My code:
Arguments: id, name.
&nbsp;SELECT * FROM =
Departments &lt;dtml-sqlgroup=20
where&gt; &nbsp;&lt;dtml-sqltest id op=3Deq type=3Dint=20
optional&gt; &lt;dtml-and&gt; &nbsp;&lt;dtml-sqltest name op=3Deq=20
type=3Dstring optional&gt; IT WORKS!!! with the fix by Jim=20
Penny &lt;/dtml-sqlgroup&gt; ORDER BY id
My Query Result without blanks arguments, =
Zope=20
renders...
SELECT * FROM =
Departments where name =3D=20
'' ORDER BY idDepartamento
Ups! Is it my code or is it a new bug? =
I=B4m thinking=20
about change to psicopg... Is it a good idea?
Antonio =
Carrasco 
&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_0127_01C12F04.7EB48920--