Re: [Virtuoso-users] random in sparql

Hello Nathan, > Is there any way to achieve 'ORDER BY RANDOM() LIMIT 1' in a sparql > query using virtuoso? Consider using sparql select order by asc( bif:rnd(20, )) limit 1 ; where two billions is big enough to provide variety of sorting criterion but not too big so it's a plain inte

[Virtuoso-users] WordPress SIOC post queries

Hi, maybe there is a problem left ;) When I'm querying for WordPress posts, I get the following errors on the following queries. I have just one post in my blog. Cheers, Bob SPARQL query: define

[Virtuoso-users] random in sparql

hi all, Is there any way to achieve 'ORDER BY RANDOM() LIMIT 1' in a sparql query using virtuoso? regards, nathan

Re: [Virtuoso-users] unix socket leak in iodbc? (LEAK FOUND!)

Have to answer myself: I found the leak. in CLIsql1.c:864 the connection via the local socket is created. in CLIsql1.c:916 this connection is overwritten with a newly created one. Thus, the former connection is never disconnected as its handle is leaking. A tried a quick fix by adding "if(ses)"

Re: [Virtuoso-users] WordPress SIOC queries

Hi, I got it ;) There where no grants on that tables for the user "SPARQL". Cheers, Bob Bob Ferris schrieb: Hi Rumi, thanks a lot for the update and your help. Now it works. Unfortunately, there is another problem, when I'm querying at the SPARQL endpoint. I get the following error messag

Re: [Virtuoso-users] WordPress SIOC queries

Hi Rumi, thanks a lot for the update and your help. Now it works. Unfortunately, there is another problem, when I'm querying at the SPARQL endpoint. I get the following error message: "42000 Error SQ200: Must have select privileges on view wordpress.DBA.wpl_site_rdf ". This happens after I add