Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Need Code For MapQuest
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

shaneb
Junior Member

USA
319 Posts

Posted - 04 April 2002 :  02:06:41  Show Profile  Send shaneb a Yahoo! Message
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.

  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.28 seconds. Powered By: Snitz Forums 2000 Version 3.4.07