<br><font size=2 face="sans-serif">Since I didn't solve this yet, is there
a way to somehow debug the query and see what is happening on individual
"layers"?</font>
<br>
<br><font size=2 face="sans-serif">regards, dejan</font>
<br>
<br><tt><font size=2>mapserver-users-bounces@lists.osgeo.org wrote on 18.05.2009
08:22:37:<br>
<br>
> <br>
> <br>
> <br>
> <br>
> Try to remove the brackets [] from the field names<br>
> <br>
> queryByAttributes("KOORDINATAX", 5460870, MS_MULTIPLE);<br>
> <br>
> Regards<br>
> Maher<br>
> <br>
> <br>
> <br>
> |---------+---------------------------><br>
> |         |          
Dejan.Gambin@pul|<br>
> |         |          
a.hr            |<br>
> |         |          
                |<br>
> |         |          
05/18/2009 09:19|<br>
> |         |          
AM              |<br>
> |---------+---------------------------><br>
>   <br>
> >--------------------------------------------------------------------------------------------------------------------------------------------------<br>
> |<br>
>   |                  
                     
                     
          |<br>
>   |        To:      Maher
Karim <Maher_Karim@dorsch.com.jo>          
      |<br>
>   |        cc:      mapserver-users
<mapserver-users@lists.osgeo.<br>
> org>, mapserver-users-bounces <mapserver-users-bounces@lists.osgeo.<br>
> org>             |<br>
>   |        Subject: Re: [mapserver-users]
queryByAttributes returns <br>
> no result with OGR/ODBC data source          
                     
        |<br>
>   <br>
> >--------------------------------------------------------------------------------------------------------------------------------------------------<br>
> |<br>
> <br>
> <br>
> <br>
> <br>
> Hi,<br>
> <br>
> Unfortunatelly it doesn't help. I have tried with:<br>
> <br>
> queryByAttributes("[KOORDINATAX]", ( [KOORDINATAX] = 5460870
),<br>
> MS_MULTIPLE);<br>
> <br>
> and with<br>
> <br>
> queryByAttributes("[KOORDINATAX]", 5460870, MS_MULTIPLE);<br>
> <br>
> Neither one gives results :-(<br>
> <br>
> dejan<br>
> <br>
> 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<br>
> 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>
> > |<br>
> >   |<br>
> |<br>
> >   |        To:      mapserver-users@lists.osgeo.org<br>
> |<br>
> >   |        cc:<br>
> |<br>
> >   |        Subject: [mapserver-users]
queryByAttributes returns no<br>
> > result with OGR/ODBC     data source<br>
> |<br>
> ><br>
> ><br>
> >--------------------------------------------------------------------------------------------------------------------------------------------------<br>
> <br>
> > |<br>
> ><br>
> ><br>
> ><br>
> ><br>
> > Hi,<br>
> ><br>
> > I am using OGR Virtual Spatial Data to connect to MS Access database<br>
> 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>
> <br>
> _______________________________________________<br>
> mapserver-users mailing list<br>
> mapserver-users@lists.osgeo.org<br>
> http://lists.osgeo.org/mailman/listinfo/mapserver-users<br>
</font></tt>