Unfortunately I don't have too much time this and next week, so the fix will have to wait a bit. I'll try and see in the weekend if I can easily fix it.
Ok, in the mean time my work around is as follows:
1 - make a temporary .xq file somwhere on your file-system using PHP 2 - invoke this file using: $output = shell_exec('MapiClient.bat -l xquery tempXQFile.xq'); header("Content-Type: text/xml"); echo $output;
But offcourse a proper database-connection is preferred.
Looking forward to some kind of solution!
With kind regards,
Menno Holtkamp
-----Original Message----- From: Fabian Groffen [mailto:Fabian.Groffen@cwi.nl] Sent: Thu 11/23/2006 2:35 PM To: monetdb-users@lists.sourceforge.net Cc: Subject: Re: [MonetDB-users] Using MonetDB / XQuery with PHP
On 23-11-2006 14:21:44 +0100, Menno Holtkamp wrote:
[snip]
Performing a query with:
$query = 'count(doc("HelloWorld.xml")/doc)'; $result = monetdb_query($query); if(!$result)die("Query failed : " . monetdb_error() ."\n"); else echo '<br>Performed query';
succeeds as well.
But the content of the result set seems to remain 'empty'.
print_r($result) -> Resource id #3
But while($row = monetdb_fetch_array($result)) { print_r($row); }
remains empty.
I see. This is probably because the default XQuery output is a wee bit different. ;) I might be able to fix monetdb_php to support XQuery like JDBC does. Unfortunately I don't have too much time this and next week, so the fix will have to wait a bit. I'll try and see in the weekend if I can easily fix it.
Does somebody have a working example of performing an XQuery using PHP?
No ;)
I wondered, is it required to connect to a specific database in the monetdb_connect command? (the XML-document) I think not, but hey!
Nope; this only works on M5 which has support for multiple catalogs.
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=D... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users