You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by java guru <ja...@yahoo.co.in> on 2001/06/18 18:33:43 UTC

sql sample throws blank page...newbie

HI.,
  I am trying to get the sample sql link from welcome
page work..the esql link works fine ... but the sql
link throws blank page ( i mean the static content is
coming up ) but not the database content..


Any help appreciated....

thanks


____________________________________________________________
Do You Yahoo!?
For regular News updates go to http://in.news.yahoo.com

---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>

Re: sql sample throws blank page...newbie

Posted by Aurelien DEHAY <au...@sncf.fr>.
java guru <ja...@yahoo.co.in> writes:

> The log file didnt show any error..or may be i am
> missing it...
> 
> Anyway, I was using following code(note the
> esql:error-results) for catching database exceptions..
> 
>      <esql:execute-query>
>        <esql:query>select * from
> department_table1</esql:query>
>        <esql:results>
>          <esql:row-results>
>            <para><esql:get-string
> column="name"/></para>
>            <esql:get-columns/>
>          </esql:row-results>
>        </esql:results>
>        <esql:error-results>
>        	<para> this is error </para>
>        </esql:error-results>
>        
>      </esql:execute-query>
> 

I'm not sure that * is a good thing. Try putting a column name.

-- 
Aurélien

---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>

Re: sql sample throws blank page...newbie

Posted by java guru <ja...@yahoo.co.in>.
The log file didnt show any error..or may be i am
missing it...

Anyway, I was using following code(note the
esql:error-results) for catching database exceptions..

     <esql:execute-query>
       <esql:query>select * from
department_table1</esql:query>
       <esql:results>
         <esql:row-results>
           <para><esql:get-string
column="name"/></para>
           <esql:get-columns/>
         </esql:row-results>
       </esql:results>
       <esql:error-results>
       	<para> this is error </para>
       </esql:error-results>
       
     </esql:execute-query>


*****************************************
--- Mariano Kamp <mk...@codamax.com> wrote: > Hi,
> 
>   have you checked the logfile (by default it is 
> cocoon/WEB-INF/logs/cocoon.log)?
> 
>   I am also wondering how I can extract the
> exception from an esql query?!?!
> 
> Mariano
> 
> >   I am trying to get the sample sql link from
> welcome
> > page work..the esql link works fine ... but the
> sql
> > link throws blank page ( i mean the static content
> is
> > coming up ) but not the database content..
> 
>
---------------------------------------------------------------------
> 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:
> <co...@xml.apache.org>
> For additional commands, e-mail:
> <co...@xml.apache.org>
> 


____________________________________________________________
Do You Yahoo!?
For regular News updates go to http://in.news.yahoo.com

---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>

Re: sql sample throws blank page...newbie

Posted by Mariano Kamp <mk...@codamax.com>.
Hi,

  have you checked the logfile (by default it is 
cocoon/WEB-INF/logs/cocoon.log)?

  I am also wondering how I can extract the exception from an esql query?!?!

Mariano

>   I am trying to get the sample sql link from welcome
> page work..the esql link works fine ... but the sql
> link throws blank page ( i mean the static content is
> coming up ) but not the database content..

---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>