On Thu, 10 Apr 2008 02:25:30 -0700 (PDT), project_trainees wrote
> Hi,
> 
>   For a local database in mysql, we wrote this code, but neither 
> give any error nor display the details. Where is my fault?
> 
> #set  ($mydb=$xwiki.sql.getDatabase('test'))
> <table>
> #foreach($row in $mydb.executeQuery(
>                     "select Name, RNo from student") )
>  <tr>
> 
>   <td> $row.getString("Name") </td>
>   <td> $row.getLong("RNo") </td>
>  </tr>
> #end
> </table>
> 
> THANks.
> 


1. check is xwikisql is added as plugin.
2. Try to enable logging of xwikisql 
(i.e. add to <xwiki-app>/WEB-INF/classes/log4j.properties next string

log4j.logger.ua.gradsoft.xwikisql=debug
)



> .............................................................
> Hi all,
> 
>   We are using XE 1.2.1 and Mysql 5.0,
> 
>   we created a Todo application by following this
> http://www.theserverside.com/tt/articles/article.tss?l=XWiki
>   and it is possible to add and display data in a filterable table.
> 
>   We have to fetch and insert the inserted data into a Mysql table, can
> any   one help us?
> 
> Thanks in advance,
> 
> Regards,
> Project Trainees.
> _______________________________________________
> users mailing list
> [email protected]
> http://lists.xwiki.org/mailman/listinfo/users



--
Ruslan Shevchenko
GradSoft. http://www.gradsoft.ua

_______________________________________________
users mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/users

Reply via email to