Thanks very much Armin, It seems this function works, but since I got the empty result table, I have realised I get the empty table for any query done by "i". The source of the table page has valid resultJSON string, for example:
var resultJSON = [ [{"name": "mjesni_odbori", "description": "Mjesni odbori", "header": ["@","Naziv","Adresa"], "values": [ [{"shplink": ["0","0","5405119.69141+4970703.06201+5408357.32124+4974248.66045"]}, "\"Å TINJAN\"", "Selo br. 2"]]} ], {"allextent": "5404957.80991+4970525.78209+5408519.20273+4974425.94037", "zoomall": false, "autozoom": "auto", "infoWin": "window"} ]; but there is nothing below "<div id="queryResult"></div>" In Error console I get many "jQuery is not defined" errors (from jquery.compat-1.0.js, jquery.pmapper.js, jquery.dimensions.js, jquery.treeview.pack.js) and one "$ is not defined" from pmjson.js Regards, dejan -----Original Message----- From: Armin Burger [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 31, 2007 8:01 PM To: Gambin Dejan Cc: pmapper-users@lists.sourceforge.net Subject: Re: [pmapper-users] Problem with join to external database table via MDB2 I updated the SVN with a patched version, replace function 'returnData()' in squery.php with the one from here http://svn.pmapper.net/trac/browser/pmapper/trunk/incphp/query/squery.php and see if it resolves the problem. armin Gambin Dejan wrote: > Hi, > > > > I am using the latest pmapper version (3.2-beta2). I am trying to make > an external join to Oracle database. I have installed MDB2 PEAR package > and I have succesfully (after many trials/errors) made a connection > using a sample PHP script. The point was I had to configure the oci8 > connect string differently because it couldn't find tnsnames.ora and I > have used the direct naming method so my conect string now is something > like: > "oci8://username:[EMAIL PROTECTED]:1521/?service=server_databas > e_service" > > > > In p.mapper, it is successfully connected but I am getting error (using > debug=3): "PHP Fatal error: Call to undefined function: > MDB2_Driver_oci8::getAll(). in > C:\Projekti\GIS\WebGIS\ms4w\Apache\php\PEAR\MDB2.php on line 1936" > > > > I can see in PEAR documentation getAll method exists so something else > must be the problem. > > > > Any help? > > > > Thanks very much > > > > Regards, dejan > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > pmapper-users mailing list > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users > ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users