[Zope] Building a page from multiple paramatised queries

Tue, 7 Aug 2001 12:05:58 +0100

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C11F30.EF8C86E0
Content-Type: text/plain;
	charset="iso-8859-1"

I'm a zope novice so I'm probably missing something obvious.  My intent is
to build a web page from the results of two queries, each of which are
paramatised by the same value.

I've got a single query working fine:

FeatureDetailQuery has a parameter ID and SQL:
select * from Feature where <dtml-sqltest Id op=eq type=int>

FeatureDetail is a simple web page:
<dtml-var standard_html_header>
<h1><dtml-var Name></h1>
<dtml-var standard_html_footer>

and I bind the two together by referencing them with the a href =
FeatureDetailQuery/Id/<dtml-var Id>/FeatureDetail

All's well.  My problem is that I want to add the output of another query,
also parametised by Id to the same web page and I'm stumped as to how to go
about it.  Any suggestions?

Giles Chamberlin

------_=_NextPart_001_01C11F30.EF8C86E0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>Building a page from multiple paramatised queries</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>I'm a zope novice so I'm probably missing something =
obvious.&nbsp; My intent is to build a web page from the results of two =
queries, each of which are paramatised by the same value.</FONT></P>

<P><FONT SIZE=3D2>I've got a single query working fine:</FONT>
</P>

<P><FONT SIZE=3D2>FeatureDetailQuery has a parameter ID and SQL:</FONT>
<BR><FONT SIZE=3D2>select * from Feature where &lt;dtml-sqltest Id =
op=3Deq type=3Dint&gt;</FONT>
</P>

<P><FONT SIZE=3D2>FeatureDetail is a simple web page:</FONT>
<BR><FONT SIZE=3D2>&lt;dtml-var standard_html_header&gt;</FONT>
<BR><FONT SIZE=3D2>&lt;h1&gt;&lt;dtml-var Name&gt;&lt;/h1&gt;</FONT>
<BR><FONT SIZE=3D2>&lt;dtml-var standard_html_footer&gt;</FONT>
</P>

<P><FONT SIZE=3D2>and I bind the two together by referencing them with =
the a href =3D FeatureDetailQuery/Id/&lt;dtml-var =
Id&gt;/FeatureDetail</FONT>
</P>

<P><FONT SIZE=3D2>All's well.&nbsp; My problem is that I want to add =
the output of another query, also parametised by Id to the same web =
page and I'm stumped as to how to go about it.&nbsp; Any =
suggestions?</FONT></P>

<P><FONT SIZE=3D2>Giles Chamberlin</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C11F30.EF8C86E0--