Getting Started with SQL & XML direction please

Hello everyone,
I am working on a project and I need some help getting started in the
right direction. But first let me give you some background on what I
want to do, I work for an ambulance company and our ambulances are
equipped with GPS receivers and the data of the LAT and LONG are
transmitted and stored in a MS-SQL 2000 DB. This data is transmitted
every ~30 seconds as the unit drives around the county. The data is
then used in a 32-bit client application in our main office.
I want to build a web page that our field supervisors can monitor from
their SUV's, the locations of the ambulances (via a laptop and wireless
card).
I have played a little with Google and Yahoo Map API's and I think I
like the Yahoo best. I have built a static xml file with three
ambulances and the LAT and LONG for each and was able to display in the
information on the webpage map
(http://api.maps.yahoo.com/maps/v1/a...s.com/route.xml).
The problem is that I am not sure how to create this document
dynamically when a user hits the web site. As the XY of the ambulances
are constantly changing it can not be a static xml document.
I am not sure what tools I need to make this happen and how to go about
it.
I am reading all I can about javascripts, Yahoo API and XML and my head
is starting to spin a little. I think I need a push in the right
direction.
Thanks all who might reply!
Jim P
Largo, FlOn 29 Sep 2005 12:01:08 -0700, Jim wrote:

> Hello everyone,
> I am working on a project and I need some help getting started in the
> right direction. But first let me give you some background on what I
> want to do, I work for an ambulance company and our ambulances are
> equipped with GPS receivers and the data of the LAT and LONG are
> transmitted and stored in a MS-SQL 2000 DB. This data is transmitted
> every ~30 seconds as the unit drives around the county. The data is
> then used in a 32-bit client application in our main office.
> I want to build a web page that our field supervisors can monitor from
> their SUV's, the locations of the ambulances (via a laptop and wireless
> card).
> I have played a little with Google and Yahoo Map API's and I think I
> like the Yahoo best. I have built a static xml file with three
> ambulances and the LAT and LONG for each and was able to display in the
> information on the webpage map
> (http://api.maps.yahoo.com/maps/v1/a...s.com/route.xml).
> The problem is that I am not sure how to create this document
> dynamically when a user hits the web site. As the XY of the ambulances
> are constantly changing it can not be a static xml document.
> I am not sure what tools I need to make this happen and how to go about
> it.
> I am reading all I can about javascripts, Yahoo API and XML and my head
> is starting to spin a little. I think I need a push in the right
> direction.
> Thanks all who might reply!
> Jim P
> Largo, Fl
In the webpage, you could first "SELECT" the latest data from the table by
using "FORXML" clause. This should give you the XML string with the data
you need. If needed you can format the xml using xsl transform or
something. Then you could call the yahoo maps api page and pass the XML
string as the "xmlsrc" querystring parameter.
HTH,
Ayyappan Nairsql