Re: [xwiki-users] Programming Help

2008-05-14 Thread project_trainees
Hi,
  Surely right, but as beginners which is better for us? And I put sql
plugin in WEB-INF/lib directory and wrote the following code, it neither
shows any error nor changed the table.

##receive database
#set  ($mydb=$xwiki.sql.getDatabase("test"))

#set ($myname="prinsi")
#set ($myid=876)
#set  ($result=$mydb.executeUpdate(
 'update projects set assignee=? where id=?',
 [$myname,$myid]))

Where assignee and id are columns of table projects, I have added
ua.gradsoft.xwikisql.SqlPlugin to list of active plugins in
/WEB-INF/xwiki.cfg and restarted xwiki.


> On May 14, 2008, at 12:41 PM, [EMAIL PROTECTED] wrote:
>
>> Hi,
>>
>>  I have to deal some external data in xwiki. Is it require to connect
>> xwiki with Mysql through Hibernate.cfg or Is it possible through
>> program
>> using velocity or groovy? Is velocity enough for transactions? One
>> another Qn. a groovy code should be called by a velocity code?
>
> Everything is possible... your imagination is the limit :)
>
> See the sql plugin for example:
> http://code.xwiki.org/xwiki/bin/view/Plugins/XWikiSqlPlugin
>
> Thanks
> -Vincent
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] Programming Help

2008-05-14 Thread Vincent Massol

On May 14, 2008, at 2:39 PM, [Ricardo Rodriguez] Your EPEC Network ICT  
Team wrote:

> I've quoted your statement in our wiki! :-)
>
> http://environmentalchange.net

nice ;)

-Vincent

> Vincent Massol wrote:
>> Hi,
>>
>> On May 14, 2008, at 12:41 PM, [EMAIL PROTECTED] wrote:
>>
>>
>>> Hi,
>>>
>>> I have to deal some external data in xwiki. Is it require to connect
>>> xwiki with Mysql through Hibernate.cfg or Is it possible through
>>> program
>>> using velocity or groovy? Is velocity enough for transactions? One
>>> another Qn. a groovy code should be called by a velocity code?
>>>
>>
>> Everything is possible... your imagination is the limit :)
>>
>> See the sql plugin for example:
>> http://code.xwiki.org/xwiki/bin/view/Plugins/XWikiSqlPlugin
>>
>> Thanks
>> -Vincent
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] Programming Help

2008-05-14 Thread [Ricardo Rodriguez] Your EPEC Network ICT Team
I've quoted your statement in our wiki! :-)

http://environmentalchange.net

Cheers,

Ricardo

Vincent Massol wrote:
> Hi,
>
> On May 14, 2008, at 12:41 PM, [EMAIL PROTECTED] wrote:
>
>   
>> Hi,
>>
>>  I have to deal some external data in xwiki. Is it require to connect
>> xwiki with Mysql through Hibernate.cfg or Is it possible through  
>> program
>> using velocity or groovy? Is velocity enough for transactions? One
>> another Qn. a groovy code should be called by a velocity code?
>> 
>
> Everything is possible... your imagination is the limit :)
>
> See the sql plugin for example:
> http://code.xwiki.org/xwiki/bin/view/Plugins/XWikiSqlPlugin
>
> Thanks
> -Vincent
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>
>
>   


-- 
Ricardo Rodríguez
Your EPEC Network ICT Team

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] Programming Help

2008-05-14 Thread Vincent Massol
Hi,

On May 14, 2008, at 12:41 PM, [EMAIL PROTECTED] wrote:

> Hi,
>
>  I have to deal some external data in xwiki. Is it require to connect
> xwiki with Mysql through Hibernate.cfg or Is it possible through  
> program
> using velocity or groovy? Is velocity enough for transactions? One
> another Qn. a groovy code should be called by a velocity code?

Everything is possible... your imagination is the limit :)

See the sql plugin for example:
http://code.xwiki.org/xwiki/bin/view/Plugins/XWikiSqlPlugin

Thanks
-Vincent
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users