[Zope] SQL and dtml-tree

Mike Kelland mike@studiomatic.com
Wed, 29 Nov 2000 16:29:49 -0500 

This is a multi-part message in MIME format.

------=_NextPart_000_004C_01C05A21.97C0CEF0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I'm attempting to create a tree structure using dtml-tree from SQL =
results but I'm finding the documentation exceedingly cryptic.  What I =
want to do is create the following structure:

   Client1 (tree Branch)
                     Project1                        Edit | Delete
                     Project2                        Edit | Delete
  Client2
                     Project1                        Edit | Delete
  Client3
  Client4=20

out of a database contaning the above information (ie client names, =
project names, and unique identifiers for each).  I have the SQL queries =
that will give me the appropriate information I just need how to make =
the dtml-tree tag work with this.  Any help whatsoever would be useful, =
thanks!

Mike
mike@studiomatic.com


------=_NextPart_000_004C_01C05A21.97C0CEF0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I'm attempting to create a tree =
structure using=20
dtml-tree from SQL results but I'm finding the documentation exceedingly =

cryptic.&nbsp; What I want to do is create the following =
structure:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp; Client1 (tree =
Branch)</FONT></DIV>
<DIV><FONT face=3DArial=20
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Project1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
=20
Edit | Delete</FONT></DIV>
<DIV><FONT face=3DArial=20
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Project2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
=20
Edit | Delete</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp; Client2</FONT></DIV>
<DIV><FONT face=3DArial=20
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Project1&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Edit | Delete</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp; Client3</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp; Client4 </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>out of a database contaning the above =
information=20
(ie client names, project names, and unique identifiers for each).&nbsp; =
I have=20
the SQL queries that will give me the appropriate information I just =
need how to=20
make the dtml-tree tag work with this.&nbsp; Any help whatsoever would =
be=20
useful, thanks!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Mike</FONT></DIV>
<DIV><FONT face=3DArial size=3D2><A=20
href=3D"mailto:mike@studiomatic.com">mike@studiomatic.com</A></FONT></DIV=
>
<DIV>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_004C_01C05A21.97C0CEF0--