[Mapserver-users] How to import mysql data in mapscript

Tue May 4 13:36:22 EDT 2004

This is a multi-part message in MIME format.

------_=_NextPart_001_01C431FE.50D74C70
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi all,

=20

Please let me know if it's possible at all. I am trying to import data
(which is not shape data, but just simple data like population of all
counties of a state) from a MySQL database, and query the shapefiles for
"Counties" based on the fields in the MySQL database.  The shapefiles
and the results from the MySQL query have nothing in common. They are
two totally different data sources. How can I integrate them?=20

=20

Has anyone done something like this? If yes, then how will you set the
values of 'data', 'classitem' and 'setexpression'   in the layer and
class objects?

If that's not possible, what else can be done to achieve the above
purpose?=20

=20

I have tried a lot of combinations to import data, and query the result
set, but was not successful to create the layer based on MySQL data.
Please help!

=20

With thanks,

=20

Abhishek

=20

=20

=20

=20

------_=_NextPart_001_01C431FE.50D74C70
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>
<!--
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:Arial;
	color:windowtext;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Hi all,<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

Please let me know if it&#8217;s possible at all. I =
am
trying to import data (which is not shape data, but just simple data =
like
population of all counties of a state) from a MySQL database, and query =
the shapefiles
for &#8220;Counties&#8221; based on the fields in the MySQL database. =
&nbsp;The
shapefiles and the results from the MySQL query have nothing in common. =
They are
two totally different data sources. How can I integrate them? =
<o:p></o:p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

Has anyone done something like this? If yes, then how =
will
you set the values of &#8216;data&#8217;, &#8216;classitem&#8217; and =
&#8216;setexpression&#8217;
&nbsp;&nbsp;in the layer and class objects?<o:p></o:p>

If that&#8217;s not possible, what else can be done =
to
achieve the above purpose? <o:p></o:p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

I have tried a lot of combinations to import data, =
and query
the result set, but was not successful to create the layer based on =
MySQL data.
Please help!<o:p></o:p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>With thanks,<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Abhishek<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

</div>

</body>

</html>

------_=_NextPart_001_01C431FE.50D74C70--