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