Hello,
I'm using Mapserver 6.0.1 with the following PostGIS layer:
http://pastie.org/private/84042k84vmljbontls5xvq
The user has the possibility to select quite a lot of filters, which
implies that the SQL query should, in theory ,be generated dynamically.
As this is not possible with
Hi,
So you have tried to define variables %SEX% and %BOD_ID%, used them inside your
DATA and then fired WMS GetMaps by adding SEX=your_valueBOD_ID=your_id? Does
in not work or why it is not powerful enough?
-Jukka Rahkonen-
Julien Cigar wrote:
Hello,
I'm using Mapserver 6.0.1 with the
At the SQL level, you can do some fancy work with CASE and setting some
default values
The CASE function allows you to set all kind of logical comparisons. You
can do conditional joins that way, setting the join condition to a non
matching value when you don't want the join, etc. SQL is more
And perhaps, if you would like to do something very tricky, you could create a
function or stored procedure into your database and call that from DATA with
the dynamic variables? The compute_style thing in this thread suggests that it
might work
On 09/21/2012 13:30, Rahkonen Jukka wrote:
And perhaps, if you would like to do something very tricky, you could create a
function or stored procedure into your database and call that from DATA with
the dynamic variables? The compute_style thing in this thread suggests that it
might work
On 09/21/2012 13:24, Smith, Michael ERDC-RDE-CRREL-NH wrote:
At the SQL level, you can do some fancy work with CASE and setting some
default values
The CASE function allows you to set all kind of logical comparisons. You
can do conditional joins that way, setting the join condition to a non
On 09/21/2012 13:24, Smith, Michael ERDC-RDE-CRREL-NH wrote:
At the SQL level, you can do some fancy work with CASE and setting some
default values
The CASE function allows you to set all kind of logical comparisons. You
can do conditional joins that way, setting the join condition to a non
I think that¹s correct for ansi syntax
Mike
On 9/21/12 8:13 AM, Julien Cigar jci...@ulb.ac.be wrote:
On 09/21/2012 13:24, Smith, Michael ERDC-RDE-CRREL-NH wrote:
At the SQL level, you can do some fancy work with CASE and setting some
default values
The CASE function allows you to set all
On 09/21/2012 14:22, Smith, Michael ERDC-RDE-CRREL-NH wrote:
What I've done is have the join in the sql but either join it to the
correct join column or join it to a null match (and make it an outer
join).
I typically use oracle syntax and not ansi syntax but the trick is to have
all the table