Next RecordSet Problem

Results 1 to 2 of 2

Thread: Next RecordSet Problem

  1. #1
    Mark Brailsford Guest

    Default Next RecordSet Problem

    I want to be able to update a record and select a record in a stored procedure in SQL 6.5, but when I try to retrieve the records from the select, I get an error becuase the first SQL statement yeilds no record set. No problem, I can use a set recordset = recordset.nextrecordset. Is there a way to test the record set for its condition when it has no records as a result of an update? EOF and BOF both return false.

  2. #2
    Matthew Hazlett Guest

    Default RE: Next RecordSet Problem

    Hope this helps:<BR><BR>Set DBConnection = Server.CreateObject("ADODB.Connection")<BR>DBConne ction.Open "uid=??;pwd=??;dsn=??"<BR>set IsEmpty = DbConnection.execute("select * from mytable")<BR><BR>if IsEmpty.eof then<BR> response.write "Empty!"<BR>else<BR> response.write "Do whatever here"<BR>end if<BR><BR>dbconnection.close<BR>set dbconnection=nothing<BR>set isempty = nothing<BR>

Posting Permissions

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