DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=5517>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=5517 How to generate XML tags within methods?! [EMAIL PROTECTED] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |WORKSFORME ------- Additional Comments From [EMAIL PROTECTED] 2001-12-19 16:18 ------- This uses esql, but the principal is the same. <?xml version="1.0"?> <xsp:page language="java" xmlns:xsp="http://apache.org/xsp"; xmlns:esql="http://apache.org/cocoon/SQL/v2";> <xsp:structure> <xsp:include>java.util.Calendar</xsp:include> <xsp:include>java.util.Date</xsp:include> <xsp:include>java.text.SimpleDateFormat</xsp:include> </xsp:structure> <xsp:logic> private void print_msgs(int bid, int parent ) throws SAXException { AttributesImpl xspAttr = new AttributesImpl(); String lastMonth = null; SimpleDateFormat sqlDate = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); Calendar cal = Calendar.getInstance(); cal.add(Calendar.DATE, -30); lastMonth = sqlDate.format( cal.getTime() ); <esql:connection> <esql:pool>phantom</esql:pool> <esql:execute-query> <esql:query> select message.id, parent_id, subject, first_name, last_name, date_posted from message left join user on message.user_id=user.id where parent_id=<xsp:expr>parent</xsp:expr> and hidden=0 and date_posted > '<xsp:expr>lastMonth</xsp:expr>' order by date_posted desc </esql:query> <esql:error-results> <esql:get-stacktrace/> </esql:error-results> <esql:results> <ul class="messages"> <esql:row-results> <li><a><xsp:attribute name="href">viewmessage.xsp?id=<esql:get-string column="id"/></xsp:attribute><esql:get-string column="subject"/></a> <esql:get-string column="first_name"/> <esql:get-string column="last_name"/> <em><esql:get-string column="date_posted"/></em> <xsp:logic>print_msgs(0,<esql:get-int column="id"/>);</xsp:logic></li> </esql:row-results> </ul> </esql:results> </esql:execute-query> </esql:connection> } </xsp:logic> <page> <title>Student Consultant Server</title> <div class="dontbreakme"> <div class="messages" > <xsp:logic>print_msgs(1, 0);</xsp:logic> </div> </div> </page> </xsp:page> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
