[Zope] Splitting ZSQL results across pages

Wilkinson Charlie E Charlie.E.Wilkinson@irs.gov
Thu, 10 Aug 2000 17:50:02 -0400


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_01C00314.F13738F2
Content-Type: text/plain;
	charset="iso-8859-1"

-----Original Message-----
>From: Dieter Maurer [dieter@handshake.de]
>
>John Morton writes:
> > I'd like to split the output of a ZSQL query across different instances
of
> > a page in the same fashion as zope.org does with ZCatalog output, but I
> > can't for the life of me find any documentation on how it's done. Does
> > anyone know the magic incarntations or where the documents are?
>
> Look at the "in" tag's batching features.

Or for something with a gentler learning curve:

http://www.zope.org/Documentation/Guides/ZSQL

Go there and read the section on "Creating Search Interfaces."  Zope will
magically create a search query form and a table-formatted batching output
method on the back end, based on an SQL Query method of your own design.  So
read that, do that, and then look at the methods it creates.  I found it
very useful in getting up to speed on how to roll my own batching DTML
methods.

-cw-

PS - (OT rant warning) I have set everywhere I know of to tell %^#$@!
Outlook 2k to send PLAIN TEXT, but it's apparently WAY TO SMART to simply
let me do ASCII and leave me be.  If you have a solution (especially if it
involves high explosives), I'm all ears.  I don't hafta put up with this
kinda crap from my *nix boxes.  (Mutter grumble...)  If I could get an
Exchange(r)(tm)(c2000) client running on my Linus W/S, this thing would be
history sooo fast.  What a waste of a Pentium3 box...  (I feel a little
better now, thanks.)

-- 
Charlie Wilkinson
TRIS Development Systems Administrator 
IS:SD:CT:CC:TD
Phone: 202-283-3241 
MSMail:   Charlie.E.Wilkinson@irs.gov
SMTP:  cwilkins@tris.irs.gov
Home:  cwilkins@boinklabs.com 
This message constructed from 90% post-consumer electrons.

------_=_NextPart_001_01C00314.F13738F2
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.2650.12">
<TITLE>RE: [Zope] Splitting ZSQL results across pages</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>&gt;From: Dieter Maurer [dieter@handshake.de]</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;John Morton writes:</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; I'd like to split the output of a ZSQL =
query across different instances of</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; a page in the same fashion as zope.org =
does with ZCatalog output, but I</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; can't for the life of me find any =
documentation on how it's done. Does</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; anyone know the magic incarntations or =
where the documents are?</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Look at the &quot;in&quot; tag's batching =
features.</FONT>
</P>

<P><FONT SIZE=3D2>Or for something with a gentler learning =
curve:</FONT>
</P>

<P><FONT SIZE=3D2><A =
HREF=3D"http://www.zope.org/Documentation/Guides/ZSQL" =
TARGET=3D"_blank">http://www.zope.org/Documentation/Guides/ZSQL</A></FON=
T>
</P>

<P><FONT SIZE=3D2>Go there and read the section on &quot;Creating =
Search Interfaces.&quot;&nbsp; Zope will magically create a search =
query form and a table-formatted batching output method on the back =
end, based on an SQL Query method of your own design.&nbsp; So read =
that, do that, and then look at the methods it creates.&nbsp; I found =
it very useful in getting up to speed on how to roll my own batching =
DTML methods.</FONT></P>

<P><FONT SIZE=3D2>-cw-</FONT>
</P>

<P><FONT SIZE=3D2>PS - (OT rant warning) I have set everywhere I know =
of to tell %^#$@! Outlook 2k to send PLAIN TEXT, but it's apparently =
WAY TO SMART to simply let me do ASCII and leave me be.&nbsp; If you =
have a solution (especially if it involves high explosives), I'm all =
ears.&nbsp; I don't hafta put up with this kinda crap from my *nix =
boxes.&nbsp; (Mutter grumble...)&nbsp; If I could get an =
Exchange(r)(tm)(c2000) client running on my Linus W/S, this thing would =
be history sooo fast.&nbsp; What a waste of a Pentium3 box...&nbsp; (I =
feel a little better now, thanks.)</FONT></P>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Charlie Wilkinson</FONT>
<BR><FONT SIZE=3D2>TRIS Development Systems Administrator </FONT>
<BR><FONT SIZE=3D2>IS:SD:CT:CC:TD</FONT>
<BR><FONT SIZE=3D2>Phone: 202-283-3241 </FONT>
<BR><FONT SIZE=3D2>MSMail:&nbsp;&nbsp; =
Charlie.E.Wilkinson@irs.gov</FONT>
<BR><FONT SIZE=3D2>SMTP:&nbsp; cwilkins@tris.irs.gov</FONT>
<BR><FONT SIZE=3D2>Home:&nbsp; cwilkins@boinklabs.com </FONT>
<BR><FONT SIZE=3D2>This message constructed from 90% post-consumer =
electrons.</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C00314.F13738F2--