<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2745.2800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 8pt Tahoma; MARGIN-LEFT: 2px"
bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I think your <body> tag should be after the
<div metal: "Main"> line...</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>as </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><body tal:define="results " bla bla
bla...</FONT></DIV>
<DIV><FONT face=Arial size=2>(at least that)</FONT></DIV>
<DIV><FONT face=Arial size=2>Sent you an email off-list...</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>hth</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>bobb</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=MILLIKEL@neumann.edu href="mailto:MILLIKEL@neumann.edu">Lawrence
Milliken</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=zope-db@zope.org
href="mailto:zope-db@zope.org">zope-db@zope.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, March 15, 2005 12:09
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Zope-DB] showing mysql results
in plone</DIV>
<DIV><BR></DIV>
<DIV><FONT size=1>Sorry for the cross-post, I'm not getting any help from
Plone-Users and I'm really stuck.</FONT></DIV>
<DIV><FONT size=1></FONT> </DIV>
<DIV>
<DIV><FONT size=1>hi all,</FONT></DIV>
<DIV><FONT size=1></FONT> </DIV>
<DIV><FONT size=1>I have a zpt for a zsql query that, when I view it, looks
like a plone document, I'm trying to figure out how to either add it to
a folder on my plone site or paste it into a plone document so that the query
results are displayed.</FONT></DIV>
<DIV><FONT size=1></FONT> </DIV>
<DIV><FONT size=1>The code for the zpt (in portal_skins/custom)
is:</FONT></DIV>
<DIV><FONT size=1><code> </FONT></DIV>
<DIV><FONT size=1><html xmlns="<A
href="http://www.w3.org/1999/xhtml">http://www.w3.org/1999/xhtml</A>"
xml:lang="en"<BR>
lang="en"<BR>
metal:use-macro="here/main_template/macros/master"<BR>
i18n:domain="plone"></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=1><body></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=1><div metal:fill-slot="main"></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=1> <span tal:define="results
here/databases_alpha_mysql;<BR>
start
request/start|python:0;<BR>
batch python:modules['ZTUtils'].Batch(results,
<BR>
size=20,
<BR>
start=start);<BR>
previous
python:batch.previous;<BR>
next python:batch.next"></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=1> <h1>Online Databases at the Neumann College
Library</h1><BR> <h4>Alphabetical by Database Name | <a
href="db_subject_html" name="db subject list">Databases by
Subject</h4> <BR> <p><BR> <a
tal:condition="previous"<BR>
tal:attributes="href
string:${request/URL0}?start:int=${previous/first}"<BR>
href="previous_url">previous <span
tal:replace="previous/length">20</span>
results</a><BR> <a
tal:condition="next"<BR>
tal:attributes="href
string:${request/URL0}?start:int=${next/first}"<BR>
href="next_url">next <span tal:replace="next/length">20</span>
results</a><BR> </p></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=1> <BR> <div tal:repeat="result batch"
><BR> <BR>
<dl><BR>
<dt><a href="#" tal:attributes="href
result/db_url;<BR>
title result/db_name"><span tal:replace="result/db_name">db_name goes
here</span></a></dt><BR>
<dd><span tal:replace="result/db_description">db_description goes
here</span></dd><BR>
</dl><BR> <br
/></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=1> </div></FONT></DIV>
<DIV><FONT size=1></code></FONT></DIV>
<DIV><FONT size=1></FONT> </DIV>
<DIV><FONT size=1>I've tried pasting that into the body of a new document but
the results don't replace the placeholders. When I view the page I
get:</FONT></DIV>
<DIV><FONT size=1></FONT> </DIV>
<DIV><!--StartFragment -->
<DIV class=plain>
<DIV metal:fill-slot="main"><SPAN
tal:define="results here/databases_alpha_mysql; start request/start|python:0; batch python:modules['ZTUtils'].Batch(results, size=20, start=start); previous python:batch.previous; next python:batch.next">
<H1>Online Databases at the Neumann College Library</H1>
<H4>Alphabetical by Database Name | <A
href="http://10.1.3.204:8200/databases/db_subject_html"
name="db subject list">Databases by Subject</A></H4><A
href="http://10.1.3.204:8200/databases/db_subject_html"
name="db subject list"></A>
<P><A href="http://10.1.3.204:8200/databases/db_subject_html"
name="db subject list"></A><A
href="http://10.1.3.204:8200/databases/previous_url" tal:condition="previous"
tal:attributes="href string:${request/URL0}?start:int=${previous/first}">previous
<SPAN tal:replace="previous/length">20</SPAN> results</A> <A
href="http://10.1.3.204:8200/databases/next_url" tal:condition="next"
tal:attributes="href string:${request/URL0}?start:int=${next/first}">next
<SPAN tal:replace="next/length">20</SPAN> results</A> </P>
<DIV tal:repeat="result batch">
<DL>
<DT><A
href="http://10.1.3.204:8200/databases/document.2005-03-14.6239199029#"
tal:attributes="href result/db_url; title result/db_name"><SPAN
tal:replace="result/db_name">db_name goes here</SPAN></A>
<DD><SPAN tal:replace="result/db_description">db_description goes
here</SPAN></DD></DL><BR></DIV>
<P><A href="http://10.1.3.204:8200/databases/previous_url"
tal:condition="previous"
tal:attributes="href string:${request/URL0}?start:int=${previous/first}">previous
<SPAN tal:replace="previous/length">20</SPAN> results</A> <A
href="http://10.1.3.204:8200/databases/next_url" tal:condition="next"
tal:attributes="href string:${request/URL0}?start:int=${next/first}">next
<SPAN tal:replace="next/length">20</SPAN> results</A> </P></SPAN></DIV></DIV>
<DIV class=documentByLine><SPAN>Any help will be appreciated.</SPAN></DIV>
<DIV> </DIV>
<DIV class=documentByLine><SPAN>Larry Milliken<BR>Reference
Librarian<BR>Neumann College Library</SPAN></DIV>
<DIV> </DIV>
<DIV class=documentByLine><SPAN>Larry Milliken<BR>Reference
Librarian<BR>Neumann College Library</SPAN></DIV></DIV></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>Zope-DB mailing
list<BR>Zope-DB@zope.org<BR>http://mail.zope.org/mailman/listinfo/zope-db<BR></BLOCKQUOTE></BODY></HTML>