<html>
<font size=3>Richard-<br>
<br>
Thanks for the reply-<br>
<br>
Sorry for my confusion - I typed a "|" when it should
have been a "/" I appear to have the syntax correct for
making a match.<br>
<br>
If I seach for qstring=/A/ I get every land use type with that as
part of the use designation<br>
including the 'AC-RW' - I don't want the 'AC-RW' match as it is not
of type 'A'<br>
<br>
If I leave it as A, /A, or A/ I get "no records
found" - How do I get a match for only the polygons of type 'A' and
none of the others with an A in the type ?<br>
<br>
I need to be able to specify an absolute equality/match for character
fields as opposed to a match based on a portion of any character value in
that field. Are there other characters to include in the qstring
that specify what type of match to perform ?<br>
<br>
Ken<br>
<br>
At 12:02 PM 12/9/2004 -0700, you wrote:<br>
>On Thu, 9 Dec 2004 08:34:26 -0800, Geographic Resource
Solutions<br>
><grs@grsgis.com> wrote:<br>
>> Dear list-<br>
>> <br>
>> I have searched the list for something like this and have come
up empty.<br>
>> <br>
>> After getting everything to work I find my queries are not
returning the<br>
>> features I desire. Rather they are returning too many 'hits.'
The search<br>
>> expression is obviously operating as an SQL 'like' with
wildcards at each<br>
>> end of the specified value rather than an SQL '='. For
example,<br>
>> <br>
>> qstring = |101011| <br>
>> <br>
>> when applied to my parcel data returns all parcels that have
the 101011<br>
>> characters present in their value, no matter where they are in
the string. <br>
>> Thus I get parcels 12 parcels starting with 101011, but I also
get parcels<br>
>> like 522101011' which I do not want.<br>
>> <br>
>> Similarly, when searching for a land use code of 'A' I return
all the 'A'<br>
>> land use polygons, but I also get all the 'AC-WR' and any
others that have<br>
>> an 'A' in them which I do not want located.<br>
>> <br>
>> So my question is:<br>
>> <br>
>> Am I doing somethin wrong ? How do I specify an expression
that should be<br>
>> an equality '=' rather than a 'like' ? Is there a wildcard that
can be<br>
>> included in the expression statement so that it operates as I
define it<br>
>> (e.g. (101011% or A%)) rather than assuming wildcards are part
of the<br>
>> expression at beginning and end. This is obviously not
following standard<br>
>> SQL formatting so what are the definitions that apply to
expressions and how<br>
>> can I generate the query results I need. Queries that return
improper<br>
>> results make the programmer look rather foolish - and of course
I would like<br>
>> to avaoid that appearance ! I figure there must be a way - and
if not, then<br>
>> there really needs to be a way - but what is it ?<br>
>> <br>
>> Thanks in advance,<br>
>> <br>
>> Ken Stumpf<br>
>> <br>
>> <br>
>> <br>
>> Geographic Resource Solutions <br>
>> 1125 16th Street, Suite 213 <br>
>> Arcata, CA 95521 <br>
>> Phone: (707) 822-8005 <br>
>> Fax: (707) 822-2864 <br>
>>
<a href="http://www.grsgis.com/" eudora="autourl">www.grsgis.com</a>
<br>
><br>
><br>
>Mapserver uses regular expression syntax, not SQL syntax, on the<br>
>qstring. Try leaving off the pipe characters for starters, the apply<br>
>regex symbols.<br>
><br>
>Regards,<br>
>-- <br>
>Richard Greenwood<br>
>richard.greenwood@gmail.com<br>
><a href="http://www.greenwoodmap.com/" eudora="autourl">www.greenwoodmap.com</a><br>
> </font>
<BR>
<div>Geographic Resource Solutions</div>
<div>1125 16th Street, Suite 213</div>
<div>Arcata, CA 95521</div>
<div>Phone: (707) 822-8005</div>
<div>Fax: (707) 822-2864</div>
<br>
<a href="http://www.grsgis.com/" EUDORA=AUTOURL>www.grsgis.com</a>
</html>