[ So What Is Included? ]
The real work horse which supplies the functionality lies in a
COM component which communicates with the database. The database comes in a MS
Access format but you can upgrade it to SQL server or any other ODBC compliant
database you like.
The database is made up of two main tables. The first table
contains all the zip code information for the United States. The second table,
called the Retailers table, contains your store/business information. The
Retailers table contains a base set of core fields that are necessary to perform
the advertised functionality, but you may add more fields to fit your
needs.
When you buy the ASP Store Locator you will also
get a Sample asp pages that highlight six main
functionalities the locator can offer. Click
Here to see a non-functioning version of the sample page.
CODE GEEKS
OK that is all nice and good but what is under the covers!
For those of you hardcore programmers who would like to do more
then just modify my examples (which in reality serves the purposes for most all
my customers) you can talk directly to the COM object.
Properties
let_ConnectionString( DataConnectionString as
string )
|
Description: Sets the
database connection information for the COM Object. This value must be
set before calling other
functions, otherwise they will fail.
|
|
get_ErrorString() |
Description: Contains useful
information about the error if one occurs while running the COM Object.
|
Methods
|
| CalculateLocations( ZIPCode
as string, NumberOfReturnRecords as integer,OPTIONAL
StringOfExtraFields as string,
OPTIONAL UnitsOfMeasure as string, OPTIONAL FieldName as string, OPTIONAL
FieldValue as string ) as recordset |
|
Description: Returns the
closest locations to a given ZIPCode. The default return set includes
the following fields found in the retailers table: ID, Distance,
Address, City, State, PostalCode, PhoneNumber, Extension,CompanyName,
and EmailAddress.
|
| CalculateLocationsByRadius( Radius as double, ZIPCode as
string, MaxNumberOfReturnRecords as integer,OPTIONAL StringOfExtraFields as
string, OPTIONAL UnitsOfMeasure as string, OPTIONAL MinRadius as double ) as recordset |
|
Description: Returns all
the locations that fall within the given Radius. The default return set
includes the following fields found in the retailers table: ID,
Distance, Address, City, State, PostalCode, PhoneNumber, Extension,
CompanyName, and EmailAddress.
|
| ResultsbyStringField( FieldName as string, FieldValue
as string, OPTIONAL OrderByField as string )
as recordset |
Description: Returns all the records that
have the FieldValue in the FieldName in the Retailers table.
|
| DistanceBetweenTwoLonLat( Long1 as double, Lat1 as
double, Long2 as double, Lat2 as
double ) as double |
Description: Returns the distance between
two points given their Longitude and Latitude.
|
| DistanceBetweenTwoZips( ZipCode1 as string, ZIPCode2 as
string ) as double |
Description: Returns the distance between
two points based on their ZIP Code.
|
| ResultDetails ( ID as integer )
as recordset. |
Description: Returns the record that has
this ID value in the Retailers table.
|
OK if you have read this much then I am willing to let you download the Installation/User Manual
|
