how do you test for null or empty binary values received from an sql table within your asp code? or rather, i'm assuming that there is such a thing as a null binary value, so what is the empty "" binary value?

response.BinaryWrite(...) always fails in such cases

wouldn't you just use isNull(myValue) in the same way you would for other null values??

yes, i've tried that...

if not isNull(myValue) thenm
response.binaryWrite(myValue) //unhandled data type error
end if

I haven't played with binary data in databases for a long time but wouldn't you have to use GetChunk to get the binary data??

http://msdn.microsoft.com/library/de...thod_oledb.asp

And you could use the ActualSize property to determine if the field was empty or not.