<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-9" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hello Murat!<br>
<br>
What I would do (as I always do when queries get complex) is create a
view in the mysql database and call that view. That will speed up
performance and give you less chance of error in your mapfile.<br>
<br>
So in MySQL:<br>
<br>
CREATE OR REPLACE VIEW MyVIEW as <br>
SELECT <br>
d_damage as damage,<br>
m_village1.name as villagename,<br>
m_village1.latitude as latitude,<br>
m_village1.longitude as longitude, <br>
sum(d_damage.deadp_rc + d_damage.deadp_wood + d_damage.deadp_briq +
d_damage.deadp_brick + d_damage.deadp_stone + d_damage.deadp_adobe) as
totaldamage<br>
from <br>
d_damage, <br>
m_village1 <br>
where <br>
d_damage.region_id=m_village1.dist_id <br>
<br>
And in the MapFile;<br>
select latitude, longitude, totaldamage from myVIEW where
d_damage.eq_id like "%eq_id%" and m_village1.name not like "%(%"<br>
<br>
<br>
This will make life less complicated, plus you can test the query
better in mySQL!<br>
<br>
<br>
Murat Beyhan schreef:
<blockquote cite="mid:46C2FB2D.702@deprem.gov.tr" type="cite">Dear
Friends,
<br>
<br>
I would like to draw a casualty distribution map for various building
types.
<br>
<br>
On the srcSQL as you see I need summation of the casualties of each
type of buildings(rc,wood,briq,brick,stone,adobe)
<br>
So I have used sum function to obtain total number of casualties. But
when I tried to make legend I have to select classitem so I have used
AS totald for that reason
<br>
then I have used totald as a classitem.
<br>
But mapserver returns an error message.
<br>
<br>
When I select only one item for select query for example select
d_damage.deadp_wood from d_damage
<br>
then If I use deadp_wood as classitem the query works and the map
drawn.
<br>
<br>
For my intend what I have to do?
<br>
Regards...
<br>
MURAT
<br>
<br>
script: as follows
<br>
<br>
<br>
LAYER
<br>
NAME "Dhuman"
<br>
CONNECTIONTYPE OGR CONNECTION '<OGRVRTDataSource>
<br>
<OGRVRTLayer name="Dhuman">
<br>
<SrcDataSource>MYSQL:turkey,user=root,password=mysql_123,host=localhost,port=3306,tables=d_damage
m_village1</SrcDataSource>
<br>
<SrcSQL>SELECT m_village1.latitude,m_village1.longitude,
*sum(d_damage.deadp_rc + d_damage.deadp_wood + d_damage.deadp_briq +
d_damage.deadp_brick + d_damage.deadp_stone + d_damage.deadp_adobe) as
totald *from d_damage, m_village1 where d_damage.eq_id like "%eq_id%"
and d_damage.region_id=m_village1.dist_id and m_village1.name not like
"%(%"</SrcSQL>
<br>
<GeometryType>wkbPoint</GeometryType>
<br>
<GeometryField encoding="PointFromColumns" x="longitude"
y="latitude"/>
<br>
</OGRVRTLayer>
<br>
</OGRVRTDataSource>'
<br>
TYPE POINT
<br>
DATA Dhuman
<br>
STATUS default
<br>
CLASSITEM "totald"
<br>
CLASS
<br>
NAME "HUMAN DAMAGE"
<br>
EXPRESSION ([totald] < 0)
<br>
# COLOR 255 0 255
<br>
# SYMBOL "cpoint"
<br>
# SIZE 12
<br>
END
<br>
<br>
<br>
<br>
CLASS
<br>
NAME "1-10"
<br>
EXPRESSION ([totald] GE 1.0 AND [totald] LT 10.0)
<br>
SYMBOL "cpoint"
<br>
SIZE 5
<br>
COLOR 255 250 250
<br>
END
<br>
<br>
CLASS
<br>
NAME "11-50"
<br>
EXPRESSION ([totald] GE 11.0 AND [totald] LT 50.0)
<br>
SYMBOL "cpoint"
<br>
SIZE 5
<br>
COLOR 248 248 255
<br>
END
<br>
<br>
CLASS
<br>
NAME "51-100"
<br>
EXPRESSION ([totald] GE 51.0 AND [totald] LT 100.0)
<br>
SYMBOL "cpoint"
<br>
SIZE 5
<br>
COLOR 255 250 240
<br>
END
<br>
CLASS
<br>
NAME "101-200"
<br>
EXPRESSION ([totald] GE 101.0 AND [totald] LT 200.0)
<br>
SYMBOL "cpoint"
<br>
SIZE 5
<br>
COLOR 102 255 204
<br>
END
<br>
CLASS
<br>
NAME "201-400"
<br>
EXPRESSION ([totald] GE 201.0 AND [totald] LT 400.0)
<br>
SYMBOL "cpoint"
<br>
SIZE 5
<br>
COLOR 102 53 0
<br>
END
<br>
CLASS
<br>
NAME "400<"
<br>
EXPRESSION ([totald] GT 400.0)
<br>
SYMBOL "cpoint"
<br>
SIZE 5
<br>
COLOR 102 153 255
<br>
END
<br>
END
<br>
<br>
<br>
<br>
the error message as follows:
<br>
<br>
msDrawMap(): Image handling error. Failed to draw layer named 'Dhuman'.
<br>
msOGRFileOpen(): OGR error. Open failed for OGR connection `
MYSQL:turkey,user=root,password=mysql_123,host=localhost,port=3306,tables=d_damage
m_village1 SELECT m_village1.latitude,m_village1.longitude,
sum(d_damage.deadp_rc+ d_damage.deadp_wood +d_damage.deadp_briq +
d_damage.deadp_brick + d_damage.deadp_stone + d_damage.deadp_adobe) as
totald from d_damage, m_village1 where d_damage.eq_id like
"200006060242-auto-000" and d_damage.region_id=m_village1.dist_id and
m_village1.name not like "%(%" wkbPoint '. SQL statement failed, or
returned no layer result: SELECT
m_village1.latitude,m_village1.longitude, sum(d_damage.deadp_rc+
d_damage.deadp_wood +d_damage.deadp_briq + d_damage.deadp_brick +
d_damage.deadp_stone + d_damage.deadp_adobe) as totald from d_damage,
m_village1 where d_damage.eq_id like "200006060242-auto-000" and
d_damage.region_id=m_village1.dist_id and m_village1.name not like
"%(%"
<br>
<br>
<br>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<title>3DSite</title>
<meta http-equiv="Content-Type" content="text/html; ">
<style type="text/css">
<!--
body {
background-color: #FFFFFF;
margin-left: 5px;
margin-top: 5px;
margin-right: 5px;
margin-bottom: 5px;
}
body,td,th {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
color: #333333;
}
.style4 {font-size: 9px; }
.style5 {font-size: 9px; color: #CCCCCC; }
-->
</style>
<meta content="MSHTML 6.00.2900.2912" name="GENERATOR">
<br>
<table border="0" cellpadding="0" cellspacing="0" width="400">
<tbody>
<tr>
<td rowspan="3" align="left" height="0" valign="bottom" width="15"><br>
</td>
<td colspan="2" align="left" height="78" valign="top" width="0">
<p class="style4">Milo van der Linden
<br>
<a href="skype:milovanderlinden?add">skype: milovanderlinden</a><br>
<a href="mailto:mlinden@zeelandnet.nl">mlinden@zeelandnet.nl</a><br>
<a href="mailto:milovanderlinden@gmail.com">milovanderlinden@gmail.com</a><br>
<a href="mailto:milo@3dsite.nl">milo@3dsite.nl</a><br>
<a href="http://www.3dsite.nl">http://www.3dsite.nl</a><br>
</p>
</td>
<td rowspan="3" align="left" height="0" valign="top" width="15"> </td>
<td valign="top" width="300">
<p class="style5"><span lang="NL">De informatie in dit bericht
reflecteert mijn persoonlijke mening en niet die van een bedrijf of
instantie. Aan de informatie kunnen geen rechten worden ontleend.
Indien dit bericht onderdeel is van een forum, mailing-list of
community dan gelden automatisch de bij het betreffende medium
behorende voorwaarden.</span>
<span lang="EN">The information in this message reflects my
personal opinion and not that of a company or public body. All rights
reserved.If this message is contained in a mailing-list or community,
the rights on the medium are automatically adapted.</span></p>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>