Querying binary data types 
Author Message
 Querying binary data types

I having trouble querying my table with binary datatypes.  I have an ASP
session variable that contains the binary number and I'm trying to do the
following query:

"SELECT * FROM Wallet WHERE walletid = " & binaryid

binaryid is stored from a record set query of a binary.  isArray(binaryid)
returns True and vartype returns byte.  I know it's a byte array, but I
still can't access any of its data.

Does anyone know how to convert this binary number into a string?

Any advice would be appreciated!  Thanks!

Tina



Sat, 08 Dec 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Binary Data Types

2. Is there a Binary data type ?

3. Binary data types

4. Data Type Conversion Error with Long Binary Field -PLEASE HELP

5. binary files and user defined data types

6. Binary data types

7. Help with Binary data types using VB

8. Binary data type in VB4???

9. A Binary Data Type Question

10. Binary data types in VB?

11. Crystal and SQL Binary Data Type

12. Saving Binary files on the Client to the Image data type in SQL Server

 

 
Powered by phpBB® Forum Software