<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>Dear List,<BR><BR>Sorry for this rather long message, but
I need to get an answer as soon as <BR>possible and want to be clear from the
beginning. I have a feeling that this <BR>can be useful to MANY newbies like me
out there.<BR><BR>I have some MySQL data (basically latitude, longitude, color
of the icon) <BR>that I want to plot on a map.<BR><BR>This is rather
urgent...<BR><BR>1.<BR>I use the SQLQuery Widget to get the data and tried out
the <BR>"MapImageSharedResource" Widget which sounded very promising, extracting
<BR>directly the points from the sharedresource returned by the
SQLQuery.<BR><BR>Here is an extract of the code I used with the
"MapImageSharedResource" <BR>Widget:<BR>__________<BR><CWC2 Type="SQLQuery"
sqlquery="SELECT latitude, longitude FROM dealer" <BR>Server="localhost"
DBTYPE="MYSQL" Database="test2" UserName="root" <BR>Password="1234"
SharedResourceName="MyResult2"><BR> <ONEVENT
Event="ConnectFailed" Text="Connection failed."/><BR>
<ONEVENT Event="SelectDBFailed" Text="Databse don't
exist."/><BR> <ONEVENT Event="QueryFailed" Text="Query
failed."/><BR> <ONEVENT Event="NoRowReturned"
Template="noresult"/><BR> <ONEVENT Event="GeocodeFailed"
Template="error"/><BR></CWC2><BR><BR><CWC2
TYPE="MapImageSharedResource" id="inline" Width="500" Height="250"
<BR>Navigable="false" Transparent="true" SYMBOLOVERLAP="true"
<BR>AUTOEXTENT="false"><BR> <POINTS NAME="START"
SRNAME="MyResult_IMAGE" SRLATCOL="latitude" <BR>SRLONCOL="longitude"
type="unique" LABEL="Team [$MyResult_IMAGE.Id]"/><BR>
<MAP POINT="START" TYPE="STYLE" PARAM="color"
VALUE="00FF00"/><BR> <MAP POINT="START" TYPE="STYLE"
PARAM="size" VALUE="25"/><BR> <POINTS NAME="END"
SRNAME="Elu" SRLATCOL="gps_lat_degree" <BR>SRLONCOL="gps_long_degree"
type="unique" LABEL="Team [$Elu.team_id]"/><BR> <MAP
POINT="END" TYPE="STYLE" PARAM="color" VALUE="0000FF"/><BR>
<MAP POINT="END" TYPE="STYLE" PARAM="size"
VALUE="20"/><BR></CWC2><BR>___________<BR>Unfortunately this doesn't
work well. After some tweaking I got the map <BR>generated OK but a lot of error
messages in the web page which cannot be <BR>removed.<BR><BR>Error
message:<BR>Notice: Undefined property: sName in
<BR>C:\ms4w\apps\chameleon\htdocs\common\wrapper\map_session.php on line
1073.<BR><BR>I went through all the material online I could find but I simply
could not <BR>make it work well. Am I missing something?<BR><BR>I use ms4w_1.2.2
and chameleon_ms4w-2.2<BR>Is it possible that the versions I use do not work
properly (too new?). I <BR>also tried ms4w_1.3.0 but that gave even more errors
with PHP (not even the <BR>Cameleon samples worked!)<BR><BR>2.<BR>I have
generated a pretty nice environment based on the Chameleon samples, <BR>using
the MapDHTML widget for the map. Unfortunately I do not know how to <BR>get
MySQL points on it via the mapserver.<BR><BR>Can the MapDHTML Widget also get
points added to it in the same way as the <BR>MapImageSharedResource Widget
can?<BR><BR>3.<BR>Anotherway around... If the MapImageSharedResource works
correctly, is it <BR>possible to make it behave as the MapDHTML widget
(Navigation...) so it can <BR>be integrated instead of it in the Chameleon
samples?<BR><BR>A lot of questions from a desesperate newbie... (I went through
the Mailing <BR>lists and could not get the answers...)<BR><BR>Best
Regards,<BR><BR>Carlo Tronnberg</BODY></HTML>