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