cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aufderheide, Alan" <>
Subject problem with SHOW TABLES using mysql with cocoon
Date Thu, 06 Apr 2000 15:58:51 GMT
Hi all,
When I try doing 'show tables' in a sql statement to mysql in cocoon,
I get the following error:

 <sqlerror message="DOM002 Illegal character"></sqlerror> 

The command 'show tables' works fine in the command-line version of mysql.
There are two tables in the database, with names like test and pet.
Other select statements and describe statements work fine.

With Oracle, doing 'select * from tab' works fine as well.

Can anyone provide insight?  What is the illegal character?
How can I list all the tables in mysql if the above doesn't work?
Below is the xml I use (editted slightly).


<?xml version="1.0"?>
<?cocoon-process type="sql"?>
  <connection name="foo_connection">
 <query connection="foo_connection">
  show tables

View raw message