I run a website which uses SQL 2000 and VB ASP. I would like to add a section to the site which posts the most popular data being queried from my SQL server. I'm sure this is possible, but I don't know where to start. Please let me know if any of you need specifics regarding my data and set up.
Not too sure why you are referring to Searching? I am trying to see what and where my visitors have been on my site and have that info postable (if thats a word) on my site.
What do you mean by record the pk??? into what? how?
I am trying to keep track of and some how log specific requests made to my db so that I can display that info on my site for puposes of showing popular games (again based on requests by the visitors to the db).
Are there any other takers on my original question???
The visitors request info which is obtained from the db - that's a search - might return many items but sounds as if it always returns one by your response. It is best if that database access is performed via a stored procedure.
The stored procedure can log to a table what is returned. The pk is the primary key which is the reference of the data returned. You can interrogate that table to display information about data access on your site.
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.