cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marco Pauck <pa...@wmd.de>
Subject Re: XSp and SQL
Date Sun, 27 Aug 2000 19:38:24 GMT
raffy wrote:
> 
> 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>

"nr" is not part of your select-list.
Instead your attribute "nachname" is 'eaten' for the
ID attribute. Just my guess ...

I had a similar problem with my first select (although with
the SQL processor, not the taglib).
Should this behavior considered as a bug or a feature, Donald?  ;-)

> <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

	Marco
--
Marco Pauck -- marco@pauck.de -- http://www.pauck.de/marco/
For every complex problem, there is a solution that is simple,
neat, and wrong.  -- H. L. Mencken

Mime
View raw message