You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@cocoon.apache.org by Nicola Ken Barozzi <ni...@supereva.it> on 2000/08/30 17:59:12 UTC

Re: SQL Processor and JETProxy JDBC Driver (Cocoon 1.7.3)

I had the same problem with spaces.
Remember that column names become tags in the resulting xml.
This means that column names must be valid for xml tags:
no spaces or special characters.
To overcome the hurdle, use the AS keyword in the query:
SELECT "person name" AS name FROM names

BTW, Donald, why not making the error more informative? :-)
It's not the first time this question arises.

nicola_ken

Nicola Ken Barozzi - AISA Industries S.p.A
http://www.aisaindustries.it/
Via Leonardo da Vinci,2 Ticengo (CR) Italy
Research Activity:
Politecnico di Milano - Dipartimento di Meccanica
Piazza Leonardo da Vinci, n.32 - 20133 Milano (Italy)
----- Original Message -----
From: LEBRETON Philippe
To: Cocoon User
Sent: Wednesday, August 30, 2000 5:39 PM
Subject: SQL Processor and JETProxy JDBC Driver (Cocoon 1.7.3)

I used the JetProxy JDBC driver to connect from MSAccess Database.
when my query is select * from <table>
The result of XML is :
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd">
<page>

</page>

In the table structure, i have some column name with a space or accent caractere.
When my query is without this "special" column name, i's OK.
how i can query this column?

Thanks
Philippe LEBRETON --------------------------------------------------------------------- To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org For additional commands, e-mail: cocoon-users-help@xml.apache.org

Re: SQL Processor and JETProxy JDBC Driver (Cocoon 1.7.3)

Posted by Nicola Ken Barozzi <ni...@supereva.it>.

----- Original Message ----- 
From: "Donald Ball" <ba...@webslingerZ.com>
To: <co...@xml.apache.org>; "Nicola Ken Barozzi" <ni...@supereva.it>
Sent: Wednesday, August 30, 2000 9:27 PM
Subject: Re: SQL Processor and JETProxy JDBC Driver (Cocoon 1.7.3)


> On Wed, 30 Aug 2000, Nicola Ken Barozzi wrote:
> 
> > I had the same problem with spaces.
> > Remember that column names become tags in the resulting xml.
> > This means that column names must be valid for xml tags:
> > no spaces or special characters.
> > To overcome the hurdle, use the AS keyword in the query:
> > SELECT "person name" AS name FROM names
> > 
> > BTW, Donald, why not making the error more informative? :-)
> > It's not the first time this question arises.
> 
> because it's never bothered me. :). c'mon, guys, this _is_ open source
> software.

Ok, I'll write the new info in your code in C2, since I'm working on
error handling. :-)
Watch out guys, I'm going to fill your code up with error info!  ;-)

nicola_ken

Nicola Ken Barozzi - AISA Industries S.p.A
http://www.aisaindustries.it/
Via Leonardo da Vinci,2 Ticengo (CR) Italy
Research Activity:
Politecnico di Milano - Dipartimento di Meccanica
Piazza Leonardo da Vinci, n.32 - 20133 Milano (Italy)

Re: SQL Processor and JETProxy JDBC Driver (Cocoon 1.7.3)

Posted by Donald Ball <ba...@webslingerZ.com>.

On Wed, 30 Aug 2000, Nicola Ken Barozzi wrote:

> I had the same problem with spaces.
> Remember that column names become tags in the resulting xml.
> This means that column names must be valid for xml tags:
> no spaces or special characters.
> To overcome the hurdle, use the AS keyword in the query:
> SELECT "person name" AS name FROM names
> 
> BTW, Donald, why not making the error more informative? :-)
> It's not the first time this question arises.

because it's never bothered me. :). c'mon, guys, this _is_ open source
software.

- donald