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 )