kewlsammie Posted April 13, 2006 Share Posted April 13, 2006 anyone here knoes how to check if a record if empty in database?? i am using ASP and SQL on this project.. i was wondering something like tat.. if EOF and BOF then blah blah? i tried this one out.. seems like it didn't work for mi.. help pls? Link to comment Share on other sites More sharing options...
pulpfiction Posted April 13, 2006 Share Posted April 13, 2006 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 Link to comment Share on other sites More sharing options...
khalidvip Posted April 17, 2006 Share Posted April 17, 2006 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<{POST_SNAPBACK}> 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 More sharing options...
Matar Posted April 17, 2006 Share Posted April 17, 2006 hi <%for each x in rs.valueif x.value <> "" then response.write("x.vlaue")end ifnext%> Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now