Q:
|
You provide a Access Database, but can I use another Database
instead? |
A:
|
Yep, just import the data into your database and change the
strConn line of code in the dbconnection.asp file. It just needs to be an
ODBCcomplaint database.
MS SQL SERVER EXAMPLE:
strConn = "Provider=SQLOLEDB.1;Password=ZipCodeUser;Persist Security
Info=True;User ID=ZipCodeUser;Data Source=localhost"
|
| |
|
Q:
|
Will it work on my Windows workstation? |
A:
|
No, it will only run on Windows NT 4.0 server or above with IIS 4.0 or
above installed. |
| |
|
Q:
|
Can I register the your .DLL using COM+? |
A:
|
Yes. We suggest you create a new Windows account to be used for
the authentication in the COM+. That way the COM object permissions level
is easy to maintain and debug security issues. If you choose to use the
default account the component will be run under the System User account. |
| |
|
Q:
|
Do you have a .NET version? |
A:
|
We are working on it now, and it should be available soon. |
|
|
Q:
|
I have added all my stores in the backend (not using the provided
admin tool), but need to update the Lon and Lat values. How do I do it? |
A:
|
Simple just run one of the following queries:
[Access];
UPDATE Retailers, Zips
SET Retailers.Lon = [Zips].[Lon], Retailers.Lat = [Zips].[Lat]
WHERE ((([Retailers].[PostalCode])=[Zips].[Zip]));
[ MS SQL Server]
UPDATE Retailers
SET Retailers.Lon = [Zips].[lon], Retailers.Lat
=[Zips].[lat]
FROM Retailers, Zips
WHERE (((Retailers.PostalCode)=[Zips].[Zip]));
After the query is done validate these columns in the Retailers table
to make sure they have data. If values are missing most likely the zip
code is wrong for that store. A small percentage may not be covered in the
Zips 43,000 records and in those cases just update with a nearby cities
Lon and Lat.
If you are using SQL server then you can download this
StoredProcedure to do all the work.
It has one optional parameter which is the Retailers table name. |
| |
|
Q:
|
I received the following error message on the admin
pages :
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/locator/admin/retail_process.asp, line XX
|
A:
|
The IUSR_computername account does not have sufficient
privileges to make edits to your Access database. Assign write privileges
to this file for IUSR_computername. |
| |
|
Q:
|
I received the following error message on the sample pages :
Server object error 'ASP 0178 : 80070005'
Server.CreateObject Access Error
/locator/resultsbyzip.asp, line XX
The call to Server.CreateObject failed while checking permissions. Access is denied to this object.
|
A:
|
It is a known bug from Microsoft. Read the Microsoft Knowledge Base Article - 278013
for the fix.
http://support.microsoft.com/default.aspx?scid=KB;en-us;q278013 |
| |
|
Q:
|
I don't want to use the automatic install,
can I install it manually? |
A:
|
Yes.
1) All you really need to do is install the zip locator .dll
(ziploc26_31.dll or similar name) which is found in the .CAB file. To get
the file out of the CAB file just double click on it. Once you have the file
in its final destination on your server then run this command in the command
prompt:
regsvr32.exe ziploc26_34.dll
2) Copy the locator folder and all its contents into the root of
your web.
3) Open the inc_constants.asp page and insert the DB connection
information |
| |
|
Q:
|
Your sample links directions to Expedia.com.
Can I use Yahoo Maps.
-or-
Can can I link to just a map of the location instead of driving directions.
|
A:
|
Sure, to learn how go here:
http://help.yahoo.com/help/us/maps/maps-26.html |
| |
|
Q:
|
What about future updates to the Zip Code table, are
those provided? |
A:
|
You will get the latest version of the Zip Codes table when you purchase
the product. However we are not in the business of reselling the list, our
focus is developing the product. However upon purchase we will send you a
link to a site that sells the updates. You can purchase the updates on a
schedule of once a year, once a quarter, or once a month. For small
websites a once a year update is usually sufficient. |
| |
|
Q:
|
I added field(s) to the retailers table but they
aren't returned in my record set? |
A:
|
By default the
fields returned to
the results page are
the mandatory fields
only (ID, Distance,
Address, City,
State, PostalCode,
PhoneNumber,
Extension,
CompanyName, and
EmailAddress). You
must tell the store
locator what extra
fields to return
also by sending it a
parameter of extra
fields into the
call.
I have made this
easy. Open up
resultsbyradius.asp
page. Approximately
9 rows from the top
you will
find this line:
ExtraRecords = ""
Just add a comma
separated list of
the extra fields you
want the
locator to return.
Example:
ExtraRecords =
"Field1,Field2"
|
| |
|
Q:
|
How do I add an image to the results page that
corresponds with each record? |
A:
|
To get a
logo to show up
on the results
you should
- Create an extra
field in the
retailers table
that is the name
of the image
file. Lets call
it "logo" for
this example.
-
Then on the
results page add
the field to the
extra fields
parameter
(see question
above)
-
Then drop in the
page add this
code to the
location of
where you want
the image: <IMG
SRC="/images/logos/<%=rs.Fields("logo")%>">
NOTE: change the
src path to the
path of your
logos relative
to the
results page.
|
| |
|
