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: [email protected] [[email protected]] On Behalf Of Vincent Massol [[email protected]] 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, <[email protected]> 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: [email protected] [[email protected]] On Behalf Of Vincent > Massol [[email protected]] > 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, [email protected] > wrote: > >> Hi Vicent! >> >>> ________________________________________ >>> From: [email protected] [[email protected]] On Behalf Of >>> Vincent Massol [[email protected]] >>> 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, <[email protected]> >>> wrote: >>> >>>> 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'") >>> >> >> 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 > > It's easy, you've used string1 instead of $string1 in bindValue()… :) > > Thanks > -Vincent > >> 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: [email protected] [[email protected]] On Behalf Of >>>> Vincent Massol [[email protected]] >>>> 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, [email protected] >>>> wrote: >>>> >>>>> Hi! >>>>> >>>>>> ________________________________________ >>>>>> From: [email protected] [[email protected]] On Behalf Of >>>>>> BOUSQUET Jeremie [[email protected]] >>>>>> 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 > [email protected] > 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 > [email protected] > http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
