I should have Values True and 01/15/2011
but I get -1 and 31510028178352E
I know the problem is Here:
adoCon.execute("update library SET flagged = "&truth&" where book_ID ="&sflag&";") adoCon.execute("update library SET expiration = "&expireing&" where book_ID ="&sflag&";")
expireing and Truth are both passed from a form on the previous page. The full code will update multiple records at a time, but right now it is inserting the wrong information... or it is inserting it the wrong way. The fields are text fields in the database.
It is most likely an obvious fix, but I don't see what I am missing. Any help would be appreciated. Thanks,