Lee, can you please tell us a bit more? Is this query against a
database? What is the DDL for the source relation? What does GeoServer
say they types are of the name and id fields?
One potential problem is that your id might be mistaken for gml:id.
On 20/04/12 17:21, Lee M. wrote:
> *if i try this :*
>
> var c_filter = new OpenLayers.Filter.Logical({
> type: OpenLayers.Filter.Logical.OR,
> filters: [
> new OpenLayers.Filter.Comparison({
> type: OpenLayers.Filter.Comparison.EQUAL_TO,
> matchCase:false,
> property: 'id',
> value:(document.getElementById("Text")).value
> }),
> new OpenLayers.Filter.Comparison({
> type: OpenLayers.Filter.Comparison.LIKE,
> matchCase:false,
> property: 'name',
> value: "*" +(document.getElementById("Text")).value + "*"
> })
> ]
> });
>
> wfsProtocol.read({
> filter: c_filter,
> callback: processTheQuery,
> scope: strategy
> })
>
>
> *the first filter works fine. but the second doesn't, when i searched for
> name: Peter Lyam, i got this error :*
> <ows:Exception exceptionCode="NoApplicableCode">
> <ows:ExceptionText>java.lang.RuntimeException: java.io.IOException
> java.io.IOException
> null
>
> *ERROR: invalid input syntax for integer: "Peter Lyam"*
>
> Position: 380</ows:ExceptionText>
> </ows:Exception>
> </ows:ExceptionReport>
>
>
> *the request :*
> <wfs:GetFeature xmlns:wfs="http://www.opengis.net/wfs"; service="WFS"
> version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs
> http://schemas.opengis.net/wfs/1.1.0/wfs.xsd";
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><wfs:Query
> typeName="feature:Main_Layer" srsName="EPSG:3857"
> xmlns:feature="http://mapmap.org";><ogc:Filter
> xmlns:ogc="http://www.opengis.net/ogc";><ogc:Or><ogc:PropertyIsEqualTo
> matchCase="false"><ogc:PropertyName>id</ogc:PropertyName><ogc:Literal>Peter
> Lyam</ogc:Literal></ogc:PropertyIsEqualTo><ogc:PropertyIsLike
> matchCase="false" wildCard="*" singleChar="."
> escapeChar="!"><ogc:PropertyName>name</ogc:PropertyName><ogc:Literal>*Peter
> Lyam*</ogc:Literal></ogc:PropertyIsLike></ogc:Or></ogc:Filter></wfs:Query></wfs:GetFeature>
>
>
> it seems like it cannot see the *OR* and did all two filters with the same
> value! and because of the first filter expects integer (id) , that cause
> this error.
> is there any way to fix that ?
>
> --
> View this message in context:
> http://osgeo-org.1560.n6.nabble.com/ogc-Or-not-working-tp4901377p4901377.html
> Sent from the GeoServer - User mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> For Developers, A Lot Can Happen In A Second.
> Boundary is the first to Know...and Tell You.
> Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
> http://p.sf.net/sfu/Boundary-d2dvs2
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
--
Ben Caradoc-Davies <[email protected]>
Software Engineer
CSIRO Earth Science and Resource Engineering
Australian Resources Research Centre
------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
