logging query strings problem

S

shank

I have a search page and I want to log the query strings being submitted to
that page. Variables are being submitted to a stored procedure. In that SP,
before the SELECT statement, I placed an INSERT INTO code that inserts the
query string into a table.

Problem: Everytime the query produces results, there are 2 identical records
in the table. If the query returns no results, then there's only 1 record in
the table.

My processing steps are basically...
1) send the variables to the SP
2) check to see if that recordset is empty and redirect if it is
3) use .RecordCount for navigation purposes
4) set up a repeat region
5) display

Is there anything that would cause the SP to be called twice everytime
there's a successful result?
thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
474,145
Messages
2,570,824
Members
47,369
Latest member
FTMZ

Latest Threads

Top