If you use mapscript you can: Insert your "items" in a a separate table and then just do a SELECT * FROM table where id in (SELECT id from TABLE_WITH_YOUR_FILTER_IDS)
On Wed, Sep 16, 2009 at 12:16 PM, I-Real - Rob ter Haar <[email protected]> wrote: > Hello All, > > 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: > > #0 0x00cf15bc in mempcpy () from /lib/libc.so.6 > No symbol table info available. > #1 0x00ce6558 in _IO_default_xsputn_internal () from /lib/libc.so.6 > No symbol table info available. > #2 0x00cc2bd8 in vfprintf () from /lib/libc.so.6 > No symbol table info available. > #3 0x00cdbd4c in vsprintf () from /lib/libc.so.6 > No symbol table info available. > #4 0x00cc853e in sprintf () from /lib/libc.so.6 > No symbol table info available. > #5 0x070fa3f5 in msOracleSpatialLayerWhichShapes (layer=0x36393639, rect= > {minx = 1.7223872351905284e-47, miny = 1.1808818690463142e-95, maxx = > 2.0056059668611313e-76, maxy = 2.7151806783827087e-33}) at > maporaclespatial.c:670 > success = <value optimized out> > i = -1081417209 > function = 959197241 > version = 909716537 > 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"... > 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"... > geom_column_name = > ",9647,9648,9649,9654,9655,9656,9657,9658,9659,9660,9661,9662,9663,9664,9665,9669,9670,9671,9672,9688" > unique = > ",9624,9625,9626,9627,9628,9629,9630,9631,9632,9633,9634,9635,9636,9637,9641,9642,9643,9644,9645,9646" > srid = > ",9604,9605,9606,9607,9608,9609,9610,9611,9612,9613,9614,9615,9616,9617,9618,9619,9620,9621,9622,9623" > adtp = (OCIDefine *) 0x3836392c > items = (OCIDefine **) 0x93b5560 > dthand = (msOracleSpatialDataHandler *) 0x938e930 > hand = (msOracleSpatialHandler *) 0x9436080 > > In the fields Table_name, geon_colomn_name, unique and srid are filled with > the string I assign to FilterItem. > > Is this a bug or do I make a mistake? > > I use the mapscript (php) to assign the variables. > > Can anyone help me? > > Met vriendelijke groet, > Rob ter Haar > > I-Real > Postbus 593 > 7000 AN Doetinchem > T: +31 (0)314 366600 > F: +31 (0)314 363410 > E: [email protected] > I: www.i-real.nl > > De informatie in dit e-mailbericht is uitsluitend bestemd voor de > geadresseerde. > Verstrekking aan en gebruik door anderen is niet toegestaan. > Door de elektronische verzending van het bericht, kunnen er geen rechten > worden ontleend aan de informatie. > > > > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > -- http://iap.md, The future is open _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
