We had to developed a very simple asp list some years back because members sometimes came back under a different name etc...
We wanted one box into which we entered a part IP or part nickname and it reports all matching IPs with nicknames used in posts (getting the nickname) from the author record.
Ours does not link to the post but I am wondering if a small enhancement of your new facility to do part IPs and/or part nicknames would be useful...
I think this was the code
Recordset1.Source = "SELECT dbo.tblAuthor.Username, dbo.tblThread.IP_addr FROM dbo.tblAuthor INNER JOIN dbo.tblThread ON dbo.tblAuthor.Author_ID=dbo.tblThread.Author_ID GROUP BY dbo.tblAuthor.Username, dbo.tblThread.IP_addr HAVING (dbo.tblThread.IP_addr) Is Not Null and ((dbo.tblAuthor.Username) Like '%" + Replace(Recordset1__nick, "'", "''") + "%' or (dbo.tblThread.IP_addr) Like '%" + Replace(Recordset1__nick, "'", "''") + "%') ORDER BY dbo.tblAuthor.Username;"
Topic Options
Post Options
Thanks(0)
)
