Hi All! First off, I'd like to thank Digital Creations for an excellent (and really fun) product. I'm building a prototype web site interface for a database where I work using Zope 1.10.2 and the ZOracleDA product and have a some questions. 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 Both tables have an ID column so Zope raises a 'ValueError' exception with the message 'Duplicate column name, ID'. I wonder if instead of raising an exception something like the following could be done? A diff of Shared/DC/ZRDB/Results.py: 120,131c120 < #raise ValueError, 'Duplicate column name, %s' % name < < #instead of error, append an extension to < #create a unique name < tempname=name < nameext=1 < while schema.has_key(name): < name=tempname+'_'+str(nameext) < nameext=nameext+1 < < #update with newly created name < item['name']=name ---

raise ValueError, 'Duplicate column name, %s' % name

I tested this some and it seems to work. Are there any problems that could be caused by doing this? 2. I'll post the other questions separately because they are unrelated. TIA!, John Jarvis Tokyo Electron, FE Ltd.