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
