Just chiming in here On 10-08-2009 01:05:51 +0200, Wouter Alink wrote:
I had some more time to look at the issue. It seems that the PHP interface still does not produce the expected behavior when a query returns multiple results. This doesn't affect your query as your query only yields 1 result.
In my opinion a different row should be available for each item in the sequence of results. An example: a query like "1 to 4" should return 4 rows with 1 column, containing 1, 2, 3, and 4 respectively. Currently it doesn't seem to do so. I added a test for this, so we can monitor the status through our testweb, but probably someone more familiar with the MonetDB/PHP interface code should have a look at how to fix this.
Wouter's previous fix, is indeed something that has to be done, the PHP module assumes SQL access at the moment. For getting "useful" results from the XQuery server, the PHP module needs a small fix to ask the server for SQL-ish results, like JDBC does. I'll see if I can get you a patch which you can test.