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 RepliesI 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 Relatedanyone knows what the formula is for finding a distance betweeen 2 zip codes?
View Replies View RelatedI need to process a string to do some data insertion into a database table.
However, this string contains some constant variables (set in the include file) and it depends on the value of intDataCtr as below : Code:
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.
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?
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 RelatedI 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.
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 RelatedI 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.
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 RelatedIs 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 RelatedWe have "orders" that are entered into our database through a data entry web-based application that we've built.Typically,the user enters the city/state/zip code/county. Now they want it to be able to autopopulate the city/state/county based on entering only the Zip Code.
We realize this can be a problem as Zip Codes can overlap different counties/cities/etc.Is there a good way to handle this?Perhaps some kind of control we can use on an ASP page that will read our Zip Code data and handle this somehow?
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 RelatedI have designed an e-commerce site for a friend and he now wants to add promotional codes to the site t work as follows:
The first 100 users to subscribe to the mailing list will be sent a promotional code be the site owner (via email) entitling them to 25% off their next purchase.
What I want to know is the bet way to implement this using ASP and access and also how to ensure that once a Code has been used by a visitor then it cant be reused again.
Having a problem with a page being skipped in the cart. Intermitting problem here. Action code 38 then 47 when this occurs.
View Replies View RelatedI have included all the db scripts in asp above the <head> tag and <html> opener tag.When i submit a page, to add a record that record just get doubled and i dont know why that is happening.It dont happen always but now and then. The problem is not with cliking the submit button twice. So all i want to know is if it may be a problem with including the asp codes above the html tag or not?
View Replies View RelatedDoes anyone have codes or articles related how to make Yahoo-like directory-based serach engine which the categories of the post can be change from one to another, theoretically expandable to unlimited level of directories, etc.
View Replies View RelatedI'm working to revise some code I had the misfortune of inheriting and am hoping someone can either give me a quick explanation or link to some more information. I need to figure out how I can edit a constant.
Specifically, I keep coming across things like
const MN_DIRECTORY=1
const DIR_RESUME_URL=22
and I need to know a.) what the values mean and b.) how I can edit these.
the code for validation? What I'm trying to do is if a person forgets to fill out something on a form...I want a pop up that will remind them what information they forgot to fill in. For example "Please enter your name before submission."
View Replies View RelatedI would like to write ASP error codes in a log file. Error message would be
for example:
ADODB.Fields error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name
or ordinal.
/ASP-application/page1.asp, line 67
I've learned that it is possible to get some information with the
'err-object' of VB. Unfortunately these codes and descriptions are not that
good as the ones ASP itself generates. First of all I'm interested in the
description ("Item cannot be found in..") and the line in the ASP-Page where
the error occurs.
Does anybody know how to catch this information?
Does anyone out there know how to encrypt the entire ASP file? That means when a person tries to view my ASP source code, it will display as rubbish. Can't use Script Encoder (srcenc.exe) cause out there in the market exist a freeware Script Decoder (scrdec.exe) which can easily decode back the file to its original state.
View Replies View RelatedI have a stored procedure that builds and sends an email using xp_sendmail. It is called after the user makes a change to a form (it tells the support centre that a change has occurred.)
The last bit of my SP is this:
-- It fails if it has no recipient list
if isnull(@recip, '') = '' set @recip = @supportemail
declare @rc int -- have also tried changing it to bit
exec @rc = master..xp_sendmail
@recipients = @supportemail
, @message = @msg
, @subject = @subj
, @no_output = 'False'
, @query = @q
, @width = 200
/*
Return Code Values
0 (success) or 1 (failure)
*/
select @rc
return @rc
If I call it through query analyzer, @rc is 0 and I receive the email.
If I call it through my ASP page (which worked earlier), cint(rs.fields(0)) is -1 and I do not get the email.
strSQL = "exec pr_EmailNotification " & iRequestID
writeline "<P>" & strSQL
set rs = ConnObj.Execute (strSQL)
writeline "<P> Result: " & cint(rs.fields(0)) '0 (success) or 1 (failure)
(All variables are declared.)
It was working earlier, I had proven it... I thought it was the return @rc line that was doing it and was just keeping in select @rc for debugging. When I was ready to move on, I removed my debug statement, and then it started failing. I've put it back in, but it still fails, so I must have also removed something else, or changed something, or something.
I'm at wits end. It still works perfectly through Query Analyzer. But not ASP.
when i try to view an ASP page in my IE web browser, all i see are the codes used to design the page but when i preview 'em in Dreamweaver its okay.Why is it so ?does it mean if i publish my asp pages to the web; thats how they'll be on other people's browsers ?what do i do to be able to see the actual web page and not the codes in an ASP page.
View Replies View RelatedIs there any sample codes/projects that does auction website ?
View Replies View RelatedI have created a form with the folowing properties, first name, last name, registration number; course; grade etc I have passed this form to a page to be called create_table.asp, and on submitting the form.
I want this page (create_table) use the info from the form to create tables in an access database (jacko) each time the submit button is pressed with the tables to be named automatically according to the convention fname_lname. I also want to create a page that I can use to edit all the tables in the database can any guru assist me with the required asp codes.
I'm now doing a project about handphone making a call and sending sms or mms by using vb.net.
But i need to make the button invisible inorber to see the buttons of my phone.when i switch the visible to false.
The button become inactive and i can't even click it. How to make the button active and it is invisible at the same time. Need to figure out the codes fast,running out of time to do the project.
I have a table with data in it and i want to generate unique icodes for each user. I have a hex function that generates random code but i get stuck when i want the items to be unique. I want to update all uses that have empty codes. How will i go about this. Code:
str_sql = "update tbluser set [usercat]='" & strcode & "' where usercat=null"
conn.execute(str_sql)
I have made a booking system, but need to somehow generate a unique confirmation code to be sent to the bookee to confirm the booking. I hve done a basic Google search, and a search through the archives of the forum, but to no avail.
View Replies View Relatedmy database is database.mdb
my file path is C:Inetpubwwwrootfypdatabase.mdb
Error Type:
Microsoft VBScript runtime (0x800A0009)
Subscript out of range: ''
Besides using this ASP code of opening up my database is here any other way??? I often get the above error due to " This is my present code..
<%
dim objConn, path
set objConn = server.createobject("ADODB.connection")
path = "C:Inetpubwwwrootfypdatabase.mdb"
objConn.open "driver={Microsoft Access Driver (*.mdb)};dbq="& path &";"
%>
I am studying Programming and Computer Engineering and got an assignment. I made a lamp kit and a program, but I now need to integrate both by using ASP. So, when somebody is in the ASP page and presses a certain button, the lamp needs to automatically switch on (or off).
This of course not only applies to a lamp but should be used for different devices. The logic is that no matter where you are or what time it is, you can remotely switch devices on or off using ASP.
My question is: What codes do I need to make this work? And what are the steps to follow?
Does anyone know where I can get a free list/database of all US zip codes as well as latitude and longitudes? I am attempting to create a distance calculator but need that information.
View Replies View RelatedI have a product that when scanned into the web site will scan as a single piece of string but it is really made out of start code - A0, componeneet code - 00150, stop code 3B, how could I drop prefix and sufix when the product is scanned so it only scans the actual product code.
View Replies View Related