<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16890" name=GENERATOR></HEAD>
<BODY
style="FONT-SIZE: 10pt; FONT-FAMILY: Trebuchet MS; BACKGROUND-COLOR: rgb(221,221,221)"
vLink=#f97810 aLink=#f97810 link=#f97810>
<DIV><SPAN class=747172613-16092009>If you take the query that MapServer is
creating and run it directly against Oracle, does it work? </SPAN></DIV>
<DIV><SPAN class=747172613-16092009></SPAN> </DIV>
<DIV><SPAN class=747172613-16092009>I seem to remember that Oracle has a limit
on the number or elements or characters allowed in IN statements. The
limit is 1000 'expressions' in an IN condition. </SPAN></DIV>
<DIV><SPAN class=747172613-16092009></SPAN> </DIV>
<DIV><SPAN class=747172613-16092009>If you care to RTM:</SPAN></DIV>
<DIV><SPAN class=747172613-16092009><A
href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/expressions014.htm#i1033664">http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/expressions014.htm#i1033664</A></SPAN></DIV>
<DIV><SPAN class=747172613-16092009></SPAN> </DIV>
<DIV><SPAN class=747172613-16092009>You are going to have to come up with
another way to write your filter query.</SPAN></DIV>
<DIV><SPAN class=747172613-16092009></SPAN> </DIV>
<DIV><SPAN class=747172613-16092009>David.</SPAN></DIV>
<DIV><SPAN class=747172613-16092009></SPAN> </DIV>
<DIV><SPAN class=747172613-16092009></SPAN> </DIV>
<DIV></DIV>
<DIV><FONT face=Tahoma>-----Original Message-----<BR><B>From:</B>
mapserver-users-bounces@lists.osgeo.org
[mailto:mapserver-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>I-Real -
Rob ter Haar<BR><B>Sent:</B> Wednesday, September 16, 2009 4:16 AM<BR><B>To:</B>
mapserver<BR><B>Subject:</B> [mapserver-users] Problem big filteritem (apache
crash)<BR><BR></DIV></FONT>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px"><FONT style="FONT-SIZE: 10pt"
face="Trebuchet MS, Arial">Hello All,<BR><BR>I have a problem with a
filteritem witch contains +/- 11000 characters. This are id's of points which
I would show on a map. When I called the page apache crasht. And in the
coredump I see the following:<BR><BR></FONT><FONT style="FONT-SIZE: 10pt"
face="Trebuchet MS, Arial">#0 0x00cf15bc in mempcpy () from
/lib/libc.so.6<BR>No symbol table info available.<BR>#1 0x00ce6558 in
_IO_default_xsputn_internal () from /lib/libc.so.6<BR>No symbol table info
available.<BR>#2 0x00cc2bd8 in vfprintf () from /lib/libc.so.6<BR>No
symbol table info available.<BR>#3 0x00cdbd4c in vsprintf () from
/lib/libc.so.6<BR>No symbol table info available.<BR>#4 0x00cc853e in
sprintf () from /lib/libc.so.6<BR>No symbol table info available.<BR>#5
0x070fa3f5 in msOracleSpatialLayerWhichShapes (layer=0x36393639,
rect=<BR> {minx = 1.7223872351905284e-47, miny =
1.1808818690463142e-95, maxx = 2.0056059668611313e-76, maxy =
2.7151806783827087e-33}) at
maporaclespatial.c:670<BR> success =
<value optimized out><BR> i =
-1081417209<BR> function =
959197241<BR> version =
909716537<BR> query_str = "SELECT
LOCATIEID, alarm_actief, NAAM, SHAPE FROM (SELECT L.LOCATIEID AS LOCATIEID,
LG.SHAPE, L.NAAM AS NAAM, L.ADRES, L.PLAATS, alarm.NAAM Laatste_alarm,
unixts_to_date(Alarm.TIJDSTIP_HOOG)
Actief_sin"...<BR> table_name =
",4992,4993,4994,4995,4996,4997,4998,4999,5000,5001,5002,5003,5035,5036,5037,5038,5039,5040,5041,5042,5043,5044,5045,5046,5047,5048,5049,5050,5051,5052,5053,5054,5055,5056,5113,5396,5546,5547,5548,5549"...<BR>
geom_column_name =
",9647,9648,9649,9654,9655,9656,9657,9658,9659,9660,9661,9662,9663,9664,9665,9669,9670,9671,9672,9688"<BR>
unique =
",9624,9625,9626,9627,9628,9629,9630,9631,9632,9633,9634,9635,9636,9637,9641,9642,9643,9644,9645,9646"<BR>
srid =
",9604,9605,9606,9607,9608,9609,9610,9611,9612,9613,9614,9615,9616,9617,9618,9619,9620,9621,9622,9623"<BR>
adtp = (OCIDefine *) 0x3836392c<BR>
items = (OCIDefine **) 0x93b5560<BR>
dthand = (msOracleSpatialDataHandler *)
0x938e930<BR> hand =
(msOracleSpatialHandler *) 0x9436080<BR><BR>In the fields Table_name,
geon_colomn_name, unique and srid are filled with the string I assign to
FilterItem.<BR><BR>Is this a bug or do I make a mistake?<BR><BR>I use the
mapscript (php) to assign the variables.<BR><BR>Can anyone help
me?<BR></FONT><FONT style="FONT-SIZE: 10pt" face="Trebuchet MS, Arial"><BR>Met
vriendelijke groet,<BR>Rob ter Haar<BR><BR><B>I-Real</B><BR>Postbus
593<BR>7000 AN Doetinchem<BR><B>T:</B> +31 (0)314 366600<BR><B>F:</B> +31
(0)314 363410<BR><B>E:</B> <A style="COLOR: rgb(249,120,16)"
href="mailto:r.terhaar@i-real.nl">r.terhaar@i-real.nl</A><BR><B>I:</B> <A
style="COLOR: rgb(249,120,16)"
href="http://www.i-real.nl">www.i-real.nl</A><BR><BR></FONT>
<DIV
style="BORDER-RIGHT: rgb(153,153,153) 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: rgb(153,153,153) 1px solid; PADDING-LEFT: 5px; FONT-SIZE: 8pt; PADDING-BOTTOM: 5px; BORDER-LEFT: rgb(153,153,153) 1px solid; WIDTH: 600px; COLOR: rgb(153,153,153); PADDING-TOP: 5px; BORDER-BOTTOM: rgb(153,153,153) 1px solid">De
informatie in dit e-mailbericht is uitsluitend bestemd voor de
geadresseerde.<BR>Verstrekking aan en gebruik door anderen is niet
toegestaan.<BR>Door de elektronische verzending van het bericht, kunnen er
geen rechten worden ontleend aan de informatie.
</DIV><BR><BR><BR></BLOCKQUOTE></BODY></HTML>