Hello,

The <sql_where> seems to be unused. If you want to specify the where 
clause in the <sql_where>, you have to modify the 
'pmapper-dir/incphp/query/search.php' file and replace
"return $sql_where"
 with
"$qs = $sql_where".

Thomas

Hermann Karl a écrit :
> Dear List,
>
> searchitem in the file "search.xml"
> .......
> .......
>    <searchitem name="countries_sql" description="Country_sql">
>         <layer type="shape" name="countries">
>               <field type="s" name="ISO2_CODE" description="Country"
> wildcard="2" />
>                 <sql_from>countries</sql_from>
>                 <sql_where>ISO2_CODE="[ISO2_CODE]"</sql_where>
>       </layer>
>     </searchitem>
> .....
> .....
>
> the result is an error message in pm_debug.log
>
> [06-May-2009 18:42:25] P.MAPPER debug info 
> Searcharray in search.php->getSearchParameters() 
>  Array
> (
>     [ISO2_CODE] => AT
>     [mode] => search
>     [PHPSESSID] => 2f37d01495a7c65ffbc5349808adef09
> )
>
> [06-May-2009 18:42:25] P.MAPPER debug info 
> Parameters for searchArray 
> file: query.php->q_execAttributeQuery 
>
>  Array
> (
>     [ISO2_CODE] => AT
>     [mode] => search
>     [PHPSESSID] => 2f37d01495a7c65ffbc5349808adef09
> )
>
> [06-May-2009 18:42:25] P.MAPPER debug info 
> Parameters for searchParams 
> file: query.php->q_execAttributeQuery
>  ISO2_CODE="^AT$"
>
> any idea whats wrong ?
>
>
> Thanks
>
> Karl
>
>
> ------------------------------------------------------------------------------
> 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

Reply via email to