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

[Dejan.Gambin at pula.hr]

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
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090518/fba132f2/attachment.html