HI Norman,
Hi, I got a query that uses bif:contains filter (see below). When I
issue it via PHP_ODBC using the "sparql" prefix keyword, it cannot
be parsed. It works however, in iSQL and via PHP_ODBC using
"SPARQL_EVAL" function. The issue occurs with both, Virtuoso
OpenSource 6.1.3 and 6.1.4.
Query:
define output:format "JSON"
SELECT DISTINCT ?resourceUri
FROM <http://lod2.eu/>
FROM <http://lod2.eu/schema/>
WHERE {
?listresource ?p0 ?o0 .
?listresource ?resourceUri ?showPropsObj .
FILTER (bif:contains(?o0, "testimonial*"))
}
The following error is thrown:
SQ200: No column t2.S., SQL state S0022 in SQLExecDirect in /Library/
WebServer/Sites/odbctest.php on line 15 Call Stack: 0.0002 645256 1.
{main}() /Library/WebServer/Sites/odbctest.php:0 0.0030 647072 2.
odbc_exec() /Library/WebServer/Sites/odbctest.php:15
Which version of PHP and ODBC driver manager are you using and what OS
are you using, so i can setup a similar testbed here and try to figure
out what is going on.
Also can you put the following into your odbc.ini or odbcinst.ini file
(latter when using unixodbc) to get a trace on the ODBC level:
[ODBC]
Trace=1
Tracefile=/tmp/odbc-trace.log
and retry the failing test, so i can see what commands are exactly
passed to the driver.
Patrick
--
OpenLink
