Return-Path: Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 60311 invoked from network); 27 Aug 2000 17:21:31 -0000 Received: from unknown (HELO grafx.server-service.de) (212.114.232.129) by locus.apache.org with SMTP; 27 Aug 2000 17:21:31 -0000 Received: from assimilierer [62.157.57.101] by grafx.server-service.de (SMTPD32-5.05) id AC29352B022E; Sun, 27 Aug 2000 19:13:13 +0200 From: "raffy" To: "cocoon list" Date: Sun, 27 Aug 2000 19:22:06 +0200 Reply-To: "raffy" Priority: Normal X-Mailer: PMMail 2000 Professional (2.10.2010) For Windows 2000 (5.0.2195;1) MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_=_=_=IMA.BOUNDARY.HTML_4963392=_=_=_" Subject: XSp and SQL Message-Id: <200008271913553.SM00191@assimilierer> X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N --_=_=_=IMA.BOUNDARY.HTML_4963392=_=_=_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, i am very new in using Cocoon and by testing the examples i get the following problem:

sun.jdbc.odbc.JdbcOdbcDriver jdbc:odbc:AND sa

DOC

ROW

yes

count

select nachname from telefonliste where nachname like 'R%'

i expected to get some data, but the only thing i get is the following: The number of rows is correct, but where is the content of the fields? - Raffy --_=_=_=IMA.BOUNDARY.HTML_4963392=_=_=_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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>



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

- Raffy

--_=_=_=IMA.BOUNDARY.HTML_4963392=_=_=_--