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, pro
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 c
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
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 :)
>
> gio
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 :
> Hi,
>
> You should try to define a view that will join the tables (for instance
> "SELECT gri
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 wi
you can virtually execute any SQL WHERE clause via the search using
the sql_where="" definition that you can apply on the database itself
via DB query tools. If you cannot create a SQL statement that gives
you back the results you need, then you will also not get in it in
p.mapper.
armin
On Thu,
Ok, I've read again the docs and the squery,php code. Now it's clear
how things work, and I see that the actual code doesn't permit what
I'm looking for...
I will try to code it and I will share if somthing useful comes out.
giovanni
2009/12/16 G. Allegri :
> Thanks Armin for the quick reply.
> T
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 | MU
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
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 r
11 matches
Mail list logo
