Re: [Zope] SQL: nested select

19 Aug 2002


      On Mon, Aug 19, 2002 at 12:47:50PM -0400, vsbabu@vsbabu.org mailed:
...
Hi,
Wouldn't this work?
select * from models
    <dtml-sqlgroup where>
      <dtml-sqltest foo type=nb optional>
    <dtml-and>
      <dtml-sqltest bar type=nb optional>
    <dtml-and>
      name = (select name from users where
      uid = <dtml-sqlvar uid type=int )
    </dtml-sqlgroup>
This make "name" a required field or matches on '' which fails, of course.
-- 
Bryan C. Andregg		Duke University Medical Center
 Programmer			Dept. of Anesthesiology
 e <bryan.andregg@duke.edu>
 p +1 919 684 6201