Variable substutition on CONNECTIONTYPE OGR CONNECTION OGRVRTDatasource (odbc)
    Huub Fleuren 
    hfl at HOME.NL
       
    Sun May 14 09:34:58 PDT 2006
    
    
  
Hi List,
Something changed, but what is it.
I'm using somthing like the following, so a ODBC datasource for a 
OGRVRTLayer with variable substitution for the CONNECTION statement.
This works for me since i first used it in mapserv version 4.2.
I compiled gdal 1.3.2 as i normally do; with Xerces, 2.7 this time.
 
ogrinfo works on a similar ovf file without variable substutution.
If i get something in the log file (this is not always the case) on this 
layer it is:
    msDrawMap(): Image handling error. Failed to draw layer named 
'kpxy'.
    msOGRFileNextShape(): OGR error. SetAttributeFilter() not supported 
on ExecuteSQL() results.
Does this mean that variable substitution is no longer supported here? I 
just want to make sure if it still is.
    CONNECTION
                "<OGRVRTDataSource>
                    <OGRVRTLayer name='wwall'>
                        <SrcDataSource>ODBC:admin/admin at db</SrcDataSource>
                        <SrcSQL>SELECT * FROM wwall WHERE (x > 
%xmin%) and (x < %xmax%) and (y > %ymin%) and (y < %ymax%) 
</SrcSQL>
                        <GeometryType>wkbPoint</GeometryType>
                        <GeometryField encoding='PointFromColumns' x='x' 
y='y'/>
                    </OGRVRTLayer>
                </OGRVRTDataSource>"
 
What is the reason why this construction does not return the selected 
points anymore?
Regards, Huub
    
    
More information about the MapServer-users
mailing list