求助:asp对数据的binary类型数据读取,急,在线给分!
6z6 2004-10-25 02:50:19 具体数据样本0x868FFFFFFFFFFFFF。我直接读出的数据是乱码“?儰??”。
代码如下:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
Dim rs
Dim rs_numRows
Set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=pp;Initial Catalog=test;Data Source=127.0.0.1"
rs.Source = "select Calling,Called,ServiceDate from Content where Calling = 0x868FFFFFFFFFFFFF order by ServiceDate desc"
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 1
rs.Open()
rs_numRows = 0
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><%=(rs.Fields.Item("Calling").Value)%>
</td>
<td><%=(rs.Fields.Item("Called").Value)%></td>
<td><%=(rs.Fields.Item("ServiceDate").Value)%></td>
</tr>
</table>
网上找了半天,没有结果。
不知哪位大侠帮帮忙!