Hi,

I want to do a query that displays duplicate records in the database based
on IP address. What syntax should I use in the WHERE********** bit please?

Thanks,

set rsData = con.execute("SELECT formtype, entrydate, ipaddress FROM
formdata WHERE ************ ORDER BY ipaddress")
arData = rsData.getrows

Hi!

I don't know which database you are using but something like this might work
(there may be some typos of course)

Select formtype, entrydate, ipaddress from formdate group by formtype,
entrydate, ipaddress having count(*) >1 order by ipaddress

Regards
/Hans

> in the database

Please tell us what you mean. What type of database, Oracle, SQL Server,
Sybase, Access, DB2, ...? What version?

Please follow up in microsoft.public.inetserver.asp.db

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

Access from Office 2000

"Hans" <hansb@sorry.nospam.com> wrote in message
news:eer8XdbMEHA.628@TK2MSFTNGP11.phx.gbl...[color=blue]
> Hi!
>
> I don't know which database you are using but something like this might[/color]
work[color=blue]
> (there may be some typos of course)
>
> Select formtype, entrydate, ipaddress from formdate group by formtype,
> entrydate, ipaddress having count(*) >1 order by ipaddress
>
> Regards
> /Hans
>
>[/color]