Find Distance Between US Cities Using Zipcodes
I have a database having, US zipcodes, longitude and latitude. What I want to do is LIST THOSE ZIPCODES which are at a distance of given miles from a particular zip code.
For Exmaple: I want to find the zip codes which are at a distance of 15 miles from zipcode 10001 (NYC).
I have the script that uses Zipcodes, latitudes and longitudes of two cities and caculate the distance. But it calculates distance.
View Replies
ADVERTISEMENT
I am looking for a way create a distance calculator from city to city, zip to zip, so on so forth. I know this has been done many times. Does anyone have this around by any chance. Also does anyone know of a place I can get the db or text file I need for this? I know there are some floating about but haven't came across a decent one yet.
View Replies
View Related
I am working on a search which is used to search for something in cities of US.I want to add an option of "include nearby cities".When the user checks this it should bring up the cities near to that also.
so if the users enters city " LOS ANGELS " and state " California".It should bring up some results in california as well as cities near to californai.
Also i have another requirement in this search which is distance search.User will search for something with the option of with 5 or 10 or 15 or 25 etc., miles , so the same above results should occur.
My database contains two fields longitude and latitude.But i do not understand how to use this " include nearby cities" and for distance search.
View Replies
View Related
I want to use something like Streetmap.co.uk's ActiveX Component on a website so that a visitor can enter a startpoint and destination and I can calculate the distance by road between those 2 points.
This is for a website I'm writing for a mate of mine who owns a Courier firm. He wants to be able to provide online quotes to potential customers. I'm going to be using Brinkster as the webhost so I won't be able to install any Server-side DLL's, etc. Is there anything available to do this?
View Replies
View Related
I am trying to find a software that can find distance between two ZIP codes. I think most of them do it by having the longtitude and latidute of each ZIP, and substract. But this gives the air distance. Where can I find software that find the ground distance (like in Mapquest).
View Replies
View Related
I have a site and i have a text box for someone to type in a zip code. i nee dto know how to program, or locate a database, where the results will display my business location(s) by zipcode and display the total distance between the zip code entered by the visitor to the site, and my locations.
like Midas has on their site (www.midas.com) where you type in a zip code and it returns the store locations and how far away they are from you.
View Replies
View Related
anyone knows what the formula is for finding a distance betweeen 2 zip codes?
View Replies
View Related
I am using this code to produce a distance from two LONg, LAT from two different tables. Can any one help me write the code so that it can pull from the correct tables and then insert into one field in on table. Code:
View Replies
View Related
Any recommendations for a freeware zip code distance program? I need the client to be able to select all clients living within a certain distance of his or her zip.
View Replies
View Related
Is it possible to have some sort of hyperlink or long distance odbc connection so that I can get pages on my server here to draw from a database that is at a different location? How would this be done?
View Replies
View Related
Alright, in regards to my previous post of finding a DB that has all of the latitude/longitudes in a DB, I need to now filter through those based on search criteria. The search criteria available includes: Code:
View Replies
View Related
I have the following code that I am trying to use to calculate distance. However I keep getting a Type Mismatch error on line 50 which is in bold. Code:
View Replies
View Related
However, when i opened a page on my pc the database string was:
DBFolder = path & "..mysqldataformuladata
I cant find the folder in question. Even when ftping.
Any ideas where is could be lurking?
View Replies
View Related
I am trying to locate a file using the following code
Set objXMLHTTP = Server.CreateObject("MSXML2.ServerXMLHTTP")
strURL = "http://server/ApprovedAutoCAD/140-00007-01.dwg"
objXMLHTTP.Open "GET", strURL, False, "login", "password"
objXMLHTTP.Send
strReturn = objXMLHTTP.status
I get a 404 status back indicating that the file is not found, which is incorrect. I am able to locate XLS and DOC files on the same directory. Any ideas why I cannot find a DWG (Drawing) file?
View Replies
View Related
I am not sure if this is a question for this forum or the IIS forum but here goes. I have a dedicated server on which I am hosting about 80 websites at the moment, all of which have been created by copying a template site. All of these sites have an identical structure and are located in the same directory on the server, C:Inetpubvhosts. Several times when I have needed to make an adjustment to the sites I have to go into the remote desktop connection to the server and go site by site, copying and pasting files. For example, as each site has the same pages, ie., map.asp, sometimes I make a change to that page and have to copy it to every site. Could I write some sort of script using the FSO and execute it from one site and have it loop through each site on the server making the neccessary change(s)?
View Replies
View Related
if i use the physical path where the database is located then my code works fine
such as ("e:folderabc.mdb")
but when i use the server.mappath("abc.mdb") , i get error
View Replies
View Related
The dreaded missing end statement
I need another set of eyes mine are about to cross.
My Error
Microsoft VBScript compilation error '800a03f6'
Expected 'End'
calendar.asp, line 289
My code:
View Replies
View Related
We have several pages that are running very slow, is there any way to
identify which pages are taking the longest to process?
View Replies
View Related
At first glance, the question in the subject line seems way too easy. But I
am finding some situations in my app where the value in a variable is some
sort of blank-like value, such as Null or " " or "", but I cannot tell
which.
Of course, in order to find out the value, I did a response.write, and added
a nonsense word afterward, to help make sure it is writing it out for me.
First, I tried to check for null: Code:
View Replies
View Related
How do I go about testing to see if a value is not equal to NULL? isNULL provides the opposite functionality, but all my attempts at the former return a FALSE value.
View Replies
View Related
I want to know how to find out who is sending visitors to my site. So i obviusly need to find out who a visitors referer is.
I took a guess and thought that this is what I should use:
request.ServerVariables("HTTP_REFERER")
But that does not return anything. Any ideas guys?
View Replies
View Related
Based on what the user selects in a combo box I need to find the value from another column in the same record. This is what I am using:
rsPrice.movefirst
rsPrice.Find "Component='Desktop'"
If (rstPrice.BOF = True) or (rstPrice.EOF = True) Then
response.write("The Price for the Component Not Found")
else
curPrice =rsPrice("Score")
End If
I keep getting an error messages:
Microsoft OLE DB Provider for SQL Server (0x80040E29) Rowset does not support scrolling backward.
View Replies
View Related
can u tell me how to find the quoteint in asp
for e.g
290 / 100 = 2
I want result 2 but it gives 2.9
View Replies
View Related
where i can get very professional and sophisticated images for my web sites ( even if i have to pay for them )
View Replies
View Related
I'm coding in classic asp and can't figure how to get IE6 to display some kind of descriptive message about code errors? I have the correct settings under ADVANCED in IE's options selected.
What bugs me is sometimes IE will report the line number and a message, and then other times it's the standard "The page can't be displayed." When you have hundreds of lines of code, how can you fight this?
View Replies
View Related
How can i count the number of times a string appears within another string.
View Replies
View Related
i have 2 columns. called wintersubjects,summersubjects . the data in the columns will be 4 subjects.
maths
science
arts
social science
i want to find out the count for all of them.
View Replies
View Related
I am attempting the following for a real estate website. I want to list the agents for the office all of whom have a unique identifier with an Auto Number type. As I loop through the recordset, I also want to open another table called listings. This table has a field called agent whose value is a number and corresponds to an agent in the agent table.
If there is a listing in the listing table, I want to insert a link to "View Listings", if not, no link. I am having a hard time doing this and if someone could point me in the right direction I'd appreciate it. I tried the Find method but to no success.
View Replies
View Related
I want to find numbers in one comma seperated string which are not in another one. For instance if I have two strings "strString1" and "strString2 how can I find numbers in "strString1" which are not in "strString2" Example:
strString1 = "1,3,6,12"
strString2 = "1,6"
In this case the numbers I want to end up with are 3 and 12.
View Replies
View Related
I am working on a survey and I have gotten the pages done to collect the data but now I am having trouble finding the correct syntax for displaying some of the data back to the user. I basicly need one to do this
Text on site <field1*field2*1.5> More Text on site.
and a seperate one to do this:
if field1=a then write "message one"
if field2=b then write "message two"
View Replies
View Related
I'm working on something at the moment which pulls through a url to another page if it exists. I've got that bit working.
The bit I don't know how to do (real asp beginner here) is to check if the url has http:// in it, and if it has, remove it.
View Replies
View Related
I have one doubt in my asp code (or) in HTML.
How to find coordinates on the image for display the text on that image....
View Replies
View Related
I am wondering if there is a command to determine what the current directory is.
My reason for this is that i have a include file called connection.asp sat in a folder called Data. My connection.asp file holds the connection details. I need to determine whether the file calling the include is in the root folder or not.
EG. if it is the root folder the location of the db will be "Data/dbMarkShop.mdb" but if it is another folder, say a Scripts folder, the location of th db would be "../Data/dbMarkShop.mdb"
View Replies
View Related