[Zope] SQL: nested select

[Bryan C. Andregg]

--96icqjDFsSi85SgI
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

I'm trying to generate a SQL query that includes a nested select tag,
something like

select * from models where name =3D
  ( select name from users where uid =3D <dtml-sqlvar uid type=3Dint )

I can do this easily by itself, but I'd like to be able to use this with so=
me
other optional parameters controled by a sqlgroup tag,

select * from models
  <dtml-sqlgroup where>
    <dtml-sqltest foo type=3Dnb optional>
  <dtml-and>
    <dtml-sqltest bar type=3Dnb optional>
  <dtml-and>
    ... My Test Here ...
  </dtml-sqlgroup>

How does one nest that select call in the DTML?

Cheers,
--=20
Bryan C. Andregg		Duke University Medical Center
 Programmer			Dept. of Anesthesiology
 e <bryan.andregg@duke.edu>
 p +1 919 684 6201

--96icqjDFsSi85SgI
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE9YQgcj9pElyS/cakRAgRhAJ4tvXiMDeQy1dPLuLJiwmSSKiLLSQCfe+yb
XqXi57gdYCfZX82sUUV85/U=
=ywfY
-----END PGP SIGNATURE-----

--96icqjDFsSi85SgI--