[Zope] ZSQL subselect P

[Farrell, Troy]

This isn't a result of ZSQL methods not wanting to do multiple SELECTs is
it?
I can't tell from the traceback.

Troy

-----Original Message-----
From: Casey Duncan [mailto:cduncan@kaivo.com]
Sent: Tuesday, March 13, 2001 4:14 PM
To: Lee Marzke
Cc: zope@zope.org
Subject: Re: [Zope] ZSQL subselect P


Lee Marzke wrote:
> 
> Hi,
> 
> I'm trying to use a subquery with the following SQL syntax and get an
error.
> 
> SELECT * from return WHERE requestid = ( SELECT requestid from return
ORDER BY
> requestid LIMIT 1 )
> 
> Each part of the queary works seperatly but not together.  Are their
limitation
> on SQL statements that are allowed ?
> 
> Using Zope 2.3.0 and
> PostgresSQL 7.0.3
> ZPoPyDA-1.2.tar.gz
> PoPy-2.0.2.tar.gz
> 

I'm no MySQL expert, but generally you would use the IN operator when
doing subselects. Can MySQL even do subselects??

-- 
| Casey Duncan
| Kaivo, Inc.
| cduncan@kaivo.com
`------------------>

_______________________________________________
Zope maillist  -  Zope@zope.org
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )