[pmapper-users] Search in 2 columns using only one field
Hello, I have one SHPfile with 3 columns [ street name / first number / last number ] but i don't know how search in 2 columns using only one field. MAPFILE: LAYER NAME "Street1" GROUP GEOSTREET1 TYPE LINE STATUS OFF DATA "streetnum_line.shp" TOLERANCEUNITS meters TOLERANCE 15 CLASS NAME " " TEMPLATE void END METADATA "DESCRIPTION" "Street" "RESULT_FIELDS" "STREET,NUMBER1,NUMBER2" "RESULT_HEADERS" "Street Name, First Number, Last Number" "LAYER_ENCODING" "ISO-8859-1" "ows_title" "Street" END END I need search this Address: STREET NAME => ONE STREET NUMBER => 110 SQL Expression: SELECT * FROM streetnum_line WHERE STREET = "ONE STREET" and NUMBER1<= 110 and NUMBER2 => 110 SEARCH XML: (not working) Can anybody help me? -- ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search one layer
Hello,
Thanks. I have tried to insert this modification.
I see my layer defined, but without white box on the right to put the
search attribute.
Where is the the problem?
best
Bogumił
W dniu 2014-07-22 23:11, Armin Burger pisze:
not a very elegant solution, but should work:
add the following block at the end of your
/config/[your-config]/custom.js
file
$.extend(PM.Query,
{
createSearchItems: function(url) {
$.ajax({
url: url,
dataType: json,
success: function(response){
var searchJson = response.searchJson;
var action = response.action;
//---
delete searchJson.options[0];
//---
if (action == 'searchitem') {
PM.Query.createSearchInput(searchJson);
} else {
var searchHtml = PM.Query.json2Select(searchJson, 0);
$('#searchoptions').html(searchHtml);
}
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
if (window.console) console.log(errorThrown);
}
});
}
});
or use
//---
if (Object.keys(searchJson.options).length 3) {
delete searchJson.options[0];
}
//---
to do this just in case the search has just 1 layer defined for search,
in case you once will add another one you don't remember what you once
modified...
On 07/22/2014 07:25 PM, Bogumił Szady wrote:
Hello,
Is it possible to get one default search field turned on in the moment
of starting of application window?
I have only one layer to search and I would like to avoid every time
selecting layer to search.
all the best
Bogumił
--
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
--
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
--
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search one layer
Ok, the change event is not applied if no change happens... Try the
following for the custom.js which should also improve the labels and
logic in this case:
$.extend(PM.Query,
{
createSearchItems: function(url) {
$.ajax({
url: url,
dataType: json,
success: function(response){
var searchJson = response.searchJson;
var action = response.action;
if (action == 'searchitem') {
PM.Query.createSearchInput(searchJson);
} else {
delete searchJson.options[0];
var searchHtml = PM.Query.json2Select(searchJson, 0);
$('#searchoptions').html(searchHtml);
PM.Query.setSearchInput();
$('#searchoptions').html(_p(Search
for)).css({white-space: nowrap});
}
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
if (window.console) console.log(errorThrown);
}
});
}
});
On 07/23/2014 08:58 AM, Bogumił Szady wrote:
Hello,
Thanks. I have tried to insert this modification.
I see my layer defined, but without white box on the right to put the
search attribute.
Where is the the problem?
best
Bogumił
W dniu 2014-07-22 23:11, Armin Burger pisze:
not a very elegant solution, but should work:
add the following block at the end of your
/config/[your-config]/custom.js
file
$.extend(PM.Query,
{
createSearchItems: function(url) {
$.ajax({
url: url,
dataType: json,
success: function(response){
var searchJson = response.searchJson;
var action = response.action;
//---
delete searchJson.options[0];
//---
if (action == 'searchitem') {
PM.Query.createSearchInput(searchJson);
} else {
var searchHtml = PM.Query.json2Select(searchJson,
0);
$('#searchoptions').html(searchHtml);
}
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
if (window.console) console.log(errorThrown);
}
});
}
});
or use
//---
if (Object.keys(searchJson.options).length 3) {
delete searchJson.options[0];
}
//---
to do this just in case the search has just 1 layer defined for search,
in case you once will add another one you don't remember what you once
modified...
On 07/22/2014 07:25 PM, Bogumił Szady wrote:
Hello,
Is it possible to get one default search field turned on in the moment
of starting of application window?
I have only one layer to search and I would like to avoid every time
selecting layer to search.
all the best
Bogumił
--
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
--
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
--
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
--
Want fast and easy access to all the code in your enterprise? Index and
search up
Re: [pmapper-users] search one layer
I have tried and it doesn't work.
Like before I have normal search for label and then I have to select
my one layer to search.
:(
Bogumił
W dniu 2014-07-23 20:38, Armin Burger pisze:
Ok, the change event is not applied if no change happens... Try the
following for the custom.js which should also improve the labels and
logic in this case:
$.extend(PM.Query,
{
createSearchItems: function(url) {
$.ajax({
url: url,
dataType: json,
success: function(response){
var searchJson = response.searchJson;
var action = response.action;
if (action == 'searchitem') {
PM.Query.createSearchInput(searchJson);
} else {
delete searchJson.options[0];
var searchHtml = PM.Query.json2Select(searchJson, 0);
$('#searchoptions').html(searchHtml);
PM.Query.setSearchInput();
$('#searchoptions').html(_p(Search
for)).css({white-space: nowrap});
}
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
if (window.console) console.log(errorThrown);
}
});
}
});
On 07/23/2014 08:58 AM, Bogumił Szady wrote:
Hello,
Thanks. I have tried to insert this modification.
I see my layer defined, but without white box on the right to put the
search attribute.
Where is the the problem?
best
Bogumił
W dniu 2014-07-22 23:11, Armin Burger pisze:
not a very elegant solution, but should work:
add the following block at the end of your
/config/[your-config]/custom.js
file
$.extend(PM.Query,
{
createSearchItems: function(url) {
$.ajax({
url: url,
dataType: json,
success: function(response){
var searchJson = response.searchJson;
var action = response.action;
//---
delete searchJson.options[0];
//---
if (action == 'searchitem') {
PM.Query.createSearchInput(searchJson);
} else {
var searchHtml = PM.Query.json2Select(searchJson,
0);
$('#searchoptions').html(searchHtml);
}
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
if (window.console) console.log(errorThrown);
}
});
}
});
or use
//---
if (Object.keys(searchJson.options).length 3) {
delete searchJson.options[0];
}
//---
to do this just in case the search has just 1 layer defined for search,
in case you once will add another one you don't remember what you once
modified...
On 07/22/2014 07:25 PM, Bogumił Szady wrote:
Hello,
Is it possible to get one default search field turned on in the moment
of starting of application window?
I have only one layer to search and I would like to avoid every time
selecting layer to search.
all the best
Bogumił
--
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
--
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
--
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
___
pmapper-users mailing
Re: [pmapper-users] search one layer
I suppose some error in brackets (syntax error).
I am trying to find...
Bogumil
W dniu 2014-07-23 20:38, Armin Burger pisze:
Ok, the change event is not applied if no change happens... Try the
following for the custom.js which should also improve the labels and
logic in this case:
$.extend(PM.Query,
{
createSearchItems: function(url) {
$.ajax({
url: url,
dataType: json,
success: function(response){
var searchJson = response.searchJson;
var action = response.action;
if (action == 'searchitem') {
PM.Query.createSearchInput(searchJson);
} else {
delete searchJson.options[0];
var searchHtml = PM.Query.json2Select(searchJson, 0);
$('#searchoptions').html(searchHtml);
PM.Query.setSearchInput();
$('#searchoptions').html(_p(Search
for)).css({white-space: nowrap});
}
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
if (window.console) console.log(errorThrown);
}
});
}
});
On 07/23/2014 08:58 AM, Bogumił Szady wrote:
Hello,
Thanks. I have tried to insert this modification.
I see my layer defined, but without white box on the right to put the
search attribute.
Where is the the problem?
best
Bogumił
W dniu 2014-07-22 23:11, Armin Burger pisze:
not a very elegant solution, but should work:
add the following block at the end of your
/config/[your-config]/custom.js
file
$.extend(PM.Query,
{
createSearchItems: function(url) {
$.ajax({
url: url,
dataType: json,
success: function(response){
var searchJson = response.searchJson;
var action = response.action;
//---
delete searchJson.options[0];
//---
if (action == 'searchitem') {
PM.Query.createSearchInput(searchJson);
} else {
var searchHtml = PM.Query.json2Select(searchJson,
0);
$('#searchoptions').html(searchHtml);
}
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
if (window.console) console.log(errorThrown);
}
});
}
});
or use
//---
if (Object.keys(searchJson.options).length 3) {
delete searchJson.options[0];
}
//---
to do this just in case the search has just 1 layer defined for search,
in case you once will add another one you don't remember what you once
modified...
On 07/22/2014 07:25 PM, Bogumił Szady wrote:
Hello,
Is it possible to get one default search field turned on in the moment
of starting of application window?
I have only one layer to search and I would like to avoid every time
selecting layer to search.
all the best
Bogumił
--
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
--
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
--
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
Re: [pmapper-users] search one layer
It works
Thanks a lot!
Bogumił
W dniu 2014-07-23 20:38, Armin Burger pisze:
$.extend(PM.Query,
{
createSearchItems: function(url) {
$.ajax({
url: url,
dataType: json,
success: function(response){
var searchJson = response.searchJson;
var action = response.action;
if (action == 'searchitem') {
PM.Query.createSearchInput(searchJson);
} else {
delete searchJson.options[0];
var searchHtml = PM.Query.json2Select(searchJson, 0);
$('#searchoptions').html(searchHtml);
PM.Query.setSearchInput();
$('#searchoptions').html(_p(Search
for)).css({white-space: nowrap});
}
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
if (window.console) console.log(errorThrown);
}
});
}
});
--
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] search one layer
Hello, Is it possible to get one default search field turned on in the moment of starting of application window? I have only one layer to search and I would like to avoid every time selecting layer to search. all the best Bogumił -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search one layer
not a very elegant solution, but should work:
add the following block at the end of your
/config/[your-config]/custom.js
file
$.extend(PM.Query,
{
createSearchItems: function(url) {
$.ajax({
url: url,
dataType: json,
success: function(response){
var searchJson = response.searchJson;
var action = response.action;
//---
delete searchJson.options[0];
//---
if (action == 'searchitem') {
PM.Query.createSearchInput(searchJson);
} else {
var searchHtml = PM.Query.json2Select(searchJson, 0);
$('#searchoptions').html(searchHtml);
}
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
if (window.console) console.log(errorThrown);
}
});
}
});
or use
//---
if (Object.keys(searchJson.options).length 3) {
delete searchJson.options[0];
}
//---
to do this just in case the search has just 1 layer defined for search,
in case you once will add another one you don't remember what you once
modified...
On 07/22/2014 07:25 PM, Bogumił Szady wrote:
Hello,
Is it possible to get one default search field turned on in the moment
of starting of application window?
I have only one layer to search and I would like to avoid every time
selecting layer to search.
all the best
Bogumił
--
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
--
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search several database columns at the same time with the same search field
Hi I tried in several ways, but without success, because I had to get the content of col1 and col2. Then I remembered to do it the right way and normalized the database. So now it is working with a FULL OUTER JOIN. Thanks for your support! Best regards, Pedro -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search several database columns at the same time with the same search field
I think you should do this SELECT DISTINCT id FROM table WHERE col_1 ilike '^[search]' OR col_2 ilike '^[search]' ORDER BY col_1 to obtain your expected result. and this will only show the id in suggest list. i think this will help you. Enjoy suman -- View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-Search-several-database-columns-at-the-same-time-with-the-same-search-field-tp4025500p4025531.html Sent from the pmapper-users -- p.mapper users mailing list mailing list archive at Nabble.com. -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck#174; Code Sight#153; - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search several database columns at the same time with the same search field
Hi, Do you think this is possible just configuring the search in the config_xxx.xml? I've tried several ways, but without success. Thanks. Best regards, Pedro - Mensagem original - DE: Pedro Hi, I'm trying to create a search of type suggest, that search multiple columns of a PostGIS layer, at the same time. For example, col1 | col2 a | b c | d e | f ... I tried this: searchitem name=n_casas description=Casas layer type=postgis name=tipo field type=s name=col1 alias=nomes description=Nome wildcard=0 operator=OR definition type=suggest connectiontype=db minlength=0 sort=asc dsn encoding=UTF-8pgsql://xxx:xxx@localhost/cartografia/dsn sqlSELECT DISTINCT col1 FROM xxx.casas WHERE col1 ~* '[search]' ORDER BY col1/sql /definition /field field type=s name=col2 alias=nomes operator=OR definition type=suggest connectiontype=db minlength=0 sort=asc dsn encoding=UTF-8pgsql://xxx:xxx@localhost/cartografia/dsn sqlSELECT DISTINCT col2 FROM xxx.casas WHERE col2 ~* '[search]' ORDER BY col2/sql /definition /field /layer /searchitem This way I can search and get the correct result. However, two fields are displayed to do the search (image attached), and I want to just get one field, where it does the search for the values of the two columns (col1 and col2). Any suggestions? Thank you very much! Best regards, Pedro -- ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] Search several database columns at the same time with the same search field
Hi, I'm trying to create a search of type suggest, that search multiple columns of a PostGIS layer, at the same time. For example, col1 | col2 a | b c | d e | f ... I tried this: searchitem name=n_casas description=Casas layer type=postgis name=tipo field type=s name=col1 alias=nomes description=Nome wildcard=0 operator=OR definition type=suggest connectiontype=db minlength=0 sort=asc dsn encoding=UTF-8pgsql://xxx:xxx@localhost/cartografia/dsn sqlSELECT DISTINCT col1 FROM xxx.casas WHERE col1 ~* '[search]' ORDER BY col1/sql /definition /field field type=s name=col2 alias=nomes operator=OR definition type=suggest connectiontype=db minlength=0 sort=asc dsn encoding=UTF-8pgsql://xxx:xxx@localhost/cartografia/dsn sqlSELECT DISTINCT col2 FROM xxx.casas WHERE col2 ~* '[search]' ORDER BY col2/sql /definition /field /layer /searchitem This way I can search and get the correct result. However, two fields are displayed to do the search (image attached), and I want to just get one field, where it does the search for the values of the two columns (col1 and col2). Any suggestions? Thank you very much! Best regards, Pedro -- Open source business process management suite built on Java and Eclipse Turn processes into business applications with Bonita BPM Community Edition Quickly connect people, data, and systems into organized workflows Winner of BOSSIE, CODIE, OW2 and Gartner awards http://p.sf.net/sfu/Bonitasoft ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search several database columns at the same time with the same search field
Sorry, I forgot to attach the image. Here it is. Best regards, Pedro - Mensagem original - DE: Pedro Assunto: Search several database columns at the same time with the same search field Hi, I'm trying to create a search of type suggest, that search multiple columns of a PostGIS layer, at the same time. For example, col1 | col2 a | b c | d e | f ... I tried this: searchitem name=n_casas description=Casas layer type=postgis name=tipo field type=s name=col1 alias=nomes description=Nome wildcard=0 operator=OR definition type=suggest connectiontype=db minlength=0 sort=asc dsn encoding=UTF-8pgsql://xxx:xxx@localhost/cartografia/dsn sqlSELECT DISTINCT col1 FROM xxx.casas WHERE col1 ~* '[search]' ORDER BY col1/sql /definition /field field type=s name=col2 alias=nomes operator=OR definition type=suggest connectiontype=db minlength=0 sort=asc dsn encoding=UTF-8pgsql://xxx:xxx@localhost/cartografia/dsn sqlSELECT DISTINCT col2 FROM xxx.casas WHERE col2 ~* '[search]' ORDER BY col2/sql /definition /field /layer /searchitem This way I can search and get the correct result. However, two fields are displayed to do the search (image attached), and I want to just get one field, where it does the search for the values of the two columns (col1 and col2). Any suggestions? Thank you very much! Best regards, Pedro -- Open source business process management suite built on Java and Eclipse Turn processes into business applications with Bonita BPM Community Edition Quickly connect people, data, and systems into organized workflows Winner of BOSSIE, CODIE, OW2 and Gartner awards http://p.sf.net/sfu/Bonitasoft___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] search with numeric field of postgis table and wildcard 1 not functions
dear pmapper users i have a table with field raumnr (numeric 3,2 unique) and field gid (integer as primary key). in the mapfile i have all the field names. my searchfile: searchitem name=1 description=1 Untergeschoss layer type=postgis name=e44_ug field type=n name=raumnr description=raumnr wildcard=1 / /layer /searchitem if i use for the search the sign * to show all datas, this search does not function ! if i take a string field, the search functions with wildcard 1 and *, the result table shows all fields: searchitem name=1 description=1 Untergeschoss layer type=postgis name=e44_ug field type=s name=bezeichn description=bezeichn wildcard=1 / /layer /searchitem i cannot understand this behavior thank you for any help matthias moser -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349351iu=/4140/ostg.clktrk ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search with numeric field of postgis table and wildcard 1 not functions
Hallo Matthias, Have a look at the pm_debug.log You should find there what request is sent to PGSQL. Regards, Chris On Thu, Nov 28, 2013 at 11:59 AM, i...@architekten.coop wrote: dear pmapper users i have a table with field raumnr (numeric 3,2 unique) and field gid (integer as primary key). in the mapfile i have all the field names. my searchfile: searchitem name=1 description=1 Untergeschoss layer type=postgis name=e44_ug field type=n name=raumnr description=raumnr wildcard=1 / /layer /searchitem if i use for the search the sign * to show all datas, this search does not function ! if i take a string field, the search functions with wildcard 1 and *, the result table shows all fields: searchitem name=1 description=1 Untergeschoss layer type=postgis name=e44_ug field type=s name=bezeichn description=bezeichn wildcard=1 / /layer /searchitem i cannot understand this behavior thank you for any help matthias moser -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349351iu=/4140/ostg.clktrk ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349351iu=/4140/ostg.clktrk ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search with numeric field of postgis table and wildcard 1 not functions
thank you chris, i missed to mention the error log in my question, here the only message i got: error_pmapper.log: [28-Nov-2013 11:36:39] P.MAPPER: PG Query error for : SELECT gid, xmin(box3d(the_geom)), ymin(box3d(the_geom)), xmax(box3d(the_geom)), ymax(box3d(the_geom)), raumnr,bezeichn,nutzung,kategorie,trakt,geschoss,flaeche FROM schema02.e44_raeume WHERE raumnr ILIKE '%' AND geschoss = -1 LIMIT 301 in pm_debug.log [28-Nov-2013 10:36:59] P.MAPPER debug info Parameters for searchParams file: query.php-q_execAttributeQuery Array ( [layerName] = raeume [layerType] = postgis [firstFld] = raumnr [qStr] = raumnr = * ) [28-Nov-2013 10:36:59] P.MAPPER debug info P.MAPPER-DEBUG: squery.php/dumpPGQueryResults() - SQL Cmd: SELECT gid, xmin(box3d(the_geom)), ymin(box3d(the_geom)), xmax(box3d(the_geom)), ymax(box3d(the_geom)), raumnr,bezeichn,nutzung,kategorie,trakt,geschoss,flaeche FROM schema02.e44_raeume WHERE raumnr = * LIMIT 301 regards, matthias moser Am 28.11.2013 16:15, schrieb Chris forum: Hallo Matthias, Have a look at the pm_debug.log You should find there what request is sent to PGSQL. Regards, Chris On Thu, Nov 28, 2013 at 11:59 AM, i...@architekten.coop mailto:i...@architekten.coop wrote: dear pmapper users i have a table with field raumnr (numeric 3,2 unique) and field gid (integer as primary key). in the mapfile i have all the field names. my searchfile: searchitem name=1 description=1 Untergeschoss layer type=postgis name=e44_ug field type=n name=raumnr description=raumnr wildcard=1 / /layer /searchitem if i use for the search the sign * to show all datas, this search does not function ! if i take a string field, the search functions with wildcard 1 and *, the result table shows all fields: searchitem name=1 description=1 Untergeschoss layer type=postgis name=e44_ug field type=s name=bezeichn description=bezeichn wildcard=1 / /layer /searchitem i cannot understand this behavior thank you for any help matthias moser -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349351iu=/4140/ostg.clktrk ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net mailto:pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349351iu=/4140/ostg.clktrk ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search with numeric field of postgis table and wildcard 1 not functions
Wildcard searches as you can see in the debug logs are using ILIKE function, this however will not work on numeric fields. Just insert the query in a standard DB client and you will get errors. On 11/28/2013 04:36 PM, i...@architekten.coop wrote: thank you chris, i missed to mention the error log in my question, here the only message i got: error_pmapper.log: [28-Nov-2013 11:36:39] P.MAPPER: PG Query error for : SELECT gid, xmin(box3d(the_geom)), ymin(box3d(the_geom)), xmax(box3d(the_geom)), ymax(box3d(the_geom)), raumnr,bezeichn,nutzung,kategorie,trakt,geschoss,flaeche FROM schema02.e44_raeume WHERE raumnr ILIKE '%' AND geschoss = -1 LIMIT 301 in pm_debug.log [28-Nov-2013 10:36:59] P.MAPPER debug info Parameters for searchParams file: query.php-q_execAttributeQuery Array ( [layerName] = raeume [layerType] = postgis [firstFld] = raumnr [qStr] = raumnr = * ) [28-Nov-2013 10:36:59] P.MAPPER debug info P.MAPPER-DEBUG: squery.php/dumpPGQueryResults() - SQL Cmd: SELECT gid, xmin(box3d(the_geom)), ymin(box3d(the_geom)), xmax(box3d(the_geom)), ymax(box3d(the_geom)), raumnr,bezeichn,nutzung,kategorie,trakt,geschoss,flaeche FROM schema02.e44_raeume WHERE raumnr = * LIMIT 301 regards, matthias moser Am 28.11.2013 16:15, schrieb Chris forum: Hallo Matthias, Have a look at the pm_debug.log You should find there what request is sent to PGSQL. Regards, Chris On Thu, Nov 28, 2013 at 11:59 AM, i...@architekten.coop mailto:i...@architekten.coop wrote: dear pmapper users i have a table with field raumnr (numeric 3,2 unique) and field gid (integer as primary key). in the mapfile i have all the field names. my searchfile: searchitem name=1 description=1 Untergeschoss layer type=postgis name=e44_ug field type=n name=raumnr description=raumnr wildcard=1 / /layer /searchitem if i use for the search the sign * to show all datas, this search does not function ! if i take a string field, the search functions with wildcard 1 and *, the result table shows all fields: searchitem name=1 description=1 Untergeschoss layer type=postgis name=e44_ug field type=s name=bezeichn description=bezeichn wildcard=1 / /layer /searchitem i cannot understand this behavior thank you for any help matthias moser -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349351iu=/4140/ostg.clktrk ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net mailto:pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349351iu=/4140/ostg.clktrk ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349351iu=/4140/ostg.clktrk ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search for....... Warning: pg_numrows() expects parameter 1
Hi, With postgis 2, you need a recent pmapper. What version are you using please? Thomas Le 08/10/2012 20:18, miguel miguelito a écrit : Hello Friends'm on the verge of madness happens that the search for ... fails, use win7, ms4w_3.0.6, postgis 2 data tables are drawn on the pmapper, pear install MDB2. HolaAmigos estoy al borde de la locura sucede que el buscar por... no da resultado, uso win7, ms4w_3.0.6, postgis 2, los datos de tablas se dibujan en el pmapper, instale el pear MDB2. config_default.xml-searchlist version=1.0 dataroot$/datarootsearchitem name=sectores description=sectoreslayer type=postgis name=sectores field type=n name=cod_sector alias=momo description=Sector wildcard=0 /field /layer/searchitem searchitem name=vias1 description=VIAalayer type=postgis name=vias1field type=s name=descrip description=via wildcard=0definition type=suggest connectiontype=db sort=ascdsn encoding=UTF-8pgsql://postgres:123456@localhost/catas/dsn sqlSELECT DISTINCT descrip FROM vias1 WHERE descrip ='[search]'/sql /definition/field/layer /searchitem /searchlist map file---LAYERNAME 'vias1'TYPE LINEDUMP true TEMPLATE fooOnlyForWMSGetFeatureInfo EXTENT 383230.235738 8242604.834650 400453.717167 8252242.309691CONNECTIONTYPE postgisCONNECTION dbname='catas' host=localhost port=5432 user='postgres' password='123456' sslmode=disableDATA 'geom FROM vias1 USING UNIQUE gid USING srid=4326' METADATA LAYER_ENCODING UTF-8 DESCRIPTION vias1 RESULT_FIELDS descrip RESULT_HEADERS Descripcion ows_title vias1END#STATUS DEFAULT#METADATA# 'ows_title' 'vias1'#ENDSTATUS OFFTRANSPARENCY 100PROJECTION 'proj=longlat''datum=WGS84''no_defs'ENDCLASS NAME 'vias1'STYLE WIDTH 0.91 COLOR 229 149 93 END END END LOG ERROR DE APACHE--[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] Incorrect setting for 'error_log' in 'php.ini'. Set to a valid file name., referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] PHP Warning: pg_query(): in C:\\ms4w\\apps\\pmapper\\pmapper-4.2.0\\incphp\\query\\squery.php on line 712, referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] P.MAPPER: PG Query error for : SELECT gid, , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] xmin(box3d(geom)), , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] ymin(box3d(geom)), , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] xmax(box3d(geom)), , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] ymax(box3d(geom)), , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] descrip , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] FROM vias1 , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1]WHERE descrip ILIKE '%JR.APACHETA%' , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1]LIMIT 301, referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] PHP Warning: pg_numrows() expects parameter 1 to be resource, boolean given in C:\\ms4w\\apps\\pmapper\\pmapper-4.2.0\\incphp\\query\\squery.php on line 716, referer: http://localhost/pmapper/map_default.phtml Saludos Miguel Cisneros -- Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app performance management and know exactly what is happening inside your Ruby, Python, PHP, Java, and .NET app Try New Relic at no cost today and get our sweet Data Nerd shirt too! http://p.sf.net/sfu/newrelic-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users -- Don't let slow site performance ruin your
Re: [pmapper-users] search for....... Warning: pg_numrows() expects parameter 1
Not sure to understand... You should chose between: - pmapper 4.2 and postgis = 1.5 - pmapper dev (try this: http://www.pmapper.net/dl/pmapper-dev.zip) and postgis = 2. But careful, this is not a DEVELOPMENT version! - search en replace every xmin by ST_xmin, etc like here: http://svn.pmapper.net/trac/changeset/1272 in you pmapper install and use postgis = 2 Le 09/10/2012 09:08, miguel miguelito a écrit : Hi Thomas Thanks for your reply. Use pmapper-4.2.0-MS4W. it recommends you, maybe need to change operating system, postgis. --- El *mar, 9/10/12, Thomas RAFFIN /traf...@sirap.fr/* escribió: De: Thomas RAFFIN traf...@sirap.fr Asunto: Re: [pmapper-users] search for... Warning: pg_numrows() expects parameter 1 Para: pmapper-users@lists.sourceforge.net Fecha: martes, 9 de octubre, 2012 01:30 Hi, With postgis 2, you need a recent pmapper. What version are you using please? Thomas Le 08/10/2012 20:18, miguel miguelito a écrit : Hello Friends'm on the verge of madness happens that the search for ... fails, use win7, ms4w_3.0.6, postgis 2 data tables are drawn on the pmapper, pear install MDB2. HolaAmigos estoy al borde de la locura sucede que el buscar por... no da resultado, uso win7, ms4w_3.0.6, postgis 2, los datos de tablas se dibujan en el pmapper, instale el pear MDB2. config_default.xml-searchlist version=1.0 dataroot$/dataroot searchitem name=sectores description=sectoreslayer type=postgis name=sectores field type=n name=cod_sector alias=momo description=Sector wildcard=0 /field/layer /searchitem searchitem name=vias1 description=VIAa layer type=postgis name=vias1field type=s name=descrip description=via wildcard=0 definition type=suggest connectiontype=db sort=asc dsn encoding=UTF-8pgsql://postgres:123456@localhost/catas/dsn sqlSELECT DISTINCT descrip FROM vias1 WHERE descrip ='[search]'/sql /definition /field /layer /searchitem /searchlist map file---LAYERNAME 'vias1'TYPE LINEDUMP trueTEMPLATE fooOnlyForWMSGetFeatureInfo EXTENT 383230.235738 8242604.834650 400453.717167 8252242.309691 CONNECTIONTYPE postgisCONNECTION dbname='catas' host=localhost port=5432 user='postgres' password='123456' sslmode=disableDATA 'geom FROM vias1 USING UNIQUE gid USING srid=4326'METADATA LAYER_ENCODING UTF-8 DESCRIPTION vias1 RESULT_FIELDS descrip RESULT_HEADERS Descripcion ows_title vias1END#STATUS DEFAULT#METADATA# 'ows_title' 'vias1'#ENDSTATUS OFF TRANSPARENCY 100 PROJECTION'proj=longlat' 'datum=WGS84''no_defs'END CLASS NAME 'vias1'STYLE WIDTH 0.91 COLOR 229 149 93 ENDEND END LOG ERROR DE APACHE--[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] Incorrect setting for 'error_log' in 'php.ini'. Set to a valid file name., referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] PHP Warning: pg_query(): in C:\\ms4w\\apps\\pmapper\\pmapper-4.2.0\\incphp\\query\\squery.php on line 712, referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] P.MAPPER: PG Query error for : SELECT gid, , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] xmin(box3d(geom)), , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] ymin(box3d(geom)), , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] xmax(box3d(geom)), , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] ymax(box3d(geom)), , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] descrip , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1]FROM vias1 , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] WHERE descrip ILIKE '%JR.APACHETA%' , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] LIMIT 301, referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] PHP
[pmapper-users] search for....... Warning: pg_numrows() expects parameter 1
Hello Friends'm on the verge of madness happens that the search for ... fails, use win7, ms4w_3.0.6, postgis 2 data tables are drawn on the pmapper, pear install MDB2. HolaAmigos estoy al borde de la locura sucede que el buscar por... no da resultado, uso win7, ms4w_3.0.6, postgis 2, los datos de tablas se dibujan en el pmapper, instale el pear MDB2. config_default.xml-searchlist version=1.0 dataroot$/dataroot searchitem name=sectores description=sectores layer type=postgis name=sectores field type=n name=cod_sector alias=momo description=Sector wildcard=0 /field /layer /searchitem searchitem name=vias1 description=VIAa layer type=postgis name=vias1 field type=s name=descrip description=via wildcard=0 definition type=suggest connectiontype=db sort=asc dsn encoding=UTF-8pgsql://postgres:123456@localhost/catas/dsn sqlSELECT DISTINCT descrip FROM vias1 WHERE descrip ='[search]'/sql /definition /field /layer /searchitem /searchlist map file---LAYER NAME 'vias1' TYPE LINE DUMP true TEMPLATE fooOnlyForWMSGetFeatureInfo EXTENT 383230.235738 8242604.834650 400453.717167 8252242.309691 CONNECTIONTYPE postgis CONNECTION dbname='catas' host=localhost port=5432 user='postgres' password='123456' sslmode=disable DATA 'geom FROM vias1 USING UNIQUE gid USING srid=4326' METADATA LAYER_ENCODING UTF-8 DESCRIPTION vias1 RESULT_FIELDS descrip RESULT_HEADERS Descripcion ows_title vias1 END #STATUS DEFAULT #METADATA # 'ows_title' 'vias1' #END STATUS OFF TRANSPARENCY 100 PROJECTION 'proj=longlat' 'datum=WGS84' 'no_defs' END CLASS NAME 'vias1' STYLE WIDTH 0.91 COLOR 229 149 93 END END END LOG ERROR DE APACHE--[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] Incorrect setting for 'error_log' in 'php.ini'. Set to a valid file name., referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] PHP Warning: pg_query(): in C:\\ms4w\\apps\\pmapper\\pmapper-4.2.0\\incphp\\query\\squery.php on line 712, referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] P.MAPPER: PG Query error for : SELECT gid, , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] xmin(box3d(geom)), , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] ymin(box3d(geom)), , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] xmax(box3d(geom)), , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] ymax(box3d(geom)), , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] descrip , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] FROM vias1 , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] WHERE descrip ILIKE '%JR.APACHETA%' , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] LIMIT 301, referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] PHP Warning: pg_numrows() expects parameter 1 to be resource, boolean given in C:\\ms4w\\apps\\pmapper\\pmapper-4.2.0\\incphp\\query\\squery.php on line 716, referer: http://localhost/pmapper/map_default.phtml Saludos Miguel Cisneros -- Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app performance management and know exactly what is happening inside your Ruby, Python, PHP, Java, and .NET app Try New Relic at no cost today and get our sweet Data Nerd shirt too! http://p.sf.net/sfu/newrelic-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] search postgis layer eror
Hi I have problem with search tool on pmapper when I change my shapefile layer to my postgis layer. After I change to postgis layer, search tool never give a result and keep processing. I am using pmapper v.4.2, mapserver v.6.0.3, php v.5.4.3 and postgis v.2.0. Is there any compability issue with pmapper v.4.2 and postgis v.2.0 ? or there is some code that I have to changed? Thanks, Surahman Putra -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] search
Hello list, I have one problem, When I move my files of p.mapper to server, my search of two layers, (configured in layer_config) crashed, it's forever making the load... In the log files i don´t find nothing about that... Someone have an idea about what is the problem? Thanks Pedro -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search definition via XML file for DB
On 24/01/2012 07:29, Andreas Douvalis wrote: Sorry for my mistakes! Again my question: Why in Search definition via XML we have to write dsn string? I think it is more convenient to construct dsn string from connection string of layer in map file. In other case I have to maintain two config files (map file and search.xml). Am I right or I miss something? Just to clarify this: for standard search definitions you do not need to define the dsn, just for the special case of type=suggest and type=options. One reason for this was probably just simpler handling of the dsn without the need to extract it from the connection in the map file. Another was that you could use any type of DB connection in combination with any type of layer. Maybe looking a bit exotic, but I found use cases for it. There needs to be also a definition of the DB encoding. This might be possible to be extracted from some Postgres system tables but I don't think this is too much asking to set it in the XML definition. A simplified definition could e.g. be something like dsn encoding=UTF-8@/dsn If you find this double definition annoying create a new feature ticket in the p.mapper TRAC site suggesting reading the dsn from the map file in case of Postgis layers. Then the chances are much better that this feature once gets added. Armin -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search and activation of layer
you can try the following:
add in your custom.js under your /config/your-config/ directory (usually
'default') the following lines
$.extend(PM.Query,
{
getQueryResult: function(qurl, params) {
$.ajax({
type: POST,
url: qurl,
data: params,
dataType: json,
success: function(response){
var mode = response.mode;
var queryResult = response.queryResult;
if (mode != 'iquery') {
$('#infoFrame').showv();
PM.Query.writeQResult(queryResult, PM.infoWin);
PM.ajaxIndicatorHide();
// NEW CODE
if (mode == 'search') {
var grpName = queryResult[0][0]['name'];
$('#ginput_' + grpName).attr('checked', true);
PM.Toc.setlayers(grpName, true);
}
// NEW CODE END
} else {
// Display result in DIV and postion it correctly
PM.Query.showIQueryResults(queryResult);
}
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
if (window.console) console.log(errorThrown);
}
});
}
})
Note that this quick hack might not work in all cases and might have
some inconsistencies left, so it might needed to be refined. One could
e.g. trigger the click event for the checkbox, which very likely will
cause a double reload of the map though, though...
If you want, add a ticket in the pmapper TRAC as new feature request, so
the idea is not getting lost and it might get implemented in a cleaner
way in the core code.
Armin
On 23/01/2012 14:10, i...@architekten.coop wrote:
dear pmapper users
i am using pmapper 4.1.0
when i make a search e.g. in the pmapper-demodata
for a river, but the layer river is not activated, it would be nice, when
that layer river could be turned active by the search process.
ist that possible with short piece of code ?
thank you very much
matthias moser switzerland
--
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
--
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] Search definition via XML file for DB
Hi! Whi in Search definition via XML we have to write dsn string? I think it is more convenient to construct dsn string from connection string of layer in map file. Ii other case I have to maintain two config files (map file and search.xml). Am I right or I miss something? -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] Search definition via XML file for DB
Sorry for my mistakes! Again my question: Why in Search definition via XML we have to write dsn string? I think it is more convenient to construct dsn string from connection string of layer in map file. In other case I have to maintain two config files (map file and search.xml). Am I right or I miss something? -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] search attributes on postgres/postgis layer
Hi all, I've many postgis layers in my mapfile. I'm able to make a search for a field in a polygon layer but not in a point layer. In this second case (layer Test) search starts but nothing happens. I attach mapfile and config_default.xml. Any hints? Thanks in advance MAPFILE = [...] LAYER NAME 'test' TYPE POINT CONNECTIONTYPE postgis CONNECTION dbname='dbname' host=localhost port=5432 password='' user='postgres' DATA the_geom FROM test USING UNIQUE gid USING SRID=-1 METADATA #'wms_title' 'test' RESULT_FIELDS id_punto,nome_ortof,strato_uso,strato_u_1,quota_pop,istatr,istatp,istatc RESULT_HEADERS Codice Punto,Ortofoto,Uso del suolo,Uso del suolo 2,Quota,Istat Reg,Istat Pro,Istat Com END STATUS OFF TRANSPARENCY 100 PROJECTION init=epsg:3004 END TEMPLATE void CLASS NAME 'test' STYLE SYMBOL 'CIRCLE' SIZE 4 OUTLINECOLOR 0 0 0 COLOR 255 0 0 END END END [.] CONFIG_DEFAULT.XML [.] searchlist version=1.0 dataroot$/dataroot searchitem name=provincia description=Provincia (nome) layer type=postgis name=ita_pro_gbe field type=s name=provincia description=Nome della Provincia wildcard=0 / /layer /searchitem searchitem name=sigla description=Provincia (sigla) layer type=postgis name=ita_pro_gbe field type=s name=sigla description=Sigla della Provincia wildcard=0 / /layer /searchitem searchitem name=ID_punto description=Codice PUNTO layer type=postgis name=test field type=n name=id_punto description=Codice PUNTO wildcard=1/ /layer /searchitem /searchlist [.] -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search attributes on postgres/postgis layer
Solved! There were some fields upper case and others in lower case, in my Postgres DB. A. Da: Alberto Laurenti a.laure...@yahoo.it A: pmapper-users@lists.sourceforge.net Inviato: Ven 16 luglio 2010, 15:11:04 Oggetto: [pmapper-users] search attributes on postgres/postgis layer Hi all, I've many postgis layers in my mapfile. I'm able to make a search for a field in a polygon layer but not in a point layer. In this second case (layer Test) search starts but nothing happens. I attach mapfile and config_default.xml. Any hints? Thanks in advance MAPFILE = [...] LAYER NAME 'test' TYPE POINT CONNECTIONTYPE postgis CONNECTION dbname='dbname' host=localhost port=5432 password='' user='postgres' DATA the_geom FROM test USING UNIQUE gid USING SRID=-1 METADATA #'wms_title' 'test' RESULT_FIELDS id_punto,nome_ortof,strato_uso,strato_u_1,quota_pop,istatr,istatp,istatc RESULT_HEADERS Codice Punto,Ortofoto,Uso del suolo,Uso del suolo 2,Quota,Istat Reg,Istat Pro,Istat Com END STATUS OFF TRANSPARENCY 100 PROJECTION init=epsg:3004 END TEMPLATE void CLASS NAME 'test' STYLE SYMBOL 'CIRCLE' SIZE 4 OUTLINECOLOR 0 0 0 COLOR 255 0 0 END END END [.] CONFIG_DEFAULT.XML [.] searchlist version=1.0 dataroot$/dataroot searchitem name=provincia description=Provincia (nome) layer type=postgis name=ita_pro_gbe field type=s name=provincia description=Nome della Provincia wildcard=0 / /layer /searchitem searchitem name=sigla description=Provincia (sigla) layer type=postgis name=ita_pro_gbe field type=s name=sigla description=Sigla della Provincia wildcard=0 / /layer /searchitem searchitem name=ID_punto description=Codice PUNTO layer type=postgis name=test field type=n name=id_punto description=Codice PUNTO wildcard=1/ /layer /searchitem /searchlist [.] -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search does not work.
Estimado Nahum, la versión de pmapper es la 4 stable, adjunto parte archivos de configuración: Archivo .map LAYER CONNECTIONTYPE postgis DATA the_geom from v_callepuerta USING UNIQUE gid USING SRID=32721 TYPE point CONNECTION user=montevimap password=xxx dbname=nucleo host=desgis.imm.gub.uy port=5432 NAME busqueda STATUS OFF DUMP TRUE END Archivo search.xml searchitem name=busqueda description=Calle y Nº de puerta layer type=postgis name=busqueda field type=s name=nom_calle description=Calle wildcard=0 definition type=suggest connectiontype=db sort=asc minlength=1 dependfld=cmcncd dsn encoding=UTF-8pgsql://montevimap:x...@desgis.imm.gub. uy/nucleo/dsn sql SELECT nom_calle FROM v_callepuerta WHERE nom_calle ='[search]' /sql /definition /field field type=n name=num_puerta description=Numero de Puerta wildcard=2 definition type=suggest connectiontype=db sort=asc minlength=1 dependfld=cmcncd dsn encoding=UTF-8pgsql: //montevimap:x...@desgis.imm.gub.uy/nucleo/dsn sqlSELECT num_puerta FROM v_callepuerta WHERE num_puerta ='[search]' /sql /definition /field /layer /searchitem Definición tabla postgrs. Columna | Tipo| Modificadores +---+--- gid| bigint| cod_nombre_via | integer | nom_calle | character varying | num_puerta | integer | letra | character(5) | paridad| character(1) | the_geom | geometry Muchas gracias por cualquier ayuda, otras busquedas si me funcionan pero no logro que esta funciones. Richard Montevideo, Uruguay English Dear Nahum, pmapper version is 4 stable, attached some configuration files: Archive. Map LAYER CONNECTIONTYPE postgis DATA the_geom from v_callepuerta USING UNIQUE gid USING SRID = 32721 TYPE point CONNECTION user = montevimap password = xxx dbname = nucleo desgis.imm.gub.uy host = port = 5432 NAME Search STATUS OFF DUMP TRUE END File search.xml searchitem name=busqueda description=Calle and Nº of puerta layer type=postgis name=busqueda field type=s name=nom_calle description=Calle wildcard=0 definition type=suggest connectiontype=db sort=asc minlength= 1 dependfld=cmcncd dsn encoding=UTF-8 pgsql: / / montevimap:x...@desgis.imm.gub.uy /nucleo / dsn nom_calle SELECT sql FROM v_callepuerta WHERE nom_calle = '[search]' / sql / definition / field field type=n name=num_puerta description=Numero of Puerta wildcard=2 definition type=suggest connectiontype=db sort=asc minlength=1 dependfld=cmcncd dsn encoding=UTF-8 pgsql: / / montevimap:x...@desgis.imm.gub.uy /nucleo / dsn num_puerta SELECT sql FROM v_callepuerta WHERE num_puerta = '[search]' / sql / definition / field / layer / searchitem Definition postgres table. Column | Type | Modifiers --- --- gid | bigint | cod_nombre_via | integer | nom_calle | character varying | num_puerta | integer | letter | character (5) | parity | character (1) | the_geom | geometry Thank you very much for any help, if I run other searches but can not get these functions. Richard Montevideo, Uruguay Spanish ¿Cómo tienes definido tu .map y el archivo de configuración de búsquedas? ¿Qué versión de pmapper tienes?. English How is defined your .map file and search.xml file? Wich pmapper version you have? Saludos. Nahum 2010/1/20 richardcam...@adinet.com.uy richardcam...@adinet.com.uy - Ocultar texto citado - llo everyone, sorry for my English. I have configured and installed the viewer pmapper, the only problem I have is with the search, the same achievements on Postgres with PostGIS, work correctly on some tables, but in others does not search me. I use both geometry tables or views both with the corresponding column the_geom and gid. The log tells me that there is an error with the gid, but it exists and it's OK, I can properly display the layer in the map view. Deputy log with errors. [20-Jan-2010 17:27:17] PHP Warning: pg_query () [a href='function. pg- query' function.pg-query / a]: Query failed: ERROR: syntax error at or near FROM at character 257 in / inetpub / wwwroot / maps / incphp / query / squery.php on line 704 [20-Jan-2010 17:27:17] P. MAPPER: PG for error Query: SELECT gid,
Re: [pmapper-users] Search does not work.
The SQL used is missing the result fields and therefore the SQL is not correct (the comma at the end of the line before FROM...) . Try to add the result fields in the layer definition like METADATA ... RESULT_FIELDS NAME, ISO2_CODE, POPULATION, GTOPO30 RESULT_HEADERS Name,Country,Inhabitants,Altitude ... END # Metadata If they are not defined normally *all* fields are defined, but there might be a bug. I never define layers without them (I do not want to display the column names literally in the result, normally... ), so I have not stumbled over this problem armin On Thu, Jan 21, 2010 at 12:16 PM, richardcam...@adinet.com.uy richardcam...@adinet.com.uy wrote: Estimado Nahum, la versión de pmapper es la 4 stable, adjunto parte archivos de configuración: Archivo .map LAYER CONNECTIONTYPE postgis DATA the_geom from v_callepuerta USING UNIQUE gid USING SRID=32721 TYPE point CONNECTION user=montevimap password=xxx dbname=nucleo host=desgis.imm.gub.uy port=5432 NAME busqueda STATUS OFF DUMP TRUE END Archivo search.xml searchitem name=busqueda description=Calle y Nº de puerta layer type=postgis name=busqueda field type=s name=nom_calle description=Calle wildcard=0 definition type=suggest connectiontype=db sort=asc minlength=1 dependfld=cmcncd dsn encoding=UTF-8pgsql://montevimap:x...@desgis.imm.gub. uy/nucleo/dsn sql SELECT nom_calle FROM v_callepuerta WHERE nom_calle ='[search]' /sql /definition /field field type=n name=num_puerta description=Numero de Puerta wildcard=2 definition type=suggest connectiontype=db sort=asc minlength=1 dependfld=cmcncd dsn encoding=UTF-8pgsql: //montevimap:x...@desgis.imm.gub.uy/nucleo/dsn sqlSELECT num_puerta FROM v_callepuerta WHERE num_puerta ='[search]' /sql /definition /field /layer /searchitem Definición tabla postgrs. Columna | Tipo | Modificadores +---+--- gid | bigint | cod_nombre_via | integer | nom_calle | character varying | num_puerta | integer | letra | character(5) | paridad | character(1) | the_geom | geometry Muchas gracias por cualquier ayuda, otras busquedas si me funcionan pero no logro que esta funciones. Richard Montevideo, Uruguay English Dear Nahum, pmapper version is 4 stable, attached some configuration files: Archive. Map LAYER CONNECTIONTYPE postgis DATA the_geom from v_callepuerta USING UNIQUE gid USING SRID = 32721 TYPE point CONNECTION user = montevimap password = xxx dbname = nucleo desgis.imm.gub.uy host = port = 5432 NAME Search STATUS OFF DUMP TRUE END File search.xml searchitem name=busqueda description=Calle and Nº of puerta layer type=postgis name=busqueda field type=s name=nom_calle description=Calle wildcard=0 definition type=suggest connectiontype=db sort=asc minlength= 1 dependfld=cmcncd dsn encoding=UTF-8 pgsql: / / montevimap:x...@desgis.imm.gub.uy /nucleo / dsn nom_calle SELECT sql FROM v_callepuerta WHERE nom_calle = '[search]' / sql / definition / field field type=n name=num_puerta description=Numero of Puerta wildcard=2 definition type=suggest connectiontype=db sort=asc minlength=1 dependfld=cmcncd dsn encoding=UTF-8 pgsql: / / montevimap:x...@desgis.imm.gub.uy /nucleo / dsn num_puerta SELECT sql FROM v_callepuerta WHERE num_puerta = '[search]' / sql / definition / field / layer / searchitem Definition postgres table. Column | Type | Modifiers --- --- gid | bigint | cod_nombre_via | integer | nom_calle | character varying | num_puerta | integer | letter | character (5) | parity | character (1) | the_geom | geometry Thank you very much for any help, if I run other searches but can not get these functions. Richard Montevideo, Uruguay Spanish ¿Cómo tienes definido tu .map y el archivo de configuración de búsquedas? ¿Qué versión de pmapper tienes?. English How is defined your .map file and search.xml file? Wich pmapper version you have? Saludos. Nahum 2010/1/20 richardcam...@adinet.com.uy richardcam...@adinet.com.uy - Ocultar texto citado - llo everyone, sorry for my English. I have configured and installed the viewer pmapper, the only
Re: [pmapper-users] Search does not work.
just noticed that you're mainly missing the template tag for the layer, so *no* query will work. see http://svn.pmapper.net/trac/wiki/DocManual#LayerGroupDescriptionsandFieldsforQueries On Thu, Jan 21, 2010 at 12:16 PM, richardcam...@adinet.com.uy richardcam...@adinet.com.uy wrote: Estimado Nahum, la versión de pmapper es la 4 stable, adjunto parte archivos de configuración: Archivo .map LAYER CONNECTIONTYPE postgis DATA the_geom from v_callepuerta USING UNIQUE gid USING SRID=32721 TYPE point CONNECTION user=montevimap password=xxx dbname=nucleo host=desgis.imm.gub.uy port=5432 NAME busqueda STATUS OFF DUMP TRUE END Archivo search.xml searchitem name=busqueda description=Calle y Nº de puerta layer type=postgis name=busqueda field type=s name=nom_calle description=Calle wildcard=0 definition type=suggest connectiontype=db sort=asc minlength=1 dependfld=cmcncd dsn encoding=UTF-8pgsql://montevimap:x...@desgis.imm.gub. uy/nucleo/dsn sql SELECT nom_calle FROM v_callepuerta WHERE nom_calle ='[search]' /sql /definition /field field type=n name=num_puerta description=Numero de Puerta wildcard=2 definition type=suggest connectiontype=db sort=asc minlength=1 dependfld=cmcncd dsn encoding=UTF-8pgsql: //montevimap:x...@desgis.imm.gub.uy/nucleo/dsn sqlSELECT num_puerta FROM v_callepuerta WHERE num_puerta ='[search]' /sql /definition /field /layer /searchitem Definición tabla postgrs. Columna | Tipo | Modificadores +---+--- gid | bigint | cod_nombre_via | integer | nom_calle | character varying | num_puerta | integer | letra | character(5) | paridad | character(1) | the_geom | geometry Muchas gracias por cualquier ayuda, otras busquedas si me funcionan pero no logro que esta funciones. Richard Montevideo, Uruguay English Dear Nahum, pmapper version is 4 stable, attached some configuration files: Archive. Map LAYER CONNECTIONTYPE postgis DATA the_geom from v_callepuerta USING UNIQUE gid USING SRID = 32721 TYPE point CONNECTION user = montevimap password = xxx dbname = nucleo desgis.imm.gub.uy host = port = 5432 NAME Search STATUS OFF DUMP TRUE END File search.xml searchitem name=busqueda description=Calle and Nº of puerta layer type=postgis name=busqueda field type=s name=nom_calle description=Calle wildcard=0 definition type=suggest connectiontype=db sort=asc minlength= 1 dependfld=cmcncd dsn encoding=UTF-8 pgsql: / / montevimap:x...@desgis.imm.gub.uy /nucleo / dsn nom_calle SELECT sql FROM v_callepuerta WHERE nom_calle = '[search]' / sql / definition / field field type=n name=num_puerta description=Numero of Puerta wildcard=2 definition type=suggest connectiontype=db sort=asc minlength=1 dependfld=cmcncd dsn encoding=UTF-8 pgsql: / / montevimap:x...@desgis.imm.gub.uy /nucleo / dsn num_puerta SELECT sql FROM v_callepuerta WHERE num_puerta = '[search]' / sql / definition / field / layer / searchitem Definition postgres table. Column | Type | Modifiers --- --- gid | bigint | cod_nombre_via | integer | nom_calle | character varying | num_puerta | integer | letter | character (5) | parity | character (1) | the_geom | geometry Thank you very much for any help, if I run other searches but can not get these functions. Richard Montevideo, Uruguay Spanish ¿Cómo tienes definido tu .map y el archivo de configuración de búsquedas? ¿Qué versión de pmapper tienes?. English How is defined your .map file and search.xml file? Wich pmapper version you have? Saludos. Nahum 2010/1/20 richardcam...@adinet.com.uy richardcam...@adinet.com.uy - Ocultar texto citado - llo everyone, sorry for my English. I have configured and installed the viewer pmapper, the only problem I have is with the search, the same achievements on Postgres with PostGIS, work correctly on some tables, but in others does not search me. I use both geometry tables or views both with the corresponding column the_geom and gid. The log tells me that there is an error with the gid, but it exists and it's OK, I can properly display the layer in the map view. Deputy log with errors.
Re: [pmapper-users] Search does not work.
Dear Armin, thank you very much for your response I could fix it, I really lacked the METADATA section Greetings Richard Montevideo, Uruguay Mensaje original De: armin.bur...@gmail.com Fecha: 21/01/2010 12:12 Para: richardcam...@adinet.com.uyrichardcam...@adinet.com.uy CC: pmapper-users@lists.sourceforge.net Asunto: Re: [pmapper-users] Search does not work. just noticed that you're mainly missing the template tag for the layer, so *no* query will work. see http://svn.pmapper. net/trac/wiki/DocManual#LayerGroupDescriptionsandFieldsforQueries On Thu, Jan 21, 2010 at 12:16 PM, richardcam...@adinet.com.uy richardcam...@adinet.com.uy wrote: Estimado Nahum, la versión de pmapper es la 4 stable, adjunto parte archivos de configuración: Archivo .map LAYER CONNECTIONTYPE postgis DATA the_geom from v_callepuerta USING UNIQUE gid USING SRID=32721 TYPE point CONNECTION user=montevimap password=xxx dbname=nucleo host=desgis.imm.gub.uy port=5432 NAME busqueda STATUS OFF DUMP TRUE END Archivo search.xml searchitem name=busqueda description=Calle y Nº de puerta layer type=postgis name=busqueda field type=s name=nom_calle description=Calle wildcard=0 definition type=suggest connectiontype= db sort=asc minlength=1 dependfld=cmcncd dsn encoding=UTF-8pgsql: //montevimap:x...@desgis.imm.gub. uy/nucleo/dsn sql SELECT nom_calle FROM v_callepuerta WHERE nom_calle ='[search]' /sql /definition /field field type=n name=num_puerta description= Numero de Puerta wildcard=2 definition type=suggest connectiontype= db sort=asc minlength=1 dependfld=cmcncd dsn encoding=UTF-8pgsql: //montevimap:x...@desgis.imm.gub.uy/nucleo/dsn sqlSELECT num_puerta FROM v_callepuerta WHERE num_puerta ='[search]' /sql /definition /field /layer /searchitem Definición tabla postgrs. Columna | Tipo | Modificadores +---+--- gid | bigint | cod_nombre_via | integer | nom_calle | character varying | num_puerta | integer | letra | character(5) | paridad | character(1) | the_geom | geometry Muchas gracias por cualquier ayuda, otras busquedas si me funcionan pero no logro que esta funciones. Richard Montevideo, Uruguay English Dear Nahum, pmapper version is 4 stable, attached some configuration files: Archive. Map LAYER CONNECTIONTYPE postgis DATA the_geom from v_callepuerta USING UNIQUE gid USING SRID = 32721 TYPE point CONNECTION user = montevimap password = xxx dbname = nucleo desgis.imm.gub.uy host = port = 5432 NAME Search STATUS OFF DUMP TRUE END File search.xml searchitem name=busqueda description=Calle and Nº of puerta layer type=postgis name=busqueda field type=s name=nom_calle description=Calle wildcard=0 definition type=suggest connectiontype=db sort=asc minlength= 1 dependfld=cmcncd dsn encoding=UTF-8 pgsql: / / montevimap:x...@desgis.imm.gub.uy /nucleo / dsn nom_calle SELECT sql FROM v_callepuerta WHERE nom_calle = '[search]' / sql / definition / field field type=n name=num_puerta description= Numero of Puerta wildcard=2 definition type=suggest connectiontype= db sort=asc minlength=1 dependfld=cmcncd dsn encoding=UTF-8 pgsql: / / montevimap:x...@desgis.imm.gub.uy /nucleo / dsn num_puerta SELECT sql FROM v_callepuerta WHERE num_puerta = '[search]' / sql / definition / field / layer / searchitem Definition postgres table. Column | Type | Modifiers --- --- gid | bigint | cod_nombre_via | integer | nom_calle | character varying | num_puerta | integer | letter | character (5) | parity | character (1) | the_geom | geometry Thank you very much for any help, if I run other searches but can not get these functions. Richard Montevideo, Uruguay Spanish ¿Cómo tienes definido tu .map y el archivo de configuración de búsquedas? ¿Qué versión de pmapper tienes?. English How is defined your .map file and search.xml file? Wich pmapper version you have? Saludos. Nahum 2010/1/20 richardcam...@adinet.com.uy richardcam...@adinet.com.uy - Ocultar texto citado - llo everyone, sorry for my English. I have configured and installed the viewer pmapper, the only problem I have
Re: [pmapper-users] Search does not work.
Spanish ¿Cómo tienes definido tu .map y el archivo de configuración de búsquedas? ¿Qué versión de pmapper tienes?. English How is defined your .map file and search.xml file? Wich pmapper version you have? Saludos. Nahum 2010/1/20 richardcam...@adinet.com.uy richardcam...@adinet.com.uy llo everyone, sorry for my English. I have configured and installed the viewer pmapper, the only problem I have is with the search, the same achievements on Postgres with PostGIS, work correctly on some tables, but in others does not search me. I use both geometry tables or views both with the corresponding column the_geom and gid. The log tells me that there is an error with the gid, but it exists and it's OK, I can properly display the layer in the map view. Deputy log with errors. [20-Jan-2010 17:27:17] PHP Warning: pg_query () [a href='function.pg- query' function.pg-query / a]: Query failed: ERROR: syntax error at or near FROM at character 257 in / inetpub / wwwroot / maps / incphp / query / squery.php on line 704 [20-Jan-2010 17:27:17] P. MAPPER: PG for error Query: SELECT gid, xmin (box3d (the_geom)), ymin (box3d (the_geom)), xmax (box3d (the_geom)), ymax (box3d (the_geom)), FROM x_sig_busqueda WHERE nom_calle ILIKE '% COLONIA%' LIMIT 301 [20-Jan-2010 17:27:17] PHP Warning: pg_numrows (): supplied argument is not a valid PostgreSQL result resource in / inetpub / wwwroot / map s / incphp / query / squery.php on line 708 Thank you very much for any help. Greetings Richard -- Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users -- Nahum Castro González León, Guanajuato, México -- Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search 2 (or more) fields with same data column
On 05/01/2010 04:26, i-boy wrote:
Thanks you Armin, it works great !
I have updated Docs at the end of trac/wiki/DocManualsearch with this:
---
For search multi-items in one database column:
- In file search.php = function: getSearchParameters() change $operator
from AND to OR
- Use alias for the search column, ex:
{{{
searchitem name=Item description=Items
layer type=shape name=Layer
field type=s name=DB_Column description=Item_1
wildcard=0 /
field type=s name=DB_Column alias=DB_Column_2
description=Item_2 wildcard=0 /
field type=s name=DB_Column alias=DB_Column_3
description=Item_3 wildcard=0 /
...
/layer
/searchitem
}}}
something I noticed now is that you changed the code in search.php to
have an OR operator. This is not recommended and you should use the setting
operator=OR
instead, like
field type=s name=DB_Column alias=DB_Column_2
description=Item_2 wildcard=0 operator=OR /
If you want to have the various tags and attributes available when you
edit the xml file use an editor supporting xml schemas and use the
provided schema, see
http://svn.pmapper.net/trac/wiki/DocManualsearch
The search string that is created can be retrieved via the debug log
(see docs for it) and tested with
= http://svn.pmapper.net/trac/wiki/FaqDebugging#a9.Testofquerystrings
armin
--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search 2 (or more) fields with same data column
On 04/01/2010 04:40, i-boy wrote: Hi lists, I defined a search item like this: -- searchitem name=Dist description=District ___layer type=shape name=HN_District __field type=s name=D_Name description=ID0 wildcard=0 / __field type=s name=D_Name description=ID1 wildcard=0 / ___/layer /searchitem -- and changed in search.php = getSearchParameters() operator AND to OR it works fine when search fields in different DB column but when use same column name (as above), it only found the last field. Can I edit some file to make it (search multi item in one database column) work ? it should work defining an alias for the 2nd field, like field type=s name=D_Name alias=D_Name_1 description=ID1 wildcard=0 / If it works fine please update the docs in the Trac system (use the 'Register' link to create an account). armin -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search 2 (or more) fields with same data column
Thanks you Armin, it works great !
I have updated Docs at the end of trac/wiki/DocManualsearch with this:
---
For search multi-items in one database column:
- In file search.php = function: getSearchParameters() change $operator
from AND to OR
- Use alias for the search column, ex:
{{{
searchitem name=Item description=Items
layer type=shape name=Layer
field type=s name=DB_Column description=Item_1
wildcard=0 /
field type=s name=DB_Column alias=DB_Column_2
description=Item_2 wildcard=0 /
field type=s name=DB_Column alias=DB_Column_3
description=Item_3 wildcard=0 /
...
/layer
/searchitem
}}}
---
--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] Search 2 (or more) fields with same data column
Hi lists, I defined a search item like this: -- searchitem name=Dist description=District ___layer type=shape name=HN_District __field type=s name=D_Name description=ID0 wildcard=0 / __field type=s name=D_Name description=ID1 wildcard=0 / ___/layer /searchitem -- and changed in search.php = getSearchParameters() operator AND to OR it works fine when search fields in different DB column but when use same column name (as above), it only found the last field. Can I edit some file to make it (search multi item in one database column) work ? Thanks a lot !! -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search distinct features on one-to-many join query (for time series)
Hi Thomas. it' not clear how DATASUBSTITUTION works. AFAICS it's only used inside pmap_addResultLayer to retrieve the shapes, so after the query/select have run. So what you mean with This way pmapper will use the DATASUBSTITION when you will search / query objects? thanks again, giovanni 2009/12/17 Thomas Raffin traf...@sirap.fr: Hi, You should try to define a view that will join the tables (for instance SELECT grid.*, rainfall_ts.rainfall FROM grid,rainfall_ts WHERE grid.gid = rainfall_ts.gid). So you will have 2 ways to use your data in your mapfile : - DATA the_geom FROM grid USING UNIQUE gid -- only 1 object without the rainfall attribute - DATA the_geom FROM your_view USING UNIQUE gid -- many objects at the same place with different rainfall values, and surely longer to execute What you should do in your mapfile is : LAYER METADATA . PM_RESULT_DATASUBSTITION the_geom FROM your_view USING UNIQUE gid END DATA the_geom FROM grid USING UNIQUE gid END This way pmapper will use the DATASUBSTITION when you will search / query objects and use DATA when it will draw images. G. Allegri a écrit : Thanks Armin for the quick reply. The problem is not with the join, my doubt is about how to use it :) I have the following structure: GRID | gid |the_geom | | 1 | MULTYPOLYGON..| | 2 | MULTYPOLYGON. | | 3 | MULTYPOLYGON..| | | . | RAINFALL_TS | gid | rainfall | | 1 | 5 | | 1 | 10.4 | | 1 | 1.3 | | | . | From the docs it's not clear to me how to query RAINFALL_TS to retrieve tha unique gid values to select/highlight the cells from GRID... I've read: http://svn.pmapper.net/trac/wiki/FaqConfiguration#Joinstoexternaldatabasetables http://svn.pmapper.net/trac/wiki/DocManualsearch both seem to refer on the reverse need: retrieve attributes from joined tables, while I need to retrieve the unique gids from them. Am I missing something? I'm sorry if I'm asking stupid questions... giovanni 2009/12/16 Armin Burger armin.bur...@gmail.com: On 16/12/2009 20:04, G. Allegri wrote: Hello list. Before spending too much time on this, I would like to know if the trunk beta supports this thing: I have a big postgis table with a time series (TS) associated with a polygonal grid layer. For each polygon/cell I have multiple rows in the TS table. Let's say I have the list od daily rainfall. I need to let the user query the TS table to see if there is ANY cell where the daily rainfall have exceeded a certain threshold. (The truth is that I have many TS tables, coming from different simulations, and one single vector layer...) So, the user should be able to do a Search for Rainfall values higher then X, and receive all the cells where it happens. The actual code seems to offer many ways to deal with multiple joins, but nothing seems to respond to my need. Am I wrong? Is this already available or should I code it? There is no special support for joins in Postgis layers in p.mapper, just use the functionality of the database for all sorts of joins and be aware of the special settings for this in the DATA parameter map file. I usually use DB views that do all the join definitions instead of defining the join in the map file. If the search does exactly what you want I cannot say, but you can define the full SQL statement in the search definition. Just check the docs and samples. armin -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search distinct features on one-to-many join query (for time series)
Hi, I mean pmapper will use the DATA definition when it needs to draw object and PM_RESULT_DATASUBSTITION definition when it needs to search object (attributes queries) or show attributes values (results in the table, iquery, ...). So it will draw only one object of your main table witch contains geometry, but when you will click on 1 object you will get many results (with the same geometry but different attributes due to the join made in the view). G. Allegri a écrit : Hi Thomas. it' not clear how DATASUBSTITUTION works. AFAICS it's only used inside pmap_addResultLayer to retrieve the shapes, so after the query/select have run. So what you mean with This way pmapper will use the DATASUBSTITION when you will search / query objects? thanks again, giovanni 2009/12/17 Thomas Raffin traf...@sirap.fr: Hi, You should try to define a view that will join the tables (for instance SELECT grid.*, rainfall_ts.rainfall FROM grid,rainfall_ts WHERE grid.gid = rainfall_ts.gid). So you will have 2 ways to use your data in your mapfile : - DATA the_geom FROM grid USING UNIQUE gid -- only 1 object without the rainfall attribute - DATA the_geom FROM your_view USING UNIQUE gid -- many objects at the same place with different rainfall values, and surely longer to execute What you should do in your mapfile is : LAYER METADATA . PM_RESULT_DATASUBSTITION the_geom FROM your_view USING UNIQUE gid END DATA the_geom FROM grid USING UNIQUE gid END This way pmapper will use the DATASUBSTITION when you will search / query objects and use DATA when it will draw images. G. Allegri a écrit : Thanks Armin for the quick reply. The problem is not with the join, my doubt is about how to use it :) I have the following structure: GRID | gid |the_geom | | 1 | MULTYPOLYGON..| | 2 | MULTYPOLYGON. | | 3 | MULTYPOLYGON..| | | . | RAINFALL_TS | gid | rainfall | | 1 | 5 | | 1 | 10.4 | | 1 | 1.3 | | | . | From the docs it's not clear to me how to query RAINFALL_TS to retrieve tha unique gid values to select/highlight the cells from GRID... I've read: http://svn.pmapper.net/trac/wiki/FaqConfiguration#Joinstoexternaldatabasetables http://svn.pmapper.net/trac/wiki/DocManualsearch both seem to refer on the reverse need: retrieve attributes from joined tables, while I need to retrieve the unique gids from them. Am I missing something? I'm sorry if I'm asking stupid questions... giovanni 2009/12/16 Armin Burger armin.bur...@gmail.com: On 16/12/2009 20:04, G. Allegri wrote: Hello list. Before spending too much time on this, I would like to know if the trunk beta supports this thing: I have a big postgis table with a time series (TS) associated with a polygonal grid layer. For each polygon/cell I have multiple rows in the TS table. Let's say I have the list od daily rainfall. I need to let the user query the TS table to see if there is ANY cell where the daily rainfall have exceeded a certain threshold. (The truth is that I have many TS tables, coming from different simulations, and one single vector layer...) So, the user should be able to do a Search for Rainfall values higher then X, and receive all the cells where it happens. The actual code seems to offer many ways to deal with multiple joins, but nothing seems to respond to my need. Am I wrong? Is this already available or should I code it? There is no special support for joins in Postgis layers in p.mapper, just use the functionality of the database for all sorts of joins and be aware of the special settings for this in the DATA parameter map file. I usually use DB views that do all the join definitions instead of defining the join in the map file. If the search does exactly what you want I cannot say, but you can define the full SQL statement in the search definition. Just check the docs and samples. armin -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search distinct features on one-to-many join query (for time series)
I don't want to bother you more, but... I have set my mapfile with PM_RESULT_DATASUBSTITION, but if I query/search I obtain only one result. I don't see PM_RESULT_DATASUBSTITION in the query code (search.php, query.php and squery.php), so it seems it's rever used during the query phase... Ok, probably I miss something foundamental of the pmapper logic. I apologize for asking so much... bye, giovanni 2009/12/18 Thomas Raffin traf...@sirap.fr: Hi, I mean pmapper will use the DATA definition when it needs to draw object and PM_RESULT_DATASUBSTITION definition when it needs to search object (attributes queries) or show attributes values (results in the table, iquery, ...). So it will draw only one object of your main table witch contains geometry, but when you will click on 1 object you will get many results (with the same geometry but different attributes due to the join made in the view). G. Allegri a écrit : Hi Thomas. it' not clear how DATASUBSTITUTION works. AFAICS it's only used inside pmap_addResultLayer to retrieve the shapes, so after the query/select have run. So what you mean with This way pmapper will use the DATASUBSTITION when you will search / query objects? thanks again, giovanni 2009/12/17 Thomas Raffin traf...@sirap.fr: Hi, You should try to define a view that will join the tables (for instance SELECT grid.*, rainfall_ts.rainfall FROM grid,rainfall_ts WHERE grid.gid = rainfall_ts.gid). So you will have 2 ways to use your data in your mapfile : - DATA the_geom FROM grid USING UNIQUE gid -- only 1 object without the rainfall attribute - DATA the_geom FROM your_view USING UNIQUE gid -- many objects at the same place with different rainfall values, and surely longer to execute What you should do in your mapfile is : LAYER METADATA . PM_RESULT_DATASUBSTITION the_geom FROM your_view USING UNIQUE gid END DATA the_geom FROM grid USING UNIQUE gid END This way pmapper will use the DATASUBSTITION when you will search / query objects and use DATA when it will draw images. G. Allegri a écrit : Thanks Armin for the quick reply. The problem is not with the join, my doubt is about how to use it :) I have the following structure: GRID | gid |the_geom | | 1 | MULTYPOLYGON..| | 2 | MULTYPOLYGON. | | 3 | MULTYPOLYGON..| | | . | RAINFALL_TS | gid | rainfall | | 1 | 5 | | 1 | 10.4 | | 1 | 1.3 | | | . | From the docs it's not clear to me how to query RAINFALL_TS to retrieve tha unique gid values to select/highlight the cells from GRID... I've read: http://svn.pmapper.net/trac/wiki/FaqConfiguration#Joinstoexternaldatabasetables http://svn.pmapper.net/trac/wiki/DocManualsearch both seem to refer on the reverse need: retrieve attributes from joined tables, while I need to retrieve the unique gids from them. Am I missing something? I'm sorry if I'm asking stupid questions... giovanni 2009/12/16 Armin Burger armin.bur...@gmail.com: On 16/12/2009 20:04, G. Allegri wrote: Hello list. Before spending too much time on this, I would like to know if the trunk beta supports this thing: I have a big postgis table with a time series (TS) associated with a polygonal grid layer. For each polygon/cell I have multiple rows in the TS table. Let's say I have the list od daily rainfall. I need to let the user query the TS table to see if there is ANY cell where the daily rainfall have exceeded a certain threshold. (The truth is that I have many TS tables, coming from different simulations, and one single vector layer...) So, the user should be able to do a Search for Rainfall values higher then X, and receive all the cells where it happens. The actual code seems to offer many ways to deal with multiple joins, but nothing seems to respond to my need. Am I wrong? Is this already available or should I code it? There is no special support for joins in Postgis layers in p.mapper, just use the functionality of the database for all sorts of joins and be aware of the special settings for this in the DATA parameter map file. I usually use DB views that do all the join definitions instead of defining the join in the map file. If the search does exactly what you want I cannot say, but you can define the full SQL statement in the search definition. Just check the docs and samples. armin -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app
Re: [pmapper-users] search distinct features on one-to-many join query (for time series)
Hi, You should try to define a view that will join the tables (for instance SELECT grid.*, rainfall_ts.rainfall FROM grid,rainfall_ts WHERE grid.gid = rainfall_ts.gid). So you will have 2 ways to use your data in your mapfile : - DATA the_geom FROM grid USING UNIQUE gid -- only 1 object without the rainfall attribute - DATA the_geom FROM your_view USING UNIQUE gid -- many objects at the same place with different rainfall values, and surely longer to execute What you should do in your mapfile is : LAYER METADATA . PM_RESULT_DATASUBSTITION the_geom FROM your_view USING UNIQUE gid END DATA the_geom FROM grid USING UNIQUE gid END This way pmapper will use the DATASUBSTITION when you will search / query objects and use DATA when it will draw images. G. Allegri a écrit : Thanks Armin for the quick reply. The problem is not with the join, my doubt is about how to use it :) I have the following structure: GRID | gid |the_geom | | 1 | MULTYPOLYGON..| | 2 | MULTYPOLYGON. | | 3 | MULTYPOLYGON..| | | . | RAINFALL_TS | gid | rainfall | | 1 | 5 | | 1 | 10.4 | | 1 | 1.3 | | | . | From the docs it's not clear to me how to query RAINFALL_TS to retrieve tha unique gid values to select/highlight the cells from GRID... I've read: http://svn.pmapper.net/trac/wiki/FaqConfiguration#Joinstoexternaldatabasetables http://svn.pmapper.net/trac/wiki/DocManualsearch both seem to refer on the reverse need: retrieve attributes from joined tables, while I need to retrieve the unique gids from them. Am I missing something? I'm sorry if I'm asking stupid questions... giovanni 2009/12/16 Armin Burger armin.bur...@gmail.com: On 16/12/2009 20:04, G. Allegri wrote: Hello list. Before spending too much time on this, I would like to know if the trunk beta supports this thing: I have a big postgis table with a time series (TS) associated with a polygonal grid layer. For each polygon/cell I have multiple rows in the TS table. Let's say I have the list od daily rainfall. I need to let the user query the TS table to see if there is ANY cell where the daily rainfall have exceeded a certain threshold. (The truth is that I have many TS tables, coming from different simulations, and one single vector layer...) So, the user should be able to do a Search for Rainfall values higher then X, and receive all the cells where it happens. The actual code seems to offer many ways to deal with multiple joins, but nothing seems to respond to my need. Am I wrong? Is this already available or should I code it? There is no special support for joins in Postgis layers in p.mapper, just use the functionality of the database for all sorts of joins and be aware of the special settings for this in the DATA parameter map file. I usually use DB views that do all the join definitions instead of defining the join in the map file. If the search does exactly what you want I cannot say, but you can define the full SQL statement in the search definition. Just check the docs and samples. armin -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search distinct features on one-to-many join query (for time series)
I don't know if it is documented. I'm sure we have discuss about it with Armin, but that's it... G. Allegri a écrit : Thanks Thomas. I will take a look to this PM_RESULT_DATASUBSTITION. Is it documented? I didn't see it anywhere... except into map.php, now that you indicated it :) giovanni 2009/12/17 Thomas Raffin traf...@sirap.fr: Hi, You should try to define a view that will join the tables (for instance SELECT grid.*, rainfall_ts.rainfall FROM grid,rainfall_ts WHERE grid.gid = rainfall_ts.gid). So you will have 2 ways to use your data in your mapfile : - DATA the_geom FROM grid USING UNIQUE gid -- only 1 object without the rainfall attribute - DATA the_geom FROM your_view USING UNIQUE gid -- many objects at the same place with different rainfall values, and surely longer to execute What you should do in your mapfile is : LAYER METADATA . PM_RESULT_DATASUBSTITION the_geom FROM your_view USING UNIQUE gid END DATA the_geom FROM grid USING UNIQUE gid END This way pmapper will use the DATASUBSTITION when you will search / query objects and use DATA when it will draw images. G. Allegri a écrit : Thanks Armin for the quick reply. The problem is not with the join, my doubt is about how to use it :) I have the following structure: GRID | gid |the_geom | | 1 | MULTYPOLYGON..| | 2 | MULTYPOLYGON. | | 3 | MULTYPOLYGON..| | | . | RAINFALL_TS | gid | rainfall | | 1 | 5 | | 1 | 10.4 | | 1 | 1.3 | | | . | From the docs it's not clear to me how to query RAINFALL_TS to retrieve tha unique gid values to select/highlight the cells from GRID... I've read: http://svn.pmapper.net/trac/wiki/FaqConfiguration#Joinstoexternaldatabasetables http://svn.pmapper.net/trac/wiki/DocManualsearch both seem to refer on the reverse need: retrieve attributes from joined tables, while I need to retrieve the unique gids from them. Am I missing something? I'm sorry if I'm asking stupid questions... giovanni 2009/12/16 Armin Burger armin.bur...@gmail.com: On 16/12/2009 20:04, G. Allegri wrote: Hello list. Before spending too much time on this, I would like to know if the trunk beta supports this thing: I have a big postgis table with a time series (TS) associated with a polygonal grid layer. For each polygon/cell I have multiple rows in the TS table. Let's say I have the list od daily rainfall. I need to let the user query the TS table to see if there is ANY cell where the daily rainfall have exceeded a certain threshold. (The truth is that I have many TS tables, coming from different simulations, and one single vector layer...) So, the user should be able to do a Search for Rainfall values higher then X, and receive all the cells where it happens. The actual code seems to offer many ways to deal with multiple joins, but nothing seems to respond to my need. Am I wrong? Is this already available or should I code it? There is no special support for joins in Postgis layers in p.mapper, just use the functionality of the database for all sorts of joins and be aware of the special settings for this in the DATA parameter map file. I usually use DB views that do all the join definitions instead of defining the join in the map file. If the search does exactly what you want I cannot say, but you can define the full SQL statement in the search definition. Just check the docs and samples. armin -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net
[pmapper-users] search distinct features on one-to-many join query (for time series)
Hello list. Before spending too much time on this, I would like to know if the trunk beta supports this thing: I have a big postgis table with a time series (TS) associated with a polygonal grid layer. For each polygon/cell I have multiple rows in the TS table. Let's say I have the list od daily rainfall. I need to let the user query the TS table to see if there is ANY cell where the daily rainfall have exceeded a certain threshold. (The truth is that I have many TS tables, coming from different simulations, and one single vector layer...) So, the user should be able to do a Search for Rainfall values higher then X, and receive all the cells where it happens. The actual code seems to offer many ways to deal with multiple joins, but nothing seems to respond to my need. Am I wrong? Is this already available or should I code it? Thanks a lot, giovanni -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search distinct features on one-to-many join query (for time series)
On 16/12/2009 20:04, G. Allegri wrote: Hello list. Before spending too much time on this, I would like to know if the trunk beta supports this thing: I have a big postgis table with a time series (TS) associated with a polygonal grid layer. For each polygon/cell I have multiple rows in the TS table. Let's say I have the list od daily rainfall. I need to let the user query the TS table to see if there is ANY cell where the daily rainfall have exceeded a certain threshold. (The truth is that I have many TS tables, coming from different simulations, and one single vector layer...) So, the user should be able to do a Search for Rainfall values higher then X, and receive all the cells where it happens. The actual code seems to offer many ways to deal with multiple joins, but nothing seems to respond to my need. Am I wrong? Is this already available or should I code it? There is no special support for joins in Postgis layers in p.mapper, just use the functionality of the database for all sorts of joins and be aware of the special settings for this in the DATA parameter map file. I usually use DB views that do all the join definitions instead of defining the join in the map file. If the search does exactly what you want I cannot say, but you can define the full SQL statement in the search definition. Just check the docs and samples. armin -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search distinct features on one-to-many join query (for time series)
Thanks Armin for the quick reply. The problem is not with the join, my doubt is about how to use it :) I have the following structure: GRID | gid |the_geom | | 1 | MULTYPOLYGON..| | 2 | MULTYPOLYGON. | | 3 | MULTYPOLYGON..| | | . | RAINFALL_TS | gid | rainfall | | 1 | 5 | | 1 | 10.4 | | 1 | 1.3 | | | . | From the docs it's not clear to me how to query RAINFALL_TS to retrieve tha unique gid values to select/highlight the cells from GRID... I've read: http://svn.pmapper.net/trac/wiki/FaqConfiguration#Joinstoexternaldatabasetables http://svn.pmapper.net/trac/wiki/DocManualsearch both seem to refer on the reverse need: retrieve attributes from joined tables, while I need to retrieve the unique gids from them. Am I missing something? I'm sorry if I'm asking stupid questions... giovanni 2009/12/16 Armin Burger armin.bur...@gmail.com: On 16/12/2009 20:04, G. Allegri wrote: Hello list. Before spending too much time on this, I would like to know if the trunk beta supports this thing: I have a big postgis table with a time series (TS) associated with a polygonal grid layer. For each polygon/cell I have multiple rows in the TS table. Let's say I have the list od daily rainfall. I need to let the user query the TS table to see if there is ANY cell where the daily rainfall have exceeded a certain threshold. (The truth is that I have many TS tables, coming from different simulations, and one single vector layer...) So, the user should be able to do a Search for Rainfall values higher then X, and receive all the cells where it happens. The actual code seems to offer many ways to deal with multiple joins, but nothing seems to respond to my need. Am I wrong? Is this already available or should I code it? There is no special support for joins in Postgis layers in p.mapper, just use the functionality of the database for all sorts of joins and be aware of the special settings for this in the DATA parameter map file. I usually use DB views that do all the join definitions instead of defining the join in the map file. If the search does exactly what you want I cannot say, but you can define the full SQL statement in the search definition. Just check the docs and samples. armin -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search question
Javier for p.mapper 4 set in /config/.../js_config.php PM.suggestLaunchSearch = false; (true is the default) for pm 3 it should be something like 'pmSuggestLaunchSearch' instead armin 2009/11/27 Fco. Javier García Ricca fjri...@gmail.com: Hello, I use this code in the config.xml. searchitem name=secciones description=Secciones Censales layer type=shape name=secciones field type=s name=Distrito_1 description=Distrito wildcard=2 definition type=suggest connectiontype=ms minlength=1 startleft=1 sort=asc mslayer encoding=UTF-8/ /definition /field field type=s name=Seccione_1 description=Seccion wildcard=2 definition type=suggest connectiontype=ms minlength=1 startleft=1 sort=asc dependfld=Distrito_1 mslayer encoding=UTF-8/ /definition /field /layer /searchitem to search features. I would like search those feature only when I press the button search. Is this possible? Thans -- -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] search question
Hello, I use this code in the config.xml. searchitem name=secciones description=Secciones Censales layer type=shape name=secciones field type=s name=Distrito_1 description=Distrito wildcard=2 definition type=suggest connectiontype=ms minlength=1 startleft=1 sort=asc mslayer encoding=UTF-8/ /definition /field field type=s name=Seccione_1 description=Seccion wildcard=2 definition type=suggest connectiontype=ms minlength=1 startleft=1 sort=asc dependfld=Distrito_1 mslayer encoding=UTF-8/ /definition /field /layer /searchitem to search features. I would like search those feature only when I press the button search. Is this possible? Thans -- FJRicca -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search
Hi, You can put the search parameters everywhere you want in your map.phtml. Move those lines: !-- Search Container -- ?php echo UiElement::searchContainer(inline) ? and change the mode if needed (inline = vertical / block = horizontal). Maybe it will require some css enhancement. Else you can use the queryEditor plugin as Siki Zoiltan said or the searchTool plugin. Documentation is here but not finished: http://svn.pmapper.net/trac/wiki/PluginsQuery Thomas Siki Zoltan a écrit : Hi Kevin, What about using queryeditor plugin or customise it for your purposes? Regards, Zoltan On Mon, 5 Oct 2009, Kevin Edmundson wrote: I have a relatively complex search for a parcel layer (sale price range (low - high) sale date range (low - high)) that I want to present to the user to use. However...the search parameters that show are too large to display on the normal search area. Is there a way to force the search parameters to show up in the west frame that is not used for anything that I can see? Kevin Edmundson CIO WTH Technology, Inc 567 W Westfield Blvd Indianapolis, IN 46208 317.259.0105 office 317.259.1423 fax 317.501.8560 mobile kevin.edmund...@wthtechnology.com NOTICE: This message is from the technology firm WTH Technology, Inc. This message is intended only for the individual or entity to which it is directed. If you are not the addressee, or if this message has been addressed to you in error, you are not authorized to use, read, copy or distribute this message and any attachments, and we ask that you please immediately delete this message and attachments (including all copies), and notify the sender by return e-mail so that our records can be corrected. All personal messages express views only of the sender, which are not to be attributed to WTH Technology, Inc, and may not be distributed or copied without this statement. -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] search
I have a relatively complex search for a parcel layer (sale price range (low - high) sale date range (low - high)) that I want to present to the user to use. However...the search parameters that show are too large to display on the normal search area. Is there a way to force the search parameters to show up in the west frame that is not used for anything that I can see? Kevin Edmundson CIO WTH Technology, Inc 567 W Westfield Blvd Indianapolis, IN 46208 317.259.0105 office 317.259.1423 fax 317.501.8560 mobile kevin.edmund...@wthtechnology.com NOTICE: This message is from the technology firm WTH Technology, Inc. This message is intended only for the individual or entity to which it is directed. If you are not the addressee, or if this message has been addressed to you in error, you are not authorized to use, read, copy or distribute this message and any attachments, and we ask that you please immediately delete this message and attachments (including all copies), and notify the sender by return e-mail so that our records can be corrected. All personal messages express views only of the sender, which are not to be attributed to WTH Technology, Inc, and may not be distributed or copied without this statement. -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search
Hi Kevin, What about using queryeditor plugin or customise it for your purposes? Regards, Zoltan On Mon, 5 Oct 2009, Kevin Edmundson wrote: I have a relatively complex search for a parcel layer (sale price range (low - high) sale date range (low - high)) that I want to present to the user to use. However...the search parameters that show are too large to display on the normal search area. Is there a way to force the search parameters to show up in the west frame that is not used for anything that I can see? Kevin Edmundson CIO WTH Technology, Inc 567 W Westfield Blvd Indianapolis, IN 46208 317.259.0105 office 317.259.1423 fax 317.501.8560 mobile kevin.edmund...@wthtechnology.com NOTICE: This message is from the technology firm WTH Technology, Inc. This message is intended only for the individual or entity to which it is directed. If you are not the addressee, or if this message has been addressed to you in error, you are not authorized to use, read, copy or distribute this message and any attachments, and we ask that you please immediately delete this message and attachments (including all copies), and notify the sender by return e-mail so that our records can be corrected. All personal messages express views only of the sender, which are not to be attributed to WTH Technology, Inc, and may not be distributed or copied without this statement. -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] search
Hi List, I get in trouble with search, I have slash character in the search pattern. When I use wildcard=2 it works, but when I try to use wildcard 0 or 1 it finds no match because slases are not escaped in query string ($qs in search.php). in pm_debug.log I get [qStr] = ( [HRSZ] =~ /^(2|2)(2|2)(4|4)(8|8)(6|6)(9|9)/(2|2)$/) The search string I looked for '224869/2'. I think the slashes would be escaped in the query string in search.php (getSearchParamsShp). I use shape files. Thanks, Zoltan -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search
Zoltan,
I use something like this in query.php, q_execAttributeQuery() (around
line 724):
if (substr_count($this-qStr, /) == 3) {
$qStrArray = explode(/, $this-qStr);
$newqStr =
$qStrArray[0]./.$qStrArray[1]...$qStrArray[2]./.$qStrArray[3];
$this-qStr = $newqStr;
}
regards, dejan
Siki Zoltan s...@agt.bme.hu wrote on 13.09.2009 11:34:40:
Hi List,
I get in trouble with search, I have slash character in the search
pattern. When I use wildcard=2 it works, but when I try to use wildcard
0
or 1 it finds no match because slases are not escaped in query string
($qs
in search.php).
in pm_debug.log I get
[qStr] = ( [HRSZ] =~ /^(2|2)(2|2)(4|4)(8|8)(6|6)(9|9)/(2|2)$/)
The search string I looked for '224869/2'.
I think the slashes would be escaped in the query string in search.php
(getSearchParamsShp). I use shape files.
Thanks,
Zoltan
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008
30-Day
trial. Simplify your report design, integration and deployment -
andfocus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search
Dear Dejan,
Thank you for your answer. I did something similar as a quick and dirty
solution. Using . instead of / has some side effect.
If the search pattern is /^12.5$/ will match not only 12/5, but 1215,
1225, etc. This side affect is difficult to explane to the end users.
Thanks,
Zoltan
On Sun, 13 Sep 2009, dejan.gam...@pula.hr wrote:
Zoltan,
I use something like this in query.php, q_execAttributeQuery() (around
line 724):
if (substr_count($this-qStr, /) == 3) {
$qStrArray = explode(/, $this-qStr);
$newqStr =
$qStrArray[0]./.$qStrArray[1]...$qStrArray[2]./.$qStrArray[3];
$this-qStr = $newqStr;
}
regards, dejan
Siki Zoltan s...@agt.bme.hu wrote on 13.09.2009 11:34:40:
Hi List,
I get in trouble with search, I have slash character in the search
pattern. When I use wildcard=2 it works, but when I try to use wildcard
0
or 1 it finds no match because slases are not escaped in query string
($qs
in search.php).
in pm_debug.log I get
[qStr] = ( [HRSZ] =~ /^(2|2)(2|2)(4|4)(8|8)(6|6)(9|9)/(2|2)$/)
The search string I looked for '224869/2'.
I think the slashes would be escaped in the query string in search.php
(getSearchParamsShp). I use shape files.
Thanks,
Zoltan
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008
30-Day
trial. Simplify your report design, integration and deployment -
andfocus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search from Shapefile problem (with dirty patch)
Hi,I experienced the same problem with pmapper 3.2 but no with 4.0 beta 1, this one was always fine.So, i reviewed the code inside incphp\query\ and by checking every line in both versions, I could solve it. It is not just copying from 4.0beta to 3.2. There're some other little corrections. I had to work with a 2 parameters search. In fact the difference between 3.2 and 4.0beta1 was: function: q_execAttributeQuery [qStr] = ( [NOMBRE] =~ /(A|a)(L|l)(L|l)(E|e)(N|n)(D|d)(E|e)/)( AND [NUMERO] =~ /4301/) Which has no results. But in 4.0beta1, the function retrieves this: [qStr] = (( ( [NOMBRE] =~ /(A|a)(L|l)(L|l)(E|e)(N|n)(D|d)(E|e)/ ) ) AND ( [NUMERO] =~ /(4|4)(3|3)(0|0)(1|1)/ ) Fixing the spelling of the second parameter I solved my problem. You can check also: function getSearchParamsShp in search.php (depends on the data source, in my case were shapefiles) The only way to realized about this error is with debug (pm_debug). I'll check your code, but just reading I mean it's the correct way and can be also useful for my app. Thanks. Raul Retamozo Lima-Peru Date: Wed, 6 May 2009 13:30:51 +0200 From: nicc...@rigacci.org To: pmapper-users@lists.sourceforge.net Subject: [pmapper-users] Search from Shapefile problem (with dirty patch) Hi, I experienced the search from shapefile problem: blank result when wildcard is set to 0 in search.xml. I got the same problem with pmapper 3 and 4beta. It turned out that the syntax of the query was wrong: a double parenthesis is added, which is considered an error (by MapServer query engine?). I fixed the code in incphp/query/search.php: simply do not enclse with parenthesis in some cases. See the attachment. But beware that I'm not so confident with pmapper query code, so deeper insight is required. P.S. is the bug tracker used, or we just use the mailing list? -- Niccolo Rigacci Firenze - Italy _ ¡Quítate unos clics! Ahora, Internet Explorer 8 tiene todo lo que te gusta de Windows Live ¡Consíguelo gratis! http://ie8.msn.com/microsoft/internet-explorer-8/es-es/ie8.aspx -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search from Shapefile problem (with dirty patch)
I cannot find big differences in the search on shapefiles between current 4 and 3.2. But I also never experienced the problems mentioned, neither on Win nor Linux. The first search string you list is for sure wrong since the AND is at the wrong place. This looked for me like an older bug already fixed in 3.2 armin On 06/05/2009 17:47, raul retamozo velarde wrote: Hi,I experienced the same problem with pmapper 3.2 but no with 4.0 beta 1, this one was always fine.So, i reviewed the code inside incphp\query\ and by checking every line in both versions, I could solve it. It is not just copying from 4.0beta to 3.2. There're some other little corrections. I had to work with a 2 parameters search. In fact the difference between 3.2 and 4.0beta1 was: function: q_execAttributeQuery [qStr] = ( [NOMBRE] =~ /(A|a)(L|l)(L|l)(E|e)(N|n)(D|d)(E|e)/)( AND [NUMERO] =~ /4301/) Which has no results. But in 4.0beta1, the function retrieves this: [qStr] = (( ( [NOMBRE] =~ /(A|a)(L|l)(L|l)(E|e)(N|n)(D|d)(E|e)/ ) ) AND ( [NUMERO] =~ /(4|4)(3|3)(0|0)(1|1)/ ) Fixing the spelling of the second parameter I solved my problem. You can check also: function getSearchParamsShp in search.php (depends on the data source, in my case were shapefiles) The only way to realized about this error is with debug (pm_debug). I'll check your code, but just reading I mean it's the correct way and can be also useful for my app. Thanks. Raul Retamozo Lima-Peru Date: Wed, 6 May 2009 13:30:51 +0200 From: nicc...@rigacci.org To: pmapper-users@lists.sourceforge.net Subject: [pmapper-users] Search from Shapefile problem (with dirty patch) Hi, I experienced the search from shapefile problem: blank result when wildcard is set to 0 in search.xml. I got the same problem with pmapper 3 and 4beta. It turned out that the syntax of the query was wrong: a double parenthesis is added, which is considered an error (by MapServer query engine?). I fixed the code in incphp/query/search.php: simply do not enclse with parenthesis in some cases. See the attachment. But beware that I'm not so confident with pmapper query code, so deeper insight is required. P.S. is the bug tracker used, or we just use the mailing list? -- Niccolo Rigacci Firenze - Italy _ ¡Quítate unos clics! Ahora, Internet Explorer 8 tiene todo lo que te gusta de Windows Live ¡Consíguelo gratis! http://ie8.msn.com/microsoft/internet-explorer-8/es-es/ie8.aspx -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search OGR layer
Hi Armin, Thxs I found the problem, in the LAYER CLASS I forgot the sintaxe TEMPLATE void. Date: Tue, 27 Jan 2009 19:47:03 +0100 From: armin.bur...@gmail.com To: juliano...@hotmail.com CC: pmapper-users@lists.sourceforge.net Subject: Re: [pmapper-users] Search OGR layer and whats's the problem with your settings? does your listed search config not work with map info files? do you get errors, no results? I converted the cities1eu shapefile from the demo data to tab format and everything works fine as with it in shapefile format. armin On 27/01/2009 12:36, Juliano Agostinho wrote: Hi, I have many layers with OGR connection but i dont know how config the search file. MAPFILE : LAYER NAME City MAXSCALE 8000 TYPE POLYGON STATUS ON CONNECTIONTYPE OGR CONNECTION City.TAB STYLEITEM AUTO CLASS Name City END METADATA DESCRIPTION City RESULT_FIELDS NAME RESULT_HEADERS Name RESULT_HYPERLINK Name LAYER_ENCODING UTF-8 ows_title City END END Search file (XML): searchitem name=City description=City layer type=shape name=City field type=s name=NAME description=Name wildcard=0 / /layer /searchitem I want search in OGR LAYER. I dont want convert TAB to SHP, anyone have one suggestion ? THX _ Receba GRÁTIS as mensagens do Messenger no seu celular quando você estiver offline. Conheça o MSN Mobile! http://mobile.live.com/signup/signup2.aspx?lc=pt-br -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users _ Conheça o Windows Live Spaces, a rede de relacionamentos do Messenger! http://www.amigosdomessenger.com.br/ -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] Search OGR layer
Hi, I have many layers with OGR connection but i dont know how config the search file. MAPFILE : LAYER NAME City MAXSCALE 8000 TYPE POLYGON STATUS ON CONNECTIONTYPE OGR CONNECTION City.TAB STYLEITEM AUTO CLASS Name City END METADATA DESCRIPTION City RESULT_FIELDS NAME RESULT_HEADERS Name RESULT_HYPERLINK Name LAYER_ENCODING UTF-8 ows_title City END END Search file (XML): searchitem name=City description=City layer type=shape name=City field type=s name=NAME description=Name wildcard=0 / /layer /searchitem I want search in OGR LAYER. I dont want convert TAB to SHP, anyone have one suggestion ? THX _ Receba GRÁTIS as mensagens do Messenger no seu celular quando você estiver offline. Conheça o MSN Mobile! http://mobile.live.com/signup/signup2.aspx?lc=pt-br -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search OGR layer
and whats's the problem with your settings? does your listed search config not work with map info files? do you get errors, no results? I converted the cities1eu shapefile from the demo data to tab format and everything works fine as with it in shapefile format. armin On 27/01/2009 12:36, Juliano Agostinho wrote: Hi, I have many layers with OGR connection but i dont know how config the search file. MAPFILE : LAYER NAME City MAXSCALE 8000 TYPE POLYGON STATUS ON CONNECTIONTYPE OGR CONNECTION City.TAB STYLEITEM AUTO CLASS Name City END METADATA DESCRIPTION City RESULT_FIELDS NAME RESULT_HEADERS Name RESULT_HYPERLINK Name LAYER_ENCODING UTF-8 ows_title City END END Search file (XML): searchitem name=City description=City layer type=shape name=City field type=s name=NAME description=Name wildcard=0 / /layer /searchitem I want search in OGR LAYER. I dont want convert TAB to SHP, anyone have one suggestion ? THX _ Receba GRÁTIS as mensagens do Messenger no seu celular quando você estiver offline. Conheça o MSN Mobile! http://mobile.live.com/signup/signup2.aspx?lc=pt-br -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] Search XML with PostGIS
Hi, p.mapper is great - and I am experimenting for quite a while but didn't found out how exactly to define a search funktion in the search.xml file using PostGIS; the examples show the connection without sending a username and password. e.g.: Database name ist testdb Tablename is testfile Username is testperson Password is testpassword and I would like to select all the geometries where the field NAME is searchstring Here is your example where I have tried to fill this informations in, but I failed - I would simply like to establish a connection but did not know how to handle username and password (since the XML file is open to the public I could/would not include it here): searchitem name=testsearch description=Only a test layer type=postgis name=testfile field type=s name=name description=City wildcard=2 definition type=suggest connectiontype=db sort=asc minlength=1 dependfld=cmcncd dsn encoding=UTF-8pgsql:// postgres:[EMAIL PROTECTED]/testdb/dsn sqlSELECT DISTINCT name FROM testtfile WHERE name ~* '^[search]' ORDER BY name/sql /definition /field /layer /searchitem As far as I understand I don't need the suggest type in my case instead of receiving the results immediately at the map. So the most simple example how to write a request with PostGIS would be appreciated! Thanks for your help! Regards Andreas - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search XML with PostGIS
Andreas have a look here http://svn.pmapper.net/trac/browser/pmapper/trunk/config/dev/search.xml If you do not need things like options/suggest then the definition should be quite straightforward: searchitem name=cities_pg description=City PG layer type=postgis name=cities1eu_pg field type=s name=name description=City wildcard=1 / /layer /searchitem For options/suggest username/passwd need to be defined in the dsn like dsn encoding=UTF-8pgsql://username:[EMAIL PROTECTED]/gisdb/dsn armin On Fri, Oct 17, 2008 at 9:23 AM, Andreas Haux [EMAIL PROTECTED] wrote: Hi, p.mapper is great - and I am experimenting for quite a while but didn't found out how exactly to define a search funktion in the search.xml file using PostGIS; the examples show the connection without sending a username and password. e.g.: Database name ist testdb Tablename is testfile Username is testperson Password is testpassword and I would like to select all the geometries where the field NAME is searchstring Here is your example where I have tried to fill this informations in, but I failed - I would simply like to establish a connection but did not know how to handle username and password (since the XML file is open to the public I could/would not include it here): searchitem name=testsearch description=Only a test layer type=postgis name=testfile field type=s name=name description=City wildcard=2 definition type=suggest connectiontype=db sort=asc minlength=1 dependfld=cmcncd dsn encoding=UTF-8pgsql:// postgres:[EMAIL PROTECTED]/testdb/dsn sqlSELECT DISTINCT name FROM testtfile WHERE name ~* '^[search]' ORDER BY name/sql /definition /field /layer /searchitem As far as I understand I don't need the suggest type in my case instead of receiving the results immediately at the map. So the most simple example how to write a request with PostGIS would be appreciated! Thanks for your help! Regards Andreas - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search XML with PostGIS
Armin, thanks for your feedback - and sorry for coming back with this issue. I have defined the XML as follows: ?xml version='1.0'? !-- ?xml-stylesheet href=style.xsl type=text/xsl ? -- searchlist version=1.0 dataroot$/dataroot searchitem name=pfarreien description=Pfarrei layer type=postgis name=pfarreien field type=s name=pfarrei description=Name wildcard=1 / /layer /searchitem /searchlist - The layer name in the .map-file is pfarreien - The database connection is defined in the map file - The database is world, the table is bamberg_pfarreien; but this seems not to be neccessary here? - The column of the table where the search shall took place is pfarrei Everytime I start a search I only see the working image in the top right corner and nothing happens. After hours of testing - could you please have a look whether something is wrong with the xml? Thanks!! Regards Andreas -- screen paper Werbeagentur GmbH Firmensitz: Martin-Luther-Straße 6, D-85354 Freising Telefon: +49-(0)8161-97 94-0 Telefax: +49-(0)8161-97 94-23 Registergericht: Freising, HRB 104 687 Geschäftsführer: Andreas Haux http://www.screen-paper.de http://www.csite.de http://www.maps-on-demand.com http://www.mapshop-online.de -- Disclaimer Der Inhalt dieser E- Mail ist ausschließlich für den bezeichneten Adressaten bestimmt und enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn diese E- Mail nicht an Sie persönlich adressiert ist oder Sie die Vertretung sein sollten, so beachten Sie, dass jede Form der Kenntnisnahme, Veröffentlichung, Vervielfältigung oder die Weitergabe des Inhalts dieser E- Mail unzulässig ist. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Am 17.10.2008 um 12:50 schrieb Armin Burger: Andreas have a look here http://svn.pmapper.net/trac/browser/pmapper/trunk/config/dev/ search.xml If you do not need things like options/suggest then the definition should be quite straightforward: searchitem name=cities_pg description=City PG layer type=postgis name=cities1eu_pg field type=s name=name description=City wildcard=1 / /layer /searchitem For options/suggest username/passwd need to be defined in the dsn like dsn encoding=UTF-8pgsql://username:[EMAIL PROTECTED]/gisdb/dsn armin On Fri, Oct 17, 2008 at 9:23 AM, Andreas Haux [EMAIL PROTECTED] wrote: Hi, p.mapper is great - and I am experimenting for quite a while but didn't found out how exactly to define a search funktion in the search.xml file using PostGIS; the examples show the connection without sending a username and password. e.g.: Database name ist testdb Tablename is testfile Username is testperson Password is testpassword and I would like to select all the geometries where the field NAME is searchstring Here is your example where I have tried to fill this informations in, but I failed - I would simply like to establish a connection but did not know how to handle username and password (since the XML file is open to the public I could/would not include it here): searchitem name=testsearch description=Only a test layer type=postgis name=testfile field type=s name=name description=City wildcard=2 definition type=suggest connectiontype=db sort=asc minlength=1 dependfld=cmcncd dsn encoding=UTF-8pgsql:// postgres:[EMAIL PROTECTED]/testdb/dsn sqlSELECT DISTINCT name FROM testtfile WHERE name ~* '^[search]' ORDER BY name/sql /definition /field /layer /searchitem As far as I understand I don't need the suggest type in my case instead of receiving the results immediately at the map. So the most simple example how to write a request with PostGIS would be appreciated! Thanks for your help! Regards Andreas - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users - This SF.Net email is sponsored by the Moblin Your Move Developer's
Re: [pmapper-users] Search XML with PostGIS
Hi Andreas and Armin, I have te *same problem* too. why it happens? I have defined the XML as follows: searchitem name=acudes_grupo description=Açudes layer type=postgis name=acudes field type=s name=ds_acude description=Nome do Açude wildcard=0 / /layer /searchitem and my layer: LAYER NAME 'acudes1' GROUP 'acudes_grupo' # POSTGIS # CONNECTIONTYPE postgis CONNECTION dbname=MYDB user=MYUSER host=MYHOST password=PASS DATA the_geom FROM (SELECT a.cd_acude AS oid , a.ds_acude, a.nm_anoconclusao, a.ds_riachobarrado, a.ds_tipobarragem, a.nm_capacidade, a.nm_areabaciahidrografica, a.nm_baciahidraulica, a.nm_vazaoregularizada, a.nm_extensaocoroamento, a.nm_larguracoroamento, a.nm_cotacoroamento, a.nm_alturamaxima, a.ds_tiposangradouro, a.nm_largurasangradouro, a.nm_laminamaximasangradouro, a.nm_cotasoleira, a.ds_tipotomadadagua, a.nm_diametrotomadadagua, a.nm_comprimentotomadadagua, a.ds_obs, cd_statusacude, a.fl_gerenciado, a.vl_valorestimado, a.the_geom AS the_geom, m.ds_municipio, b.ds_baciahidrografica FROM acudes a, municipio m, baciahidrografica b where a.cd_baciahidrografica = b.cd_baciahidrografica AND a.cd_municipio = m.cd_municipio AND cd_statusacude=1) as foo USING UNIQUE oid USING SRID=29184 # END POSTGIS # TYPE Point TEMPLATE void TOLERANCE 20 TOLERANCEUNITS pixels METADATA DESCRIPTION Açudes RESULT_FIELDS ds_acude, ds_municipio, ds_baciahidrografica, ds_riachobarrado, ds_tipobarragem, nm_capacidade, nm_areabaciahidrografica, nm_vazaoregularizada, oid RESULT_HEADERS Nome do Açude, Município, Bacia Hidrográfica, Rio Barrado, Tipo de Barragem, Capacidade (m3), Bacia Hidrográfica (ha), Vazão (m3/s), Detalhamento RESULT_HYPERLINK oid||Clique aqui para mais informações END # Metadata LABELITEM 'ds_acude' LABELMINSCALE 100 LABELMAXSCALE 160 CLASS NAME 'Construído' LABEL TYPE TRUETYPE FONT FreeSans POSITION UR BUFFER 5 SIZE 8 COLOR 0 0 255 OUTLINECOLOR 255 255 255 ANTIALIAS TRUE FORCE TRUE END #LABEL STYLE SYMBOL 'triangle' SIZE 12 COLOR 0 0 255 OUTLINECOLOR 0 0 0 END #STYLE END #CLASS END #LAYER #- 2008/10/17 Andreas Haux [EMAIL PROTECTED] Armin, thanks for your feedback - and sorry for coming back with this issue. I have defined the XML as follows: ?xml version='1.0'? !-- ?xml-stylesheet href=style.xsl type=text/xsl ? -- searchlist version=1.0 dataroot$/dataroot searchitem name=pfarreien description=Pfarrei layer type=postgis name=pfarreien field type=s name=pfarrei description=Name wildcard=1 / /layer /searchitem /searchlist - The layer name in the .map-file is pfarreien - The database connection is defined in the map file - The database is world, the table is bamberg_pfarreien; but this seems not to be neccessary here? - The column of the table where the search shall took place is pfarrei Everytime I start a search I only see the working image in the top right corner and nothing happens. After hours of testing - could you please have a look whether something is wrong with the xml? Thanks!! Regards Andreas -- screen paper Werbeagentur GmbH Firmensitz: Martin-Luther-Straße 6, D-85354 Freising Telefon: +49-(0)8161-97 94-0 Telefax: +49-(0)8161-97 94-23 Registergericht: Freising, HRB 104 687 Geschäftsführer: Andreas Haux http://www.screen-paper.de http://www.csite.de http://www.maps-on-demand.com http://www.mapshop-online.de -- Disclaimer Der Inhalt dieser E- Mail ist ausschließlich für den bezeichneten Adressaten bestimmt und enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn diese E- Mail nicht an Sie persönlich adressiert ist oder Sie die Vertretung sein sollten, so beachten Sie, dass jede Form der Kenntnisnahme, Veröffentlichung, Vervielfältigung oder die Weitergabe des Inhalts dieser E- Mail unzulässig ist. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Am 17.10.2008 um 12:50 schrieb Armin Burger: Andreas have a look here http://svn.pmapper.net/trac/browser/pmapper/trunk/config/dev/ search.xml If you do not need things like options/suggest then the definition should be quite straightforward: searchitem name=cities_pg description=City PG layer type=postgis name=cities1eu_pg field type=s name=name description=City wildcard=1 / /layer /searchitem For options/suggest username/passwd need to be defined in the dsn like dsn encoding=UTF-8pgsql://username:[EMAIL PROTECTED]/gisdb/dsn
Re: [pmapper-users] Search XML with PostGIS
Andreas 1. Check all the error logs (mainly PHP, but also Javascript) 2. set the debugging to value 3 and analyze the debug output. You should get the query strings sent to the database. Try to launch this query directly on the database via a generic DB client. See the FAQ for more details http://svn.pmapper.net/trac/wiki/FaqDebugging Report any error you get, including some debugging info. Include the map file, etc. There's a whole bunch of things you need to do and analyze. Armin On 17/10/2008 15:46, Andreas Haux wrote: Armin, thanks for your feedback - and sorry for coming back with this issue. I have defined the XML as follows: ?xml version='1.0'? !-- ?xml-stylesheet href=style.xsl type=text/xsl ? -- searchlist version=1.0 dataroot$/dataroot searchitem name=pfarreien description=Pfarrei layer type=postgis name=pfarreien field type=s name=pfarrei description=Name wildcard=1 / /layer /searchitem /searchlist - The layer name in the .map-file is pfarreien - The database connection is defined in the map file - The database is world, the table is bamberg_pfarreien; but this seems not to be neccessary here? - The column of the table where the search shall took place is pfarrei Everytime I start a search I only see the working image in the top right corner and nothing happens. After hours of testing - could you please have a look whether something is wrong with the xml? Thanks!! Regards Andreas -- screen paper Werbeagentur GmbH Firmensitz: Martin-Luther-Straße 6, D-85354 Freising Telefon: +49-(0)8161-97 94-0 Telefax: +49-(0)8161-97 94-23 Registergericht: Freising, HRB 104 687 Geschäftsführer: Andreas Haux http://www.screen-paper.de http://www.csite.de http://www.maps-on-demand.com http://www.mapshop-online.de -- Disclaimer Der Inhalt dieser E- Mail ist ausschließlich für den bezeichneten Adressaten bestimmt und enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn diese E- Mail nicht an Sie persönlich adressiert ist oder Sie die Vertretung sein sollten, so beachten Sie, dass jede Form der Kenntnisnahme, Veröffentlichung, Vervielfältigung oder die Weitergabe des Inhalts dieser E- Mail unzulässig ist. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Am 17.10.2008 um 12:50 schrieb Armin Burger: Andreas have a look here http://svn.pmapper.net/trac/browser/pmapper/trunk/config/dev/search.xml If you do not need things like options/suggest then the definition should be quite straightforward: searchitem name=cities_pg description=City PG layer type=postgis name=cities1eu_pg field type=s name=name description=City wildcard=1 / /layer /searchitem For options/suggest username/passwd need to be defined in the dsn like dsn encoding=UTF-8pgsql://username:[EMAIL PROTECTED]/gisdb/dsn armin On Fri, Oct 17, 2008 at 9:23 AM, Andreas Haux [EMAIL PROTECTED] wrote: Hi, p.mapper is great - and I am experimenting for quite a while but didn't found out how exactly to define a search funktion in the search.xml file using PostGIS; the examples show the connection without sending a username and password. e.g.: Database name ist testdb Tablename is testfile Username is testperson Password is testpassword and I would like to select all the geometries where the field NAME is searchstring Here is your example where I have tried to fill this informations in, but I failed - I would simply like to establish a connection but did not know how to handle username and password (since the XML file is open to the public I could/would not include it here): searchitem name=testsearch description=Only a test layer type=postgis name=testfile field type=s name=name description=City wildcard=2 definition type=suggest connectiontype=db sort=asc minlength=1 dependfld=cmcncd dsn encoding=UTF-8pgsql:// postgres:[EMAIL PROTECTED]/testdb/dsn sqlSELECT DISTINCT name FROM testtfile WHERE name ~* '^[search]' ORDER BY name/sql /definition /field /layer /searchitem As far as I understand I don't need the suggest type in my case instead of receiving the results immediately at the map. So the most simple example how to write a request with PostGIS would be appreciated! Thanks for your help! Regards Andreas - This SF.Net email is sponsored by the
Re: [pmapper-users] Search XML with PostGIS
see my mail to Andreas. In your case in addition: make you life easier and put your join in a DB view and try using this view as DATA. armin On 17/10/2008 16:38, Marcello Benigno wrote: Hi Andreas and Armin, I have te *same problem* too. why it happens? I have defined the XML as follows: searchitem name=acudes_grupo description=Açudes layer type=postgis name=acudes field type=s name=ds_acude description=Nome do Açude wildcard=0 / /layer /searchitem and my layer: LAYER NAME 'acudes1' GROUP 'acudes_grupo' # POSTGIS # CONNECTIONTYPE postgis CONNECTION dbname=MYDB user=MYUSER host=MYHOST password=PASS DATA the_geom FROM (SELECT a.cd_acude AS oid , a.ds_acude, a.nm_anoconclusao, a.ds_riachobarrado, a.ds_tipobarragem, a.nm_capacidade, a.nm_areabaciahidrografica, a.nm_baciahidraulica, a.nm_vazaoregularizada, a.nm_extensaocoroamento, a.nm_larguracoroamento, a.nm_cotacoroamento, a.nm_alturamaxima, a.ds_tiposangradouro, a.nm_largurasangradouro, a.nm_laminamaximasangradouro, a.nm_cotasoleira, a.ds_tipotomadadagua, a.nm_diametrotomadadagua, a.nm_comprimentotomadadagua, a.ds_obs, cd_statusacude, a.fl_gerenciado, a.vl_valorestimado, a.the_geom AS the_geom, m.ds_municipio, b.ds_baciahidrografica FROM acudes a, municipio m, baciahidrografica b where a.cd_baciahidrografica = b.cd_baciahidrografica AND a.cd_municipio = m.cd_municipio AND cd_statusacude=1) as foo USING UNIQUE oid USING SRID=29184 # END POSTGIS # TYPE Point TEMPLATE void TOLERANCE 20 TOLERANCEUNITS pixels METADATA DESCRIPTION Açudes RESULT_FIELDS ds_acude, ds_municipio, ds_baciahidrografica, ds_riachobarrado, ds_tipobarragem, nm_capacidade, nm_areabaciahidrografica, nm_vazaoregularizada, oid RESULT_HEADERS Nome do Açude, Município, Bacia Hidrográfica, Rio Barrado, Tipo de Barragem, Capacidade (m3), Bacia Hidrográfica (ha), Vazão (m3/s), Detalhamento RESULT_HYPERLINK oid||Clique aqui para mais informações END # Metadata LABELITEM 'ds_acude' LABELMINSCALE 100 LABELMAXSCALE 160 CLASS NAME 'Construído' LABEL TYPE TRUETYPE FONT FreeSans POSITION UR BUFFER 5 SIZE 8 COLOR 0 0 255 OUTLINECOLOR 255 255 255 ANTIALIAS TRUE FORCE TRUE END #LABEL STYLE SYMBOL 'triangle' SIZE 12 COLOR 0 0 255 OUTLINECOLOR 0 0 0 END #STYLE END #CLASS END #LAYER #- 2008/10/17 Andreas Haux [EMAIL PROTECTED] Armin, thanks for your feedback - and sorry for coming back with this issue. I have defined the XML as follows: ?xml version='1.0'? !-- ?xml-stylesheet href=style.xsl type=text/xsl ? -- searchlist version=1.0 dataroot$/dataroot searchitem name=pfarreien description=Pfarrei layer type=postgis name=pfarreien field type=s name=pfarrei description=Name wildcard=1 / /layer /searchitem /searchlist - The layer name in the .map-file is pfarreien - The database connection is defined in the map file - The database is world, the table is bamberg_pfarreien; but this seems not to be neccessary here? - The column of the table where the search shall took place is pfarrei Everytime I start a search I only see the working image in the top right corner and nothing happens. After hours of testing - could you please have a look whether something is wrong with the xml? Thanks!! Regards Andreas -- screen paper Werbeagentur GmbH Firmensitz: Martin-Luther-Straße 6, D-85354 Freising Telefon: +49-(0)8161-97 94-0 Telefax: +49-(0)8161-97 94-23 Registergericht: Freising, HRB 104 687 Geschäftsführer: Andreas Haux http://www.screen-paper.de http://www.csite.de http://www.maps-on-demand.com http://www.mapshop-online.de -- Disclaimer Der Inhalt dieser E- Mail ist ausschließlich für den bezeichneten Adressaten bestimmt und enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn diese E- Mail nicht an Sie persönlich adressiert ist oder Sie die Vertretung sein sollten, so beachten Sie, dass jede Form der Kenntnisnahme, Veröffentlichung, Vervielfältigung oder die Weitergabe des Inhalts dieser E- Mail unzulässig ist. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Am 17.10.2008 um 12:50 schrieb Armin Burger: Andreas have a look here http://svn.pmapper.net/trac/browser/pmapper/trunk/config/dev/ search.xml If you do not need things like options/suggest then the definition should be quite straightforward: searchitem name=cities_pg description=City PG layer type=postgis
Re: [pmapper-users] search for...
pag66 wrote: Try to use this metadata LAYER_ENCODING UTF-8 end in your layer definition I think it solve your problem Thanks for your reply, but it don't work for me! My pm_debug is: [12-Jul-2008 15:05:04] P.MAPPER debug info Searcharray in search.php-getSearchParameters() Array ( [nome] = SANT\'ANGELO LE FRATTE [mode] = search [PHPSESSID] = 2ff4c48f24cec5f8a11633fccc7744d9 ) [12-Jul-2008 15:05:04] P.MAPPER debug info Parameters for searchArray file: query.php-q_execAttributeQuery Array ( [nome] = SANT\'ANGELO LE FRATTE [mode] = search [PHPSESSID] = 2ff4c48f24cec5f8a11633fccc7744d9 ) [12-Jul-2008 15:05:04] P.MAPPER debug info P.MAPPER Warning: no UNIQUE field specified for PostGIS table 'public.comuni_pit'. Trying using OID field... [12-Jul-2008 15:05:04] P.MAPPER debug info P.MAPPER-DEBUG: squery.php/dumpPGQueryResults() - SQL Cmd: SELECT gid, xmin(box3d(the_geom)), ymin(box3d(the_geom)), xmax(box3d(the_geom)), ymax(box3d(the_geom)), nome,istat FROM public.comuni_pit WHERE nome = 'SANT\\\'ANGELO LE FRATTE' LIMIT 301 Bye - Salvatore Larosa GPG: 0xE504BBE2 (FP: D9B2 CA87 81CD 1B91 E24D 3B42 D0F7 FA01 E504 BBE2) -- View this message in context: http://www.nabble.com/search-for...-tp17648809p18418496.html Sent from the pmapper users mailing list archive at Nabble.com. - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search for...
seems there are a bit too many escaping backslashes added. Check your php.ini file for magic_quotes_gpc and magic_quotes_runtime and if they're set to On, try to set them to Off and see if the problem still appears. Armin On 12/07/2008 13:12, Salvator*eL*arosa wrote: pag66 wrote: Try to use this metadata LAYER_ENCODING UTF-8 end in your layer definition I think it solve your problem Thanks for your reply, but it don't work for me! My pm_debug is: [12-Jul-2008 15:05:04] P.MAPPER debug info Searcharray in search.php-getSearchParameters() Array ( [nome] = SANT\'ANGELO LE FRATTE [mode] = search [PHPSESSID] = 2ff4c48f24cec5f8a11633fccc7744d9 ) [12-Jul-2008 15:05:04] P.MAPPER debug info Parameters for searchArray file: query.php-q_execAttributeQuery Array ( [nome] = SANT\'ANGELO LE FRATTE [mode] = search [PHPSESSID] = 2ff4c48f24cec5f8a11633fccc7744d9 ) [12-Jul-2008 15:05:04] P.MAPPER debug info P.MAPPER Warning: no UNIQUE field specified for PostGIS table 'public.comuni_pit'. Trying using OID field... [12-Jul-2008 15:05:04] P.MAPPER debug info P.MAPPER-DEBUG: squery.php/dumpPGQueryResults() - SQL Cmd: SELECT gid, xmin(box3d(the_geom)), ymin(box3d(the_geom)), xmax(box3d(the_geom)), ymax(box3d(the_geom)), nome,istat FROM public.comuni_pit WHERE nome = 'SANT\\\'ANGELO LE FRATTE' LIMIT 301 Bye - Salvatore Larosa GPG: 0xE504BBE2 (FP: D9B2 CA87 81CD 1B91 E24D 3B42 D0F7 FA01 E504 BBE2) - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search for...
Armin Burger-2 wrote: seems there are a bit too many escaping backslashes added. Check your php.ini file for magic_quotes_gpc and magic_quotes_runtime and if they're set to On, try to set them to Off and see if the problem still appears. Armin On 12/07/2008 13:12, Salvator*eL*arosa wrote: pag66 wrote: Try to use this metadata LAYER_ENCODING UTF-8 end in your layer definition I think it solve your problem Thanks for your reply, but it don't work for me! My pm_debug is: [12-Jul-2008 15:05:04] P.MAPPER debug info Searcharray in search.php-getSearchParameters() Array ( [nome] = SANT\'ANGELO LE FRATTE [mode] = search [PHPSESSID] = 2ff4c48f24cec5f8a11633fccc7744d9 ) [12-Jul-2008 15:05:04] P.MAPPER debug info Parameters for searchArray file: query.php-q_execAttributeQuery Array ( [nome] = SANT\'ANGELO LE FRATTE [mode] = search [PHPSESSID] = 2ff4c48f24cec5f8a11633fccc7744d9 ) [12-Jul-2008 15:05:04] P.MAPPER debug info P.MAPPER Warning: no UNIQUE field specified for PostGIS table 'public.comuni_pit'. Trying using OID field... [12-Jul-2008 15:05:04] P.MAPPER debug info P.MAPPER-DEBUG: squery.php/dumpPGQueryResults() - SQL Cmd: SELECT gid, xmin(box3d(the_geom)), ymin(box3d(the_geom)), xmax(box3d(the_geom)), ymax(box3d(the_geom)), nome,istat FROM public.comuni_pit WHERE nome = 'SANT\\\'ANGELO LE FRATTE' LIMIT 301 Bye - Salvatore Larosa GPG: 0xE504BBE2 (FP: D9B2 CA87 81CD 1B91 E24D 3B42 D0F7 FA01 E504 BBE2) - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users Thank you very much, the problem is disappears! - Salvatore Larosa GPG: 0xE504BBE2 (FP: D9B2 CA87 81CD 1B91 E24D 3B42 D0F7 FA01 E504 BBE2) -- View this message in context: http://www.nabble.com/search-for...-tp17648809p18419253.html Sent from the pmapper users mailing list archive at Nabble.com. - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] search dinamic list
Hello everyone one question: in the search list, is it possible to see only fields of layer turned on in TOC? I have a TOC with many layers and I have a search field list very large! thanks emanuele masiero _ Tutta la posta in un solo posto… scarica Windows Live Mail!!! http://get.live.com/wlmail/overview - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search for...
Try to use this metadata LAYER_ENCODING UTF-8 end in your layer definition I think it solve your problem -- View this message in context: http://www.nabble.com/search-for...-tp17648809p18244826.html Sent from the pmapper users mailing list archive at Nabble.com. - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search for...
Salvator*eL*arosa wrote: Hello everyone, I have a problem with apostrophes in research an attribute! The fields with SANT'ANTONIO, SANT'AGATA produce no result! Someone knows how can I fix? Someone has some ideas about? Thanks! - Salvatore Larosa GPG: 0xE504BBE2 (FP: D9B2 CA87 81CD 1B91 E24D 3B42 D0F7 FA01 E504 BBE2) -- View this message in context: http://www.nabble.com/search-for...-tp17648809p17942108.html Sent from the pmapper users mailing list archive at Nabble.com. - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] search for...
Hello everyone, I have a problem with apostrophes in research an attribute! The fields with SANT'ANTONIO, SANT'AGATA produce no result! Someone knows how can I fix? - Salvatore Larosa GPG: 0xE504BBE2 (FP: D9B2 CA87 81CD 1B91 E24D 3B42 D0F7 FA01 E504 BBE2) -- View this message in context: http://www.nabble.com/search-for...-tp17648809p17648809.html Sent from the pmapper users mailing list archive at Nabble.com. - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] Search / zoomto error
Dears, when i try to zoomto an item of search result, nothing happen and in my php_error.log say : [06-Dec-2007 13:17:11] PHP Fatal error: Object expected as argument. in C:\ms4w\apps\pmapper-3.2-beta2\incphp\map.php on line 735. this is my layer LAYER NAME vias_dao STATUS ON TYPE line CONNECTIONTYPE postgis CONNECTION user=postgres password=ruyi4232 dbname=postgis host=localhost port=5432 DATA the_geom from vias_dao TEMPLATE silueta.html # LABELITEM NAME # LABELCACHE ON MINSCALE 10 MAXSCALE 14 PROJECTION proj=latlong ellps=WGS84 datum=WGS84 END METADATA DESCRIPTION Vias RESULT_FIELDS nombre RESULT_HEADERS NOMBRE END # Metadata CLASS Name 'vias_dao' COLOR 0 0 0 OUTLINECOLOR 0 0 0 LABEL SIZE TINY #tinysmallmediumlargegiant POSITION auto ANGLE AUTO BUFFER 1 #40 how close label are to each other MINDISTANCE 50 MINFEATURESIZE 30 TYPE truetype FONT arial SIZE 6 COLOR 0 0 0 SHADOWCOLOR 218 218 218 SHADOWSIZE 2 2 END END # Class END # Layer If you please help me best regards Cristian -- View this message in context: http://www.nabble.com/Search---zoomto-error-tf4958216.html#a14199697 Sent from the pmapper users mailing list archive at Nabble.com. - SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search / zoomto error
and what is written in the file \incphp\map.php in the lines before line 735...? Cristian_rougier wrote: Dears, when i try to zoomto an item of search result, nothing happen and in my php_error.log say : [06-Dec-2007 13:17:11] PHP Fatal error: Object expected as argument. in C:\ms4w\apps\pmapper-3.2-beta2\incphp\map.php on line 735. this is my layer LAYER NAME vias_dao STATUS ON TYPE line CONNECTIONTYPE postgis CONNECTION user=postgres password=ruyi4232 dbname=postgis host=localhost port=5432 DATA the_geom from vias_dao TEMPLATE silueta.html # LABELITEM NAME # LABELCACHE ON MINSCALE 10 MAXSCALE 14 PROJECTION proj=latlong ellps=WGS84 datum=WGS84 END METADATA DESCRIPTION Vias RESULT_FIELDS nombre RESULT_HEADERS NOMBRE END # Metadata CLASS Name 'vias_dao' COLOR 0 0 0 OUTLINECOLOR 0 0 0 LABEL SIZE TINY #tinysmallmediumlargegiant POSITION auto ANGLE AUTO BUFFER 1 #40 how close label are to each other MINDISTANCE 50 MINFEATURESIZE 30 TYPE truetype FONT arial SIZE 6 COLOR 0 0 0 SHADOWCOLOR 218 218 218 SHADOWSIZE 2 2 END END # Class END # Layer If you please help me best regards Cristian - SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] Search / zoomto error
Armin, yow are you...
This are the lines, I see your warning but I'm create the tables WITH OIDS
The search work ok, the trouble are the zoomto.
// Change projection to map projection if necessary
if ($changeLayProj) {
// If error appears here for Postgis layers, then DATA is not defined
properly as:
// the_geom from (select the_geom, oid, xyz from layer) AS new USING UNIQUE
oid USING SRID=4258
$resShape-project($qLayerProjObj, $mapProjObj);
}
$newResLayer-addFeature($resShape);
}
Look my table
CREATE TABLE vias_dao
(
gid serial NOT NULL,
fnode_ int4,
tnode_ int4,
lpoly_ int4,
rpoly_ int4,
length numeric,
vialidad_ int4,
vialidad_i int4,
fid_ int4,
id numeric,
nombre varchar(60),
categoria int8,
tipo int8,
sentido int4,
velocidad_ int8,
the_geom geometry,
CONSTRAINT vias_dao_pkey PRIMARY KEY (gid),
CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) =
'MULTILINESTRING'::text OR the_geom IS NULL),
CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = -1)
)
WITH OIDS;
ALTER TABLE vias_dao OWNER TO postgres;
And my search.xml
searchlist version=1.0
dataroot$/dataroot
searchitem name=vias_dao description=Calles
layer type=postgis name=vias_dao
field type=s name=nombre description=Calle wildcard=0
/
/layer
/searchitem
/searchlist
-Original Message-
From: Armin Burger [mailto:[EMAIL PROTECTED]
Sent: jueves, 06 de diciembre de 2007 13:58
To: Cristian_rougier
Cc: pmapper-users@lists.sourceforge.net
Subject: Re: [pmapper-users] Search / zoomto error
and what is written in the file \incphp\map.php in the lines before line
735...?
Cristian_rougier wrote:
Dears, when i try to zoomto an item of search result, nothing happen
and in my php_error.log say :
[06-Dec-2007 13:17:11] PHP Fatal error: Object expected as argument. in
C:\ms4w\apps\pmapper-3.2-beta2\incphp\map.php on line 735.
this is my layer
LAYER
NAME vias_dao
STATUS ON
TYPE line
CONNECTIONTYPE postgis
CONNECTION user=postgres password=ruyi4232 dbname=postgis
host=localhost
port=5432
DATA the_geom from vias_dao
TEMPLATE silueta.html
# LABELITEM NAME
# LABELCACHE ON
MINSCALE 10
MAXSCALE 14
PROJECTION
proj=latlong
ellps=WGS84
datum=WGS84
END
METADATA
DESCRIPTION Vias
RESULT_FIELDS nombre
RESULT_HEADERS NOMBRE
END # Metadata
CLASS
Name 'vias_dao'
COLOR 0 0 0
OUTLINECOLOR 0 0 0
LABEL
SIZE TINY #tinysmallmediumlargegiant
POSITION auto
ANGLE AUTO
BUFFER 1 #40 how close label are to each other
MINDISTANCE 50
MINFEATURESIZE 30
TYPE truetype
FONT arial
SIZE 6
COLOR 0 0 0
SHADOWCOLOR 218 218 218
SHADOWSIZE 2 2
END
END # Class
END # Layer
If you please help me
best regards
Cristian
-
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] search in postgis layer is always with wildcard
Armin, I found that the search in postgis layer is always with wildcard. It is not respecting wildcard=0 or wildcard=1 in search.xml . I just temporary replaced $qs .= $valoperator $f ~* '$wc1$val$wc2' ; by $qs .= $valoperator $f = '$val' ; to get it working without the wildcard. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search in postgis layer is always with wildcard
You need to read the docs. - wildcard=0 means that the query is *always* performed in a non-exact way, applying regex style pattern matching. In other words: the query is always performed as if the user had typed wildcards. For a user typed string pippo, in regex notation this would be data-match /pippo/. - wildcard=1 means that the search is using wildcards (*) that the user inserts - or not, like *pippo : regex /pippo$/. *pippo* : regex /pippo/ pippo : regex /^pippo$/ Typically useful in cases where there is a training for users and where they are taught how to use the application. all pattern matching is performed case-*IN*sensitive. If you want to use full exact search specify wildcard=2 as of pm 3.2 beta. This should give you data = pippo, case-sensitive. In most cases this is not very useful and I have mainly foreseen it for searches with options or suggest. This all is how it is intended to be, otherwise there is a bug ;-). armin ivan minčík wrote: Armin, I found that the search in postgis layer is always with wildcard. It is not respecting wildcard=0 or wildcard=1 in search.xml . I just temporary replaced $qs .= $valoperator $f ~* '$wc1$val$wc2' ; by $qs .= $valoperator $f = '$val' ; to get it working without the wildcard. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] search button
Hi, i have a problem about the width of button search,
when i change width in query.css:
div.searchitem input, select {
font-size : 9px;
background-color : #EBEBEB;
border-color : #003366;
border-width : 1px;
padding-top: 1px;
padding-left: 2px;
width: 18em;
vertical-align: middle;
}
also the button's (Ricerca) width changes like the input
forms, but i would like to have a smaller width
(50px)...Somebody could help me??
thank all,
marco zanieri
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search button
maybe this helps:
input.search_textinput {
width:18em;
}
instead of specifying the width in 'div.searchitem input, select'
armin
[EMAIL PROTECTED] wrote:
Hi, i have a problem about the width of button search,
when i change width in query.css:
div.searchitem input, select {
font-size : 9px;
background-color : #EBEBEB;
border-color : #003366;
border-width : 1px;
padding-top: 1px;
padding-left: 2px;
width: 18em;
vertical-align: middle;
}
also the button's (Ricerca) width changes like the input
forms, but i would like to have a smaller width
(50px)...Somebody could help me??
thank all,
marco zanieri
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search
Hi Gregor, It's a strange behavior... If you are using frame query visual option... don't you see no match found on frame window? Please can you post your search.xml file? W Gregor Mosheh ha scritto: Now for the last item: the search widget. I configured search.xml and it shows my new options for searching by road name, parcel owner name, etc. When I run a search, nothing happens. Is there an option I have to set to have searches work, as there was with the query info? -- Please no .doc, .xls, .ppt, .dwg: https://www.faunalia.it/dokuwiki/doku.php?id=public:OpenFormats Walter Lorenzetti email+jabber: [EMAIL PROTECTED] www.faunalia.it Cell: (+39) 347-6597931 Tel+Fax: (+39) 0587-213742 Piazza Garibaldi 5 - 56025 Pontedera (PI), Italy - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search
Walter Lorenzetti wrote: It's a strange behavior... If you are using frame query visual option... don't you see no match found on frame window? Correct; it displays nothing. Under Firefox, there's no JavaScript error either, FYI. The map is at http://69.59.158.6/pmapper/2/map.phtml I did make changes to the layout.js so the infoZone would be on the right instead of the bottom. Please can you post your search.xml file? Sure thing. http://69.59.158.6/pmapper/2/config/default/search.xml For the layer items, the shapefiles are named SampleParcels.shp and SampleParcels.shp -- Gregor Mosheh / Greg Allensworth System Administrator, HostGIS cartographic development hosting services http://www.HostGIS.com/ Remember that no one cares if you can back up, only if you can restore. - AMANDA - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] search
Now for the last item: the search widget. I configured search.xml and it shows my new options for searching by road name, parcel owner name, etc. When I run a search, nothing happens. Is there an option I have to set to have searches work, as there was with the query info? -- Gregor Mosheh / Greg Allensworth System Administrator, HostGIS cartographic development hosting services http://www.HostGIS.com/ Remember that no one cares if you can back up, only if you can restore. - AMANDA - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] Search function over a postgis layer problem.
Hi everyone First of all, I am testing pmapper with version p.mapper 3.1 beta4 (Mar 8, 2007) available in http://maptools.org/ms4w/index.phtml?page=downloads.html. The problem is the search function. When I search in a postgis layer this function goes wrong, however this same layer, converted to shape, is searched correctly by pmapper. This is the javascript error that returns the search in the postgis layer: Error: invalid flag after regular expression Source file: http://prueba1/pmapper/javascript/xmlhttp.js Line: 93, column: 11 Source code: bWarning/b: pg_query() [a href='function.pg-query'function.pg-query/a]: Query failed: ERROR: column quot;oidquot; does not exist at character 8 in bC:\ms4w\apps\pmapper-3.1-beta4\incphp\query\squery.php/b on line b666/bbr / I have followed the steps in http://svn.pmapper.net/trac/wiki/UpgradeInfo to define attribute search via /config/.../search.xml, but it seems dont take effect for postgis layers. I also have tried to download the stable version of pmapper from http://www.pmapper.net/download.shtml to try the search function in a postgis layer in this version, however this stable version seems to be wrong configurated, the demo map is not loading correctly ... Anyone can tell me something about this topics? Thanks in advance This is one of my postgis layers in the .map file and my search.xml: LAYER NAME 'casas_rurales' ### Defined like a postgis layer CONNECTIONTYPE postgis CONNECTION user=my_user password=my_passw dbname=gis host=prueba1 port=5432 DATA the_geom FROM public.casas_rurales Defined like a shape layer DATA C:\ms4w\apps\pmapper- 3.1-beta4\config\alojamientos\casas_rurales TYPE point STATUS ON TOLERANCE 10 TOLERANCEUNITS PIXELS METADATA DESCRIPCION casas_rurales RESULT_FIELDS nombre,desmun,direccion RESULT_HEADERS Nombre,Municipio,Direccion END # Metadata CLASSITEM gid CLASS NAME 'casa_rurales' MINSCALE 5000 MAXSCALE 25 TEMPLATE void STYLE SYMBOL 'icono_casas rurales' COLOR 0 0 0 OUTLINECOLOR 0 0 0 END END END SYMBOL NAME 'icono_casas rurales' TYPE pixmap IMAGE 'C:\ms4w\apps\callejero\iconos\ico_casas_rurales.gif' END the search.xml ?xml version='1.0'? !-- ?xml-stylesheet href=style.xsl type=text/xsl ? -- searchlist version=1.0 dataroot/dataroot searchitem name=casas_rurales description=Casas Rurales layer type=postgis name=casas_rurales field type=s name=nombre description=Casa: wildcard=0 / /layer /searchitem searchitem name=Comarcas description=Comarcas layer type=shape name=Comarcas field type=s name=comarcas description=Comarca: wildcard=0 / /layer /searchitem /searchlist - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search in IE
Dear Armin, I'm not sure it work for other encoding or not. My project use uft-8 encoding and problem with Thai character when search with IE not problem with FireFox. I just insert a line before line no.78 on xmlhttp.js 78 url = encodeURI(url); // add for thai search in IE before 78 req.open(GET, url, true); Work well for me. According to lazaros at http://www.nabble.com/PHP-and-AJAX-t3562272.html hope it help, Wirote Laongmanee 2007/5/17, Armin Burger [EMAIL PROTECTED]: It's a bit difficult to identify the problem. It is somewhere in the handling of an XMLHttp request where IE6 does not want to accept non-Ascii characters and the request fails. I never noticed this before. I will see how to fix it. armin ivan mincik wrote: Dear Armin, first, thanks for relasing beta 5. I would like to also draw attention to one bug in searching layers by attributes in non UTF layers (in my case windows-1250) in IE. In firefox of opera browsers, everything is OK. only IE is bad. When I try to find fo example string Šariš - nothing is found in layer - nothing is found in case when non UTF character is first in string. In the case of looking for Prešov I will get Predmier Prečín Prešov PrejtaPredajná Prestavlky Prenčov Preseľany Ipeľské Predmostie Preseľany nad Ipľom Thanks - 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 -- Wirote Laongmanee http://parn-site.blogspot.com - 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 in IE
Wirote thanks for the hint. I will add this as patch for v3.0 if somebody still wants to use this version. For v3.1 I got rid of this problem by using POST instead of GET requests for the AJAX calls. POST has not these prpblems of non Ascii characters in the parameter values. I think encodeURI has been introduced in JS 1.5, my reference manual is still as of 1.3 ;-) armin Original-Nachricht Datum: Thu, 31 May 2007 13:36:30 +0700 Von: wirote la [EMAIL PROTECTED] An: [EMAIL PROTECTED] CC: [EMAIL PROTECTED], pmapper-users@lists.sourceforge.net Betreff: Re: [pmapper-users] search in IE Dear Armin, I'm not sure it work for other encoding or not. My project use uft-8 encoding and problem with Thai character when search with IE not problem with FireFox. I just insert a line before line no.78 on xmlhttp.js 78 url = encodeURI(url); // add for thai search in IE before 78 req.open(GET, url, true); Work well for me. According to lazaros at http://www.nabble.com/PHP-and-AJAX-t3562272.html hope it help, Wirote Laongmanee 2007/5/17, Armin Burger [EMAIL PROTECTED]: It's a bit difficult to identify the problem. It is somewhere in the handling of an XMLHttp request where IE6 does not want to accept non-Ascii characters and the request fails. I never noticed this before. I will see how to fix it. armin ivan mincik wrote: Dear Armin, first, thanks for relasing beta 5. I would like to also draw attention to one bug in searching layers by attributes in non UTF layers (in my case windows-1250) in IE. In firefox of opera browsers, everything is OK. only IE is bad. When I try to find fo example string Šariš - nothing is found in layer - nothing is found in case when non UTF character is first in string. In the case of looking for Prešov I will get Predmier Prečín Prešov PrejtaPredajná Prestavlky Prenčov Preseľany Ipeľské Predmostie Preseľany nad Ipľom Thanks - 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 -- Wirote Laongmanee http://parn-site.blogspot.com -- 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
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
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
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
[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
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
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
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 in IE
It's a bit difficult to identify the problem. It is somewhere in the handling of an XMLHttp request where IE6 does not want to accept non-Ascii characters and the request fails. I never noticed this before. I will see how to fix it. armin ivan mincik wrote: Dear Armin, first, thanks for relasing beta 5. I would like to also draw attention to one bug in searching layers by attributes in non UTF layers (in my case windows-1250) in IE. In firefox of opera browsers, everything is OK. only IE is bad. When I try to find fo example string Šariš - nothing is found in layer - nothing is found in case when non UTF character is first in string. In the case of looking for Prešov I will get Predmier Prečín Prešov PrejtaPredajná Prestavlky Prenčov Preseľany Ipeľské Predmostie Preseľany nad Ipľom Thanks - 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 in IE
Dear Armin, first, thanks for relasing beta 5. I would like to also draw attention to one bug in searching layers by attributes in non UTF layers (in my case windows-1250) in IE. In firefox of opera browsers, everything is OK. only IE is bad. When I try to find fo example string Šariš - nothing is found in layer - nothing is found in case when non UTF character is first in string. In the case of looking for Prešov I will get Predmier Prečín Prešov PrejtaPredajná Prestavlky Prenčov Preseľany Ipeľské Predmostie Preseľany nad Ipľom Thanks -- Mgr. Ivan Minčík www.gpsmapy.sk tel: 0907 639 570 e-mail: [EMAIL PROTECTED] - 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 field encoding
Hello all. I have a problem with the search field, when i want to find something like Acámbaro, I get an error on Postgresql, It says than the word Ac\xe1mbaro is not a valid unicode. I have all my settings on UTF-8 Apache, Postgresql database, the metadata field on the map file, php.ini, config.ini I can't find where the text changes from Acámbaro that I write in the form field to Ac\xe1mbaro which postgresql get from php givin the invalid unicode. pmapper 2.1.2 apache 2.0.52 php 4.3.9 postgresql 8.1.9 postgis 1.1.6 OS: Linux Thanks -- Nahum Castro González León, Guanajuato, México - 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 display
Hi Armin, I tried by putting the code $clStyle-label-set(position, MS_AUTO); in the function 'pmap_addResultLayer()'.But it is not working.Please suggest me the code to add label in the function and at which line i need to put it. Thanks Regards radhika. On Thu, September 21, 2006 8:12 am, Armin Burger wrote: modify the function 'pmap_addResultLayer()' and add a label. armin Original-Nachricht Datum: Thu, 21 Sep 2006 02:48:18 -0400 (EDT) Von: Radhika radhikadubey at infobase.in An: pmapper-users at faunalia.it Betreff: [Pmapper-users] Search display Hi Armin, While performing search , the place is highlighted.But I also want to display place name of the highlighted place. Please suggest me what should I do to display name of the highlighted point or polygon. Thanks Regards radhika. - NOTICE: This e-mail message including any attachment (collectively the e-mail) may contain privileged and confidential information. Except for personal use by the intended recipient, or as expressly authorized by the sender, any person who receives this information is prohibited from disclosure, copy, distribute, or take of any action in reliance on the contents of this e-mailed information. If you are not the intended recipient, then please (i) do not read, forward, print, copy or otherwise disseminate this e-mail, (ii) notify us of the error by a reply, and (iii) delete this e-mail from your computer. Nothing in this communication is intended to operate as an electronic signature under applicable law. Compare Infobase will not be responsible for loss or damage arising from the use of the information transmitted by this email including damage from virus or some other third party intervention
[Pmapper-users] Search display
Hi Armin, While performing search , the place is highlighted.But I also want to display place name of the highlighted place. Please suggest me what should I do to display name of the highlighted point or polygon. Thanks Regards radhika. - NOTICE: This e-mail message including any attachment (collectively the e-mail) may contain privileged and confidential information. Except for personal use by the intended recipient, or as expressly authorized by the sender, any person who receives this information is prohibited from disclosure, copy, distribute, or take of any action in reliance on the contents of this e-mailed information. If you are not the intended recipient, then please (i) do not read, forward, print, copy or otherwise disseminate this e-mail, (ii) notify us of the error by a reply, and (iii) delete this e-mail from your computer. Nothing in this communication is intended to operate as an electronic signature under applicable law. Compare Infobase will not be responsible for loss or damage arising from the use of the information transmitted by this email including damage from virus or some other third party intervention
[Pmapper-users] Search display
modify the function 'pmap_addResultLayer()' and add a label. armin Original-Nachricht Datum: Thu, 21 Sep 2006 02:48:18 -0400 (EDT) Von: Radhika radhikadubey at infobase.in An: pmapper-users at faunalia.it Betreff: [Pmapper-users] Search display Hi Armin, While performing search , the place is highlighted.But I also want to display place name of the highlighted place. Please suggest me what should I do to display name of the highlighted point or polygon. Thanks Regards radhika. -- Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! Ideal f?r Modem und ISDN: http://www.gmx.net/de/go/smartsurfer
[Pmapper-users] search is missing in 1.2.0
I tried to upgrade from 1.1.0 to 1.2.0 everything is looking better good work But i notice that search is missing in bottom. I looked to frameview.phtm and have no changes I looked in search.phtml and have no changes Why is not showing search options in bottom like in versions 1.0.8 or 1.1.0 ?? -- Carlos Tim?teo Portugal
