queryByAttributes PostGIS Problem

Paul Moen pmoen at STATE.ND.US
Thu Mar 23 14:15:40 EST 2006


Can anyone tell me how to use queryByAttributes in PHP mapscript to query a
postgis layer with the following WHERE clause.

WHERE (location LIKE '12458%' AND county = 'Bowman')

I assume that I can do it with 4.8.2 since I could with mapscript 4.6.2
using $search = $qlayer->queryByAttributes(county,"(location LIKE '12458%'
AND county = 'Bowman')",MS_MULTIPLE);

With 4.6.2, it didn't seem to matter what field I put in the first
parameter, as long as it was a valid field. The second parameter was
essentially the where clause.

With 4.8.2, using $search = $qlayer->queryByAttributes(county,"(location
LIKE '12458%' AND county = 'Bowman')",MS_MULTIPLE);
creates the malformed where clause below.

WHERE (county = 'location LIKE '12458%' AND county = 'Bowman'')

Is this a bug or did the functionality go away?

Thank you,

Paul T. Moen
pmoen at state.nd.us
ND State Water Commission



More information about the mapserver-users mailing list