[mapserver-dev] Oracle SQL (MS trunk)

[bartvde at osgis.nl]

Hi Mike,

thanks, right, it is an SE_ANNO_CAD_DATA column, but nulling it out also
means it is also output in the WFS GML, which is unwanted (shows up in
attribute tables etc.):

..
<rws:PERIMETER>13507.68</rws:PERIMETER>
<rws:null/>
</rws:AAA35>
..

Do you see a solution?

Or do I need to change my DATA statement to exclude it (but then again, I
need to always change the SQL when the datamodel changes).

TIA.

Best regards,
Bart

> Bart,
>
> I'm not sure about the 2 objectid's, but it is probably due to requesting
> unique OBJECTID. This gets added to the column list with has all the
> columns
> already present. The NULL is probably a blob column, perhaps an
> SE_ANNO_CAD_DATA column. NULLing it out was a patch I submitted to allow
> WFS
> to work when you have a blob column.
>
> Mike
>
>
> --
> Michael Smith
> RSGIS Center
> US Army Corps of Engineers
>
>
>
>
> On 12/10/09 6:30 AM, "bartvde at osgis.nl" <bartvde at osgis.nl> wrote:
>
>> Hi list,
>>
>> using Mapserver trunk I see the following SQL being generated for Oracle
>> Spatial layers:
>>
>> SELECT OBJECTID, OBJECTID, VOOR, LETTER, CYFER, KALK, ACHTER, SCHOP,
>> HEL,
>> GWT, CODE, OMSCHR, EERSTE_BOD, EERSTE_GWT, KLEUR_BOD, KLEUR_GWT, AREA,
>> PERIMETER, null, SHAPE FROM BODEM.BODEMKAART50 WHERE  ROWNUM<=5  AND
>> SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, :srid,
>> NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates
>> ),'querytype=window')
>> = 'TRUE'
>>
>> Questions:
>>
>> 1) why is OBJECTID requested twice? DATA statement is "SHAPE FROM
>> BODEM.BODEMKAART50 USING UNIQUE OBJECTID".
>> 2) where is the null after PERIMETER coming from?
>>
>> Best regards,
>> Bart
>>
>> _______________________________________________
>> mapserver-dev mailing list
>> mapserver-dev at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
>
>