Well done! \o/
Works perfectly now : ))
Thank you so much Thomas!
Should I dare asking a last question?
Do I better use this, what is it actually doing?
<events>onchange="$('#pmsfld_numero').val('').flushCache()"</events>
On Wed, Apr 3, 2013 at 3:28 PM, Thomas RAFFIN <[email protected]> wrote:
> 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 <[email protected]> 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 <[email protected]> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
