cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Antonio Gallardo" <agalla...@agsoftware.dnsalias.com>
Subject RE: Don't get XML tags with SQLTransformer
Date Tue, 03 Dec 2002 21:45:40 GMT
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>


Mime
View raw message