help clearing a recordset

Results 1 to 2 of 2

Thread: help clearing a recordset

  1. #1
    Join Date
    Dec 1969

    Default help clearing a recordset

    Hello:<BR><BR>I&#039;ve done a lot of searching on this subject and haven&#039;t found an answer. Please help me if you can. I am using SQL Server...<BR><BR>I have created two subroutines(using VBScript) in my ASP file. Each function is a SQL query, which uses an IP address ("" or "") as a parameter of the query. <BR><BR>I call each function more than once, passing in different IPs. So, the first call to RunQuery1 is "". The second time I call the function, I pass "". <BR><BR>Although I am closing the recordset (recordset.close) and re-setting the object (set recordset = nothing) after each run of the function, I am coming across the situation where the second call to the function returns the original recordset - the information returned after calling "" is for the IP "".<BR><BR>Can someone give me a hint on why the recordset is not getting the new information?<BR><BR>Thanks!!<BR>

  2. #2
    Join Date
    Dec 1969

    Default Post some code...

    Might have to do with the scope of the recordset and whatnot...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts