Paul,
You have to populate the values two times. The first value of the pair is the
data value for building the next query (bound value), the second value is the
display value which you should see in te box. Study carefully the samples.
The sql should be:
Select distinct canton, canton from etcetc
Now you have two fields. Eventually use 2 aliasses for the two fields if
necessary.
__________________________________________________
Met vriendelijke groet,
Andre van Atten
-----Original Message-----
From: Paul Alarcon <[EMAIL PROTECTED]>
To: Andre van Atten
Sent: Tue May 20 18:34:13 2008
Subject: RE: [pmapper-users] combo istead of text box search
thanks a lot Andre now i 'm using the combo box but i have anothr problem i
could show the text into the combo only appear white spaces buth the query
works, did you know where i coudl use the alias or where i put the value for
this combo because in the log appears the values extract form the database bui
don't appear the name for use in the combo box PLease give a hand and thank
again in the log i have the follow message:
[20-May-2008 11:16:35] P.MAPPER debug info Validation of search.xml file
succeeded
[20-May-2008 11:16:39] P.MAPPER debug info
XML->//definition
SimpleXMLElement Object
(
[EMAIL PROTECTED] => Array
(
[type] => options
[connectiontype] => db
[sort] => asc
)
[dsn] => pgsql:/user:[EMAIL PROTECTED]/db
[sql] => SELECT DISTINCT canton FROM planteles_mor where canton is NOT NULL
ORDER BY canton
[events] => onchange="resetSuggestCache();$('canton').val('')"
)
[20-May-2008 11:16:39] P.MAPPER debug info
search.php->getOptionsFromDb()
SELECT DISTINCT canton FROM planteles_mor where canton is NOT NULL ORDER BY
canton
[20-May-2008 11:16:39] P.MAPPER debug info search.php->getOptionsFromDb()->json
{ "GUALAQUIZA":"", "HUAMBOYA":"", "LIMON INDANZA":"", "LOGROÑO":"", "MERA":"",
"MORONA":"", "PALORA":"", "PAULO VI":"", "SAN JUAN BOSCO":"", "SANTIAGO":"",
"SUCUA":"", "TAISHA":"", "TIWINTZA":""}
[20-May-2008 11:17:35] P.MAPPER debug info Validation of search.xml file
succeeded
[20-May-2008 11:17:39] P.MAPPER debug info
XML->//definition
SimpleXMLElement Object
(
[EMAIL PROTECTED] => Array
(
[type] => options
[connectiontype] => db
[sort] => asc
)
[dsn] => pgsql://postgres:[EMAIL PROTECTED]/morona
[sql] => SELECT DISTINCT canton FROM planteles_mor where canton is NOT NULL
ORDER BY canton
[events] => onchange="resetSuggestCache();$('canton').val('')"
)
[20-May-2008 11:17:39] P.MAPPER debug info
search.php->getOptionsFromDb()
SELECT DISTINCT canton FROM planteles_mor where canton is NOT NULL ORDER BY
canton
[20-May-2008 11:17:39] P.MAPPER debug info search.php->getOptionsFromDb()->json
{ "GUALAQUIZA":"", "HUAMBOYA":"", "LIMON INDANZA":"", "LOGROÑO":"", "MERA":"",
"MORONA":"", "PALORA":"", "PAULO VI":"", "SAN JUAN BOSCO":"", "SANTIAGO":"",
"SUCUA":"", "TAISHA":"", "TIWINTZA":""}
[20-May-2008 11:20:12] P.MAPPER debug info Validation of search.xml file
succeeded
___________________________________________________________________________________________________________________________
Paul,
See http://svn.pmapper.net/trac/wiki/DocManualsearch
Andre
-----Oorspronkelijk bericht-----
Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Paul Alarcon
Verzonden: maandag 19 mei 2008 20:23
Aan: [email protected]
Onderwerp: [pmapper-users] combo istead of text box search
I want to know how i could change the text box from the search into a combo
with a preload data, just for choose, coudl someone tell me what's the file i
have to change please Thanks a lot
_________________________________________________________________
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R)
Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
_________________________________________________________________
Connect to the next generation of MSN Messenger
http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
