Hi,
Running develop7 with a procedure that attempts to return two result sets.
Probably not wise but I was experimenting with ways to return metadata
about a query.
The procedure did something including:
==================
...other stuff...
query := 'select ?S ?P ?O {....} limit 10 offset 20';
exec (query, errorCode, errorMessage, vector(), 0, meta, _dt);
if (meta <> 0) {
exec_result_names (meta[0]);
inx := 0;
if (_dt <> 0) {
while (inx < length (_dt))
{
exec_result (_dt[inx]);
inx := inx + 1;
}
}
} else exec_result_names(vector('?NullRecords'));
declare meta, _dt any;
declare errorCode, errorMessage varchar;
declare inx integer;
query := 'select count (distinct ?S) as ?count {....}';
end_result();
exec (query, errorCode, errorMessage, vector(), 0, meta, _dt);
exec_result (_dt[0]);
}
==================
I wasn't really expecting it to work but a server crash seems worth
reporting.
As an aside, does anyone have any advice on how to return something like a
count of total rows together in the same query that returns a paginated set
of rows?
I'm actually paginating the entities themselves and would like to be able
to report the number of entities in the same procedure so as to avoid
unnecessary pagination.
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
