Hi Luis,
I've made few modification for querying Oracle layers but I haven't yet
finished my tests.
Try to replace in "your-pmapper-dir/incphp/query.php", at the end of
"q_execAttributeQuery" function :
"
@$this->qLayer->queryByAttributes($fldName, $this->qStr,
MS_MULTIPLE);
"
with
"
if ($this->qLayerType == "oracle") {
@$this->qLayer->queryByAttributes(null, $this->qStr,
MS_MULTIPLE);
} else {
@$this->qLayer->queryByAttributes($fldName,
$this->qStr, MS_MULTIPLE);
}
"
I think it will solve your problem.
Thomas
Armin Burger a écrit :
> Luis
>
> I unfortunately have no Oracle installation available so I usually
> cannot test the functioning of it. All tests made so far with oracle
> was on a server from a user that I could access via ftp. Since 1 year
> or more I have not any more tried this and I guess the connection is
> not any more available.
>
> Why the query doesn't return any result, I don't know. The whole
> querybyattribute stuff is not one of the best parts of Mapserver and
> not always working as expected with anything else than shapefiles.
> That's the reason why I still keep the separate query for Postgis
> using PHP-Postgres functions instead of Mapscript.
>
> Please try the query with a simple, example using the script from here
> http://svn.pmapper.net/trac/browser/pmapper/trunk/utils/test_query_string.php?format=txt
>
> modify the parameters for mapfile, layer name and query string (taking
> the one from the debug log, like
> UPPER(DPTO) LIKE '%CHALATENANGO%'), ie. $mapFile, $qLayer, $qStr. If
> no result is returned then you need to ask this on the Mapserver
> mailing list. Be sure that the query executes correctly when executing
> it from a normal Oracle client.
>
> armin
>
> On Wed, May 6, 2009 at 6:22 AM, Luis Orlando Melendez
> <luisorlando.melen...@gmail.com> wrote:
>
>> Hi everyone,
>>
>> Im trying to configure search.xml file for a oracle layer and when
>> performing the search i have no results, please any idea about what i
>> m doing wrong is welcome:
>>
>> * I'm using : MS4W 2.2.8, mapserv 5.2.0 , pmapper 3.2 0 -
>> BUILD 2008-03-05, the database is oracle XE 10g
>> Im runnig all in a ruindows xp sp2
>>
>> *
>> this is the search.xml file :
>>
>> <?xml version="1.0" ?>
>> <!--<?xml-stylesheet type="text/xsl" href="stylesheet.xsl"?>-->
>> <searchlist version="1.0">
>>
>> <dataroot>$</dataroot>
>>
>> <searchitem name="departamentos" description="departamentos">
>> <layer type="oracle" name="departamentos">
>> <field type="n" name="GID" description="GID" wildcard="2" />
>> </layer>
>> </searchitem>
>>
>>
>> <searchitem name="municipios" description="Municipios">
>> <layer type="oracle" name="municipios">
>> <field type="s" name="LONGNAME" description="Municipios"
>> wildcard="0" />
>> </layer>
>> </searchitem>
>>
>> <searchitem name="iglesias" description="iglesias">
>> <layer type="oracle" name="iglesias">
>> <field type="s" name="LONGNAME" description="iglesias" wildcard="0" />
>> </layer>
>> </searchitem>
>>
>>
>> <searchitem name="campings" description="Camping">
>> <layer type="oracle" name="campings">
>> <field type="s" name="LONGNAME" description="Camping :" wildcard="0">
>> </field>
>> </layer>
>> </searchitem>
>> </searchlist>
>>
>>
>> the layer I have configured is this:
>>
>> #========================================== DEPARTAMENTOS
>> ==================#
>> #departamentos
>> #
>> # Start of Layer Departamentos
>> #
>> LAYER
>> NAME "departamentos"
>> TYPE polygon
>> CONNECTIONTYPE oraclespatial
>> CONNECTION "mapa/m...@admin"
>> DATA "GEOMETRY FROM DEPARTAMENTOS USING UNIQUE GID"
>> DUMP TRUE
>> TEMPLATE "void"
>> STATUS ON
>> #TRANSPARENCY 70
>> PROJECTION
>> "init=epsg:32062"
>> END
>> METADATA
>> "DESCRIPTION" "departamentos"
>> "RESULT_FIELDS" "DPTO, GID"
>> "RESULT_HEADERS" "dpto, gid"
>> "RESULT_HYPERLINK" "DPTO, GID"
>> "ows_title" "departamentos"
>> END # Metadata
>> CLASS
>> Name 'departamentos'
>> COLOR 16 181 84
>> OUTLINECOLOR 0 0 0
>> TEMPLATE "void"
>> END # Class
>> END # Layer
>>
>>
>> THIS IS THE PM_DEBUG.LOG i n the \incphp\xajax directory
>>
>>
>> [05-May-2009 23:04:11] P.MAPPER debug info
>> Validation of search.xml file succeeded
>>
>> [05-May-2009 23:04:37] P.MAPPER debug info
>> Searcharray in search.php->getSearchParameters()
>> Array
>> (
>> [DPTO] => CHALATENANGO
>> [mode] => search
>> [PHPSESSID] => 5d82664df04e9a59a4c450810ad4857d
>> )
>>
>> [05-May-2009 23:04:37] P.MAPPER debug info
>> Parameters for searchArray
>> file: query.php->q_execAttributeQuery
>>
>> Array
>> (
>> [DPTO] => CHALATENANGO
>> [mode] => search
>> [PHPSESSID] => 5d82664df04e9a59a4c450810ad4857d
>> )
>>
>> [05-May-2009 23:04:37] P.MAPPER debug info
>> Parameters for searchParams
>> file: query.php->q_execAttributeQuery
>> Array
>> (
>> [layerName] => departamentos
>> [layerType] => oracle
>> [firstFld] => DPTO
>> [qStr] => UPPER(DPTO) LIKE '%CHALATENANGO%'
>> )
>>
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
>> production scanning environment may not be a perfect world - but thanks to
>> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
>> Series Scanner you'll get full speed at 300 dpi even with all image
>> processing features enabled. http://p.sf.net/sfu/kodak-com
>> _______________________________________________
>> pmapper-users mailing list
>> pmapper-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>>
>>
>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> pmapper-users mailing list
> pmapper-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>
>
>
>
>
>
------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image
processing features enabled. http://p.sf.net/sfu/kodak-com
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
