The compress js version is certainly not up-to-date. Try to change your configuration like this: <pm_javascript_location>javascript/src</pm_javascript_location>
Armin, could you update the js compress files please? Le 03/04/2013 14:35, Chris forum a écrit : > Still no luck here... > I copy/paste your search above, replacing the test shema with public > one, but the second field is still not proposing anything. > > Here under the content of the pm_debug.log, with 'abe'->Abeilles and > '2' values used in the fields. > > Looking at the last line of the log, I have tried to replace > '[dependfldval]' with 'Abeilles' in search.xml, and the second field > this time proposed me values to choose from! > > Shouldn't the last line of the log contain 'Abeilles' instead of > '[dependfldval]'? It looks like the substitution is not done. > > > [03-Apr-2013 13:44:46] P.MAPPER debug info > Validation of search.xml file succeeded > [03-Apr-2013 13:44:49] P.MAPPER debug info > XML->//definition > SimpleXMLElement Object > ( > [@attributes] => Array > ( > [type] => suggest > [connectiontype] => db > [minlength] => 1 > [startleft] => 1 > [sort] => asc > [nosubmit] => 1 > ) > > [dsn] => @ > [sql] => SELECT DISTINCT lastname FROM > public.goeland_addresse_lausanne WHERE lastname IS NOT NULL ORDER BY > lastname > [comment] => SimpleXMLElement Object > ( > ) > > ) > > [03-Apr-2013 13:44:49] P.MAPPER debug info > XML->//definition > SimpleXMLElement Object > ( > [@attributes] => Array > ( > [type] => suggest > [connectiontype] => db > [sort] => asc > [minlength] => 0 > [dependfld] => lastname > ) > > [dsn] => @ > [sql] => SELECT DISTINCT numero FROM > public.goeland_addresse_lausanne WHERE numero::text ~* '^[search]' and > lastname = '[dependfldval]' ORDER BY numero > ) > > [03-Apr-2013 13:44:51] P.MAPPER debug info > request > Array > ( > [searchitem] => goeland_adresses > [fldname] => lastname > [q] => abe > [limit] => 0 > [timestamp] => 1364989492518 > ) > > [03-Apr-2013 13:44:51] P.MAPPER debug info > Parameters for attribute search file: suggest.php function: __construct > Array > ( > [type] => db > [sort] => asc > [minlength] => 1 > [regexleft] => > [startleft] => 1 > [dsn] => pgsql://user:pass@localhost:5432/goeland > [encoding] => UTF-8 > [sql] => SELECT DISTINCT lastname FROM > public.goeland_addresse_lausanne WHERE lastname IS NOT NULL ORDER BY > lastname > [dependFields] => Array > ( > ) > > ) > > [03-Apr-2013 13:44:51] P.MAPPER debug info > SELECT DISTINCT lastname FROM public.goeland_addresse_lausanne WHERE > lastname IS NOT NULL ORDER BY lastname > > [03-Apr-2013 13:45:39] P.MAPPER debug info > request > Array > ( > [searchitem] => goeland_adresses > [fldname] => numero > [q] => 2 > [limit] => 0 > [timestamp] => 1364989540505 > [dependfldval] => Abeilles > ) > > [03-Apr-2013 13:45:39] P.MAPPER debug info > Parameters for attribute search file: suggest.php function: __construct > Array > ( > [type] => db > [sort] => asc > [minlength] => 0 > [regexleft] => > [startleft] => 0 > [dsn] => pgsql://user:pass@localhost:5432/goeland > [encoding] => UTF-8 > [sql] => SELECT DISTINCT numero FROM > public.goeland_addresse_lausanne WHERE numero::text ~* '^[search]' and > lastname = '[dependfldval]' ORDER BY numero > [dependFields] => Array > ( > ) > > ) > > [03-Apr-2013 13:45:39] P.MAPPER debug info > SELECT DISTINCT numero FROM public.goeland_addresse_lausanne WHERE > numero::text ~* '^2' and lastname = '[dependfldval]' ORDER BY numero > > > On Wed, Apr 3, 2013 at 11:05 AM, Thomas RAFFIN <traf...@sirap.fr > <mailto:traf...@sirap.fr>> wrote: > > Hi, > > With your data and this search definition it worked yesterday: > > <searchitem name="goeland_adresses" description="Adresses -Suggest > Suggest PGSQL-"> > <layer type="postgis" name="goeland_addresse_lausanne"> > <field type="s" name="lastname" description="Rue" wildcard="2"> > > <definition type="suggest" connectiontype="db" > minlength="1" startleft="1" sort="asc" nosubmit="1"> > <dsn encoding="UTF-8">@</dsn> > <sql>SELECT DISTINCT lastname FROM > test.goeland_addresse_lausanne WHERE lastname IS NOT NULL ORDER BY > lastname</sql> > > <!--<events>onchange="$('#pmsfld_numero').val('').flushCache()"</events>--> > </definition> > </field> > > <field type="n" name="numero" description="No" wildcard="2"> > <definition type="suggest" connectiontype="db" sort="asc" > minlength="0" dependfld="lastname"> > > <dsn encoding="UTF-8">@</dsn> > <sql>SELECT DISTINCT numero FROM > test.goeland_addresse_lausanne WHERE numero::text ~* '^[search]' > and lastname = '[dependfldval]' ORDER BY numero</sql> > </definition> > </field> > </layer> > </searchitem> > > Take a look on the dsn that don't need to be re-specified. But it > requires 1 character or more. > The table is in the "test" schema here. > > Le 03/04/2013 10:06, Chris forum a écrit : >> Hi Thomas, >> >> Thx a lot for the explanation, I have chosen to use the >> nosubmit="1" parameter. >> >> First field works now, the query is not launched anymore when a >> suggested street name is clicked: >> <definition type="suggest" connectiontype="db" minlength="1" >> startleft="1" sort="asc" *nosubmit="1"*> >> >> >> So I am a step further, there is still a problem though with the >> second field: it doesn't suggest anything: >> <definition type="suggest" connectiontype="db" sort="asc" >> minlength="1" dependfld="lastname"> >> >> Did you manage to test my data? Does it work on your system? >> Here, if I choose the street name "Abeilles" and then type "2" in >> the second field, nothing is proposed while the numbers "23" , >> "25", "27" and "29" are in the db (the one I sent you). >> >> Sorry to insist... >> >> Chris >> >> >> >> >> On Tue, Apr 2, 2013 at 6:05 PM, Thomas RAFFIN <traf...@sirap.fr >> <mailto:traf...@sirap.fr>> wrote: >> >> OK, it is due to bad configuration. >> >> You could do one of those: >> - Unactivate auto submit for suggested fields ==> set >> "PM.suggestLaunchSearch = false;" in js_config.php (applies >> to all suggested fields!) >> - keep "PM.suggestLaunchSearch = true;" and add to each >> definition where it is needed the "nosubmit" parameter to "1" >> like this for instance: >> <definition type="suggest" connectiontype="db" minlength="1" >> startleft="1" sort="asc" nosubmit="1"> >> >> Bye >> >> Thomas >> >> Le 02/04/2013 15:43, Chris forum a écrit : >> >> Hi Thomas, >> >> Please find attached the necessary files to reproduce my >> environment. >> >> Thanx a lot! >> Chris >> >> >> >> > > ------------------------------------------------------------------------------ Minimize network downtime and maximize team effectiveness. Reduce network management and security costs.Learn how to hire the most talented Cisco Certified professionals. Visit the Employer Resources Portal http://www.cisco.com/web/learning/employer_resources/index.html _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
