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
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