when you have a <NULL> value in one of the records in your MS SQL database and you get the recordset containing a bunch of stuff including that record. then you put this recordset into a VB/ASP array using RS.GetRows. what's the value of the variable that gets the null value?
i can't seem to figure it out.. it's not NULL, it's not NOTHING, isEmpty doesn't work on it..
basically, to summarize the question, when a value is taken from an SQL DB and put into a VB/ASP variable, how do you check whether the value was <NULL> in the DB or if it contained something?
Update: Nevermind, got it... needed to use IsNull =)
i can't seem to figure it out.. it's not NULL, it's not NOTHING, isEmpty doesn't work on it..
basically, to summarize the question, when a value is taken from an SQL DB and put into a VB/ASP variable, how do you check whether the value was <NULL> in the DB or if it contained something?
Update: Nevermind, got it... needed to use IsNull =)
