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 )