[xwiki-users] Issue when using foreign database

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. ............................................................. 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.