By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,644 Members | 2,082 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,644 IT Pros & Developers. It's quick & easy.

logging query strings problem

P: n/a
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
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.