Hello,
I have one SHPfile with 3 columns [ street name / first number / last number
] but i don't know how search in 2 columns using only one field.
MAPFILE:
LAYER
NAME "Street1"
GROUP GEOSTREET1
TYPE LINE
STATUS OFF
DATA "streetnum_line.shp"
TOLERANCEUNITS meters
TOLERANCE 15
CLASS
NAME " "
TEMPLATE void
END
METADATA
"DESCRIPTION" "Street"
"RESULT_FIELDS" "STREET,NUMBER1,NUMBER2"
"RESULT_HEADERS" "Street Name, First Number, Last
Number"
"LAYER_ENCODING" "ISO-8859-1"
"ows_title" "Street"
END
END
I need search this Address:
STREET NAME => ONE STREET
NUMBER => 110
SQL Expression:
SELECT * FROM streetnum_line WHERE STREET = "ONE STREET" and NUMBER1<= 110
and NUMBER2 => 110
SEARCH XML: (not working)
<searchitem name="Address" description="Street Name / Number">
<layer type="shape" name="Street1">
<field type="s" name="STREET" description="Street" wildcard="0"
sort="asc">
</field>
<field type="n" name="NUMBER1" description="Number"
compare=">=">
</field>
</layer>
</searchitem>
Can anybody help me?
------------------------------------------------------------------------------
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
