oracle layers: php sometime crashes

[Fernando Siimon]

Hi,
    Is it right the "," before FROM clause?
    As Bart, I suggest to use the 4.6 version, it's more stable and 
contains some improves in the code that can help with this problem.
    Thanks.

------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://g10.cttmar.univali.br - UNIVALI/CTTMAR
------------------------------------------------------------------------

Bart van den Eijnden wrote:

>Are you able to upgrade to Mapserver/Mapscript 4.6 and see if the problem is still there?
>
>Best regards,
>Bart
>
>Bart van den Eijnden
>Syncera IT Solutions
>Postbus 270
>2600 AG  DELFT
>
>tel.nr.: 015-7512436
>email: BEN at Syncera-ITSolutions.nl
>
>  
>
>>>>Francesco Sozzi <fsozzi at INTERCAD.CH> 08/18/05 05:20pm >>>
>>>>        
>>>>
>Hi all,
>
>I have a trouble in using QueryByAttributes or QueryByShape on an Oracle Spatial layer: PHP sometime crashes.
>The strange thing is that it happens only on some layer and on some PC.
>I have a test installation with exactly the same php code, Apache version, Mapserver version, Oracle Version, OS version (Windows XP Professional) and on one machine works fine and on another php crashes (and only on one oracle layer, for the other oracle layers it works fine).
>
>Has anybody already experimented a problem like this?....
>
>Bets regards
>
>
>
>I use:
>- PHP 4.3.10
>- Mapserver 4.4.1
>- Apache 2
>- Windows XP
>
>The test code is:
><?php
>
>$gMap = ms_newMapObj("C:/App/QueryMapWEB/data/AIL/gas.map");
>$gLayer = $gMap->getLayerByName("Condotte");
>
>$rectDrawnedMapCoord = ms_newrectObj();
>$rectDrawnedMapCoord->setextent(716765.866548,
>    89471.4128114 ,
>    717831.590747,
>    87732.5996441);
>
>$qresult = $gLayer->queryByRect($rectDrawnedMapCoord);
>$layer->open();
>
>?>
>
>The layer definition is:
># ------------------------------------------------------------------------
># Condotte
># ------------------------------------------------------------------------
>LAYER
> NAME "Condotte"
> TYPE LINE 
> CONNECTIONTYPE oraclespatial
> CONNECTION "ail_gas/avs at tb"
> DATA "GEOM FROM (SELECT fid,geom,FROM ga_strang WHERE geom is not null AND DELETED=0) USING UNIQUE fid NONE"
> STATUS DEFAULT 
> SYMBOLSCALE 200
>        
> CLASS  
>  NAME "nessuna"
>  COLOR 0 0 0
>  SYMBOL 1
>  SIZE 8
>  TEMPLATE "templates/default.html"
> END
> 
>END
>
>  
>