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 <maher_ka...@dorsch.com.jo>
|
| cc: mapserver-users <mapserver-users@lists.osgeo.org>,
mapserver-users-bounces <mapserver-users-boun...@lists.osgeo.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 <maher_ka...@dorsch.com.jo> 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
>
>
>
>
> |---------+--------------------------------------->
> | | dejan.gam...@pula.hr |
> | | Sent by: |
> | | mapserver-users-boun...@list|
> | | s.osgeo.org |
> | | |
> | | |
> | | 05/18/2009 12:50 AM |
> |---------+--------------------------------------->
>
>
>--------------------------------------------------------------------------------------------------------------------------------------------------
> |
> |
|
> | To: mapserver-users@lists.osgeo.org
|
> | 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
> mapserver-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users