Page 1 of 1

Never used XML before - Need it for Google Maps App

Posted: Tue Jun 27, 2006 12:20 pm
by Luke
I am building an application that will request a record from a database, and put the results in an xml document for easy integration with google maps. The table fields will be as follows:

Business Name
Owner
Contact Person
Address1
Address2
City
State
Zip
Phone
Fax
Email
Website

Description Short
Description Long

Date Added
Date Suspended

How would I go about setting up an XML document to contain this information? Are there any tips to keep in mind while building the doc? Any advice would be appreciated.

Posted: Tue Jun 27, 2006 12:40 pm
by RobertGonzalez
My first crack it this...
(structure only)

Code: Select all

<root>
  <business>
    <BusinessName>
    <Owner>
    <ContactPerson>
    <Address1>
    <Address2>
    <City>
    <State>
    <Zip>
    <Phone>
    <Fax>
    <Email>
    <Website>
  </business>
  <description>
    <DescriptionShort>
    <DescriptionLong>
  </description>
  <dates>
    <DateAdded>
    <DateSuspended>
  </dates>
</root>
This is not meant to be actual XML code, but a quick crack at a possible structure of an XML document surrounding your data.