help with if statement in response.write
i am trying to get a response if there are no records listed in field "venue"
what am i doing wrong please. both records with and without venue listing are showing "Venue Details" the ones without a records should be showing "none"
Set objRs = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT Count(venue) AS `venuecount` FROM `gigs` GROUP BY `Contact`"
objRS.Open strSQL, objconn
IF objRS.EOF AND objRS.BOF THEN
Response.Write "<venuedetails.asp>Venue Details</a>"
venuecount = objRS("venuecount")