Re: [C1] Cocoon SQL vs ESQL

[Christopher Painter-Wakefield]

You don't say in what way the code is not working; do you get an exception,
other error message, or just no data? If the latter, are you sure your XSL
stylesheet matches the structure of the XML you are creating?

-Christopher




Please respond to [EMAIL PROTECTED]

To:   <[EMAIL PROTECTED]>
cc:

Subject:  [C1] Cocoon SQL vs ESQL


I have been struggling to get ESQL working... I had thought it was the
database setup, but turns out that is OK (see below) - now I am stuck
again.

Following previous suggestions, I have tried to get an equivalent of the
sample code shippped wiht Cocoon working.  I could not find any ESQL to
test, so I used the the SQL code instead - it worked!  But the - as far as
I can see - equivalent code in ESQL does not work.

I hope someone with a sharp pair of eyes can see why the first sample would
work, and the next one not??

Thanks!
Derek











 
  
   org.gjt.mm.mysql.Driver
  jdbc:mysql://myhost.com/est
  est
  est
  
 

 
  select * from computer
 

SELECT * FROM computer












http://www.apache.org/1999/XSP/Core";
  xmlns:esql="http://apache.org/cocoon/SQL/v2";
  xmlns:request="http://www.apache.org/1999/XSP/Request";
>




  org.gjt.mm.mysql.Driver
  jdbc:mysql://myhost.com/est
  est
  est

  
SELECT * FROM computer


  

 

  



  
 No computer
  


  



SELECT * FROM computer









-
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

[C1] Cocoon SQL vs ESQL

[Derek Hohls]

I have been struggling to get ESQL working... I had thought it was the database setup, 
but turns out that is OK (see below) - now I am stuck again.

Following previous suggestions, I have tried to get an equivalent of the sample code 
shippped wiht Cocoon working.  I could not find any ESQL to test, so I used the the 
SQL code instead - it worked!  But the - as far as I can see - equivalent code in ESQL 
does not work.

I hope someone with a sharp pair of eyes can see why the first sample would work, and 
the next one not??

Thanks!
Derek











 
  
   org.gjt.mm.mysql.Driver
  jdbc:mysql://myhost.com/est
  est
  est
  
  
 
 
  select * from computer
 

SELECT * FROM computer 












http://www.apache.org/1999/XSP/Core";
  xmlns:esql="http://apache.org/cocoon/SQL/v2";
  xmlns:request="http://www.apache.org/1999/XSP/Request"; 
>




  org.gjt.mm.mysql.Driver
  jdbc:mysql://myhost.com/est
  est
  est

  
SELECT * FROM computer


  



  



  
 No computer
  


  



SELECT * FROM computer 







-
Please check that your question has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>