Jump to content

how to check for empty records?


Recommended Posts

recordset.RecordCount, if this value is zero then the recoder set is empty.check out this site...http://www.4guysfromrolla.com/webtech/092398-1.shtml

hi,its so easy you can do it simply by adding the following IF condition:<% If Not isnull(rsRecordset1.Fields.Item("your_database_fieldname").Value) AND (rsRecordset1.Fields.Item("your_database_fieldname").Value)<>"" Then %>some statements....<% End If %>
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...