VBSCRIPT and Access SQL Query

[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.

 

[Stefan B Rusynko]

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.

 

[Andrew Murray]

Just do a search as normal...and if it doesn't find any match it will tell
you