cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Ball <ba...@webslingerZ.com>
Subject Re: [C2] (hopefully) last sitemap major changes
Date Mon, 03 Jul 2000 03:33:56 GMT
> I hope it doesn't get too complicated.
> Before I found Cocoon was thinking of creating a servlet for report
> generation and database insertions and transactions in the intranet. The XML
> i was creating was beginning to become a monster.
> This is one of the first versions (the text is in Italian):
> 
> <?xml version="1.0"?>
> <!DOCTYPE SQLQuerySetDB SYSTEM "SQLQuerySetDB.dtd">
> <SQLQuerySetDB>
>    <DBIds>
>       <DBId DBref="OreLavorateDB" DBdriver="sun.jdbc.odbc.JdbcOdbcDriver"
> DBname="jdbc:odbc:OreLavorate" userId="admin" userPass="admin"/>
>       <DBId DBref="KeyDB" DBdriver="sun.jdbc.odbc.JdbcOdbcDriver"
> DBname="jdbc:odbc:KeyDB" userId="admin" userPass="admin"/>
>    </DBIds>
>    <SQLQuerySet name="TestQuerySet" stylesheet="testsheet.xsl">
>       <SQLQuery name="TestQuery" DB="OreLavorate" type="SELECT">
>          <SQLQueryString>SELECT ? from contatti</SQLQueryString>
>          <SQLQueryParameters>
>             <form name="firstform" stylesheet="testsheet.xsl">
>                <select name="C1" default="0">
>                   <caption>Scegli un choice:</caption>
>                   <choices>
>                      <choice value="1">choice 1</choice>
>                      <choice value="2">choice 2</choice>
>                   </choices>
>                </select>
>                <input name="I1" default="0">
>                   <caption>Inserisci:</caption>
>                </input>
>                <hidden name="H1" default="defaulthiddenvalue"/>
>                <select name="SQLS1" default="0">
>                   <caption>Scegli un choice SQL:</caption>
>                   <choices>
>                      <SQLQuery name="TestQuery2" DB="OreLavorate"
> type="SELECT">
>                         <SQLQueryString>SELECT "Gino" from
> contatti</SQLQueryString>
>                      </SQLQuery>
>                   </choices>
>                </select>
>             </form>
>          </SQLQueryParameters>
>       </SQLQuery>
>    </SQLQuerySet>
> </SQLQuerySetDB>
> 
> I was creating a tree containing all transaction info, starting fron the
> result wanted (report in this case).
> It was getting too big and to make decision branching possible I thought of
> putting forward and backward branches: A NIGHTMARE!
> So +100 to the idea of keeping it simple.

holy ratatouille, batman! that's a hell of a chunk of XML there. you might
be interested in my castor logicsheet for doing database editing -

http://www.webslingerZ.com/balld/wz-castor-0.2.zip

- donald


Mime
View raw message