[Zope] Request.py and duplicate column names

[TFE MMS JARVIS JOHN]

Oops! The a.b_id=a.id was a typo in my mail. Sorry about that. I did
mean a.b_id=b.id.
I also tried out Brad Clements' suggestion (thanks, I would have never
thought to write it that way!) but it raises the same exception. It
works fine with the patch, though.

Thank you for your responses!

 John Jarvis
 Tokyo Electron FE, Ltd.

> -----Original Message-----
> From:	chris.hunter@humancode.com [SMTP:chris.hunter@humancode.com]
> Sent:	Wednesday, March 03, 1999 1:46 AM
> To:	bkc@murkworks.com
> Cc:	TFE MMS JARVIS JOHN; zope@zope.org
> Subject:	Re: [Zope] Request.py and duplicate column names
> 
> 
> 
> Brad Clements wrote:
> > 
> > On 2 Mar 99, at 18:40, TFE MMS JARVIS JOHN wrote:
> > 
> > > 1. When trying to do a join (a lazy query, I know) like:
> > >
> > >    select a.*, b.*
> > >    from tablea a, tableb b
> > >    where a.b_id=a.id
> 
> 	Is there any chance that you're trying to do something
> 	like:
> 
> 	select *
> 	from a, b
> 	where a.b_id = b.id
>                        ^
> 	Note that I'm joining a field in a to a field
> 	in b here (not 2 fields in a)
> 
> 	Hope this helps.
> 
> 	--chris
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://www.zope.org/mailman/listinfo/zope