Re: [Virtuoso-users] Problem with SPARQL query

2013-09-19 Thread Jim McCusker
On virtuoso you need to use concat to count tuples of variables: select count(concat(?s,"|", ?o)) as ?indegree where { ?s ?o . } will return 81 on http://dbpedia.org/sparql On Thu, Sep 19, 2013 at 11:51 AM, Julien Plu < julien@redaction-developpez.com> wr

Re: [Virtuoso-users] Problem with SPARQL query

2013-09-19 Thread Julien Plu
Thanks for your quick reply :-) But when I use an aggregates functions inside the INSERT clause Virtuoso send me an error saying it was a syntax error. I would like using this count result inside the INSERT not inside a SELECT. Best. Julien. 2013/9/19 Jim McCusker > On virtuoso you need to

Re: [Virtuoso-users] Problem with SPARQL query (or dataset?)

2008-05-05 Thread Hugh Williams
Rob, On 5 May 2008, at 00:17, robl wrote: robl wrote: Ivan Mikhailov wrote: Rob, I've tried on my database (that is mix of dbpedia and few other databases. Both queries return accurate results. So questions are: 1. What version of Virtuoso Open Source do you use? 5.0.6 2. What version of

Re: [Virtuoso-users] Problem with SPARQL query (or dataset?)

2008-05-04 Thread robl
robl wrote: Ivan Mikhailov wrote: Rob, I've tried on my database (that is mix of dbpedia and few other databases. Both queries return accurate results. So questions are: 1. What version of Virtuoso Open Source do you use? 5.0.6 2. What version of Virtuoso Open Source was used at the time yo

Re: [Virtuoso-users] Problem with SPARQL query (or dataset?)

2008-05-01 Thread robl
Ivan Mikhailov wrote: Rob, I've tried on my database (that is mix of dbpedia and few other databases. Both queries return accurate results. So questions are: 1. What version of Virtuoso Open Source do you use? 5.0.6 2. What version of Virtuoso Open Source was used at the time you've loaded t

Re: [Virtuoso-users] Problem with SPARQL query (or dataset?)

2008-05-01 Thread Ivan Mikhailov
Rob, I've tried on my database (that is mix of dbpedia and few other databases. Both queries return accurate results. So questions are: 1. What version of Virtuoso Open Source do you use? 2. What version of Virtuoso Open Source was used at the time you've loaded the database? 3. Did you create any

Re: [Virtuoso-users] Problem with SPARQL query (or dataset?)

2008-05-01 Thread robl
Hugh Williams wrote: Rob, Querying against the officially host Virtuoso DBpedia endpoint (http://dbpedia.org:8890/sparql), the second query does return a single result as you expect. So it would appear their is something wrong most probably with your DBpedia datasets loaded I would think. Whe

Re: [Virtuoso-users] Problem with SPARQL query (or dataset?)

2008-05-01 Thread Hugh Williams
Rob, Querying against the officially host Virtuoso DBpedia endpoint (http://dbpedia.org:8890/sparql), the second query does return a single result as you expect. So it would appear their is something wrong most probably with your DBpedia datasets loaded I would think. When you state havin