[Mapserver-dev] MapOracleSpatial

Tue Aug 17 09:17:09 EDT 2004

This is a multi-part message in MIME format.
--------------050408040306010804010209
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Hi,
    My name is Fernando Simon and I work for G10 (Laboratório de 
Computação Aplicada - Brazil). I am continuing the development of the 
MapOracleSpatial source code, at this moment the 
msOracleSpatialLayerGetItems function and its complements.

    I'm with some problems, I'll try to explain them:

    When the fetched rows are equal to zero, I get a weird message after 
the results, like this one below:

    /"Content-type: text/html" /

    And in the source it's like this:

    </table>Content-type: text/html
    <HTML>
    <HEAD><TITLE>MapServer Message</TITLE></HEAD>
    <!-- MapServer version 4.2.2 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG 
OUTPUT=WBMP OUTPUT=PDF    SUPPORTS=PROJ SUPPORTS=FREETYPE 
SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER 
SUPPORTS=WFS_CLIENT INPUT=TIFF INPUT=EPPL7 INPUT=ORACLESPATIAL     
INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE -->
    <BODY BGCOLOR="#FFFFFF">
    </BODY></HTML>

I followed the code of the mappostgis as example. I followed the same 
steps, the else of "if ( 0 < PQntuples(query_result) )", but I still 
got this message.

    So, what's wrong, am I forgetting any step, anything? What do I need 
to do after rows fetched (equal zero), any more functions? 
(msOracleSpatialLayerFreeItemInfo?)

    Another question is how to use, or what sets the record attribute in 
msOracleSpatialLayerGetShape function? If I use the row_num (layerinfo) 
will I have the same effect?

    Thank's.

Fernando Simon

--------------050408040306010804010209
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
 <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
 <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi, 
&nbsp;&nbsp;&nbsp; My name is Fernando Simon and I work for G10 (Laborat&oacute;rio de
Computa&ccedil;&atilde;o Aplicada - Brazil). I am continuing the development of the
MapOracleSpatial source code, at this moment the
msOracleSpatialLayerGetItems function and its complements. 
 
&nbsp;&nbsp;&nbsp; I'm with some problems, I'll try to explain them: 
 
&nbsp;&nbsp;&nbsp; When the fetched rows are equal to zero, I get a weird message
after the results, like this one below: 
&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; "Content-type: text/html" 
 
&nbsp;&nbsp;&nbsp; And in the source it's like this: 
 
&nbsp;&nbsp;&nbsp; &lt;/table&gt;Content-type: text/html 
&nbsp;&nbsp;&nbsp; &lt;HTML&gt; 
&nbsp;&nbsp;&nbsp; &lt;HEAD&gt;&lt;TITLE&gt;MapServer Message&lt;/TITLE&gt;&lt;/HEAD&gt; 
&nbsp;&nbsp;&nbsp; &lt;!-- MapServer version 4.2.2 OUTPUT=GIF
OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=PDF &nbsp;&nbsp; SUPPORTS=PROJ
SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT
SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT INPUT=TIFF INPUT=EPPL7
INPUT=ORACLESPATIAL &nbsp;&nbsp;&nbsp; INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE --&gt; 
&nbsp;&nbsp;&nbsp; &lt;BODY
BGCOLOR="#FFFFFF"&gt; 
&nbsp;&nbsp;&nbsp; &lt;/BODY&gt;&lt;/HTML&gt; 
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp; I followed the code of the mappostgis as example. I followed the
same steps, the else of "if (&nbsp; 0 &lt; PQntuples(query_result) )", but I
still got this message. 
 
&nbsp;&nbsp;&nbsp; So, what's wrong, am I forgetting any step, anything? What do I
need to do after rows fetched (equal zero), any more functions?
(msOracleSpatialLayerFreeItemInfo?) 
 
&nbsp;&nbsp;&nbsp; Another question is how to use, or what sets the record attribute
in msOracleSpatialLayerGetShape function? If I use the row_num
(layerinfo) will I have the same effect? 
 
&nbsp;&nbsp;&nbsp; Thank's. 
 
 
Fernando Simon 
</body>
</html>

--------------050408040306010804010209--