31 May
2013
31 May
'13
10:50 a.m.
Thanks Vincent! The evil were in the XWQL sentence: it read ':string1' instead of
:string1.
Could it be useful to add an XWQL sentence example to the Query Module page or a link to a
page explaining the syntax to avoid this kind of errors?
http://www.idisantiago.es/bin/XWQL/QueryOnComments
I'll copy it to the snippet's repository ASAP!
Cheers!
Ricardo
________________________________________
From: users-bounces(a)xwiki.org [users-bounces(a)xwiki.org] On Behalf Of Vincent Massol
[vincent(a)massol.net]
Sent: 31 May 2013 09:26
To: XWiki Users
Cc: Lista Garcia, Isabel
Subject: Re: [xwiki-users] XWQL query on several objects of the same class
instantiated in the same doc
Try this:
#set ($xwqlquery = "SELECT doc2.fullName FROM Document doc2,
doc2.object(XWiki.XWikiComments) comm2 WHERE doc2.translation = 0 and comm2.comment LIKE
:string1")
#set ($results =
$services.query.xwql($xwqlquery).bindValue("string1","test").execute())
Thanks
-Vincent
On May 31, 2013, at 9:14 AM, <Ricardo.Julio.Rodriguez.Fernandez(a)sergas.es> wrote:
Hi Vicent!
Sorry for top-replying, but this email client is a PITA!
Something else must be failing, this alternatives don't work neither:
#set ($xwqlquery = "SELECT doc2.fullName FROM Document doc2,
doc2.object(XWiki.XWikiComments) comm2 WHERE doc2.translation = 0 and comm2.comment LIKE
':string1'")
#set ($results =
$services.query.xwql($xwqlquery).bindValue("string1",$string1).execute())
#set ($xwqlquery = "SELECT doc2.fullName FROM Document doc2,
doc2.object(XWiki.XWikiComments) comm2 WHERE doc2.translation = 0 and comm2.comment LIKE
':string1'")
#set ($results =
$services.query.xwql($xwqlquery).bindValue("string1",'$string1').execute())
#set ($xwqlquery = "SELECT doc2.fullName FROM Document doc2,
doc2.object(XWiki.XWikiComments) comm2 WHERE doc2.translation = 0 and comm2.comment LIKE
':string1'")
#set ($results =
$services.query.xwql($xwqlquery).bindValue("string1","$string1").execute())
I always get the same error...
Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate
execute
Wrapped Exception: could not locate named parameter [string1]
Any idea will be welcome!
Thanks!
________________________________________
From: users-bounces(a)xwiki.org [users-bounces(a)xwiki.org] On Behalf Of Vincent Massol
[vincent(a)massol.net]
Sent: 31 May 2013 08:15
To: XWiki Users
Cc: Lista Garcia, Isabel
Subject: Re: [xwiki-users] XWQL query on several objects of the same class
instantiated in the same doc
Hi Ricardo,
On May 30, 2013, at 10:54 PM, Ricardo.Julio.Rodriguez.Fernandez(a)sergas.es wrote:
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Nota: A información contida nesta mensaxe e os seus posibles documentos adxuntos é privada
e confidencial e está dirixida únicamente ó seu destinatario/a. Se vostede non é o/a
destinatario/a orixinal desta mensaxe, por favor elimínea. A distribución ou copia desta
mensaxe non está autorizada.
Nota: La información contenida en este mensaje y sus posibles documentos adjuntos es
privada y confidencial y está dirigida únicamente a su destinatario/a. Si usted no es
el/la destinatario/a original de este mensaje, por favor elimínelo. La distribución o
copia de este mensaje no está autorizada.
See more languages: http://www.sergas.es/aviso_confidencialidad.htm
Hi Vicent!
It's easy, you've used string1 instead of $string1 in bindValue()… :)
Thanks
-Vincent
________________________________________
From: users-bounces(a)xwiki.org [users-bounces(a)xwiki.org] On Behalf Of Vincent Massol
[vincent(a)massol.net]
Sent: 28 May 2013 08:45
To: XWiki Users
Cc: Lista Garcia, Isabel
Subject: Re: [xwiki-users] XWQL query on several objects of the same class
instantiated in the same doc
Hi Ricardo,
On May 28, 2013, at 7:35 AM, <Ricardo.Julio.Rodriguez.Fernandez(a)sergas.es> wrote:
Thanks for the note, Vicent! I've already tried that, but I was not able to solve
this error:
Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate
execute
Wrapped Exception: could not locate named parameter [string1]
I've modified the code at the link below to show you the whole error message...
http://www.idisantiago.es/bin/XWQL/QueryOnComments Hi Vincent, all!
Please, do you think this is of any value and clear enough as to going to XWiki
Extensions Query Module page?
http://www.idisantiago.es/bin/XWQL/QueryOnComments
Yes it would be great to add this to extensions.xwiki.org :)
Since it's not a single query I'm not sure the best place is the query module
page.
I'd say that it could be added as an entire snippet on extensions.xwiki.org.
Important Note: Your code is written dangerously and is subject to XSS attacks. You need
to modify it and use binding:
#set ($xwqlquery = "SELECT doc2.fullName FROM Document doc2,
doc2.object(XWiki.XWikiComments) comm2
WHERE doc2.translation = 0 and comm2.comment LIKE '$string1'")
should be:
#set ($xwqlquery = "SELECT doc2.fullName FROM Document doc2,
doc2.object(XWiki.XWikiComments) comm2
WHERE doc2.translation = 0 and comm2.comment LIKE ':string1'")
I read your reference to bind variables in
http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module, but I'm not able to
find my error!
Please, where am I wrong? I'm still working with a XE 2.4.30451 installation.
Thanks!
> And then:
>
> $services.query.xwql($xwqlquery).bindValue("string1", string1).execute()
>
> Thanks
> -Vincent
>
>>
>> Thanks!
>>
>> ________________________________________
>> From: users-bounces(a)xwiki.org [users-bounces(a)xwiki.org] On Behalf Of Vincent
Massol [vincent(a)massol.net]
>> Sent: 23 May 2013 08:09
>> To: XWiki Users
>> Cc: Lista Garcia, Isabel
>> Subject: Re: [xwiki-users] XWQL query on several objects of the same class
instantiated in the same doc
>>
>> Getting closer :)
>>
>> Ricardo, when you resolve this, it would be great if you could add an example on
>> http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module so that next
time someone has the same question he/she can find some example of nested query there.
>>
>> Thanks
>> -Vincent
>>
>> On May 23, 2013, at 1:36 AM, Ricardo.Julio.Rodriguez.Fernandez(a)sergas.es wrote:
>>
>>> Hi!
>>>
>>>> ________________________________________
>>>> From: users-bounces(a)xwiki.org [users-bounces(a)xwiki.org] On Behalf Of
BOUSQUET Jeremie [Jeremie.BOUSQUET(a)gemalto.com]
>>>> Sent: 22 May 2013 22:38
>>>> To: XWiki Users
>>>> Cc: Lista Garcia, Isabel
>>>> Subject: [xwiki-users] Re : XWQL query on several objects of the same
class instantiated in the same doc
>>>>
>>>> Hi,
>>>>
>>>> You miss the .execute() at the end :)
>>>>
>>>
>>> Call me stupid! Thanks, Jeremie! Thanks Louis-Marie and Ebo!
>>>
>>> But I'm afraid I'm still not able to run the script without errors.
It seems to me that the XWQL query...
>>>
>>> SELECT doc2.fullName FROM Document doc2, doc2.object(XWiki.XWikiComments)
comm2
>>> WHERE comm2.comment LIKE '%Withdrawal:2011%'
>>>
>>> doesn't generate a suitable list to enter in a NOT In construct. It
generates this...
>>>
>>> [XWiki.MariaCerezo, XWiki.RodrigoCabanasGancedo, XWiki.JeronimoFortezaVila,
...]
>>>
>>>
>>> 'XWiki.MariaCerezo', 'XWiki.RodrigoCabanasGancedo',
'XWiki.JeronimoFortezaVila', ...
>>>
>>> At the bottom of the page...
>>>
>>> http://www.idisantiago.es/bin/XWQL/SnapshotE0012012
>>>
>>> ... you'll find the error and the script split into several code chunks
working perfectly.
>>>
>>> Please, am I right with the source of the problem? How could I change to the
'item','item2',ìtem3'...
>>>
>>> How could I change the way XWQL gives layout to the list?
>>>
>>> Thank you very much!!
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Nota: A información contida nesta mensaxe e os seus posibles documentos adxuntos é
privada e confidencial e está dirixida únicamente ó seu destinatario/a. Se vostede non é
o/a destinatario/a orixinal desta mensaxe, por favor elimínea. A distribución ou copia
desta mensaxe non está autorizada.
Nota: La información contenida en este mensaje y sus posibles documentos adjuntos es
privada y confidencial y está dirigida únicamente a su destinatario/a. Si usted no es
el/la destinatario/a original de este mensaje, por favor elimínelo. La distribución o
copia de este mensaje no está autorizada.
See more languages: http://www.sergas.es/aviso_confidencialidad.htm
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users