Re: [Virtuoso-users] inserting xsd:boolean datatype

2009-11-25 Thread Hugh Williams
Hi Cristian, Virtuoso does not have a native boolean type as many databases don't becuase it is not a native SQL type. So we cast booleans to integers inside the engine because there's no built-in SQL datatype for booleans. If the SQL standard is ever extended with native boolean as a basic dat

[Virtuoso-users] inserting xsd:boolean datatype

2009-11-25 Thread Cristian Vasquez
Hello, I'm having a problem when I try to recover inserted triples which had xsd:boolean datatypes, after insertion, they seem to be turned into xsd:integer Example: SQL> TTLP (' @prefix xsd: . @prefix nameme: .

Re: [Virtuoso-users] Upper Limit of triples inserted

2009-11-25 Thread Nirmala Seehappan
Hi Hugh, To give a detailed look into the load and the insert statements, i have provided the statements below: DB.DBA.RDF_LOAD_RDFXML(file_to_string_output('/data/graph1.rdf'),'http://test/','http://test/graph1'); sparql BASE PREFIX rdfs:

[Virtuoso-users] Set upper limit for matches from bif:contains wildcard

2009-11-25 Thread Magnus Haraldsen Amundsen
Hi, We have a free text search query with bif:contains that has a wildcard that gives more than 1000 matches. Virtuoso returns an error because of this, even if the query is limited by 'AND' between all search terms: 22015 Error FT038: wildcard has over 1000 matches The query: PRE

Re: [Virtuoso-users] OAT database connection

2009-11-25 Thread Eddy Vanderlinden
Hi Hugh, As a reply to the question Does the same issue occur >> using the OAT Web site Form Designer app at: >> http://oat.openlinksw.com/formdesigner/index.html The answer is: A data connection is configured, a grid widget is configured to catch the output of the data connection.