VBSCRIPT and Access SQL Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I run an SQL query from VBSCRIPT how do I test if there are no records
returned ? E.g. - if the query were to search for the word Microsoft and no
matches were found. Thanks in advance for any replies.
 
If Not objRS.EOF Then
'display results her
Else
response.write "No Matching records found"
End If

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| When I run an SQL query from VBSCRIPT how do I test if there are no records
| returned ? E.g. - if the query were to search for the word Microsoft and no
| matches were found. Thanks in advance for any replies.
 
Back
Top