[Zope-DB] HowTo access query fields of multiple tables?

maverick121@gmx.de maverick121@gmx.de
Tue, 23 Apr 2002 19:55:27 +0200 (MEST)


 Hi,
 
 I wrote a query like:
 
 SELECT tableA.name, tableB.name
 FROM tableA, tableB 
 WHERE ...
 
The query works well in the ZSQL test view. 
But how can I access the content of the .name fields in a dtml-var tag?
I tried it with:
 
 <dtml-in myquery>
   <dtml-var tableA.name>
   <dtml-var tableB.name>
 </dtml-in>
 
 ... this doesn't work.
 I also tried renaming the fields in SQL:

 SELECT tableA.name AS Aname, tableB.name AS BName
 FROM tableA, tableB 
 WHERE ...
 
 <dtml-in myquery>
   <dtml-var Aname>
   <dtml-var Bname>
 </dtml-in>

 but this also results in an error.
 I guess this is a FAQ, but I couldn't find the answer...
 Thanks in advance.
 regards,
 mike
 

-- 
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net