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:[EMAIL PROTECTED]] Sent: > Tuesday, December 03, 2002 8:34 PM > To: [EMAIL PROTECTED] > 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: <[EMAIL PROTECTED]> >> For additional commands, e-mail: <[EMAIL PROTECTED]> > > > > > --------------------------------------------------------------------- > 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: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> > > > --------------------------------------------------------------------- > 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: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> --------------------------------------------------------------------- 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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>