Variable substutition on CONNECTIONTYPE OGR CONNECTION OGRVRTDatasource (odbc)

[Paul Ramsey]

Huub,

Yes, things changed in later versions (they got more secure!). Check  
out the DATAPATTERN clause in the latest mapfile reference manual.

Paul

On 14-May-06, at 9:34 AM, Huub Fleuren wrote:

> 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