Ok thanks, that is working now. But now  I have another problem, no
data coming back.

 Currently I have two bookmarks in the bookmarks application, the
first one I didn't put in a folder, I just used tags because all I
want are tags, but the second I put in a folder just to see what the
difference in the result might be.

using the example sparql query mentioned below, which is from the
example here 
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/SIOCRefBookmarksExample4
described as "Dump of all Bookmark Urls" with the command line: isql
1111 dba dba duumpuserbookmarks.sprql

which gives me back the following result:

Connected to OpenLink Virtuoso
Driver: 05.08.3034 OpenLink Virtuoso ODBC Driver
bookmark
VARCHAR
_______________________________________________________________________________


0 Rows. -- 31 msec.


So I guess that is wrong.

Best Regards,
Bryan Rasmussen


On Mon, Oct 27, 2008 at 9:11 AM, Ivan Mikhailov
<imikhai...@openlinksw.com> wrote:
> Hello Bryan,
>
> Do you have a semicolon after the query text? ISQL commands are not just
> delimited by semicolons, the last command is supposed to be ended with
> semicolon as well as all previous. According to tradition, ISQL will
> silently ignore any incomplete statement at the end of input file,
> that's why you don't get an explicit error.
>
> In addition, to have the output clear from console input hints, you
> might wish to specify input file in ISQL command line, not pass it via
> stdin redirection, so try the following:
>
> isql 1111 dba dba errors=stdout  dumpusersbookmarks.sprql >test.out
>
> Best Regards,
>
> Ivan Mikhailov
> OpenLink Software,
> http://virtuoso.openlinksw.com
>
> On Sun, 2008-10-26 at 19:19 +0100, bryan rasmussen wrote:
>> Hi,
>>
>> I have the bookmarks example installed. I can log in as dba dba and
>> see my bookmarks in the local site server, where I have placed one
>> bookmark.
>>
>> Unfortunately I can't figure out how to access the information via the
>> isql utility.
>>
>> I have the following command
>>
>>
>> isql 1111 dba dba errors=stdout <dumpusersbookmarks.sprql >test.out
>>
>> with dumpuserbookmarks.sprql being the example code from one of the
>> examples you have from working with bookmarks:
>>
>>
>>
>> sparql
>>
>>
>> prefix sioc: <http://rdfs.org/sioc/ns#>
>> prefix sioct: <http://rdfs.org/sioc/types#>
>> prefix dct: <http://purl.org/dc/elements/1.1/>
>> prefix dcc: <http://purl.org/dc/terms/>
>> prefix bmk: <http://www.w3.org/2002/01/bookmark#>
>> select ?bookmark
>> where
>>   {
>>     ?forum a sioct:BookmarkFolder .
>>     ?forum sioc:container_of ?post .
>>     optional{ ?post bmk:recalls ?bookmark}.
>>   }
>>
>>
>> the response in test.out is:
>>
>> Connected to OpenLink Virtuoso
>> Driver: 05.08.3034 OpenLink Virtuoso ODBC Driver
>> OpenLink Interactive SQL (Virtuoso), version 0.9849b.
>> Type HELP; for help and EXIT; to exit.
>> SQL> Type the rest of statement, end with a semicolon (;)> Type the
>> rest of statement, end with a semicolon (;)> Type the rest of
>> statement, end with a semicolon (;)> Type the rest of statement, end
>> with a semicolon (;)> Type the rest of statement, end with a semicolon
>> (;)> Type the rest of statement, end with a semicolon (;)> Type the
>> rest of statement, end with a semicolon (;)> Type the rest of
>> statement, end with a semicolon (;)> Type the rest of statement, end
>> with a semicolon (;)> Type the rest of statement, end with a semicolon
>> (;)> Type the rest of statement, end with a semicolon (;)> Type the
>> rest of statement, end with a semicolon (;)> Type the rest of
>> statement, end with a semicolon (;)> Type the rest of statement, end
>> with a semicolon (;)> Type the rest of statement, end with a semicolon
>> (;)>
>>
>> Exactly what should I be ending with a semicolon here? Given that the
>> query is one of the examples on the site? Syntactically it's correct
>> isn't it?
>>
>>
>>
>> Best Regards,
>> Bryan Rasmussen
>>
>> -------------------------------------------------------------------------
>> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
>> Build the coolest Linux based applications with Moblin SDK & win great prizes
>> Grand prize is a trip for two to an Open Source event anywhere in the world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>

Reply via email to