[pmapper-users] Search in 2 columns using only one field

[Juliano C. P. A. <jul...@ho...>]

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?