PDA

View Full Version : Problem with recordsets ????


krnaveen
08-09-2002, 07:56 AM
Hi! Friends,
Once again at your doorstep with another problem

as follows:-

I have four recordsets generated as per requirements

submitted by the user. I have to display the contents of

the recordsets. If the requirement of the user is not

met then the recordset remains empty. Am displaying the

contents using table in Internet Explorer. If any of the recordset remains empty then an error message is displayed that either BOF or EOF is true. If a match is found for each recordset then it works fine. I even tried imposing the if clause to check whether the number of records in each recordset is greater than 0(zero) or not. If it is then only the rows are generated, but in vain.
How to handle it ???? Thanks in advance.

-Navin.

Roy Sinclair
08-09-2002, 02:37 PM
if (oRS.EOF) then
response.write('Empty record set')
else
.... insert display recordset code here
end if