What do you do or how can you determine if the ADODB.Recordset returns null or nothing. I have a querystring that works fine if a column has a value, but if it doesn't i get an error. I want to do something if the querystring doesn't work instead of the page not working at all.
SELECT AVG(ColumnA) AS Expr1 FROM datatable WHERE columnB = 'this' and columnC = 'that'
If i take "and columnC = 'that'" out it works or if i do "and columnC = 'acertainthat'" it works fine but if there's no value for ColumnA where columnC = 'that' i get an error. I've tried RecordCount > 0 and Field.Count > 0 and they don't work