Problem with sqlserver and binary

[Kain]

hi, i m trying to read some data (supposed to be 10 integer) from my database declare binary (sqlserver) and i try to use getchunk like :

dim a as variant
a=rs("popol").getchunk(10)


When i try it the error "operation not allowed in the context" apprears, why?
How getting my info in a string or in integer??
thx

[Cakkie]

the getchunk method retrieves a given numer of bytes to retrieve. If you try to retrieve more bytes than there are in the field, you will get an error. You can check the length of the data with the actualsize property of the field.

Tom Cannaerts
[email protected]

Programming today is a race between software engineers striving to build bigger and better idot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook

[Kain]

thx but even when i try to put a lengh of 1, it doesn t work..i don t know why
i m sure something is in cause i do a actualsize and it return 10...
please i reaally need help