Since I didn't solve this yet, is there a way to somehow debug the query and see what is happening on individual "layers"?
regards, dejan [email protected] wrote on 18.05.2009 08:22:37: > > > > > Try to remove the brackets [] from the field names > > queryByAttributes("KOORDINATAX", 5460870, MS_MULTIPLE); > > Regards > Maher > > > > |---------+---------------------------> > | | dejan.gam...@pul| > | | a.hr | > | | | > | | 05/18/2009 09:19| > | | AM | > |---------+---------------------------> > > >-------------------------------------------------------------------------------------------------------------------------------------------------- > | > | | > | To: Maher Karim <[email protected]> | > | cc: mapserver-users <[email protected]. > org>, mapserver-users-bounces <[email protected]. > org> | > | Subject: Re: [mapserver-users] queryByAttributes returns > no result with OGR/ODBC data source | > > >-------------------------------------------------------------------------------------------------------------------------------------------------- > | > > > > > Hi, > > Unfortunatelly it doesn't help. I have tried with: > > queryByAttributes("[KOORDINATAX]", ( [KOORDINATAX] = 5460870 ), > MS_MULTIPLE); > > and with > > queryByAttributes("[KOORDINATAX]", 5460870, MS_MULTIPLE); > > Neither one gives results :-( > > dejan > > Maher Karim <[email protected]> wrote on 18.05.2009 07:28:19: > > > > > > > > > > > HI, > > Please consider that there is a difference the field name definintion for > > the item query, the field name is differenet when you are using > shapefiles > > than PostGIS tables. > > Try to use > > $strExp=( [KOORDINATAX] = 5460870 ); > > queryByAttributes('itemname',$strExp,MS_MULTIPLE) > > > > and if Not working try > > queryByAttributes( [KOORDINATAX],5460870,MS_MULTIPLE) > > > > Hope that it helps > > > > Regards > > Maher > > > > > > > > > > |---------+---------------------------------------> > > | | [email protected] | > > | | Sent by: | > > | | mapserver-users-boun...@list| > > | | s.osgeo.org | > > | | | > > | | | > > | | 05/18/2009 12:50 AM | > > |---------+---------------------------------------> > > > > > >-------------------------------------------------------------------------------------------------------------------------------------------------- > > > | > > | > | > > | To: [email protected] > | > > | cc: > | > > | Subject: [mapserver-users] queryByAttributes returns no > > result with OGR/ODBC data source > | > > > > > >-------------------------------------------------------------------------------------------------------------------------------------------------- > > > | > > > > > > > > > > Hi, > > > > I am using OGR Virtual Spatial Data to connect to MS Access database > using > > ODBC. Database has X/Y columns. I have created .ovf file like this: > > > > <OGRVRTDataSource> > > <OGRVRTLayer name="krk"> > > <SrcDataSource>ODBC:@Krk</SrcDataSource> > > <FID>ID</FID> > > <SrcLayer>Dozvole</SrcLayer> > > <GeometryType>wkbPoint</GeometryType> > > <GeometryField encoding="PointFromColumns" x="KoordinataX" > > y="KoordinataY"/> > > </OGRVRTLayer> > > </OGRVRTDataSource> > > > > It is all working fine and the points are showing on the map (using > > p.mapper). Alos, ogrinfo with -where clause is working fine. But the > > attribute query gives no result, whichever field I query. Query string is > > like: > > > > ( [KOORDINATAX] = 5460870 ) > > > > This syntax works fine with shape files and also wit OGR layers based on > > MapInfo files. But not with ODBC/Access. > > > > I am using ms4w 2.2.7 > > > > Any help? > > > > regards, dejan_______________________________________________ > > mapserver-users mailing list > > [email protected] > > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > > > > > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
