Thread: query problem
View Single Post
  #7 (permalink)  
Old September 9th, 2003, 06:10 AM
nbryson nbryson is offline
Authorized User
 
Join Date: Jun 2003
Location: Edinburgh, , United Kingdom.
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi

You need to replace 'raise error' and 'work with recordset' text with you own code.

if rs.BOF = True and rs.EOF = True then
  raise error
else
  work with recordset
end if

The error that was raised 'Microsoft VBScript compilation (0x800A03EA)
Syntax error
/dcil2/paging7.asp, line 25, column 5
work with recordset' could not compile your application as it is just text.

Just to give you an idea replace the above code with :-
if rs.BOF = True and rs.EOF = True then
  msgbox "Error retrieving recordset. description = " & Err.Description
else
  msgbox "Column 1 returned is " & rs.fields(0)
end if

See how you get on.

Nickie
Reply With Quote