Hi I need to change a JPG to BYT

[KatiS]

Hi

I need to change a JPG to BYTE and insert it to SQL database.
I used a function to read the JPG and change it to BYTE using oStream.Read

bData = oStream.Read

Now I need to send this value to my storedprocedure. I need to create a text command like this

l_SQL = " exec dbo.sp_Custom_UpdateAnagpersPhoto " & bData

I get type mismatch.

Would you please tell me ?

Thank you
Kati

 

[NoCoolHandle]

I think you need to convert the bytearray into a string first
this function may be what you need

Function Byte2String(s)
    Dim i
    For i = 1 to LenB(s)
        Byte2String = Byte2String & CHR(AscB(MidB(s,i,1)))
    Next
End Function

pass the byte array into the function and then read the return into a string, pass that string into your stored proc