Re: [pmapper-users] Search on exact value
Sorry, forgot the debug info: Search with 23+ [24-May-2007 15:29:10] P.MAPPER debug info Searcharray in search.php->getSearchParameters() Array ( [PHPSESSID] => 9a541549cd6b6e508eaad68df45b2eb7 [MAPPALE] => 23 [mode] => search ) [24-May-2007 15:29:10] P.MAPPER debug info Parameters for searchArray file: query.php->q_execAttributeQuery Array ( [PHPSESSID] => 9a541549cd6b6e508eaad68df45b2eb7 [MAPPALE] => 23 [mode] => search ) [24-May-2007 15:29:10] P.MAPPER debug info Parameters for searchParams file: query.php->q_execAttributeQuery Array ( [layerName] => catastale [layerType] => shape [firstFld] => CODICI [qStr] => ( ( "[MAPPALE]" =~ /^(2|2)(3|3) $/) ) ) Search with 23 [24-May-2007 15:29:25] P.MAPPER debug info Searcharray in search.php->getSearchParameters() Array ( [PHPSESSID] => 9a541549cd6b6e508eaad68df45b2eb7 [MAPPALE] => 23 [mode] => search ) [24-May-2007 15:29:25] P.MAPPER debug info Parameters for searchArray file: query.php->q_execAttributeQuery Array ( [PHPSESSID] => 9a541549cd6b6e508eaad68df45b2eb7 [MAPPALE] => 23 [mode] => search ) [24-May-2007 15:29:25] P.MAPPER debug info Parameters for searchParams file: query.php->q_execAttributeQuery Array ( [layerName] => catastale [layerType] => shape [firstFld] => CODICI [qStr] => ( ( "[MAPPALE]" =~ /^(2|2)(3|3)$/) ) ) It seem that the + is seen as a space. Bye Luca On 5/24/07, Luca Casagrande <[EMAIL PROTECTED]> wrote: > > Hi Armin, > > I am still working on the search feature of my project. > I noticed this: > In a column i have some value with a + at the end (like 23+); also if i > set the search on the exact value > using 23 as input show both 23 and 23+.This is ok. > The matter is that if i use 23+ as search string, no result is show. > > P.S all fields are set as "s" string. > > Thank you very much! > > Luca > > > On 5/22/07, Luca Casagrande <[EMAIL PROTECTED]> wrote: > > > > Thank you Armin...it works like charm! > > > > i'll continue the testing and will report any bug. > > > > Have a nice day > > Luca > > > > Il giorno 22/mag/07, alle ore 00:00, Armin Burger ha scritto: > > > > > I uploaded a modified search.php: > > > http://svn.pmapper.net/trac/browser/pmapper/trunk/incphp/query/ > > > search.php > > > > > > it solved some problems with multiple fields. Try if it helps. > > > > > > armin > > > > > > Luca Casagrande wrote: > > >> I installed the p.mapper 3.1 beta-6 available and the result seem > > >> the same: > > >> [21-May-2007 17:42:52] P.MAPPER debug info > > >> Parameters for searchParams > > >> file: query.php->q_execAttributeQuery > > >> Array > > >> ( > > >> [layerName] => catastale > > >> [layerType] => shape > > >> [firstFld] => FOGLIO > > >> [qStr] => (( ( "[FOGLIO]" =~ > > >> /^(F|f)(8|8)(4|4)(4|4)(_|_)(0|0)(0|0)(0|0)(4|4)(0|0)(0|0)$/) )AND > > >> ( AND > > >> "[MAPPALE]" =~ /^(7|7)(8|8)$/) ) > > >> Should i try with svn? > > >> Thanks > > >> Luca > > > > > - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search on exact value
Hi Armin, I am still working on the search feature of my project. I noticed this: In a column i have some value with a + at the end (like 23+); also if i set the search on the exact value using 23 as input show both 23 and 23+.This is ok. The matter is that if i use 23+ as search string, no result is show. P.S all fields are set as "s" string. Thank you very much! Luca On 5/22/07, Luca Casagrande <[EMAIL PROTECTED]> wrote: > > Thank you Armin...it works like charm! > > i'll continue the testing and will report any bug. > > Have a nice day > Luca > > Il giorno 22/mag/07, alle ore 00:00, Armin Burger ha scritto: > > > I uploaded a modified search.php: > > http://svn.pmapper.net/trac/browser/pmapper/trunk/incphp/query/ > > search.php > > > > it solved some problems with multiple fields. Try if it helps. > > > > armin > > > > Luca Casagrande wrote: > >> I installed the p.mapper 3.1 beta-6 available and the result seem > >> the same: > >> [21-May-2007 17:42:52] P.MAPPER debug info > >> Parameters for searchParams > >> file: query.php->q_execAttributeQuery > >> Array > >> ( > >> [layerName] => catastale > >> [layerType] => shape > >> [firstFld] => FOGLIO > >> [qStr] => (( ( "[FOGLIO]" =~ > >> /^(F|f)(8|8)(4|4)(4|4)(_|_)(0|0)(0|0)(0|0)(4|4)(0|0)(0|0)$/) )AND > >> ( AND > >> "[MAPPALE]" =~ /^(7|7)(8|8)$/) ) > >> Should i try with svn? > >> Thanks > >> Luca > > - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search on exact value
Thank you Armin...it works like charm! i'll continue the testing and will report any bug. Have a nice day Luca Il giorno 22/mag/07, alle ore 00:00, Armin Burger ha scritto: > I uploaded a modified search.php: > http://svn.pmapper.net/trac/browser/pmapper/trunk/incphp/query/ > search.php > > it solved some problems with multiple fields. Try if it helps. > > armin > > Luca Casagrande wrote: >> I installed the p.mapper 3.1 beta-6 available and the result seem >> the same: >> [21-May-2007 17:42:52] P.MAPPER debug info >> Parameters for searchParams >> file: query.php->q_execAttributeQuery >> Array >> ( >> [layerName] => catastale >> [layerType] => shape >> [firstFld] => FOGLIO >> [qStr] => (( ( "[FOGLIO]" =~ >> /^(F|f)(8|8)(4|4)(4|4)(_|_)(0|0)(0|0)(0|0)(4|4)(0|0)(0|0)$/) )AND >> ( AND >> "[MAPPALE]" =~ /^(7|7)(8|8)$/) ) >> Should i try with svn? >> Thanks >> Luca - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search on exact value
I uploaded a modified search.php: http://svn.pmapper.net/trac/browser/pmapper/trunk/incphp/query/search.php it solved some problems with multiple fields. Try if it helps. armin Luca Casagrande wrote: > I installed the p.mapper 3.1 beta-6 available and the result seem the same: > > [21-May-2007 17:42:52] P.MAPPER debug info > Parameters for searchParams > file: query.php->q_execAttributeQuery > Array > ( > [layerName] => catastale > [layerType] => shape > [firstFld] => FOGLIO > [qStr] => (( ( "[FOGLIO]" =~ > /^(F|f)(8|8)(4|4)(4|4)(_|_)(0|0)(0|0)(0|0)(4|4)(0|0)(0|0)$/) )AND ( AND > "[MAPPALE]" =~ /^(7|7)(8|8)$/) ) > > Should i try with svn? > > Thanks > Luca - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] Search on exact value
I installed the p.mapper 3.1 beta-6 available and the result seem the same: [21-May-2007 17:42:52] P.MAPPER debug info Parameters for searchParams file: query.php->q_execAttributeQuery Array ( [layerName] => catastale [layerType] => shape [firstFld] => FOGLIO [qStr] => (( ( "[FOGLIO]" =~ /^(F|f)(8|8)(4|4)(4|4)(_|_)(0|0)(0|0)(0|0)(4|4)(0|0)(0|0)$/) )AND ( AND "[MAPPALE]" =~ /^(7|7)(8|8)$/) ) Should i try with svn? Thanks Luca On 5/21/07, Armin Burger <[EMAIL PROTECTED]> wrote: > > which version of p.mapper are you using? In the latest ones this error > should have been corrected, at least I thought so. You could try using the > latest beta and see if it works. > > armin > > > > > > This is the debug output just after sending the search: > > [21-May-2007 16:15:57] P.MAPPER debug info > > Searcharray in search.php->getSearchParameters() > > Array > > ( > > [FOGLIO] => f844_000100 > > [MAPPALE] => 10 > > [mode] => search > > ) > > > > [21-May-2007 16:15:57] P.MAPPER debug info > > Parameters for searchArray > > file: query.php->q_execAttributeQuery > > > > Array > > ( > > [FOGLIO] => f844_000100 > > [MAPPALE] => 10 > > [mode] => search > > ) > > > > [21-May-2007 16:15:57] P.MAPPER debug info > > Parameters for searchParams > > file: query.php->q_execAttributeQuery > > Array > > ( > > [layerName] => catastale > > [layerType] => shape > > [firstFld] => FOGLIO > > [qStr] => (( ( "[FOGLIO]" =~ > > /^(F|f)(8|8)(4|4)(4|4)(_|_)(0|0)(0|0)(0|0)(1|1)(0|0)(0|0)$/) )AND ( AND > > "[MAPPALE]" =~ /^(1|1)(0|0)$/) ) > > ) > > > > Can it be the second AND just befor "[MAPPALE]" ? > > > > Thanks > > Luca > > > > > > On 5/21/07, Armin Burger <[EMAIL PROTECTED]> wrote: > > > > > > For searches combined by 2 or more fields there were some bugs. I > might > > > not have removed them all. I'll have a look on it. > > > > > > You can also check the query parameters setting debug to 3 in the > > > config.ini and then look at the file pm_debug.log that is created in > > the > > > same dir as the PHP error log. > > > > > > armin > > > > > > -- > > > Subject: Re: [pmapper-users] Search on exact value > > > > > > > Thanks Armin for the answer! > > > > > > > > Now got a problem, but i don't know if is a bug: > > > > > > > > I have got 2 search field: X and Y; if I set a value for each one, i > > > > don't get any result. > > > > If i set just X or just Y all works very fine and as result i got > the > > > > values i used in the both-field search. > > > > > > > > Am I missing something? > > > > > > > > > > > > Thanks > > > > > > > > Luca > > > > > > > > > > > > Il giorno 21/mag/07, alle ore 10:40, Armin Burger ha scritto: > > > > > > > > > use the wildcard="1" and the search will look for exact matching > > > > > and only use wildcards when explicetly specified with an asterisk. > > > > > some info about search definitions is at > > > > > > > > > > http://svn.pmapper.net/trac/wiki/UpgradeInfo > > > > > > > > > > armin > > > > > > > > > > > > > > > Subject: [pmapper-users] Search on exact value > > > > > > > > > >> Hi to all, > > > > >> I am using latest beta and it's working very fine! > > > > >> > > > > >> In the search feature,Is it possible to return just the matching > > item > > > > >> and not all the ones that contain the string? > > > > >> For example If i use 1 as search item for a layer, i got also all > > > the > > > > >> items that contains 1 (10,11,12,ecc..). > > > > >> > > > > >> Thank you very much > > > > >> > > > > >> Luca > > > > >> > > > > > > > > > > > -- > > > Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! > > > Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer > > > > > -- > Pt! Schon vom neuen GMX MultiMessenger gehört? > Der kanns mit allen: http://www.gmx.net/de/go/multimessenger > - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search on exact value
which version of p.mapper are you using? In the latest ones this error should have been corrected, at least I thought so. You could try using the latest beta and see if it works. armin > This is the debug output just after sending the search: > [21-May-2007 16:15:57] P.MAPPER debug info > Searcharray in search.php->getSearchParameters() > Array > ( > [FOGLIO] => f844_000100 > [MAPPALE] => 10 > [mode] => search > ) > > [21-May-2007 16:15:57] P.MAPPER debug info > Parameters for searchArray > file: query.php->q_execAttributeQuery > > Array > ( > [FOGLIO] => f844_000100 > [MAPPALE] => 10 > [mode] => search > ) > > [21-May-2007 16:15:57] P.MAPPER debug info > Parameters for searchParams > file: query.php->q_execAttributeQuery > Array > ( > [layerName] => catastale > [layerType] => shape > [firstFld] => FOGLIO > [qStr] => (( ( "[FOGLIO]" =~ > /^(F|f)(8|8)(4|4)(4|4)(_|_)(0|0)(0|0)(0|0)(1|1)(0|0)(0|0)$/) )AND ( AND > "[MAPPALE]" =~ /^(1|1)(0|0)$/) ) > ) > > Can it be the second AND just befor "[MAPPALE]" ? > > Thanks > Luca > > > On 5/21/07, Armin Burger <[EMAIL PROTECTED]> wrote: > > > > For searches combined by 2 or more fields there were some bugs. I might > > not have removed them all. I'll have a look on it. > > > > You can also check the query parameters setting debug to 3 in the > > config.ini and then look at the file pm_debug.log that is created in > the > > same dir as the PHP error log. > > > > armin > > > > -- > > Subject: Re: [pmapper-users] Search on exact value > > > > > Thanks Armin for the answer! > > > > > > Now got a problem, but i don't know if is a bug: > > > > > > I have got 2 search field: X and Y; if I set a value for each one, i > > > don't get any result. > > > If i set just X or just Y all works very fine and as result i got the > > > values i used in the both-field search. > > > > > > Am I missing something? > > > > > > > > > Thanks > > > > > > Luca > > > > > > > > > Il giorno 21/mag/07, alle ore 10:40, Armin Burger ha scritto: > > > > > > > use the wildcard="1" and the search will look for exact matching > > > > and only use wildcards when explicetly specified with an asterisk. > > > > some info about search definitions is at > > > > > > > > http://svn.pmapper.net/trac/wiki/UpgradeInfo > > > > > > > > armin > > > > > > > > > > > > Subject: [pmapper-users] Search on exact value > > > > > > > >> Hi to all, > > > >> I am using latest beta and it's working very fine! > > > >> > > > >> In the search feature,Is it possible to return just the matching > item > > > >> and not all the ones that contain the string? > > > >> For example If i use 1 as search item for a layer, i got also all > the > > > >> items that contains 1 (10,11,12,ecc..). > > > >> > > > >> Thank you very much > > > >> > > > >> Luca > > > >> > > > > > > > > -- > > Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! > > Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer > > -- Pt! Schon vom neuen GMX MultiMessenger gehört? Der kanns mit allen: http://www.gmx.net/de/go/multimessenger - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search on exact value
This is the debug output just after sending the search: [21-May-2007 16:15:57] P.MAPPER debug info Searcharray in search.php->getSearchParameters() Array ( [FOGLIO] => f844_000100 [MAPPALE] => 10 [mode] => search ) [21-May-2007 16:15:57] P.MAPPER debug info Parameters for searchArray file: query.php->q_execAttributeQuery Array ( [FOGLIO] => f844_000100 [MAPPALE] => 10 [mode] => search ) [21-May-2007 16:15:57] P.MAPPER debug info Parameters for searchParams file: query.php->q_execAttributeQuery Array ( [layerName] => catastale [layerType] => shape [firstFld] => FOGLIO [qStr] => (( ( "[FOGLIO]" =~ /^(F|f)(8|8)(4|4)(4|4)(_|_)(0|0)(0|0)(0|0)(1|1)(0|0)(0|0)$/) )AND ( AND "[MAPPALE]" =~ /^(1|1)(0|0)$/) ) ) Can it be the second AND just befor "[MAPPALE]" ? Thanks Luca On 5/21/07, Armin Burger <[EMAIL PROTECTED]> wrote: > > For searches combined by 2 or more fields there were some bugs. I might > not have removed them all. I'll have a look on it. > > You can also check the query parameters setting debug to 3 in the > config.ini and then look at the file pm_debug.log that is created in the > same dir as the PHP error log. > > armin > > -- > Subject: Re: [pmapper-users] Search on exact value > > > Thanks Armin for the answer! > > > > Now got a problem, but i don't know if is a bug: > > > > I have got 2 search field: X and Y; if I set a value for each one, i > > don't get any result. > > If i set just X or just Y all works very fine and as result i got the > > values i used in the both-field search. > > > > Am I missing something? > > > > > > Thanks > > > > Luca > > > > > > Il giorno 21/mag/07, alle ore 10:40, Armin Burger ha scritto: > > > > > use the wildcard="1" and the search will look for exact matching > > > and only use wildcards when explicetly specified with an asterisk. > > > some info about search definitions is at > > > > > > http://svn.pmapper.net/trac/wiki/UpgradeInfo > > > > > > armin > > > > > > > > > Subject: [pmapper-users] Search on exact value > > > > > >> Hi to all, > > >> I am using latest beta and it's working very fine! > > >> > > >> In the search feature,Is it possible to return just the matching item > > >> and not all the ones that contain the string? > > >> For example If i use 1 as search item for a layer, i got also all the > > >> items that contains 1 (10,11,12,ecc..). > > >> > > >> Thank you very much > > >> > > >> Luca > > >> > > > > > -- > Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! > Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer > - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search on exact value
For searches combined by 2 or more fields there were some bugs. I might not have removed them all. I'll have a look on it. You can also check the query parameters setting debug to 3 in the config.ini and then look at the file pm_debug.log that is created in the same dir as the PHP error log. armin -- Subject: Re: [pmapper-users] Search on exact value > Thanks Armin for the answer! > > Now got a problem, but i don't know if is a bug: > > I have got 2 search field: X and Y; if I set a value for each one, i > don't get any result. > If i set just X or just Y all works very fine and as result i got the > values i used in the both-field search. > > Am I missing something? > > > Thanks > > Luca > > > Il giorno 21/mag/07, alle ore 10:40, Armin Burger ha scritto: > > > use the wildcard="1" and the search will look for exact matching > > and only use wildcards when explicetly specified with an asterisk. > > some info about search definitions is at > > > > http://svn.pmapper.net/trac/wiki/UpgradeInfo > > > > armin > > > > > > Subject: [pmapper-users] Search on exact value > > > >> Hi to all, > >> I am using latest beta and it's working very fine! > >> > >> In the search feature,Is it possible to return just the matching item > >> and not all the ones that contain the string? > >> For example If i use 1 as search item for a layer, i got also all the > >> items that contains 1 (10,11,12,ecc..). > >> > >> Thank you very much > >> > >> Luca > >> > > -- Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search on exact value
Thanks Armin for the answer! Now got a problem, but i don't know if is a bug: I have got 2 search field: X and Y; if I set a value for each one, i don't get any result. If i set just X or just Y all works very fine and as result i got the values i used in the both-field search. Am I missing something? Thanks Luca Il giorno 21/mag/07, alle ore 10:40, Armin Burger ha scritto: > use the wildcard="1" and the search will look for exact matching > and only use wildcards when explicetly specified with an asterisk. > some info about search definitions is at > > http://svn.pmapper.net/trac/wiki/UpgradeInfo > > armin > > ---- > Subject: [pmapper-users] Search on exact value > >> Hi to all, >> I am using latest beta and it's working very fine! >> >> In the search feature,Is it possible to return just the matching item >> and not all the ones that contain the string? >> For example If i use 1 as search item for a layer, i got also all the >> items that contains 1 (10,11,12,ecc..). >> >> Thank you very much >> >> Luca >> > - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search on exact value
use the wildcard="1" and the search will look for exact matching and only use wildcards when explicetly specified with an asterisk. some info about search definitions is at http://svn.pmapper.net/trac/wiki/UpgradeInfo armin Subject: [pmapper-users] Search on exact value > Hi to all, > I am using latest beta and it's working very fine! > > In the search feature,Is it possible to return just the matching item > and not all the ones that contain the string? > For example If i use 1 as search item for a layer, i got also all the > items that contains 1 (10,11,12,ecc..). > > Thank you very much > > Luca > -- Pt! Schon vom neuen GMX MultiMessenger gehört? Der kanns mit allen: http://www.gmx.net/de/go/multimessenger - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] Search on exact value
Hi to all, I am using latest beta and it's working very fine! In the search feature,Is it possible to return just the matching item and not all the ones that contain the string? For example If i use 1 as search item for a layer, i got also all the items that contains 1 (10,11,12,ecc..). Thank you very much Luca - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users