Set the debug level to 3 as described here
http://svn.pmapper.net/trac/wiki/FaqDebugging#WhatshouldIdoifp.mapperisnotworkingcorrectly
then look in the log file for something like
Parameters for searchParams
file: query.php->q_execAttributeQuery
Array
(
[layerName] => cities10000eu
[layerType] => shape
[firstFld] => NAME
[qStr] => ( ( "[NAME]" =~ /(B|b)(E|e)(R|r)(L|l)/ ) )
)
the [qStr] is the command sent to the database. Run it directly on
Oracle and see if you get errors or just no result. It might be that the
"/" needs to be escaped, but I don't know that for Oracle.
Armin
Gambin Dejan wrote:
> Hi,
>
>
>
> I have successfully made an external database join to Oracle database
> and it is working fine. I have enabled the attribute query too, but I
> have one problem. The join fields from shape to oracle is string.
> Unfortunatelly it has to be this way because this is how the parcels are
> identified in our cadastral plan. This wouldn't be a problem if the
> string is "normal". But the string is in form xx/yy, and I should have
> to enable the attribute query of this form. If I enter only xx or its
> part (for example the parcel id is 214/2 and I enter 214 or 21) the
> result is found and everything is ok. But if I enter the complete id
> (214/2) then no results are found.
>
>
>
> I suppose the problem is with "/" but I don't know how to solve it.
>
>
>
> Any help?
>
>
>
> Thanks very much
>
>
>
> Regards, dejan
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> pmapper-users mailing list
> pmapper-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
