It's really quite ridiculous. I'm staring at my table, which I have refreshed, and I know there is a 1 sitting there in the column. Yet my program says it's a zero. What can be the reason for this anomoly?
If Not IsDBNull(adv.TimesRMEmailed) Then
Response.Write("WE ARE HERE")
Response.Write("TimesRMEmailed: " & adv.TimesRMEmailed)
NumRMemails = adv.TimesRMEmailed
NumRMemails = NumRMemails + 1
Else : NumRMemails = 1
I put a 3 in the column and made sure it took. Usually I have to retype the data 5 times until I see a little red circle which tells me that the data took. Why do I always have to do this in the SQL tables?
When I ran my program, rather than print me the 3 which was sitting there, it thinks that the value is 0, then it adds 1 to the number and assigns it fo NumRMEmails. This is absurd....It should be 3+1=4
Why can't it read the value in the column for adv.TimesRMEmailed? It turns it to a zero every time.
View Complete Post