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)
Can anybody help me?
--
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users