Return-Path: 
 <cocoon-users-return-43424-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 6745 invoked by uid 500); 4 Dec 2002 10:48:42 -0000
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-users-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-users-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-users@xml.apache.org>
Reply-To: cocoon-users@xml.apache.org
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 6734 invoked from network); 4 Dec 2002 10:48:41 -0000
X-Authentication-Warning: ags01.agsoftware.dnsalias.com: apache set sender to
 agallardo@agsoftware.dnsalias.com using -f
Message-ID: <40552.10.0.0.1.1038951940.squirrel@_default_>
Date: Wed, 4 Dec 2002 04:45:40 +0700 (GMT-7)
Subject: RE: Don't get XML tags with SQLTransformer
From: "Antonio Gallardo" <agallardo@agsoftware.dnsalias.com>
To: <cocoon-users@xml.apache.org>
In-Reply-To: <DD00ACEE56F4A04DB7092539C493FADC4D876C@sxmbx06.corproot.net>
References: <DD00ACEE56F4A04DB7092539C493FADC4D876C@sxmbx06.corproot.net>
X-Priority: 3
Importance: Normal
X-Mailer: SquirrelMail (version 1.2.9)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Check your pool configuration in cocoon.xconf.

Antonio Gallardo



> I get this error
> org.apache.cocoon.ProcessingException: Could not read resource
> file:/C:/Program Files/Apache Group/Tomcat
> 4.1/webapps/cocoon/WorkflowMAX/Default.xml:
> org.xml.sax.SAXParseException: The prefix "esql" for element
> "esql:connection" is not bound.
>
> -----Original Message-----
> From: Antonio Gallardo [mailto:agallardo@agsoftware.dnsalias.com]  Sent:
> Tuesday, December 03, 2002 8:34 PM
> To: cocoon-users@xml.apache.org
> Subject: Re: Don't get XML tags with SQLTransformer
>
>
> Hi!
>
> You can use another xsl or a generator to get this job done. For
> example, using XSP:
>
> <esql:connection>
>   <esql:pool>mp_pool</esql:pool>
>     <esql:execute-query>
>       <esql:query>
>         SELECT usr_id, usr_name, FROM users
>         WHERE usr_enable=1
>       </esql:query>
>       <esql:results>
>         <UsersList>
>           <esql:row-results>
>             <User>
>               <ID><esql:get-int column="usr_id"/></ID>
>               <Name><esql:get-string column="usr_name"/></Name>
>             </User>
>           </esql:row-results>
>         </UsersList>
>       </esql:results>
>     </esql:execute-query>
> </esql:connection>
>
> I hope this will help you. :-)
>
> Antonio Gallardo
>
>> Hi,
>> When I execute a query like "select wfID as ID, wfName as Name from
>> Workflowlist" In the browser (I used the default xml2html stylesheet)
>> I get something like this :
>>
>> -<4="4"name="name">
>>   -<>
>>    <>1</>
>>    <>Max_pkg1</>
>>   </>
>>   -<>
>>    <>2</>
>>    <>Max_pkg2</>
>>   </>
>> ...
>> </>
>>
>> But how can I get the tags like :
>>
>> -<Workflowlist>
>>   -<Workflow>
>>    <ID>1</ID>
>>    <Name>Max_pkg1</Name>
>>   </Workflow>
>>   -<Workflow>
>>    <ID>2</ID>
>>    <Name>Max_pkg2</Name>
>>   </Workflow>
>> ...
>> </Workflowlist>
>>
>> ---------------------------------------------------------------------
>> Please check that your question  has not already been answered in the
>> FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>
>>
>> To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
>> For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>
>
>
>
>
> ---------------------------------------------------------------------
> Please check that your question  has not already been answered in the
> FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>
>
>
> ---------------------------------------------------------------------
> Please check that your question  has not already been answered in the
> FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>




---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>