<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-874">
<META content="MSHTML 6.00.2800.1515" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Dear all, </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I need to create one layer on fly using
intersection. (Layer name are twy_sec and twy_su, new layer name
is twy_intersection) SO I write down in the map file which is not
working. Does anyone have suggestion?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT size=2>LAYER</DIV>
<DIV>
<P>CONNECTIONTYPE postgis</P>
<P>CONNECTION "user=postgres password=pt dbname=apms host=localhost"</P>
<P>DATA "intersection(twy_sec.the_geom, twy_su.the_geom) from twy_sec, twy_su as
foo using gid using SRID=-1"</P>
<P>NAME twy_intersection</P>
<P>TYPE POLYGON</P>
<P>STATUS ON</P>
<P># CLASSITEM "layer"</P>
<P>#LABELITEM "no_id"</P>
<P>#LABELMINSCALE 3000</P>
<P>LABELMAXSCALE 10000</P>
<P>TEMPLATE twy_su.html</P>
<P><FONT face=Arial></FONT> </P>
<P><FONT face=Arial>Do I have to put classitem? </FONT></P>
<P><FONT face=Arial></FONT> </P>
<P><FONT face=Arial>Thanks in advance. </FONT></P>
<P><FONT face=Arial>Thip</FONT></P></FONT></DIV></BODY></HTML>