Re: [Virtuoso-users] Calling Sponger cartridge with options from sparql select

2011-10-28 Thread Ivan Mikhailov
Hello Peter, Unexpected "more than one resultset" usually means that some procedure called inside sql:myfunc uses functions result_names() ... result() ... end_result(), as in http://docs.openlinksw.com/virtuoso/fn_result_names.html etc. As a result, the generated result set is put into receiver -

Re: [Virtuoso-users] Calling Sponger cartridge with options from sparql select

2011-10-27 Thread Peter Secomb
Hi Ivan, I've played around a bit with function calls within a SPARQL query. I have the following format: select * from where { ?s ?p ?o filter(sql:myfunc(arg1, arg2, arg3)) } myfunc() does some processing on the arguments, calls another function and ultimately returns 1. I'l

Re: [Virtuoso-users] Calling Sponger cartridge with options from sparql select

2011-10-27 Thread Ivan Mikhailov
Hello Peter, Unfortunately there's no good way to pass the parameters you need. You may cheat and make your version of cartridge that will use connection_get() [1] to obtain connection variable assigned before by connection_set() [2], but that's not universal and looks bad. You may also write you

Re: [Virtuoso-users] Calling Sponger cartridge with options from sparql select

2011-10-25 Thread Peter Secomb
Hi everyone, I'm still trying to figure out how to supply parameters/options to a sparql select eg: sparql select * from where { ?s ?p ?o } I can set options in the Sponger cartridge definition via Conductor but I really need a way to pass parameters eg to change the

[Virtuoso-users] Calling Sponger cartridge with options from sparql select

2011-09-22 Thread Peter Secomb
Hi everyone, I'm trying to figure out how to supply the opts value (inout opts any, defined in sponger hook) as part of a sparql select. Without the options a sponger call (for instance to csv cartridge) can be made as: sparql select * from where {?o ?p ?s}