Hi

I am kind of new at coding, i dont know if any of you guys can help. I got a
webpage with an access table and right now everytime someone visits the page
it adds the IP of the person that is visiting the page and the date but
right now i got to many of the same ips how can i stop it from adding IPs
that are already in the table. Im using asp.net platform. thanks

You did not tell us the structure of your table that keeps track of the
visitors, however you could try making the IP column unique and use TRY and
CATCH block in your asp.net code to prevent errors that will occur when the
same IP is being tried to be added to the table.

Or you could write an SP which checks if there is already an existing IP
record before inserting it into the table. And you'd insert or ignore the IP
according to the result of that SP' s execution.

--
Ekrem Önsoy



"Chris" <900606900 (AT) linetor (DOT) net> wrote

You did not tell us the structure of your table that keeps track of the
visitors, however you could try making the IP column unique and use TRY and
CATCH block in your asp.net code to prevent errors that will occur when the
same IP is being tried to be added to the table.

Or you could write an SP which checks if there is already an existing IP
record before inserting it into the table. And you'd insert or ignore the IP
according to the result of that SP' s execution.

--
Ekrem Önsoy



"Chris" <900606900 (AT) linetor (DOT) net> wrote

You did not tell us the structure of your table that keeps track of the
visitors, however you could try making the IP column unique and use TRY and
CATCH block in your asp.net code to prevent errors that will occur when the
same IP is being tried to be added to the table.

Or you could write an SP which checks if there is already an existing IP
record before inserting it into the table. And you'd insert or ignore the IP
according to the result of that SP' s execution.

--
Ekrem Önsoy



"Chris" <900606900 (AT) linetor (DOT) net> wrote

You did not tell us the structure of your table that keeps track of the
visitors, however you could try making the IP column unique and use TRY and
CATCH block in your asp.net code to prevent errors that will occur when the
same IP is being tried to be added to the table.

Or you could write an SP which checks if there is already an existing IP
record before inserting it into the table. And you'd insert or ignore the IP
according to the result of that SP' s execution.

--
Ekrem Önsoy



"Chris" <900606900 (AT) linetor (DOT) net> wrote

You did not tell us the structure of your table that keeps track of the
visitors, however you could try making the IP column unique and use TRY and
CATCH block in your asp.net code to prevent errors that will occur when the
same IP is being tried to be added to the table.

Or you could write an SP which checks if there is already an existing IP
record before inserting it into the table. And you'd insert or ignore the IP
according to the result of that SP' s execution.

--
Ekrem Önsoy



"Chris" <900606900 (AT) linetor (DOT) net> wrote

You did not tell us the structure of your table that keeps track of the
visitors, however you could try making the IP column unique and use TRY and
CATCH block in your asp.net code to prevent errors that will occur when the
same IP is being tried to be added to the table.

Or you could write an SP which checks if there is already an existing IP
record before inserting it into the table. And you'd insert or ignore the IP
according to the result of that SP' s execution.

--
Ekrem Önsoy



"Chris" <900606900 (AT) linetor (DOT) net> wrote

You did not tell us the structure of your table that keeps track of the
visitors, however you could try making the IP column unique and use TRY and
CATCH block in your asp.net code to prevent errors that will occur when the
same IP is being tried to be added to the table.

Or you could write an SP which checks if there is already an existing IP
record before inserting it into the table. And you'd insert or ignore the IP
according to the result of that SP' s execution.

--
Ekrem Önsoy



"Chris" <900606900 (AT) linetor (DOT) net> wrote

You did not tell us the structure of your table that keeps track of the
visitors, however you could try making the IP column unique and use TRY and
CATCH block in your asp.net code to prevent errors that will occur when the
same IP is being tried to be added to the table.

Or you could write an SP which checks if there is already an existing IP
record before inserting it into the table. And you'd insert or ignore the IP
according to the result of that SP' s execution.

--
Ekrem Önsoy



"Chris" <900606900 (AT) linetor (DOT) net> wrote

You did not tell us the structure of your table that keeps track of the
visitors, however you could try making the IP column unique and use TRY and
CATCH block in your asp.net code to prevent errors that will occur when the
same IP is being tried to be added to the table.

Or you could write an SP which checks if there is already an existing IP
record before inserting it into the table. And you'd insert or ignore the IP
according to the result of that SP' s execution.

--
Ekrem Önsoy



"Chris" <900606900 (AT) linetor (DOT) net> wrote