Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to access ADO recordset field with array of 8 bytes ?

Status
Not open for further replies.

andrewd27

Programmer
Nov 12, 2001
16
AU
I have a column that stores numbers as 8 byte binary hex numbers eg. 0x0040000000000009
My problem is when I get this column in an ADO recordset I cannot access the value to show in an ASP page as a meaningfull number. The ADO recordset stores it as an array of bits which I don't know how to handle ?

question 1. Can I access this value in the ADO rs in a meaningfull way ?

question 2. Is there a way to convert this value into an 8 byte integer ? I used CONVERT(int, 0x0040000000000009) but this returned 9 the same value when I tried CONVERT(int, 0x0000000000000009) so cleary it is truncating to 4 bytes !!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top