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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Ruslan Shevchenko
GradSoft.
http://www.gradsoft.ua