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