Distance Search

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


ADVERTISEMENT

Asp Zip Code Distance Search

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

Distance Calculator

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

Distance Between Two Zip Codes

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

Find Out Distance Calculator?

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

Distance Betweeen 2 Zip Codes

anyone knows what the formula is for finding a distance betweeen 2 zip codes?

View Replies View Related

Distance From Two Tables To Insert In One

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

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 View Related

Know Any Freeware Zip Code Distance Program?

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

Long Distance ODBC Connections

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

*Efficiently* Calculate Distance Between Two Zip Codes

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

Microsoft VBScript Runtime Error '800a000d' Type Mismatch 'Distance' Problem

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

Need To Convert Google Search Ref To Find What The User Search

i get the ref url that come to my site and i want to convert it to find
out what was the query in (google or other searcher sites)

foe example : if someone goes to google and search some text and my
site was in his resaults and he click on it , in my site i see his link
ref like
http://www.google.co.il/search?hl=i...91-Google&meta=

i want to know (in asp and save it to DB) what was the word or words
that the user write in search engine.

View Replies View Related

Search Within Search Results

I am trying to create a parametric search within a table (in the column headings). My first page (search.asp) allows you to choose parameters from a dropdown box, such as package and volts. You click "search" and it reads the Access dbase to yield the results.

The results page (results.asp) displays the information based on the parameters. Under the package column heading, I have the same drop down box, and I am able to once again choose the package I want and the table will refresh. Code:

View Replies View Related

Search Box

I have list of songs in table in asp page. I would like to put a link to each song so when user click on one I can search database for it's data. How to do that?

View Replies View Related

Search

i have a database with 5 tables,
on my web site i have a search bar..
i wana link that search bar to my tables so..
when ever some 1 searchs for a product, the search bar shows that all the simmuler products to what they searchd for..

View Replies View Related

ASP Search Using Asp

I was wondering if there was a way to search pages using ASP or ASP.NET.

I have roughly 5000 static html pages (an online library of sorts) and wants a serch feature. Is there any way to do this?

View Replies View Related

Search

how to search within the selected category?? Example : Search "bubble clock" in category,Clock and watches.

View Replies View Related

Search

I have a search page that has ms frontpage database wizard results showing. The thing is, is that I want to have the search form on other pages besides my search.asp page. Does anybody know how to make a search form on a seperate page that submits the search to the database and displays the wizard results on the search page.

View Replies View Related

Search When EOF And Not EOF

Need help here~ =) ..For -> while not rsConfiguration1.EOF ... blah blah blah

How to write my code so that even if its not End of record, it will still search my db?

In short : I want the db to be able to search under 2 circumstances : EOF and not EOF

View Replies View Related

Search

How could I try and make the most important result from a search show up on top?
I was thinking of having a result where the strSearch is the most to the left come up on top but else then that vague and not necessarly effective option I have no idea on how to do this.

View Replies View Related

Search

Intranet tech support system using ASP/VBScript running on W2000 Server,
IIS, and using SQL Server 2000. I need to add a search engine. The problem
with using a regular SQL query is that if you put a phrase, say "red car" in
the text box, to hit submit, my SQL qurey would only look for that phrase,
and would leave out other items where the words red and car appeared
separately. I guess what I am saying is that I would like something like
Google or other search engines, which would find results which seem to fit
the criteria typed into the box, and rank them and highlight key words.
My research so far has shown me that SQL Server has something called
Full-Text searching, and I have tried to read up on that in BOL, but not
really seeing how I can apply it. I wonder if there's already some tutorials
or sample code out there. I have done some looking on the Web, but still
haven't found much.

View Replies View Related

ASP Search

I have created an asp server page as described in the
Microsoft Article 318387 HOW TO: Query Index Server Data
by Using ASP in FrontPage 2002
(http://support.microsoft.com/?id=318387)

It is running off my IIS server for the search results.
However, the results return only file locations; I would
like it to return a link to the hits. How would I do this?

View Replies View Related

Search

im now doin a search function... but my problem is... if i didn't enter any data in the textbox and then click search button, it will appear all list from database instead of display "please key in data".

I just want to display "please key in data" but not display all records. Code:

View Replies View Related

Search

I'm make a search and I want to limt the results to 10 and have a next button.

View Replies View Related

Search The Web

With Index Server I can search web pages stored on our servers. Is there any
way to programmatically search web pages on the web ?

View Replies View Related

DB Search

I am trying to set up a pge that allows users to search DB for their order status. I managed to get it working with 1 search parameter. I would like to give my clients more then 1 search option to search by.

This is where I ran into problem. I believe it to be with my lack of ASP knowledge and the problem here is with the SQL statement. I do not think that it will work the way SQL statement is set up right now but I am at a loss for correct syntax here. Am I way off ? Code:

View Replies View Related

Search Box

I am relatively new to asp so still need help on it.
On my site I have a search that allows users to search for a specific job skill ie.cobol, asp etc

The problem is that at the moment the search can only search for what is exactly typed in the box eg.

"ASP" this search works fine,
"ASP, HTML" this doesnt because It searches for what is typed in.
I have been told It is something to do with parsing and that this will allow me to search for multiple job skills using commas to split what is typed in. If any body has any ideas I will be very greatfull

View Replies View Related

Search PDF

Does anyone have or know of some ASP programming that will allow me to do a text search of a folder full of PDF files?

I want a user to be able to enter some text and then the programming to do a full text search across all the PDF documents and return the results.

View Replies View Related

MS SQL Search

I want to search the content of some database tables,do asp has some function or tool do this?

View Replies View Related

Search

I have a column in my database where emails are copied to, and i need to be able to search through each entry for certain keywords and display the results if the column contains any of the keywords. i can't figure out how to do this though, because if i use the select statement like this:

select * from maintable where column LIKE ('keyword')
or
select * from maintable where column IN ('keyword')

it will only display the results when the keyword is the only word in the field.

View Replies View Related

Search

I'm producing a search that when a section is chosen from a drop down menu the search only searches the selected section. The problem is the code below searches others sections as well as the selected one.

strSQL = "SELECT * FROM qry_Policies WHERE SectionID = " & request.Form("section") & " AND title like'" & txtSearch & "' or keywords like '%" & txtSearch & "' OR keywords like '" & txtSearch & "%' OR keywords like '%" & txtSearch & "%' AND '" & txtSearch & "' OR title like '%" & txtSearch & "' OR title like '" & txtSearch & "%' OR title like '%" & txtSearch & "%' ORDER by title" .

View Replies View Related

Search XML

It may be a really stupid question, but if you dont ask, you dont know. Is it possible to search an an xml file, which is used for an RSS feed, with asp at all? So for example, i want to have a search box on my site, which will then search the xml file for the search term, and then return the result to the person searcing?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved