This topic is locked

Search on dropdownbox

1/11/2009 2:30:48 PM
PHPRunner General questions
J
johnvdgaag author

I want to search in a dropwownbox not only on the first character, how is this possible ??

J
Jane 1/13/2009

Hi,
Unfortunately no.

As workaround I recommend you to have a look at the Edit box with Ajax popup option on the"Edit as" settings dialog on theVisual Editortab.

J
Johnvdg 1/13/2009

Hi,

Unfortunately no.

As workaround I recommend you to have a look at the Edit box with Ajax popup option on the"Edit as" settings dialog on theVisual Editortab.


Thanks Jane for your support.

M
mailas 2/18/2009

Hi,

Unfortunately no.

As workaround I recommend you to have a look at the Edit box with Ajax popup option on the"Edit as" settings dialog on theVisual Editortab.


Hi,

On Edit box with Ajax popup search is only on the first letter, but I need search not only on the first letter on Edit box with Ajax popup.

Thanks

J
Jane 2/19/2009

Hi,
to show all values based on any symbol open generated ..._lookupsuggest.php file, find this line:

$LookupSQL .= "`FieldName` LIKE '".db_addslashes($value)."%'";



and replace it with this one:

$LookupSQL .= "`FieldName` LIKE '%".db_addslashes($value)."%'";

M
mailas 2/19/2009

Thank you

This is good and don't need to use List page with search. I want to edit source files that this work after building project. I found:
$LookupSQL .= "##@f.strDisplayField s## LIKE '".db_addslashes($value)."%'";

$LookupSQL .= "##@f.strDisplayField ws## LIKE '".db_addslashes($value)."%'";

in two places and wil be testing.

Thanks