ASP With Firebird

Handling Firebird

I'm using a Firebird database to store user comments using my web app that I wrote in ASP. Some fields are mandatory. some are not. Whenever I leave the textareas blank, Firebird stores them as empty text. Anyhoo, the blob fields are subtyped to text 80 segments wide.

I'm using reponse.binarywrite() to output the text into text areas. If there is something in those blob fields, all goes well. But if there isn't anything in the blob fields or I leave a couple of the blob fields blank, the program crashes. So I decided that I want to check if there is something in the blob field, before binarywriting it. I tried comparing it to the string "" and checking to see if it's null but to no avail. Something about a type mismatch error. The exact error message is:

Response object, ASP 0106 (0x80020005)
An unhandled data type was encountered.
/tracking/updateproject.asp, line 314

line 314 is where I'm binarywriting the blank data.