shaneb
Junior Member
USA
319 Posts |
Posted - 04 April 2002 : 02:06:41
|
Can anybody help me out here?
I'm trying to figure out a way to write the code to do the following:
Using Mapquests LinkFree URLs I want to pull the following fields out of an Access database and put them in a link. See http://www.mapquest.com/solutions/product.adp?page=linkfree
My db is called homes.mdb The Table is called properties. The fields I want to pull are Address, City, Province, Postal_Code, and Country.
Mapquest states the following on their website: General URL Parameters: The following parameters may be included in the URL.
Example: http://www.mapquest.com/maps/map.adp? city=denver&state=CO&address=1565+california+st&zip=80202&country=us&zoom=5
The following address field combinations can be used:
Address, city, state and ZIP code Address, city and state Address and city City and state If ZIP code doesn't match the other information, it is ignored.
Other URL Restrictions:
The URL must follow standard HTML rules:
There can be no carriage returns in the URL There can be no spaces within the HREF. Replace spaces with the plus sign (+). Special characters within the URL must be replaced by their octal equivalent, because the CGI on the MapQuest site interprets them incorrectly.
Use %%25 to represent the % character Use %%26 to represent the & character Use %%30 to represent the + character
My db field almost matches up with the fields in the link above. All except State and Zip Code. Zoom is a constant that will be set to 5.
My Fields Mapquest Fields
Address Address City City Province State Postal_Code Zip Country Country
What is the code that will pull the fields out of the dB and place them in a URL to show a map of a particular record. I need the map to open in a new window or use the HTTP XML object to parse the map somehow.
Can anyone help. I'm not too good with ASP yet.
Thanks
'Surround your mind and you shall see a great future ahead'
Shane B.
|
|