[supernova333]

I am using CF with an Access DB.  This is a table of site visitors, it has their IP and some other info. I want to make a report page with each IP listed once, but srill include info from other columns.  When I try a "select distinct" it still gives me all the records, like it is doing a distinct select on all the columns I have listed instead of just "address".  Here's what I have:

select distinct address, host, created, referer, agent, id
from counter
order by id desc

Like I said, no sql errors, it just gives me every record in the database even though there are lots of duplicates in the address column.  Any ideas?  Thanks in advance!!

[gneato]

if you have duplicates... umm.. you need to make it check for that visitor before it adds another entry...

or have a relational database... like have a visitor table with all the id numbers (mabe ip address, although many are dynamic) and log the visits in another table...

with MySQL you can use LIMIT (0,30) I believe it is to only list the first 30...  (31,60) to list the next... so on...

I'm new to sql though so you should check the syntax

my typing today makes no sense...