Looking for a source for data and/or algorithm that would allow me to enter
a zipcode and find - in our case - every car dealership that sells, say,
Chevy's in that zipcode - if not there, then what about adjacent
zipcodes..? - in an ever expanding circle outward, and return a list of
those zipcodes.
In my database, I've already got the car dealers and available makes. What
I need is the zipcode "map" reference.
I am trying to write one.Are there any tools that I need to use to write it?(may be mapPoint?)I think that there are two ways to write the appication:Having database of all my dealers, each with latitude and longtitude.when the customer eneters his zip code, then I need to calculate how many dealers are in that area. I am trying to find some hints or script.
Having database of all my dealers. One table will have the dealers, the other table will have zip codes that each dealer service (some zipcodes have more than one dealer that service them, some dealers have many zipcodes that they service). Then when the customer enters his zipcode, i will use a query to find all dealers that service this zipcode?
I am writing an asp application using US Zipcodes.....I was wondering...apart from the zipcode format being different between Canada and the USA.....is the logic the same....I can't see any difference....but I was wondering if anyone else had encounter this.
View Replies View RelatedDoes anyone know how to display movie times from a particular zipcode stored in a DB? I need to find a website out there has a data feed that can be accessed with movie times. Anyone have any ideas?
View Replies View RelatedI have a web page that queries a database returning a recordset containing a whole series of URLs (host headers).
I want to display these in a table with one of the columns holding the current I.P. address for each URL. I know how to get a list of these IP addresses from the cmd prompt using "nslookup" but I'm absolutely clueless how to get hold of these values in my ASP page. I'm limited to the fact that this must be only ASP (VBScript, not .NET),
i.e. I can't call install any components.
I need help with a simple (well not so simple for me) password lookup script that will email a user their pw when they put their email in an input box. I have the db set up and the connection enabled but need some help w/ figuring out how to set it up to mail these out.
View Replies View RelatedOn the top of my page i want to check what page the user has come from, as if they havent come from two pages i wanted them to, i need to redirect them. Alot of people are bookmarking my site with a page that causes errors. Any ideas?
View Replies View RelatedDNS Lookup Error.This error resulted in the web browser that my user was using and this is details:"The URL you requested could not be retrieved because the named server is not registered in the domain name services. Please check the URL and try again."
I've checked with the user and find no fault with the URL address. What could possibly be wrong?
Is there a way that we can search a remote web page for a specific line of text?We can check if a specific URL exist using the "MSXML2.ServerXMLHTTP" object witch works just fine, but is there anyway we can search the page for text using this same object.
View Replies View RelatedDoes anyone know of a pure ASP way of doing this?I am displaying the results of a large recordset and at the moment it looks like the page is not doing anything.I have a solution using an image and some javascript, f there was a way of doing it in ASP, perhaps using the response buffer?
View Replies View RelatedI have a form on a webpage that someone enters a number (SponsorID).
After then enter that SponsorID into the form, I need to somehow query
my SQL database and find the record that has the same ID as the
SponsorID entered into the form and return the SponsorName (and write
it out on the page using a <div> tag or something of the like) WITHOUT
reloading the entire page (because I will loose the other information
already input on this page).
Now, I don't necessarly have to query the database, I *could* create
an Array when the page loads, using ASP, that will contain the
SponsorIDs and the SponsorNames and then compare the SponsorIDs within
that array with the number that was entered on the form.
I just received a database schema from our dba and was given the task of doing a look up of several fields & then doing several specific tasks, depending on the information. I know how to do a lookup and an if statement for 1 table, but how do I handle a lookup in multiple tables and also do an if statement based on multiple tables?
For example, there would be a customerid, which is in the customer table; support is in the support table; and customertype in the type table.
I need to look up what user name was used to login to a protected directory using ASP.
I don't want to create a login page, etc. It shouldn't be necessary. Only employees who already have user accounts need to log in to the webapp and the protected directory login box is all the security I need. I just need to be able to access the username that they used in my application. Code:
I'm trying to get a users free/busy status from exchange from within a website and using the code below, but when I run this a login page from MS Outlook Web Access is retrieved from the server rather than a XML file containing the users free/busy status for the specified time period.
I've spent all day looking for solutions to this but I'm stumped. I have been looking for an Exchange newsgroup but there doesn't seam to be one, does anyone know if i can post this some where else to get a response from an Exchange expert.
The Server is 2003, with Exchange 2003. Code:
I have a sql server 2000 table with a comma delimited list of ids. there is a seperate lookup table with a desc for each id.
I need for this data to be retuned in the same order in which the data was entered into the database. right now it is returning ordered by the id from the lutable.
Is it possible to do a database lookup in a javascript function *before* displaying the error alert?
We want to do a database table lookup first and get a BETTER error message based on the text field throwing the error.