[mapserver-users] Different color for each row and it's child

[Lee Keel]

I had a client request something that sounds really cool, but I don't
know how to do it (or if it is even possible in mapserver).

 

First, my setup:

I am running MS4W 2.6 on windows xp against postgis 8.2 database.  I
have table A that has anywhere from 4 to 35 rows.  And table B which
could have several hundred rows each relating back to one of the rows
from table A.

 

For Example:

TableA

 

ID                            Name

1                                             t

2                                             t2

3                                             t3

4                                             t4

 

 

TableB

ID            ta_id                      Value

1              1                              something

2              1                              something else

3              1                              test

4              2                              foo

5              2                              bar

6              3                              done

 

Now my problem:

The client would like to see all the rows rendered from tableA as
different colors.  These colors can be random, it doesn't matter.  On
top of this, they want to see all the associated rows in tableB as the
same color as their parent from tableA.

 

Can I add a column to tableA and use that as a value in the mapfile for
the style?  And if so, how?

 

I would greatly appreciate any help that anyone can provide.

 

Thanks in advance,

Lee

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080915/f3d6bdb9/attachment.htm>