cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "raffy" <ra...@jaaboo.com>
Subject XSp and SQL
Date Sun, 27 Aug 2000 17:22:06 GMT
Hi, 

i am very new in using Cocoon and by testing the examples i get the following problem:

<?xml version="1.0"?>
<?cocoon-process type="xsp"?>
<xsp:page language="java" xmlns:sql="http://www.apache.org/1999/SQL" xmlns:xsp="http://www.apache.org/1999/XSP/Core">
  <page title="SQL Search Results">
    <sql:execute-query>
      <sql:driver>sun.jdbc.odbc.JdbcOdbcDriver</sql:driver>
      <sql:dburl>jdbc:odbc:AND</sql:dburl>
      <sql:username>sa</sql:username>
      <sql:password></sql:password>
      <sql:doc-element>DOC</sql:doc-element>
      <sql:row-element>ROW</sql:row-element>
      <sql:null-indicator>yes</sql:null-indicator>
      <sql:id-attribute>id</sql:id-attribute>
      <sql:id-attribute-column>nr</sql:id-attribute-column>
      <sql:count-attribute>count</sql:count-attribute>
      <sql:query>select nachname from telefonliste where nachname like 'R%'</sql:query>
    </sql:execute-query>
  </page>
</xsp:page>

i expected to get some data, but the only thing i get is the following:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd">
<page title="SQL Search Results">
    <DOC count="25"><ROW id="0"><nachname
null="YES"></nachname></ROW><ROW id="1"><nachname
null="YES"></nachname></ROW><ROW id="2"><nachname
null="YES"></nachname></ROW><ROW id="3"><nachname
.....
null="YES"></nachname></ROW><ROW id="22"><nachname
null="YES"></nachname></ROW><ROW id="23"><nachname
null="YES"></nachname></ROW><ROW id="24"><nachname null="YES"></nachname></ROW></DOC>
  </page>

<!-- This page was served in 1573 milliseconds by Cocoon 1.7.4 -->

The number of rows is correct, but where is the content of the fields?

- Raffy






Mime
View raw message