[mapserver-users] queryByAttributes returns no result with OGR/ODBC data source

[Maher Karim]

Try to remove the brackets [] from the field names

queryByAttributes("KOORDINATAX", 5460870, MS_MULTIPLE);

Regards
Maher



|---------+--------------------------->
|         |           Dejan.Gambin at pul|
|         |           a.hr            |
|         |                           |
|         |           05/18/2009 09:19|
|         |           AM              |
|---------+--------------------------->
  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |                                                                                                                                                  |
  |        To:      Maher Karim <Maher_Karim at dorsch.com.jo>                                                                                          |
  |        cc:      mapserver-users <mapserver-users at lists.osgeo.org>, mapserver-users-bounces <mapserver-users-bounces at 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_Karim at 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.Gambin at pula.hr        |
> |         |           Sent by:                    |
> |         |           mapserver-users-bounces at list|
> |         |           s.osgeo.org                 |
> |         |                                       |
> |         |                                       |
> |         |           05/18/2009 12:50 AM         |
> |---------+--------------------------------------->
>
>
>--------------------------------------------------------------------------------------------------------------------------------------------------

> |
>   |
|
>   |        To:      mapserver-users at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>