cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Feldman, Leonid" <leonid.feld...@comverse-in.com>
Subject RE: need help with sql procesor
Date Thu, 16 Mar 2000 18:38:44 GMT


 The subs_name column has the nvarchar data type.	


Leonid

-----Original Message-----
From: Donald Ball [mailto:balld@webslingerZ.com]
Sent: Thursday, March 16, 2000 12:38 PM
To: 'cocoon-users@xml.apache.org'
Subject: Re: need help with sql procesor


This is one I haven't seen before. What type is the subs_name column?

- donald

On Thu, 16 Mar 2000, Feldman, Leonid wrote:

> 
> Hello.
> 
> I am having trouble getting SQL processor to work.
> 
> Cocoon 1.7
> Tomcat 3.1 beta
> Windows NT 4 workstation
> jdk 1.2.2 ( sun )
> 
> In the following code test1 is a valid dsn 
> ( connected to MS SQL server 7 )
> 
> ----- begin database-page.xml ----------
> 
> <?xml version="1.0"?>
> 
> <?cocoon-process type="sql"?>
> <?cocoon-format type="text/xml"?>
> 
> <page>
> 
>  <connectiondefs>
>   <connection name="foo_connection">
>    <driver>sun.jdbc.odbc.JdbcOdbcDriver</driver>
>    <dburl>jdbc:odbc:test1</dburl>
>    <username>sa</username>
>    <password></password>
>   </connection>
>  </connectiondefs> 
>  
>  <query connection="foo_connection">
>   select subs_name from subs
>  </query>
>  
> </page>
> 
> ------ end database-page.xml ---------
> 
> subs and subs_name are valid names.
> and subs has at least 12 rows.
> I get the following results:
> 
> ---- begin results -----
> 
>   <?xml version="1.0" encoding="UTF-8" ?> 
> 
> - <page>
> - <ROWSET>
>   <ROW ID="0" /> 
>   <ROW ID="1" /> 
>   <ROW ID="2" /> 
>   <ROW ID="3" /> 
>   <ROW ID="4" /> 
>   <ROW ID="5" /> 
>   <ROW ID="6" /> 
>   <ROW ID="7" /> 
>   <ROW ID="8" /> 
>   <ROW ID="9" /> 
>   <ROW ID="10" /> 
>   </ROWSET>
>   </page>
> - <!--  This page was served in 791 milliseconds by Cocoon 1.7 
>   --> 
> 
> ------ end results ------------
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
> 


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