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
