<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class=""><div class="">Good morning and best wishes for this new year</div><div class=""><br class=""></div><div class="">At the present time, I’m working on a new project,, inspired bus this site <a href="http://www.souslesmers.fr/" class="">http://www.souslesmers.fr/</a> -> Recherche avancée, but with my own pictures and « discoveries ». The main idea is to try identifying what I have seen underwater (and pictured) more quickly than going through books (which I will have to do to populate the « database » prior to the dives. But it is also a way to learn marine life).</div><div class=""><br class=""></div><div class="">I created some forms to create new Poissons (fishes), Vers (Worms) and nudibranchs based on fox cookbook contacts examples. They are working.</div><div class=""><br class=""></div><div class="">Then, I wanted to create a « facetted search » on the Poissons.Poissons page (the test form includes only 3 criteria among the 10 I used to identify a fish)</div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">J’ai créé le formulaire suivant sur la page « Poissons.Poissons »</div><div class=""><br class=""></div><div class=""><div class=""><span class="Apple-tab-span" style="white-space: pre;"> </span><font color="#0061ff" class="">(:fox formulaire ptvupdate=0 template=CherchePoisson#display ptvclear=1:)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>!!Caractéristiques</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>||'''Lieu : '''||(:input select name=$:lieu value="*" label="*":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:lieu value="Atlantique" label="Atlantique":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:lieu value="Méditerranée" label="Méditerranée":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:lieu value="Indo-Pacifique" label="Indo-Pacifique":)||</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>||'''Forme :'''||(:input select name=$:forme value="*" label="*":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:forme value="Corps fuselé" label="Corps fuselé":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:forme value="Corps comprimé latéralement" label="Corps comprimé latéralement":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:forme value="Corps allongé" label="Corps allongé":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:forme value="Corps en forme de gourdin" label="Corps en forme de gourdin":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:forme value="Corps robuste/Ovale" label="Corps robuste/ovale":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:forme value="Corps plat" label="Corps plat":)||</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>||'''Taille :'''||(:input select name=taille value="*" label="*":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="*" label="*":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="Inférieure 10cm" label="Inférieure 10cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="10-20cm" label="10-20cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="20-30cm" label="20-30cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="30-40cm" label="30-40cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="40-50cm" label="40-50cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="50-60cm" label="50-60cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="60-70cm" label="60-70cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="70-80cm" label="60-80cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="80-90cm" label="80-90cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="90-100cm" label="90-100cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="Supérieure 1m" label="Supérieure 1m":)</font></div><div class=""><font color="#0061ff" class=""><br class=""></font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input submit post Enter:)</font></div><div class=""><font color="#0061ff" class=""><br class=""></font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:foxend formulaire:)</font></div><div class=""><br class=""></div><div class="">As you see, this form is calling the page « Poissons.CherchePoisson » which includes the following :</div></div><div class=""><br class=""></div><div class=""><div class=""><span class="Apple-tab-span" style="white-space: pre;"> </span><font color="#0061ff" class="">(:nogroupheader:)</font></div><div class=""><font color="#0061ff" class=""><br class=""></font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>[[#display]]</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:pagelist taille={$$taille} lieu={$$lieu}:)</font></div><div class=""><font color="#0061ff" class=""><br class=""></font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>[[#displayend]]</font></div><div class=""><font color="#0061ff" class=""><br class=""></font></div><div class="">The first search<font color="#0061ff" class=""> </font>« Lieu=* » « Forme=* » « Taille Inférieur 10cm » is giving the expected result. The second search is also giving the proper result, except that it is piled under the previous one which is not deleted. I give you the content of the « Poissons.Poissons » page after the second search :</div></div><div class=""><br class=""></div></div><div class=""><br class=""></div><div class=""><div class=""><font color="#0061ff" class="">(:fox formulaire ptvupdate=0 template=CherchePoisson#display ptvclear=1:)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>!!Caractéristiques</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>||'''Lieu : '''||(:input select name=$:lieu value="*" label="*":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:lieu value="Atlantique" label="Atlantique":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:lieu value="Méditerranée" label="Méditerranée":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:lieu value="Indo-Pacifique" label="Indo-Pacifique":)||</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>||'''Forme :'''||(:input select name=$:forme value="*" label="*":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:forme value="Corps fuselé" label="Corps fuselé":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:forme value="Corps comprimé latéralement" label="Corps comprimé latéralement":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:forme value="Corps allongé" label="Corps allongé":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:forme value="Corps en forme de gourdin" label="Corps en forme de gourdin":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:forme value="Corps robuste/Ovale" label="Corps robuste/ovale":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:forme value="Corps plat" label="Corps plat":)||</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>||'''Taille :'''||(:input select name=taille value="*" label="*":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="*" label="*":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="Inférieure 10cm" label="Inférieure 10cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="10-20cm" label="10-20cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="20-30cm" label="20-30cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="30-40cm" label="30-40cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="40-50cm" label="40-50cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="50-60cm" label="50-60cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="60-70cm" label="60-70cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="70-80cm" label="60-80cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="80-90cm" label="80-90cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="90-100cm" label="90-100cm":)</font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input select name=$:taille value="Supérieure 1m" label="Supérieure 1m":)</font></div><div class=""><font color="#0061ff" class=""><br class=""></font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:input submit post Enter:)</font></div><div class=""><font color="#0061ff" class=""><br class=""></font></div><div class=""><font color="#0061ff" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:foxend formulaire:)</font></div><div class=""><font color="#ff2600" class=""><b class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:pagelist taille=Inférieure 10cm lieu=*:)</b></font></div><div class=""><font color="#ff2600" class=""><b class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>(:pagelist taille=Supérieure 1m lieu=*:)</b></font></div><div class=""><font color="#ff2600" class=""><b class=""><br class=""></b></font></div><div class=""><font class=""><br class=""></font></div><div class=""><font class="">I’m trying another way, using </font>sqlite, dataquery, dataplates and ZAP cookbooks. I created a new test site with the latest pmwiki version (2.2.83) using MAMP 3.4 (PHP 5.6.1) on Mac OS X Yosemite. I have created a config.php file as follow :</div><div class=""><br class=""></div><div class=""><font class=""><span class=""><div class=""><font color="#4f7a28" class=""><?php if (!defined('PmWiki')) exit();</font></div><div class=""><font color="#4f7a28" class="">$WikiTitle = "Essai";</font></div><div class=""><font color="#4f7a28" class=""><br class=""></font></div><div class=""><font color="#4f7a28" class=""><br class=""></font></div><div class=""><font color="#4f7a28" class=""># Uncomment these if needed</font></div><div class=""><font color="#4f7a28" class="">## Use "Clean URLs".</font></div><div class=""><font color="#4f7a28" class="">$EnablePathInfo = 1;</font></div><div class=""><font color="#4f7a28" class="">$ScriptUrl = "<a href="http://localhost:8888/pmwiki/pmwiki.php" class="">http://localhost:8888/pmwiki/pmwiki.php</a>";</font></div><div class=""><font color="#4f7a28" class="">#$ScriptUrl = '<a href="http://example.com/pmwiki/pmwiki.php'" class="">http://example.com/pmwiki/pmwiki.php'</a>;</font></div><div class=""><font color="#4f7a28" class="">#$PubDirUrl = '<a href="http://example.com/pmwiki/pub'" class="">http://example.com/pmwiki/pub'</a>;</font></div><div class=""><font color="#4f7a28" class=""><br class=""></font></div><div class=""><font color="#4f7a28" class="">$DefaultPasswords['admin'] = pmcrypt('root');</font></div><div class=""><font color="#4f7a28" class=""><br class=""></font></div><div class=""><font color="#4f7a28" class="">$EnableUpload = 1;</font></div><div class=""><font color="#4f7a28" class="">$DefaultPasswords['upload'] = pmcrypt('root');</font></div><div class=""><font color="#4f7a28" class=""><br class=""></font></div><div class=""><font color="#4f7a28" class=""><br class=""></font></div><div class=""><font color="#4f7a28" class=""><br class=""></font></div><div class=""><font color="#4f7a28" class="">///////////////////////////////////////////</font></div><div class=""><font color="#4f7a28" class=""><br class=""></font></div><div class=""><font color="#4f7a28" class="">## Unicode (UTF-8) allows the display of all languages and all alphabets.</font></div><div class=""><font color="#4f7a28" class="">include_once("scripts/xlpage-utf-8.php");</font></div><div class=""><font color="#4f7a28" class="">//include_once("scripts/xlpage-iso-8859-2.php");</font></div><div class=""><font color="#4f7a28" class=""><br class=""></font></div><div class=""><font color="#4f7a28" class=""><br class=""></font></div><div class=""><font color="#4f7a28" class=""><br class=""></font></div><div class=""><font color="#4f7a28" class=""> ##---------------Francisation ------------------------------------</font></div><div class=""><font color="#4f7a28" class="">//XLPage('fr','PmWikiFr.XLPage'); // Les chaînes de PmWiki</font></div><div class=""><font color="#4f7a28" class="">//XLPage('fr','PmWikiFr.XLPageCookbook'); // Les chaînes de PmWiki</font></div><div class=""><font color="#4f7a28" class=""><br class=""></font></div><div class=""><font color="#4f7a28" class="">///////////////////////////////////////////</font></div><div class=""><font color="#4f7a28" class=""><br class=""></font></div><div class=""><font color="#4f7a28" class="">##---Création de sous-dossiers XML--##</font></div><div class=""><font color="#4f7a28" class="">$EnablePageStoreXML = 1;</font></div><div class=""><font color="#4f7a28" class="">include_once('cookbook/XMLPageStore.php');</font></div><div class=""><font color="#4f7a28" class=""><br class=""></font></div><div class=""><font color="#4f7a28" class="">//$WikiDir = new XMLPageStore('$FarmD/wiki.d/{$Group}/{$FullName}');</font></div><div class=""><font color="#4f7a28" class=""><br class=""></font></div><div class=""><font color="#4f7a28" class="">##---Sqlite---##</font></div><div class=""><font color="#4f7a28" class="">include_once("$FarmD/cookbook/sqlite.php");</font></div><div class=""><font color="#4f7a28" class="">$WikiDir = new PageStoreSQLite($WorkDir.'/pmwiki.sqlite.db', 1);</font></div><div class=""><font color="#4f7a28" class="">$WikiLibDirs = array(</font></div><div class=""><font color="#4f7a28" class=""> &$WikiDir,</font></div><div class=""><font color="#4f7a28" class=""> new PageStore('wiki.d/{$FullName}'),</font></div><div class=""><font color="#4f7a28" class=""> new XMLPageStore('$FarmD/wiki.d/{$Group}/{$FullName}'),</font></div><div class=""><font color="#4f7a28" class=""> new PageStore('$FarmD/wikilib.d/{$FullName}')</font></div><div class=""><font color="#4f7a28" class="">);</font></div><div class=""><font color="#4f7a28" class=""><br class=""></font></div><div class=""><font color="#4f7a28" class=""><br class=""></font></div><div class=""><font color="#4f7a28" class="">## formulaires ZAP et databases##</font></div><div class=""><font color="#4f7a28" class="">$Databases['$FarmD/wiki.d/pmwiki.sqlite.db'] = array(</font></div><div class=""><font color="#4f7a28" class=""> 'driver' => 'sqlite',</font></div><div class=""><font color="#4f7a28" class=""> 'hostname' => 'localhost',</font></div><div class=""><font color="#4f7a28" class=""> 'database' => '$FarmD/wiki.d/pmwiki.sqlite.db'</font></div><div class=""><font color="#4f7a28" class=""> 'username' => 'admin',</font></div><div class=""><font color="#4f7a28" class=""> 'password' => 'root');</font></div><div class=""><font color="#4f7a28" class=""><br class=""></font></div><div class=""><font color="#4f7a28" class="">$DQglobals['scriptfile'] = "$PubDirUrl/dFilter.js";</font></div><div class=""><font color="#4f7a28" class="">include "$FarmD/cookbook/dataquery.php";</font></div><div class=""><font color="#4f7a28" class="">include "$FarmD/cookbook/dataplates.php";</font></div><div class=""><font color="#4f7a28" class="">include "$FarmD/cookbook/zap.php";</font></div><div class=""><font color="#4f7a28" class="">include "$FarmD/cookbook/zaptoolbox.php »;</font></div><div class=""><br class=""></div><div class="">The site is not working (blank pages)</div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Note that I tried numerous combinations of the $Databases array :</div><div class=""><br class=""></div><div class=""><font color="#4f7a28" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>$Databases['$FarmD/wiki.d/pmwiki.sqlite.db’] or pmwiki, ou pmwikir.sqlite or pmwikir.sqlite.db</font></div><div class=""><font color="#4f7a28" class=""> <span class="Apple-tab-span" style="white-space: pre;"> </span>hostname : localhost, localhost:8888, localhost:8888/pmwiki, localhost:8888/pmwiki/pmwiki.php</font></div><div class=""><font color="#4f7a28" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>database : cf first line</font></div><div class=""><font color="#4f7a28" class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>username et password : with or without</font></div><div class=""><br class=""></div><div class="">Thanks for your help and sorry for the language mistakes, as English is not my mother tongue.</div><div class=""><br class=""></div><div class="">Sincerely yours</div><div class=""><br class=""></div><div class="">Patrice PELLE</div><div class=""><a href="mailto:patrice-pelle@bbox.fr" class="">patrice-pelle@bbox.fr</a></div></span></font></div></div></body></html>