[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